Cost center / Element report downloadable to excel

[Former Member]

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

[Former Member]

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

[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