Cost center / Element report downloadable to excel


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


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.
Edited by: Tim Schmid on Jul 4, 2011 5:26 PM

October 11, 2015

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 se

Cost Center wise Report

Hi, How to display monthly expenditure related to a Cost Center. I tried the standard report but there it is showing accumulatived figure for 12 months. But I want to show monthly expenditure related to a Cost Center. General selections: Controlling

Cost Center Planing Report Layout KP65 - Fiscal Year Variable Error

Hi All, I am creating a layout for Cost Center Planing in KP65. I selected Fiscal Year Variable GJAHR. In Tex Maintenance when I give "1st Qtr $GJAHR" and save I am getting the following error. "Text variable &$GJAHR has an invalid repl

Doubt on ALV report download to EXCEL

Hi All, i have written a report with ALV_GRID FM, by default we get the option to download the output to excel. But when we click on the download to excel, it displays the output in the frist page, but it also opens so many pages like format, header,

WAD reports: download to excel

Hi, When you download your report data to excel, is there some kind of option available so that the user cannot change the data inside the excel? Or some kind of thing in the document that states that this data is original/changed. Does such a mechan

Oracle Reports Download to Excel

Can my users download an Oracle report under 6.0 to MSExcel? Do I need to specify a particular report file format to facilitate this?hi there is a way to download to csv (comma seperated) file and that is by specifying the file format as DELIMITED an

Can S_PLO_86000028 Financial Statement report generate Cost-center report?

Dear Experts, I've tried with S_PLO_86000028  Financial Statement report and it could generate report based on Profit Center but when I tried with Cost Center, it show no record.  Can this report generate cost center wise report? regards, AbrahamHi S

Cost Center wise profitability

Hi All, We want the profitability analysis cost center wise. Is it possible? If yes, how the Revenue value, sales quantity and the COGS value can be derived for the cost center wise report in KE30. Please help me as my client has asked this requireme

Report on cost center

Hi all, In standard SAP Controlling,There is a report called cost center actual/plan/variance (s_alr_87013611),this report you can also see in excel ,same time you can down load to excel .If you down load in to excel ,SAP system only capable of downl

Forecast for planning over the Cost element/Cost center with KP06

Hi all I'm searching a idea: one of our chief controller need to insert a "forecast" of budget inserted over the various cost elements/cost centers using the transaction KP06. THe problem is that he don't want lost the budget because he can need

Cost Center Vendor Wise Report

Hi All, I have a report requirement which should show Cost Center, Cost element, Vendor, Document Number,Ref Doc No, Doc text. I tried searching in the Standard reports but i could just find a series of  Actual/Plan Controlling reports based on CCA c

Report Writer Missing Data for Cost Center+Investment Internal Order

Hi Gurus, I have met a problem on Report writer. T-code KSBB -> Report for Cost Center Group by Cost Elements in diff months. The report can be drilled down to call KSB1 to give line items on the cost element by cost center/group. The problem is the

Reporting Direct Production Cost Center Over/Under Absorption

Hi, I am trying to find a way to report Manufacturing Cost Center Over/Under Absorption in a similar way COGS are reported in CO-PA. I mean - I would like to breakdown Direct Manufacturing Cost Center Over/Under Absorption into cost elements (just li

Report pianter - Responsible cost center

I have a requirement where in the user wants to look at all the internal orders that fall under the same reponsible cost center. Can anyone guide me how to get there using report painter?hi maheedhar, Report Painter Key Features of Report Painter Pre

S_ALR_87013643 Cost Center Report - Range Orders

Hi, I am executing T Code S_ALR_87013643, which is based on Cost Center, Cost Element and Order. I am restricting the selection for 1 Production cost center and 1 Production Order. The cost center section of the report is displaying costs against the

Alternative account number in cost center report

Hi, the standard SAP cost center report S_ALR_87013611, displays Actual cost & plan cost against cost elements. the requirement is to display the values against Alternative account number(SKB1-ALTKT). this report has been generated through painter, i

Is there any list / report to see the material posted to COST Center

Hi ... I have created a Purchase Order for raw material with Account category "K" cost center and prepared a goods receipts for that. As I was expecting this GR doesn't increase the stock of Plant mentioned in Purchase Order But I was expecting

Cost center and Cost element.

Hi all, I am in an urgent need to understand the relation between cost center and cost element. Please provide me with their individual information as well as the link they share. An existing relationship table between the two, if any, ...then plz me

Report Painter- Cost Center/order value

Dear All. My user want the report. All the Cost Center value & order value with Cost Element. I developed the same in the system by using the library "1VK". which one is good & working fine. User also want the value of Expense GL ( Do No

How to assign cost center to cost element.

Hello, Can any one please guide how to assign cost center to cost element. Thanks in Advance.. Have a nice day...Hi , There are 3 ways : 1. Default the cost center in cost element - Ka02 - account assingment tab enter cost center . 2. Use OKB9 for di