Table for viewing SHC details and Confirmation details

[Former Member]

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!

[Former Member]

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

Best Regards

Lauren

[Former Member]

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

[Former Member]

Hi, dear zippy21

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

Regards

Lauren

[Former Member]

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]

Hi,

Is there a joining field for CRMD_ORDERADM_H and BBP_PDBEI ?

Thanks

[Former Member]

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