Linked PO and SC

[former_member117832]

Hi Experts,

How I can get number SC from PO?? I used BBP_PD for GUID PO and from this how I can get exactly table name of SC?

Also I tried use FM BBP_GETPO_DETAIL, and find SC number from E_Header_REL, but i need the table because I need PO in last three year and SC accordingly.

Thank you,

Yusup W

[Former Member · Accepted solution]

Hi Yusup,

You can use table BBP_PDBEI. Provide your PO number in the field BE_OBJECT_ID and you will get your SC GUID in the field GUID.

From this SC GUID you can fetch the SC number using FM BBP_PD_SC_GETDETAIL

Regards,

Nikhil

[former_member117832 · Accepted solution]

Hi NIkhil,

thank you for your information. However from BBP_PDBEI I only get PO GUID item not SC GUID.

[Former Member · Accepted solution]

Dear Yusup,

The GUID obtained is indeed SC GUID and not PO GUID!

Alternatively you can use the easier option as follows

Use FM BBP_PD_PO_GETDETAIL and get the SC header GUID from E_HEADER_REL-GUID_A.

Using this GUID get the SC number from table CRMD_ORDERADM_H. SC number is available in field OBJECT_ID.

Hope this helps,

Nikhil

[former_member117832 · Accepted solution]

Hi,

yes it's right after i tried to check another PO. May be anomaly in previous PO.

thank you all.

[Former Member]

Hello ,

Please follow the steps to get SC from PO.

1. Pass the Purchase Order number to BE_OBJECT_ID field in BBP_PDBEI table.

2.. take the GUID where BE_OBJECT_TYPE = BUS2201.

Now we might get the Item GUID of Shopping cart

3. pass the Item GUID of Shopping cart into CRMD_ORDERADM_I table and get header guid .

4. pass the Header GUID of Shopping cart into CRMD_ORDERADM_H table

to get the Shopping cart number

Regards,

Neelima