How to distingush different shopping carts

[Former Member]

Hi,

We have the option of creating shopping carts using Catalog, Free text, Order, Request & Limit. Now we get a requirement to

develop a report. Report should display how many shopping carts are created on the given day based on the the above mentioned order types and its total value. Typically the o/p should look like this.

Order type No. of orders Total value

Catalog 10 $5,500

Free text 17 $15,500

Limit 4 $1,500

Order 1 $365

Request 3 $950

Is there any table filed avaliable to distinguish the SCs created based on the order type? Please suggest..

Regards

Prasad

[masa_139 · Accepted solution]

Hi,

BBP_PD transaction helps you.

For example, catalog item has CATALOG ID, free text does not have MATERIAL ID.

Regards,

Masa

[Former Member]

Thanks for the replies.

Yes, we can differentiate SCs created via catalog, free text and limit. But how to find the SCs created using "Request" &

"Order"?

Regards

Prasad

[Former Member]

Hi. What is the difference with those? Do the Purchase Orders look any different to a normal order?

Regards,

Dave.

[Former Member]

Yes, we can differentiate SCs created via catalog, free text and limit. But how to find the SCs created using "Request" &
"Order"? 

Both "request" and "order" type of SC items are related to services, which in turn means they are hierarchical item structures. I'd recommend that you test in your system by creating an SC with 5 items each with one type you want to investigate. Save the SC and then go to transaction BBP_PD as Masa suggested. Analyze the items from that transaction, especially their representation in BBP_PDIGP table. You should be able to distinguish the differences technically there.

[Former Member]

Hi Yang,

We can identify "order" and "Request" shopping carts with the description of the hierarchial line item.

Request would be the description for "Request" shopping cart line.

In case of order, "Purchase order" is the description of the SC line.

Thanks for all your inputs.

Points are awarded.

Regards

Prasad

[Former Member]

The SAP SRM standard reports may help you to meet your requirement

use below T codes

BBP_BW_SC3 Shopping Carts per Product

BBP_BW_SC4 Shopping Carts per Cost Center

[Former Member]

Hi. Masa is correct, look in BBP_PD, it gives you the table names.

Catalogue items have field "catalogid" filled in, limit items have item category "LIMI".

Regards,

Dave.