Skip to Content
author's profile photo Former Member
Former Member

ABAP Query

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2009 at 08: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,

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.