Hierarchy
SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management⤷
FIN-SEM-BCS (Application Component) Business Consolidation⤷
UCF2 (Package) SEM-BCS: Currency Translation
Basic Data
| Data Element | UC_CTR_TT_CALC_FSFREQUENCY |
| Short Description | C/T Timeframe: Calculation of Consolidation Interval |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | UC_FLG | |
| Data Type | CHAR | Character String |
| Length | 1 | |
| Decimal Places | 0 | |
| Output Length | 1 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Interval |
| Medium | 20 | Cons Interval |
| Long | 30 | Current Consolidation Interval |
| Heading | 3 | IV |
Documentation
Definition
Current consolidation interval as the calculation base for the translation timeframe.
Use
Choose this option if currency translation should include the data records of only the current consolidation interval, rather than the data records of all prior periods (as in cumulative translation).
Doing this enables you to synchronize the results of the translation of two consolidation processes with different frequencies (say, monthly and quarterly) with regards to the common time periods.
For example, monthly consolidation with the translation timeframe "current consolidation interval, quarterly consolidation frequency" at the end of a fiscal quarter produces the same translation results as quarterly consolidation with periodic translation. (Quarterly consolidation uses "periodic" translation timeframes and is equivalent to "current consolidation interval, quarterly consolidation frequency".)
Dependencies
Example
The following changes in values might result when using the translation timeframe "current consolidation interval, quarterly consolidation frequency":
Period Value Total Exch Value Total
in LC in LC in GC in GC
001 1000 1000 0.5 500 500
002 200 1200 0.6 220 720
003 300 1500 0.7 330 1050
004 100 1600 0.7 70 1120
005 200 1800 0.6 110 1230
006 200 200 0.5 70 1300
In the first quarter, the result is identical to cumulative translation. In the second quarter, the year-to-date value in group currency equals the value at the end of the last quarter plus the accumulated total in local currency of the current quarter times the current exchange rate. Thus, the value in period 006 is calculated as follows:
1050 + ( 100 + 200 + 200 ) * 0.5 = 1300
In contrast, cumulative translation is calculated as follows:
2000 * 0.5 = 1000
And periodic translation as follows:
500 + 120 + 210 + 70 + 120 + 100 = 1120.
The result would be identical with quarterly data entry and periodic translation:
1500 * 0.7 + 500 * 0.5 = 1300.
History
| Last changed by/on | SAP | 20041006 |
| SAP Release Created in | 3.1B |
