Link between Purchase Order and Contract in SRM

[Former Member]

I am a Project Manager with a project to create some simple data extracts directly from the SAP SRM database and the Data Analyst has left without creating any documentation.

I have an SRM Purchase Order and need to navigate the SRM tables to identify the SRM Contract Number and Line number.

I know that bothe the PO and Contract are held in the CRMD_ORDERADM_H table but cannot see where the relationship is held, is it in CRMD_LINK?

George

[robin_janke · Accepted solution]

Hi,

one of the best transactions for you to use is BBP_PD in there you can find which tables are used for each document and what information is maintained in the different tables.

Contracts are maintained in purchase order positions in table BBP_PDIGP-CTR_HDR_NUMBER (ctr item number is in there as well).

So,

1. CRMD_ORDERADM_H to retrieve the PO number and header Guid

2. CRMD_ORDERADM_I, use header guid in the PARENT field to get all the items (save the item_guid - GUID field)

3. BBP_PDIGP use the item guid in the GUID field to get the item data including contract information

Regards,

Robin