Relationship between tables CRMD_ORDERADM_H and BBP_PDORG

[Former Member]

Hi all,

I need to search all the RFx for a certain condition.

In the transaction BBP_PD i can see that the header table is CRMD_ORDERADM_H and the table for org. data is BBP_PDORG.

But the guid of both tables are different.

Do you know how I can relate the two tables?

Thanks in advance !

[laurent_burtaire · Accepted solution]

Hello Husalban,

SELECT set_guid FROM bbp_pdorg

SELECT guid_hi FROM crmd_link WHERE guid_set = bbp_pdorg-set_guid

SELECT header FROM crmd_orderadm_i WHERE guid = crmd_link-guid_hi

SELECT object_id process_type FROM crmd_orderadm_h WHERE guid = crmd_orderadm_i-header

Regards.

Laurent.

[Former Member · Accepted solution]

Thanks

[Former Member · Accepted solution]

Ok

Edited by: Husalban RM on Nov 11, 2010 5:20 PM

[Former Member]

Heres a helpful link

https://wiki.sdn.sap.com/wiki/display/SRM/SRM+Tables

https://wiki.sdn.sap.com/wiki/x/8Kw

hope it helps

cheers

alex