Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2015 at 07:17 AM

    Hi,

    Check the table RPSCO and COEP.

    Hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2015 at 07:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2015 at 07:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 30, 2015 at 10:59 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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