SRM Account Assignment Tables

[Former Member]

Hi Guys,

Need some help. I'm unable to locate the table from which I can get the SC number, Item number and correcponding accounting details like cost center and G/L code.

From table 'CRMD_ORDERADM_H' I can get GUID. Then with this GUID, I can get the item details in table 'CRMD_ORDERADM_I'. But I can't find a link to table 'BBP_PDACC'.

GUID in table 'BBP_PDACC' are not found in the other 2 tables. Is there any way by which I can get it?

Thanks

Debashish

[Former Member]

Hi,

If You want to get accounting data from table BBP_PDACC You must do following:

1. from table CRMD_ORDERADM_I get GUID of item

2. from table CRMD_LINK insert item GUID into GUID_HI field like that:

select guid_set into lv_acc_guid 
             from crmd_link 
             where guid_hi eq lv_item_guid
             and objtype_hi eq '06'
             and objtype_set eq '31'

Object type 06 is item data and 31 - accounting. You can get all of objects from table CRMC_OBJECTS

3. from table CRMD_LINK You get lv_acc_guid. Use this GUID on table BBP_PDACC to get accounting data.

Regards,

Marcin

please reward points for helpful answer

[former_member206441]

Hi Marcin,

Your solution works perfect. Thank you.

Thanks & Regards

Arun.K.P

[Former Member]

Hello

If you want to know the corresponding accounting details like cost center and G/L code using SC Number, You can use the FM: BBP_PD_SC_GETDETAIL.

You can get to accounting data from Table E_Account.

Thank you

Best Regards

SH