topic ABAP Query in Application Development and Automation Discussions

ABAP Query

Former Member — Mon, 17 Aug 2009 08:43:22 GMT

Dear All

Hi Abap Experts. FYI, i am not a ABAPer.

My Business owner needs a report of PO Delivery Date Vs Actual Delivery Date.

In additon, he requires a fields like PO Line Items, Material, Material description, Vendor code with Description, GRN document Date and Refernce number

So, i tried my best, through ABAP Query.

So i am using tables like EKPO, EKET, EKKO,MAKT, MSEG, MKPF, and LFA1

Finally i executed the Report

Note: I also used Left Outer Join between EKPO and EKET, EKET and MSEG, EKKO and LFA1

But my Business owner need, if the GR is not made for particular PO, then that Particular PO also should be displayed, with field Null for GRN. This is not happening in my Report i created.

Please some one help me out of this issue, by giving pristine steps, so as to understand and follow the same.

If any coding has to be written, what, how, where to be use.

if any document is there, please do attach that also. I wil be really grateful to u.

Thanks and Regards

Guru

Re: ABAP Query

Former Member — Mon, 17 Aug 2009 08:51:02 GMT

Hi ,

It is easy to get po details by using BAPIs,but for this you need to take ABAPer help.The function module below will give you the po details.

BAPI_PO_GETDETAIL1 Detail Information for a Purchase Order

MEWP BAPIs Purchase order

BAPI_PO_GETDETAIL Display Purchase Order Details

BAPI_PO_GETITEMS List Purchase Order Items

BAPI_PO_GETITEMSREL List Purchase Orders for Release (Approval): New as of 4.0A

BAPI_PO_GETRELINFO Display Detailed Release (Approval) Information on Purchase Order

BAPI_PO_GET_LIST List Purchase Orders - Only up to 4.0A

thanks,

Re: ABAP Query

Former Member — Mon, 17 Aug 2009 09:16:52 GMT

Hi,

Filter the GRN by using field: BWART

BWART = 101

Regards,

Shamma