Skip to Content
avatar image
Former Member

PO detail report

Hi Gurus,

My client want to have a report which tells us the PO number and its corresponding GRNs and the invoice verification number for the GRN.Also he wants a excise document captured against a GDN in the report.

Is there is any stanadard report available in SAP.

Waiting for an earliest reply.

Regards,

Abhi.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 07, 2009 at 05:29 AM

    Hi Abhinandan,

    U will have to create a customised report with the help of an ABAPer.

    Regards,

    Kiran

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2009 at 06:38 AM

    you will get this details through Tables

    the tables name is RSEG , P.O number, GRN Number & IV Number (MIRO Document Number)

    Regards

    Akmal

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2011 at 10:56 AM

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2011 at 11:11 AM

    Hi,

    You can find it all details by sap table 'EKBE' . This is PO history table and will full fill your wish.

    With considering this table you can develop Z report with help of ABAPER which will exactly meet your requirement.

    Dhananjay Singh.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Put PO number and line item in fields EBELN and EBELP respectively in MSEG table and then extract unique MBLNR with corresponding MJAHR. This will give you GR done for the PO

      Then input those MBLNR and MJAHR in RSEG table in fields LFBNR and LFGJA and extract BELNR and GJAHR corresponding to each and then concatenate both (BELNR and GJAHR) to input the same in BKPF table and extract BUKRS, BELNR and GJAHR corresponding to it. This will give MIRO document against each GR document.

      Now input these extracted BUKRS, BELNR and GJAHR in BSAK table, and extract AUGBL against each. If there is not entry existing in BSAK table, payment not received (keeping the fact that payment received means we clear the pending invoice entry as well). If entry exists, then either partial payment has been received or full payment has been received. For this will check the amount passed in the AUGBL document and in BELNR document and if both matches, then full payment else partial payment

      assign points if helpfull.

      Regards

      Aditya