Shopping Cart Tables

[Former Member]

Hi all,

Can i know in which tables of EBP system the shopping cart details are stored.

I want the info like shopping cart created date, Approved date, Approved by and so on.

Its urgent and all the valuable replies are highly appreciated.

Regards,

Ravi G

[Former Member]

Hi,

BBP_PD is one transation for all the associated tables.

Sometimes you have the SC no. in the table, sometimes GUID and some of the times reference GUID.

Cheers

Mick

[Former Member]

This message was moderated.

[Former Member]

HI Atul,

Please send them to the following id.

gunda.ravi@wipro.com

It will be a great help to me.

Regards,

Ravi G

[Former Member]

Ravi,

You can find Shopping Cart Header details in table CRMD_ORDERADM_H and Item details in CRMD_ORDERADM_I.

Coming to the approval details of the Shopping cart, please get the parent workitem ID from BBP_PD transaction in section Workflow Item and pass this in the parameter IV_MAIN_WORKITEM_ID and a value of 'X' in another Parameter IV_READ_FROM_DB of the function module 'BBP_WFL_DIN_APPR_CONTAINER_GET' and execute it.

You will find list of approvers and dates in the table ET_APPROVAL_AGENTS of this function module.

Hope this helps.

Please award points if the above solution is helpful to you.

Thanks & Regards,

Venkat

[Former Member]

Hi Ravi,

You get the required details regarding the shopping cart or for that matter any other business object using BBP_PD

You can also use function module BBP_PD_SC_GETDETAIL using SE37 txn for getting the specific shopping cart details.

Hope this resolves your issue.

Award points for helpful answers.

Rgds,

Teja