CO reports with different account assignmnt objects
[account with] [be different with] [business objects] [different with]
Symptom
If a report for reporting table CCSS contains different account assignment objects (cost center, order, WBS element, project, object number), unanticipated results may occur.
Example:
A report contains a section with cost centers and a section with orders. For the cost centers and for the orders, variables are included in the report definition.Definition of 1st section:
Cost center: &1KOSETDefinition of 2nd section:
Order: &6-AUFGR
If you make selections for the cost centers and the orders on the selection screen, the values are displayed correctly in the report.
If you do not make any selections for the cost centers (or orders) on the selection screen, then the system displays the same amounts in the orders (or cost centers) section as in the cost centers (or orders) section.
Additional key words
account assignment object —– SUPPORTGUIDE 20010411140028 —–
REPORTWRITER, SGRW_AMOUNT, SGRW_DATA, SGRW_DOCU_CONS_NOTE, SGRW_DATAMODEL
SGRW_OM, SGRW_PS
Cause and prerequisites
This behavior is in keeping with the program logic of Report Writer when it interacts with table CCSS. In order to elucidate this, here is some technical background information:
a) In the totals tables of CO, all account assignment objects (cost center, order, WBS element, project) are converted into an object number and stored under this object number.b) A data record always contains exactly one actual account assignment object (see also Note 41103). Consequently, other account assignment objects have the values ‘ ‘ (SPACE). In other words, if a data record has been posted for the cost center account assignment object, the order number for this data record is ‘ ‘ (SPACE).c) In the selection of Report Writer reports, the system determines the object numbers from the respective selections on the account assignment objects selection screen and it uses these object numbers for selecting the records from the database.d) If you do not make selections for a group variable (set variable) on the selection screen, then this denotes ‘All values’.e) The selection for ‘All values’ also contains the value ‘ ‘ (SPACE).f) In the output of the Report Writer report, the data records selected from the database are allocated to the rows of the report.
If you do not make a selection for the ‘Orders’ variable, then the Report Writer attempts to allocate all selected data records to the ‘Orders’ section. This is correct, because all of the data records selected for the cost centers implicitly have ‘ ‘ (SPACE) as their order number.
Solution
If different account assignment objects are contained in the sections of a report, then you must ensure that all account assignment objects have been defined completely in every section.
In addition, you must include the cost center account assignment object in the orders section. It therefore applies that the value for the cost center is always ‘ ‘ (SPACE) for all orders.
You cannot directly enter the value ‘ ‘ (SPACE) into the Report Painter report. Instead, you must enter the value ‘#’. The value ‘#’ corresponds to the value ‘ ‘ (SPACE) in Report Painter reports.
Thus, you must include the value ‘#’ for the orders in the ‘Cost centers’ section.
Example:Definition of 1st section:
Cost center: &1KOSET
Order: #Definition of 2nd section:
Cost center: #
Order: &6-AUFGR
Source code corrections