topic Re: ABAP Query in Application Development and Automation Discussions

ABAP Query

Former Member — Tue, 05 Jun 2007 20:42:32 GMT

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.

Re: ABAP Query

Former Member — Wed, 06 Jun 2007 04:00:47 GMT

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

Re: ABAP Query

Former Member — Wed, 06 Jun 2007 04:10:27 GMT

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^

Re: ABAP Query

alejandro_bindi — Wed, 06 Jun 2007 04:33:14 GMT

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.

Re: ABAP Query

Former Member — Tue, 28 Apr 2009 18:30:56 GMT

resolved