Table to find Shoping Cart Vs Purchase Order

[Former Member]

Hi Friends

I try to find a table in SRM to see a Shopping Cart and Purchase Order (SC vs PO, subsequent documents) , actually I use BI but is not clear for me

Thank a lot!!

Regards!!

[ricardo_cavedini]

Hello,

You can check the following relationship if you have Extended classic scenario.

- Go to SE16, table SRRELROLES and type the SC GUID;

- Take the SC ROLEID and check table BBP_PDBINREL;

- Take the PO ROLEID (ROLE_B) and go back to SRRELROLES table;

- Input ROLE_B as ROLEID and you will get the PO GUID.

Kind regards,

Ricardo

[Former Member]

Hello

Get the Shopping cart Header Guid from CRMD_ORDERADM_H by passing the Object_id as the Shopping cart #.

Go to CRMD_ORDERADM_I with Header = Above Guid and get all the item Guids.

Go to BBP_PDBEI with each item Guid , you will get the BE_OBJECT_TYPE & BE_OBJECT_ID .

If it is extended classic scenario, Backend will be SRM.

If classic , it will be ECC.

You will get the PO or PR Number here.

If it is an SRM document ( extended classic), you can go once again to CRMD_ORDERADM_H and get the GUID.

Thanks

Kedar