Internal order reports company code wise

[Former Member]

Hi All,

our client is asking  for the report  same lilke S_ALR_87013019 ( List: Budget/Actual/Commitments) for compny code wise ,

so we copied same report and inserted company code also throuh report painter,while executing system not allowing it is showing error

cany any body sugget how to add company code as input parameter to the CO report.or is there any anthor way to produce compny code wise CO reperots.

Thanks &Regards

Sudha

[ajaycwa1981]

Hi

how did you manage to add the comp code field.. I checked in GRR1, I could not find the Co code as a char in here..

You can also explore creating a search help for the Int Order field so that it returns all the IOs belonging to a comp code

br, Ajay M

[iklovski]

Just a small additional remark from my side: I referred to all CO reports based on CCSS table. There, company code is available. S_ALR_87013019 report is not based on CCSS; so, indeed, adding company code won't be possible there. You can do one of the following: try to modify reporting table RWCOOM (via GRCT) by adding company code to it or create groups in internal orders (KOH1) by company code. I cannot gurantee the success in the first case, but creating groups sounds to me as a reasonable workaround.

[Former Member]

Hi Ajay ,

S_ALR_87013019 ( List: Budget/Actual/Commitments) report is  based on RWCOOM  structure, for this structure we added company code field at table level. in 602 library we taken BUKRS as characteristic.

so i am able to add company code as a input parameter.

but while executing system throwing the below error

Characteristic BUKRS cannot be combined with key figures

Message no. GR410

Diagnosis

Characteristic BUKRS is being used in a report with a key figure that does not match this characteristic.

System Response

The system cancels generation.

Procedure

Check the report definition: the key figures used must be compatible with characteristic BUKRS. For examples of useful combinations of characteristics and key figures, see the SAP standard reports.

Technical explanation: The Report Writer table assigned to the report is defined as a view with multiple database tables (somewhat similar to Report Writer table CCSS) and a key figure used in the report refers to a database table which does not contain characteristic BUKRS.

Example 1 for table CCSS: If the 'cost' or 'quantity' key figures are used in a report (referring to tables COSP and COSS), you cannot use the 'Statistical key figure' (only occurs in table COSR) characteristic in the rows. On the contrary, using the 'Cost element' (tables COSP and COSS) characteristic is not permitted for the 'Statistical quantity' (table COSR) key figure.

Example 2 for table CCSS: If a report only displays line item data (key figures IE... or PE...), you cannot use the 'PERBL' characteristic, because it is only valid for summary data. You have to use the 'PERIO' characteristic for line item data.

Regards

uma

[ajaycwa1981]

Hi

I second your opinion Eli... I was also wondering that a search help can be created for the Internal orders based on company code

In case the option to go with groups is chosen, I opine that a SET be created in GS01 and it can be periodically updated with a custom program with the IOs created in that period

Or, the simplest option will be to have Order types per company code... This will simplify everyone's life

br, Ajay M

[iklovski]

Hi,

There is no problem to add company code to this type of report. What is the error that you receive?

Regards,

Eli