Report Painter - How to identity statistical orders in a Cost Center Report

[Former Member]

Hello,

currently I am in the process of building a cost center report based on reporting tabel CCSS.

This report should list all primary and secondary costs which are charged to a specific cost center/cost center group .

The cost center or cost center group is given in the general data selection.

All direct primary cost postings are identified in rows like this:

- Cost Element (SET): cost element group A1, A2,...Axx

- Business Transaction Type: COIN

All primary cost postings deriving from (real) internal orders are identified like this:

- Cost Element: 1 to 9999999999

- Business Transaction: KOAO

- Partner object number: 0 to 99999999

Now here is the problem:

The controlling department requests to identify all primary cost postings to the given cost center which have been postet to a statistical internal order at the same time. The most part of the primary costs have been directly postet to the cost center in the Additioanal Account Assignments. But some have been posted to the cost center and at the same time to a statistical internal order.

Looking into BSEG I can quickly identify these line items as they have a value in BSEG-KOSTL and BSEG-AUFNR.

How can I select these items in a report painter report?

I would like to separate all items whith connection to statistical int. orders from those with no connection to internal ordes.

Thanks for your help!

[iklovski · Accepted solution]

Hi,

You can distinguish it by Value type parameter: 4 - actual, 11 - statistical.

Regards,

Eli

[Former Member]

Dear Elli,

Dear SAP-Gurus,

once again, thank you for your quick reply.

You hints and remarks are very much appeciated.

My problem seems to be slightly more complicated than what I had expected.

All postings to the cost center/cost center group are actual postings. The cost center is the "real" cost element, there are no postings of value type 11 here.

Most postings have the cost center as the only cost element, but others additionally mention a statistical order.

My goal is to seperate those postings to the cost center [as (real) cost element] plus the statistical order from those with only the cost center.

I would also like to sort these postings by the order number.

I could easily write two reports:

One for the cost center and another one only for the statistical orders. The latter would use value type parameter 11 (as you proposed!). Unfortunately, I do not know all order numbers tied to the cost center. As table BSEG is not suitable for SAP Query, I run into deep problems here.

I know I have problem in the design of my report here and I would like to sort out, which options I have.

Is Report Painter a suitable tool for me here anyway?

Thanks again!

Karsten

[Former Member]

Hello,

I can only set the value type in columns not in rows. as far as I can see.

How do I manage that?

Can you give me a little more detail?

Thanks in advance!

[iklovski]

Hi,

Well, I was thinking of making two columns, where you can filter actual values and statistical ones accordingly. Then, you'll be able to see whether the postings to cost element X have statistical postings. You can also make a calculated column subtracting statistical from the actual, thus getting the amount which was posted only actual.

Regards,

Eli