Skip to Content

PO status report

Hi Experts,

I need to create a following report for purchase order since the 1st of January 2013 till date for countries like AT, AU, CN, DK, IT.

The information required in report is:

PO number | Goods receipt status | Order date | Country of order(for which PO is created).

It would be really great if some could help me with the trick to extract report from back-end.

Regards,

Amarjeet

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 09, 2013 at 10:34 AM

    Hi Amarjeet,

    Check Function Module BBP_PD_PO_GETLIST.

    Just execute without giving any Input data. Click on E_PDLIST and you will get the list of all PO created. Download it into Excel and than you can do filter & Vlookup manually.

    Best Regards,

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2013 at 09:58 AM

    Hi

    You need to ask ABAP team to create a report

    Source Tables :  EKKO - PO Header

                               EKPO - PO Items

                               EKBE - PO History

                               LFA1 - Vendor Master

                               ADRC - Address detail

    Join the table EKKO - EKPO - EKBE - to get the PO Items along with the Delivery Status

    Join the table EKKO-LIFNR to LFA1 - to get the address of Vendor

    Join the table ADRC with Address number to get the Country of Vendor

    Regards, Venkat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2013 at 04:03 PM

    Hi

    please use ABAP Query. Although you dont have any knowledge in ABAP, you can create report with ABAP Query.

    Or LIS : logistics information system. ABAP Query is more easy

    thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2013 at 09:23 AM

    Report Logic :

    EKKO: PO Number

    EKPO-EKBE: PO line item Goods Receipt Status

    Order Date : EKKO

    Country of Order : LFA1 -LAND1   ( Vendor Country). In this case you can take the VN country or the GS country.

    Hope this information serves your purpose.

    Regards,

    Nikhil Salian

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2013 at 11:27 AM

    Hello Experts,

    I would like to add below information to clarify the requirement further.

    System: SRM 7

    Technical Scenario: Standalone scenario

    Business Scenario: Self-services procurement

    I need to create a report for purchase order since the 1st of January 2013 till date for countries like AT, AU, CN, DK, IT.

    The information required in report is:

    PO number | Goods receipt status | Order date | Country of order(for which PO is created).

    It would be really great if some could help me with the trick to extract report from back-end.

    BR,

    Amarjeet

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2013 at 06:30 PM

    Hi,

    PO Number : EKKO-EBELN or EKPO- EBELN

    PO item      :  EKPO-EBELP

    Goods Receipt Status : EKBE -BEWTP

    Order Date : EKKO-BEDAT

    Ordered Country : Take plant details from EKPO-WERKS , pass  Plant details to T001W table and take COUNC field. this is country.

    supply country : LFA1 value take from EKKO , and pass into LFA1 and take value LFA1-LAND1

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2013 at 02:30 PM

    If you use BW, there might be some reports available in BW for SRM 7.0. SRM might not have std reports for PO extracts. Otherwise check with ABAPer, to create a custom report

    - TGB

    Add comment
    10|10000 characters needed characters exceeded