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 |