Start of Content Area

QueryVersion Comparison  Locate the document in its SAP Library structure

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