Raletions tables between SC and PO.

[Former Member]

Hi Experts,

I need to know which tables are the relation between SC and PO. Also the table where save the substitute for a user.

Many Thanks.

Regards,

David.

[peter_novoth · Accepted solution]

Hi David,

the relations are stored in the tables SRRELROLES (this consist the documents) and BBP_PDBINREL (this consists the links):

In the table SRRELROLES are all of the the documents listed (SC, PO, BID...). Each line of the SRRELROLES consist a ROLEID. If you call the table BBP_PDBINREL with this roleid, as a result you will get the link (ROLEID_A or ROLEID_B) to the related documents.

Whit this ROLEID just call the table SRRELROLES and you will get the related document.

Regards,

Peter

[Former Member]

I solved it.

[Former Member]

Hi,

Please look into the following table:

CRMD_ORDERADM_H

CRMD_ORDERADM_I

BBP_PDIGP

Also look into transaction BBP_PD for more details.

[Former Member]

David,

Refer the table HRUS_D2 for the substitute information.

Cheers!!!

NMK

[Former Member]

Hi,

Did you check this TCode BBP_PD

You can also try using FMs BBP_PD_PO_GETLIST and BBP_PD_PO_GETDETAIL .

Also please visit this site for more details.

http://www.scribd.com/doc/946498/SAP-CRM-Tech-DRAFTtablesrelationships

Thanks

Zameer