SRM Shopping cart and PO tables link

[Former Member]

HI All,

I have created Shopping cart in SRM  say 123 and its follow on document is created say 456

Now based on PO: 456 information in ECC6 I need to get SRM shopping cart: 123

I am writing RFC  in ECC to get SC based on PO

My Question is what is the table which stores PO and Shopping cat “or how to link both at SRM

Thanks

Gopal

[Former Member · Accepted solution]

Hi Gopal,

Please correct my understanding. You want to get SC number from the backend PO/PR number in SRM. Right?

In SRM their is no direct table showing SC number as well as PO information.

1. Go to this table - BBP_PDBEI --> Pass the PO and Logical system

You will get the Object GUID (SC) ITEM level.

2. Then GO to this table --> CRMD_ORDERADM_I --> Pass this Object GUID and you will get the header GUID.

3.    Finally Go to this table --> CRMD_ORDERADM_h --> Pass the header GUID you will the SC number for the PO.

4. We also have a report where the relationship between PO and SC can be seen directly -->

SE38 --> BBP_BW_SC2

I hope this will be helpful!

Thanks

From RBEI,

Snehal

[konstantin_anikeev · Accepted solution]

Hi Shehal,

will not work if more than one PO created from sc item.

BBP_PDBEI holds only the last one.

Regards

Konstantin

[Yateesh_h · Accepted solution]

Hi Konstantin,

Could you please list a few scenarios when multiple POs are created from a SC line item.

Regards,

Yateesh

[konstantin_anikeev · Accepted solution]

Hi, Yateesh,

it's typical scenarios for sourcing. In case if quantity reduced, or po deleted after creation.

Regards

Konstantin

[Former Member]

Hi Gopal,

Yes, Yateesh is right. We are using Tracking number line item field in PR/PO to store the SC number. Please see the screen shot. So we pass the number in the Reqmt No. field at line item level.

From RBEI,

Snehal

[hansbauerj]

Thanks, so I found it in EKPO, field BEDNR!

[suresh_murugan]

Hi Gopal,

Follow the below steps to retrieve the Shopping cart number from the PO number just by querying the SRM tables.

1. Pass the PO number to the Object ID field in CRMD_ORDERADM_I table and get the PO GUID.

2. Pass the PO GUID to the GUID field in BBP_PDIGP table and get the SRC_GUID value. This    SRC_GUID field is nothing but the the shopping cart GUID .

3. Pass the SRC_GUID value to the CRMD_ORDERADM_I table and get the Shopping cart number.

Regards,

Suresh

[Yateesh_h]

Hi Gopal,

One other way could be to use one of the PO line item fields to store the Shopping cart number. This way the shopping cart number will be saved in the ECC PO and will be easily available.

Hope this helps

Cheers,

Yateesh

[Former Member]

Hi Yateesh, could you explain me how to do that? i am looking into my ECC system and i am not geeting any number in that field.

Thanks.

[Former Member]

Fuction: BBP_PD_PO_GETDETAIL

Tables:

E_HEADER_REL

E_ITMLIM_REL

Regards