PO status report

[Amarjeet]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[ravindra_devarapalli]

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

[Former Member]

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

[Amarjeet]

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

[venkateswaran_k]

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

[Former Member]

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

[Amarjeet]

Hi Nikhil,

I apologise that I could not mention in mail body as well that this needs to be done in SRM 7.0 but not in MM.

Appreciate your response.

BR,

Amarjeet