How is SC & PO Linked in database.

[pankajs_dwivedi]

Hi All,

We create the Shopping Cart and then using SC no we create the Purchase Order PO No.

I want to know from the PO No how can I get SC No.

I can have seen lot of function modules but no one gives us that.

If anybody have any idea on this please let me know.

If any tables are linked at the backend please let me know.

Thanks & Regards,

Pankaj Dwivedi

[Former Member · Accepted solution]

Hi

Try using the FM BBP_PD_PO_DOC_FLOW.

Input H_OBJECT_T as BUS2201 & H_GUID as GUID of PO header.

Rgds

Reddy

[Former Member · Accepted solution]

Hi,

Table BBP_PDBEI FIELD BE_OBJECT_ID will give you all PO items GUID. Use this guid in table BBP_CRMD_ORDERADM_I TO get the parent or header guid and from the header guid use table CRMD_ORDERADM_H TO get the shopping cart number .

hope this help you !!!

Regards

Iftekhar Alam

[Former Member]

Hi Pankaj,

Use FM BBP_PD_GETHISTORY to get the details.

Following inputs needs to provided.

H_OBJECT_T as BUS2203

H_GUID as CONF guid

I_OBJECT_T as BUS2203001

I_GUID as item guid

OBJECT_ID as CONF number

NUMBER_INT as item Number

LOGSYS as BACKEND Logical system name.

Regards,

Naresh.