on 06-03-2011 7:06 AM
Hi Friends,
In which database table the cost centers are stored in srm?
Thanks,
Atanu
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
But it is asking for a "GUID"?from where we will get this "GUID"?
Thanks
Atanu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Hi,
Pl check table BBP_PDACC. It has a field COST_CTR.
Regards,
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.