Can anyone provide me with the tables related to the PO table BBP_PDORG

[Former Member]

Hi All,

I have a table "BBP_PDORG" which talks about the Purchasing Organizational Unit.

I need to have relationship tables of the Purchase Order header with this table.

Can anyone provide me with the related tables of "BBP_PDORG"

Regards

Dharma

[Former Member]

Hi,

In addition to the tables mentioned by Peter please check BBP_PDHGP and BBP_PDIGP tables for P.O header and item details respectively.

You get all the tables related to a P.O in BBP_PD when you look at the entire details of the P.O.

Clarifications are welcome. Award points for helpful answers.

Rgds,

Teja

[peter_novoth]

Hi Dharma,

the "BBP_PDORG" is item related table, so you get the linkage in two steps:

1) BBP_PDORG (organization) <----> CRMD_ORDERADM_I (item)

Table: CRMD_LINK

Write the BBP_PDORG-SET_GUID into the CRMD_LINK-GUID_SET. As a result you will get the CRMD_LINK-GUID_HI (this is a GUID of the CRMD_ORDERADM_I).

2) CRMD_ORDERADM_I (item) <-----> CRMD_ORDERADM_H (header)

In the item table you have the GUID of the header: CRMD_ORDERADM_I-HEADER

Kind regards,

Peter