Table for PO and Shopping cart combination in SRM

[Former Member]

Hi Guys,

Can any one help me out with a table which gets updated with PO and Shopping numbers in SRM.?

Regards

Srujank

[Former Member · Accepted solution]

Hi Srujan.

The table CRMD_ORDERADM_H will store the document numbers. But it wont be storing both the shopping cart as well as PO number for a record.

To find out the SC number from PO or vice versa use the following method:

You can use pass the PO number in function module BBP_PD_PO_GETDETAIL.

From here you will get the Shopping cart Item Guid in E_ITEM-SRC_GUID. You can again pass this guid in the table CRMD_ORDERADM_I and get the parent guid.

Pass this parent guid in table CRMD_ORDERADM_H to get the shopping cart number. Its stored in the OBJECT_ID field.

There is another way to find out the shopping cart number:

Pass the PO number in FM BBP_PD_PO_GETDETAIL

Check the E_HEADER_REL, when the value of the field OBJTYPE_A = BUS2121 then the field GUID_A will contain the header guid of the shopping cart.

Use this guid to get the SC number from table CRMD_ORDERADM_H.

Hope this helps.

Thanks,

Pradeep