Defining Validation-Key Checks 
Defining Validation-Key Checks
Use
To fulfill all legal requirements for the asset reporting forms, you need to define where the information below can be found in the asset master data, in order to display it in the reports. The system takes into account the tables ANLA, ANLB, and ANLZ. You can use evaluation group 1, 2, 3, or 4, or any other variables not needed in another context.
Validation Keys
|
Validation Key |
Description |
|
ANO_AQUI |
Capitalization date |
|
ANOS_VIDA_UTIL |
Useful life |
|
ANOS_VIDA_U_ESP |
Expired useful life |
|
ANO_INI_UTIL |
First year of useful life |
|
MES_INI_UTIL |
First month of useful life |
|
BAIXO_VALOR |
Low-value asset |
|
BENS_TOT_AMORT |
Completely depreciated assets |
|
B_G_REPARACAO |
Big repairs or improvements |
|
G_REPARACAO |
Assets with big repairs |
|
L_REPARACAO |
Connection between G_REPARACAO and B_G_REPARACAO |
|
ESTADO_USO |
Purchased used |
|
LEASING |
Leased asset |
|
L_TERRENOS |
Connection between buildings and land |
|
Q_DEGRESSIVAS |
Declining balance method |
|
R_A_DUODECIMOS |
Depreciation method pro rata |
|
T_VEICULOS |
Car key |
|
IMOB_FINANC |
Financial investment measures |
Procedure
In Customizing for Financial Accounting (FI), choose Asset Accounting
® Special Valuation ® Revaluation of Fixed Assets ® Settings for Mapas Fiscais Portugal. Select your company code and double-click Checks. Enter data as follows:|
Field |
Entry |
|
Validation Key |
Validation key you want to maintain |
|
Serial No. |
Sequence number; enter a sequential number for each validation key you define, starting with 1 |
|
Table Name |
Name of the master data table that stores the content of the validation key |
|
Field Name |
Field in the master data table that contains the needed value |
|
Offset |
Exact location of the information; enter the position in the field that the information begins with (0 corresponds to the first character) |
|
Length |
Number of positions to be considered starting with the offset |
|
Contents |
Value of the validation key; the program compares this content with the entry of the master data of the asset |
|
Operator |
Operator type for comparing the asset master data to the validation key; you define whether the compared values are to be equal (EQ) or not equal (NE) |
Example
|
Validation Key |
Table |
Field |
Offset |
Length |
Content |
Operator |
|
ANO_AQUI |
ANLA |
AKTIV |
0 |
4 |
1997 |
EQ |
|
ANOS_VIDA_UTIL |
ANLB |
NDJAR |
0 |
3 |
3 |
EQ |
|
ANOS_VIDA_U_ESP |
ANLA |
NDJAR |
0 |
3 |
2 |
EQ |
|
ANO_INI_UTIL |
ANLA |
AKTIV |
0 |
4 |
1997 |
EQ |
|
MES_INI_UTIL |
ANLB |
AKTIV |
4 |
2 |
10 |
EQ |
|
BAIXO_VALOR |
ANLB |
AFASL |
0 |
4 |
GWG |
EQ |
|
BENS_TOT_AMORT |
ANLA |
DEAKT |
0 |
8 |
19980315 |
EQ |
|
B_G_REPARACAO |
ANLA |
ORD41 |
0 |
4 |
YES |
EQ |
|
G_REPARACAO |
ANLA |
ORD42 |
0 |
4 |
YES |
EQ |
|
L_REPARACAO |
ANLA |
ORD43 |
0 |
4 |
YES |
EQ |
|
ESTADO_USO |
ANLA |
XAFABCH |
0 |
1 |
NE |
|
|
LEASING |
ANLA |
LEAFI |
0 |
10 |
Leasing |
EQ |
|
L_TERRENOS |
ANLA |
STORT |
0 |
10 |
LISBOA |
EQ |
|
Q_DEGRESSIVAS |
ANLB |
AFASL |
0 |
4 |
DG20 |
EQ |
|
R_A_DUODECIMOS |
ANLA |
ORD44 |
0 |
1 |
X |
EQ |
|
T_VEICULOS |
ANLA |
GDLGRP |
0 |
8 |
ANYTYPE |
EQ |
|
IMOB_FINANC |
ANLA |
ANLKL |
0 |
4 |
3500 |
EQ |
The system reads this table as follows, based on two sample validation keys highlighted above:
The system reads master data field AKTIV in table ANLB. This date field has the format YYYYMMDD (for example, 20020430). The report takes two characters starting with the fourth, which is '04' in this case, and checks whether this is equal to '10.' This condition is not met, so this check is not true.
The system reads master data field asset class ANLKL in table ANLA. This field has a length of four characters starting with the first. The report takes all four characters and checks if the entry for the assets equals '3500.'