Solved: Re: a short dump has occurred in a database operat... - Page 2

former_member713390 · ‎12-16-2020

this is my code

Now i am getting (a short dump has occurred in a database operation)error. Can Any one suggest how can i solve this issue.

  SELECT EBAN~BANFN,
         EBAN~BNFPO,
         EKPO~EBELN,
         EKPO~EBELP
  INTO TABLE @IT_FINAL
  FROM EBAN
    LEFT OUTER JOIN EKPO ON EBAN~BANFN = EKPO~BANFN
    AND EBAN~BNFPO = EKPO~BNFPO .
    SORT IT_FINAL BY EBELN .

   IF IT_FINAL IS NOT INITIAL .
     SELECT MSEG~MBLNR
           MSEG~MJAHR
           MSEG~ZEILE
           MSEG~EBELN
    INTO TABLE IT_MSEG
    FROM MSEG 
    FOR ALL ENTRIES IN IT_FINAL
    WHERE MSEG~EBELN = IT_FINAL-EBELN
      AND MSEG~EBELP = IT_FINAL-EBELP .
ENDIF.

raymond_giuseppi · ‎12-16-2020

Well no, my crystal ball is in my pocket...

You use an LEFT OUTER JOIN between purchase requisition and purchase order, so you select also the purchase requisitions without purchase order.

Then you select material movement attached to those purchase order, so also movement without purchase order... for each record ... so the database will read many records many times (before removing duplicates)

It is not surprising that the database engine fails!

former_member713390 · ‎12-20-2020

sandra.rossi

My problem is solved.

But there is another problem.

I enter the amount of delivery at the input .

Instead of displaying the records that have this delivery, it displays all the records

Sandra_Rossi · ‎12-20-2020

I still don't have a crystal ball, maybe another volunteer has one...