SC Tables

[Former Member]

Hi ,

What are the tables that store SC details other than CRMD_ORDERADM_H.

I am trying to generate a report for SC details depend upon user created, time created using query reoprt t(SQVI). When i try to generate a report, the report dosen't give all the SC's which are in CRMD_ORDERADM_H like it gives 40 records but when i check in table it gives more than 40 records.

can any one suggest on this

sameer

[Former Member · Accepted solution]

Hello,

Please reply if you get the desired data in the tables.

regards,

Prashant Rathore.

[Former Member]

Hello,

try

BBP_PD_SC_GETDETAIL - Shopping Cart

BBP_PD_PO_GETDETAIL - Purchase Order

BBP_PD_CONF_GETDETAIL - SRM Confirmations

BBP_PD_INV_GETDETAIL - Invoice and Credit Memo

I hope this will solve your queries.

regards,

Prashant Rathore.

[Former Member]

Run the transaction BBP_PD giving SC number and the SC object type - that will list all the SC details and the SC related table names - click on the output of BBP_PD transaction to see all details. Award points if helpful.