Cost center summary report

[former_member586162]

My client want cost center summary report based on Cost element, Business area, Document type and Cost center combination. And their cost center length is also not fixed. I have checked in COEP table, in there I'm getting almost all the things but I'm not getting cost center and document type. Is there any other table which I can use for my reference. Please suggest me it is very urgent.

[iklovski]

Hi,

What is exactly 'opening balance' on a cost centre? Cost centres are relevant only for profit&loss transactions; hence, there is no balances posted on them, but merely a summary of the transactions in a given period. Anyway, if none of the standard reports on cost centres, and there is plenty, satisfies your needs, you have to develop your own. Either with Report Painter, or if your report is more complicated, with ABAP. In this last case, you should work with COEP, but also with COBK (header), which stores information about document type.

Regards,

Eli

P.S. Obviously, you have info about cost centre in COEP; it is stored in OBJNR field.

[former_member586162]

Thanks Eli for your response.

The problem is with fetching cost center value only from Object number as cost center digit is not fixed in client system. I have already discussed about this alternative with ABAP team and they are denying that fetching Cost center value from Object number is not possible because there is no fixed range.

Is there any other alternative for it like any other table to fetch the data.

[iklovski]

Even if the length is not constant, what is the problem? OBJNR for cost centre would always be 'KS' and 4 characters of company code, followed by a cost centre itself.

[adamu_nuhu]

Hi,

you can also use table ONRKS for link between objnr/kostl.

[TammyPowlas]

Hi Ratul - I would look at transaction KSB1N as there is a lot you can do with the standard transaction

[former_member586162]

Hi Tammy,

Thanks for replying to my post.

I will surely look into KSB1N. But the things is client want opening balance, transaction during the given period in selection screen and closing balance.

So apart from COEP table is there any other table to fetch Cost center actual data?

[TammyPowlas]

Are you developing a new report? Have you looked at all the existing CO reports in report painter/report writer?

[former_member586162]

Yes Tammy we are developing new Z report. I checked the feasibility with report painter and report writer also but in this Z report there are more than 1 lead column so that is not possible with report Painter and report writer.

[former_member586162]

Is there any other way to get the opening balance, transaction during the period and closing balance for the combination of Cost element, Cost center, Business area and Document type?

Please note that the cost center length is also not fixed in client system. Some cost center is of 5 digit and some of the cost center is of 6 and 7 Digits.