Hierarchy
SAP_FIN (Software Component) SAP_FIN⤷
CO-OM-IS (Application Component) Information System, iViews⤷
KBWOM (Package) CO-OM-IS: BW Extractors AddOn 1.2Bff
IMG Activity
| ID | SIMG_BWOM01 | Define Report Row Hierarchies |
| Transaction Code | S_AX7_68000171 | BCT-CO: Change Report Row Hierarchy |
| Created on | 20020812 | |
| Customizing Attributes | SIMG_BWOM01 | Define Report Row Hierarchies |
| Customizing Activity | SIMG_BWOM01 | Define Report Row Hierarchies |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | SIMG_BWOM01 |
This menu item is optional. It enables you to define report row hierarchies for the evaluation of cost elements in BW. Here the values for the cost elements from a cost element group can be controlled depending on the sender/receiver indicator in different report rows.
The following functions are available for defining the report row hierarchy:
- BWOM01 Define Report Row Hierarchy
- BWOM02 Display and Check Report Row Hierarchy
Integration into BW Content
The report row hierarchies are available for evaluations in BW queries as presentation hierarchies for the 0CO_REPLINE InfoObject. The hierarchies can be extracted into the BW system using the extractors for this InfoObject.
The 0CO_REPLINE InfoObject technically includes the concatenation of sender/receiver indicators (0DB_CR_IND) and the cost element (0COSTELEMNT). This value is calculated in the update rules for the respective InfoCube.
The 0CO_REPLINE InfoObject is delivered and used with BW Content as of Release 3.10. However, the concept of report rows can also easily be integrated into BW Content for any earlier release.
Example
You have defined the following cost element groups in Controlling:
- MATERIALCOSTS with cost elements 450000 and 450001
- PERSCOSTS with cost elements 416000 and 416900
- OVERRUNCOSTS with cost elements 474000 and 474001
Now you want to define a "Personal and Material Costs" report row in which you remove the total from the debits under personal and material cost elements and the credits under overrun costs.
To do this, define the report row hierarchy in Customizing as follows:
Line 0100 / Sender-Receiver. - / Cost Element Group 04 Personal and Material Costs /Totals Row - / Description
Line 0200 / Sender-Receiver S / Cost Element Group 01 Personal Costs / Total Row 0100 / Personal Costs Description
Line 0300 / Sender-Receiver S / Cost Element Group 02 Material Costs / Total Row 0100 / Material Costs Description
Line 0400 / Sender-Receiver H / Cost Element Group 03 Overrun Costs / Total Row 0100 / Overrun Costs Description
Tip:
Display the report row hierarchy after defining it with transaction BWOM02. The system then tests Customizing again for consistency.
Requirements
Cost element groups must exist in Controlling.
Standard settings
Recommendation
Activities
When attaching a report row hierarchy, define the basic report rows and totals rows.
Assign the cost elements to a basic report row by using a cost element group. The cost elements need to be entered in this row. By using the setting for the sender/receiver indicator, you control whether credits or debits are entered in this report row.
You assign basic report row using the for a higher-level totals row.
You cannot specify cost element groups in the total rows. However, you can reference these rows for totals rows. Then enter the number for the respective totals row in the column of the same name.
There has to be one report row hierarchy for each header line. This is the totals row that does not have an entry in the column of the same name.
Procedure
Call up transaction BWOM01.
Choose New Entries.
Enter a controlling area, the name of the report row hierarchy, and a description.
Select the processed row.
Choose Line Structure.
Choose New Entries.
Enter the totals row and basic report rows.
If you select Hierarchy, the set hierarchy under the report row is extracted as the hierarchy structure into the BW system. By default, only the cost element assignments for the set are transferred, and not the hierarchical structure.
Further notes
Business Attributes
| ASAP Roadmap ID | 207 | Establish Reporting |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | SIMG_BWOM01 | 0 | HLA0009401 | Cost Center Accounting |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| VC_BWOM_RHIER | C - View cluster | SM34 | BWOM01 | Report Row Hierarchy |
History
| Last changed by/on | SAP | 20020812 |
| SAP Release Created in |
