Show TOC

Variable Replacement ExampleLocate this document in the navigation structure

The following example shows the replacement options you have for the characteristic value with regard to the setting Key / External Characteristic Value of the Key in connection with the offset start and offset length:

Fiscal Year Variant K4

Fiscal Year / Period 2002/008

  Fiscal Year 0FISCYEAR Fiscal Year / Period 0FISCPER

Internal display (key)

K42002

K42002008

External display (external characteristic value of the key)

K4/2002

K4/008.2002

Internal Display (Key)

Fiscal Year 0FISCYEAR

For the Key setting for the Fiscal Year 0FISCYEAR characteristic, you have to set the offset start at 2 and the length as 4. In the query, K42002 is replaced by the value 2002.

Fiscal Year / Period 0FISCPER

For the Key setting for the Fiscal Year / Period 0FISCPER characteristic, you have to set the offset start at 2.

If you want to display on the year in the text output, choose the offset length 4. K42002008 is replaced by 2002 in the query.

If you want to display the year and the period in the text output, choose the offset length 7. 2002008 in the query replace K42002008.

Overview

0FISCYEAR Offset start 2 Offset length 4

0FISCPER

Offset start 2

Offset length 4 for yearOffset length 7 for year and period

External Display (External Characteristic Value of the Key)

Fiscal Year 0FISCYEAR

For the External Characteristic Value of the Key setting for the Fiscal Year 0FISCYEAR characteristic, you have to set the offset start at 3 and the length as 4. In the query, K4/2002 is replaced by the value 2002.

Fiscal Year / Period 0FISCPER

For the External Characteristic Value of the Key for the Fiscal Year / Period 0FISCPER, you have to make the following settings for the offset start and the offset length:

If you want to display only the year in the text output, choose the offset start 7 and the offset length 4. K4/008.2002 is replaced by 2002 in the query.

If you want to display only the period in the text output, choose the offset start 3 and the offset length 3. 008 in the query replace K4/008.2002.

If you want to display the year and the period in the text output, choose the offset start 3 and the offset length 8. 008.2002 in the query replace K4/008.2002.

Overview

0FISCYEAR Offset Start 3 Offset Length 4

0FISCPER

Offset length 7 for year

Offset start 3 for period

Offset start 3 for year and period

Offset length 4 for year

Offset length 3 for period

Offset length 8 for year and period