Skip to Content
0
Former Member
Aug 17, 2009 at 08:43 AM

ABAP Query

26 Views

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