Which table the Shoppinng Cart data is being stored

[Former Member]

Hi,

Which table the Shopping Cart data is being stored. My client want to delete some of the Shopping Carts in order to improve the system performance.

Thanks and Regards,

Ramesh

[Former Member · Accepted solution]

Hi,

All of the SC you will find in transaction BBP_PD for object BUS2121.

If you want to delete some of SC's try to use some of this FM's:

BBP_PD_SC_DB_DELETE

BBP_PD_SC_DB_DELETE_MULTI

BBP_PD_SC_DELETE_FOR_ARCH

BBP_PD_SC_ITEM_DELETE

BBP_SC_DELETE_ITEM

It may not be easy because SC can have a refference to another document for example PO.

Regards,

Marcin Gajewski

Please reward points for helpful answers.

[Former Member · Accepted solution]

Hi Mercin,

We are using EBP 3.0 system. Here BBP_PD transaction does not exist. In this version we do not have provision to Archive. My client wants to reduce the data. Pl give me suggestion. My first doubt is which table entry can we see the Shopping Cart Details for EBP 3.0 version

Thanks and Regards,

Ramesh

[Former Member]

Hi

Which SRM versiona re you using ? Why you want to delete them, why not instead archive the data ?

<b>Anyways, Please go through follwing links, which will definitely help.</b>

<u>Use BUS2121 (Shopping carts (SC)) as object filter type in the table

CRMD_ORDERADM_H (SC- Header Data)

and

CRMD_ORDERADM_I (SC - Item level Data)</u>

<b>Other related links -></b>

Regards

- Atul

[Former Member]

Hi Atul,

We are using SRM 1.0 version. In this version there is no provision to Archive the table entries. I want to imrove my system performance. What is the best way to reduce the burden of the system.

Thanks and Regards,

Ramesh

[Former Member]

Hi Ramkesh,

Try to migrate date to another client. Create client for example 011 and migrate all transaction data to this client.

You can also use DEL_IND index in SC. SC with this index will be not visible to users.

Regards,

Marcin

Message was edited by:

Marcin Gajewski

[Former Member]

Hi

<u>Try this link, which might help.</u>

Regards

- Atul