ABAP Query

[Former Member]

Where to write select condition in a existing ABAP query. They have asked to modify the existing ABAP query to display purchase order whose delevery status is completed. I need to check for the condtion and display.Kindly help me.

[Former Member]

check table EKPO , there u will get one field called <b>Delivery Completed Indicator</b>, u have to u make use of that field.

Regards

Peram

[Former Member]

hi

good

If by query, you mean an ABAP report which you are coding in SE38. All you need to do is to create you selection screen by using the SELECT-OPTIONS statement.

SELECT-OPTIONS: s_datum for sy-datum.

Then in your where clause of your select statement say...

WHERE SOME_DATE in s_datum.

thanks

mrutyun^

[alejandro_bindi]

Code should be similar to this (this retrieves only one particular item in given PO, you should modify it according to your requirements):

      SELECT SINGLE * FROM ekpo
      INTO lwa_ekpo
      WHERE ebeln = l_ebeln AND
            ebelp = l_ebelp  AND
            loekz <> 'L' AND	" Not deleted
            elikz = space.	" Nor completely delivered

Please award points if this helps.

[Former Member]

resolved