08-17-2009 9:43 AM
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
08-17-2009 9:51 AM
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,
08-17-2009 10:16 AM
Hi,
Filter the GRN by using field: BWART
BWART = 101
Regards,
Shamma