Prior Year Comparison with Variance –
Crystal
Technical name: 0BCS_VC11_Q052_CR
Based on InfoCube or ODS object: 0BCS_VC11
Use
This query was developed for Crystal Report 9HYGOFC4AQBM8FGJWUEKTF9PU.
It lists the following:
· Cumulative transaction data of a fiscal year and the prior year
· Absolute and relative variance
Filters
|
InfoObject |
Description of InfoObject (incl. Restrictions or Calculation Formulas) |
|
0SEM_CGCOMP |
Consolidation group |
|
0BCS_CGPCTR |
Consolidation profit center group |
|
0FISCVARNT |
Fiscal year variant (= K4 calendar year with 4 special periods) |
|
0CS_VERSION |
Version |
|
0CURKEY_GC |
Group currency |
|
0FISCPER3 |
Fiscal period (single value entry, required) |
|
0CS_CHART |
Consolidation chart of accounts |
Free Characteristics
|
InfoObject |
Description |
|
0COMPANY |
Company |
|
0BCS_PRCTR |
Consolidation profit center |
|
0CO_AREA |
Controlling area |
Variables Used
|
Variable |
Description |
|
|
Consolidation group |
|
|
Controlling area (single value entry, required) |
|
|
Consolidation profit center group hierarchy |
|
|
Consolidation profit center group |
|
|
Consolidation version |
|
|
Group currency key |
|
|
Fiscal year (single value entry, required) |
|
|
Fiscal period (single value entry, required) |
|
|
Consolidation chart of accounts |
|
|
Item |
Rows
|
InfoObject |
Description of InfoObject (incl. Restrictions or Calculation Formulas) |
|
0CS_ITEM |
Item |
Columns
|
InfoObject |
Description of InfoObject (incl. Restrictions or Calculation Formulas) |
|
|
Current year · Fiscal year (single value entry, required) · Periodic value in group currency |
|
|
Prior year · Fiscal year (single value entry, required) -1 · Periodic value in group currency |
|
|
Absolute variance = current year – prior year |
|
|
Variance in percent = variance in percent compared with the prior year |