How to find the link the Header level table and Item details table in EBP

[Former Member]

Hi Gurus

We are trying to find the PO number in the following table BBP_PDBEI,CRMD_ORDERADM_H, CDHDR, but we are unable to find them using the link( i.e ; trying to query through GUID field in Header CRMD_ORDERADM_H and later querying with GUID in BBP_PDBEI item table). Could you please suggest a best possible method to find out the same.

Basically we need to find out the user who had approved the SC'S and relevant po's by giving the username.We are unable to find the particular PO's being approved by the user from R/3 side as the name.is being displayed as 'RFCPROD'.

Please suggest.

Thanks

Sada

[former_member206968 · Accepted solution]

Hi

To query BBP_PDBEI, you need to pass the sc item guid. Take the Header GUID from CRMD_ORDERADM_H and pass to Parent/Header guid field of table, crmd_orderadm_i. Now you would get all the item guids in the guid field of this table. Pass these item guids to bbp_pdbei to get the PO nos.

Regards,

Sanjeev

[Former Member]

Hi Sanjeev

Great...Its working fine.

Thanks

Sada

[Former Member]

Hi,

Request to to let me know the detailed procedure how to achieved it, i am also having the same requirement.

Thanks,

Anshu