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

Link between Purchase Order and Contract in SRM

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 03, 2014 at 03:20 PM

    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

    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.