Question Re: Cost Center in SRM in Spend Management Q&A

Cost Center in SRM

Former Member — Fri, 03 Jun 2011 06:06:08 GMT

Hi Friends,

In which database table the cost centers are stored in srm?

Thanks,

Atanu

Re: Cost Center in SRM

Former Member — Fri, 03 Jun 2011 06:15:58 GMT

Hi,

Pl check table BBP_PDACC. It has a field COST_CTR.

Regards,

Nikhil

Re: Cost Center in SRM

Former Member — Fri, 03 Jun 2011 06:30:15 GMT

But it is asking for a "GUID"?from where we will get this "GUID"?

Thanks

Atanu

Re: Cost Center in SRM

Former Member — Fri, 03 Jun 2011 06:39:22 GMT

What is your requirement? Do you want to find cost centres in ordered SC?

Go to BBP_PD, click on the Accounting section, you will get a GUID. Put this under BBP_PDACC.

Or else use function module BBP_PD_SC_GETDETAIL, provide your SC number in import parameter I_OBJECT_ID. You will get all your accounting details under table E_ACCOUNT. This is the best option if you are developing a report

Regards,

Nikhil

Edited by: Nikhil RGupta on Jun 3, 2011 8:53 AM

Re: Cost Center in SRM

Former Member — Fri, 03 Jun 2011 06:41:07 GMT

Hi ,

1. If you want to get cost centers of a SC or PO then you can get from BBP_PDACC table. You can get GUID from SC or PO from BBP_PD in accoutning details.

2.If you want to see all Cost center in SRM for a cost center attribute .check this view HRV1222B .

regards,

Devi

Re: Cost Center in SRM

Former Member — Fri, 03 Jun 2011 07:01:23 GMT

Hi Atanu,

process:

Please input shopping cart number in table CRMD_ORDERADM_H and get GUID

Please input this GUID in field CRMD_ORDERADM_H of table CRMD_ORDERADM_H and get field GUID

Please input this new GUID in field GUID_HI of table BBP_PDVIEW_ACC and you will get cost center in field COST CTR.

regards,

Parag.

Re: Cost Center in SRM

Former Member — Fri, 03 Jun 2011 07:02:53 GMT

Hi Atanu,

Corrected:

here is the process:

Please input shopping cart number in table CRMD_ORDERADM_H and get GUID

Please input this GUID in field HEADER of table CRMD_ORDERADM_I and get field GUID

Please input this new GUID in field GUID_HI of table BBP_PDVIEW_ACC and you will get cost center in field COST CTR.

Please note SRM does not store master data of cost centers

regards,

Parag.