Technical Name: 0ECCS_C01_Q007
Use
This query displays the cumulative transaction data from two versions, and also shows the absolute and percentage variances.
Enter the following variables (with their respective meanings):
Period/fiscal year |
Period of the fiscal year to be analyzed (such as 12/1999) |
Dimension |
The dimension used in the SAP system, in which the data is saved |
Consolidation version |
The version used in the SAP system, which the consolidation data is based on |
Comparison version |
The version used in the SAP system, which the comparative data is based on |
Hierarchy of consolidation groups |
Hierarchy of the consolidation groups, which are dragged over for the selection of transaction data |
Node of consolidation groups |
Node of the hierarchy in the concerned dimension; Basis of the analysis in the Business Information Warehouse |
Consolidation chart of accounts |
Consolidation chart of accounts used in the SAP system |
Key date |
Date, on which the hierarchy is selected, which is dragged over for the selection of transaction data |
Custom Characteristics
InfoObject |
Description |
0CS_UNIT |
Consolidation unit |
0CS_SITEM |
Subitem |
0CS_ITEM |
Item (vertical breakdown) |
Rows
InfoObject |
Description of the InfoObject |
Item (both balance sheet and income statement as well as statistical items) |
The transaction data is shown for the different Items |
Columns
Structure |
Description of the Structure |
Consolidation version |
Accumulated balance in GC for the selected fiscal year and version (to be entered on selection screen) |
Comparison version |
Accumulated balance in GC for the selected fiscal year and comparison version (to be entered on selection screen) |
Absolute variance |
Consolidation version - Comparison version |
Relative variance |
(Consolidation version – Comparison version) / Comparison version * 100 |