fields for budget/actual/commitment of cost centre of S_ALR_87013019

[Former Member]

Dear Experts,

I want to create a custom S_ALR_87013019   of cost center ,any one please tell me the tables and field names for  actual,budget,  assigned, committed, assigned,available.

Regards,

Santhi

[Former Member]

Hi,

Check the table RPSCO and COEP.

Hope this helps.

[raymond_giuseppi]

Did you execute some SQL traces to get the list of tables?

• Try transactions of the Accounting, Controlling, Cost Center Accounting, Information System  with SQL trace
• Also if detail not required better use COSS/COSP total tables than COEP or other detail tables)

Regards,

Raymond

[Former Member]

Hi Gaurav,

Thanks for your reply ,but rpsco we find the budget field only ,please tell me the table name for all fields.

I am writing a custom report which will give output like S_ALR_87013648 report.

I need to obtain values for  following columns,

Cost centers       Actual          Budget        Commitment       Assigned        Available

Regards

Santhi

[former_member197132]

Hi Santhi,

Variable	Reference-Field / Type	Comments
Sanction Budget	(addition of fields) RPSCO-wlp001 to wlp016	Value type should be ‘41’
Actual Cost	(addition of fields)RPSCO-wlp001 to wlp016	Value type should be ‘04’ and ‘11’
Commitment	addition of fields)RPSCO-wlp001 to wlp016	value type should be ‘21’ ‘22’23’ and ‘26’ this value type belong to Commitment.
Available cost	Actual Cost + Commitment

[raymond_giuseppi]

Same WRTTP value type (values of domain CO_WRTTP) are also available in COSS (COSP) table for objects not related to Project System.

NB: When identifying OBJNR use CSKS-OBJNR (KS/Area/CC) for cost center, you may also require the CCSL-OBJNR (KL/Area/CC/ActType) for cost center/Activity type too.

Regards,

Raymond

[Former Member]

Hi Shailendra,

Thank For your Reply ,It's Help Me a lot But I didn't understand  how we can relate cost center to  RPSCO fields . Please tell me any related field is available  for  cost centre ,controlling area to RPSCO fields.

Regards,

Santhi

[former_member197132]

Hi Santhi,

1. Get the Routing number of operation in the order from table CAUFV, this can be

achieved by giving reference of project definition.  We want this Routing number

because we need to pass this Routing number to AFVC table to get the network

object number.

2. In order to bring cost we have to use reference of WBS and get the network created under the

WBS, this can be achieved by giving the reference of routing number that we get

from step 1 into the table AFVC and we are getting network object number which we

will pass in table RPSCO and get the actual line items.

Regards,

Shailendra Karada

[raymond_giuseppi]

AFAIK RPSCO is only containing amounts related to projects and their hierarchy. So most cost centers won't be found in it.

Regards,

Raymond

[Former Member]

Hi Shailendra ,

Thanks for your Inputs , It helps me alot.

Thanks&Regards,

Santhi

[Former Member]

Hi Raymond,

Thanks for your Inputs , It helps me alot.

Thanks&Regards,

Santhi

[former_member197132]

Hi Santhi,

Mark Helpful / Correct. It will useful for other also.

Thanks.

[Former Member]

Hi Shailendra,

i am creating custom  s_alr_87013648

for my requirement i am using csks ,coep tables  .

1.                   csks(controlling area , datab, datbi, cost center)
2.                 coep (objnr , gjahr  )

                     based on wrttp (04,41) we get budget field  wobgtr

its corrcet process or not , because compare to standard some cost centers will give correct output but some cost centers cost element we didnt find in coep

so, please tell me which table field store the budget, actual values  .

Thanks

Santhi.

[former_member197132]

Hi Santhi,

What are the input parameters ?

[Former Member]

Hi Shailendra ,

I am Giving Controlling Area , Cost Center , Fiscal Year , Period are inputs.

Thanks & Regards

Santhi

[raymond_giuseppi]

COEP is not the only detail table, when COSS and COSP are total table and contain all values (eccept for project PS which may use alsi COSSP and COSPP)

Question : Can you findthe  mlssing cost centers in COSS/COSP, are those values carried by cost center or by cost center/activity ?

Regards,

Raymond