Skip to Content
author's profile photo Former Member
Former Member

Cost center / Element report downloadable to excel

Hi

does anybody know of a cost center/elements total report by period?

s_alr_87013613 has the information but ℹ️ can not get both values (cost center and elements) in columns that it is usable for excel.

I looked deeply and could not find anything.

I searched also the forums and could not find a valid awnser.

My only workaround is run KSB1 and create a PIVOT which does not really make sense

also there might be many line items.

Anybody else has an idea?

I can not believe it is not available. It seems like such a basic report.

Thanks so much for your support

Cheers

Tim

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 01, 2011 at 12:59 PM

    Unfortunately, report painter doesn't allow for two key columns (cost element and cost center).

    I myself am going to create a Query (SQ01) on table COEP with a "statistics" with fields cost element and cost center, thus showing only totals. Through the report/report interface I will link KSB1 to jump to detailed line items when necessary.

    Regards

    Nikolas

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Nikolas,

      thanks for the help.

      I decided to make a query on COSP (not COEP due to runtime).

      Cost object i splitt with local fields and field[[first digit:last digit]] function if there is another person looking for the same.

      Cheers

      Tim

      Edited by: Tim Schmid on Jul 4, 2011 5:26 PM

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.