Comparison of Consolidation Groups
● Technical name: 0BCS_VC11_Q009
Based on InfoCube: 0BCS_VC11
● Technical name: 0BCS_VC11_Q009_1
Based on MultiProvider: 0BCS_MP21
Use
This query compares the YTD transaction data of two example consolidation groups (that consist of companies), and displays the absolute and percentage variances.
This kind of comparison is only possible within the same hierarchy.
Filters
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
0CS_VERSION |
Version |
0CURKEY_GC |
Group currency |
0FISCVARNT |
Fiscal year variant (= K4 calendar year with 4 special periods) |
0FISCYEAR |
Fiscal year (single value entry, required) |
0FISCPER3 |
Posting period (single value entry, required) |
0CS_CHART |
Consolidation chart of accounts |
0REQUID |
Request ID (in MultiProvider query only) |
0BCS_REQUID |
SEM-BCS request ID (in MultiProvider query only) |
Custom Characteristics
InfoObject |
Description |
0COMPANY |
Company |
Variables Used
Variable |
Description |
|
Hierarchy of consolidation groups |
|
Consolidation group |
|
Comparison consolidation group hierarchy |
|
Comparison consolidation group |
|
Consolidation version |
|
Group currency key |
|
Fiscal year (single value entry, required) |
|
Posting period (single value entry, required) |
|
Consolidation chart of accounts |
|
Item hierarchy |
|
Item |
Rows
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
0CS_ITEM |
Item |
Columns
InfoObject |
Description of the InfoObject (and Restriction or Calculation Formula) |
|
YTD balance in group currency for the selected fiscal year and the selected consolidation group 1 (entered on selection screen) |
|
YTD balance in group currency for the selected fiscal year and the selected consolidation group 2 (entered on selection screen) |