cancel
Showing results for 
Search instead for 
Did you mean: 

Table for viewing SHC details and Confirmation details

Former Member
0 Kudos

Hi All,

I would like to ask in which table can i get SHC details in SRM (SHC Num, Company Code, Business Area, Created By)

I would also like to get same details for Confirmations in SRM.

Thanks!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Go to T.code: BBP_PD

Enter the object type : BUS 2121 for shopping cart

and execute and click on the shopping cart no

You can see all the tables for the shopping cart no.

For Confirmation check :BBP_PDCON this is also appearing in the above t.code

Please check and reply

Regards

Ganesh Kumar .G

Former Member
0 Kudos

Hi,

BBP_PDCON does not have selection criteria for date. I need a table for Conf and SHC that will output the details above for SHC/Conf created on the date i will provide.

Former Member
0 Kudos

CRMD_ORDERADM_H have document header details. Where you can get created by, document number, details.

Best Regards

Lauren

Former Member
0 Kudos

I already tried that table but it does not contain the plant code or company code.

Former Member
0 Kudos

Hi, dear zippy21

please check table: BBP_PDBEI which has company code and plant information of backend.

Regards

Lauren

Former Member
0 Kudos

Hi Lauren,

Purpose is given a specific period of time (i.e. 01/01/2009 to 12/31/2009), i can get all SHC and Confirmations with the details stated above (SHC/Conf #, Date Created, Created By, Plant, BA)

thanks,

Zippy21

Former Member
0 Kudos

Hi,

Is there a joining field for CRMD_ORDERADM_H and BBP_PDBEI ?

Thanks

Former Member
0 Kudos

Hi,

Fetch GUID from CRMD_ORDERADM_H Table by giving OBJECT_ID.

Fetch GUID from CRMD_ORDERADM_I Table Where HEADER = fetched guid.

Use GUID to the GUID of BBP_PDBEI for fetching other values.

Regards,

Neelima