SAP table J_1AAA2 (Revaluation Key)

SAP table J_1AAA2 has 3 primary key fields being MANDT,BUKRS,J_1AARVKEY.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
J_1AARVKEY Revaluation Key CHAR 4 0 J_1AARVKEY
J_1AABASEA Base Depreciation Area NUMC 2 0 FAAV_DEPR_AREA J_1AABASEA
J_1AAINDEX Inflation Index CHAR 5 0 J_1AINFT20 J_1AAINDEX
J_1AAPCMET Period Control Method CHAR 4 0 J_1AAA2M J_1AAPCMET
J_1ATBEDEP Time base and exposure to inflation for asset value date CHAR 2 0 J_1AINFT04 J_1AATBBZD
J_1AABZWKZ Base Value for Revaluation of APC CHAR 2 0 J_1AABZWKZ
01 Acquisition value
02 Half of acquisition value
03 Replacement value
04 Half of replacement value
10 Acquisition value reduced by unplanned depreciation
20 Net book value without spec. dep. and current dep.
21 Net book value without special depreciation
22 Mean net book value without special depreciation
23 Net book value without current depreciation
24 Net book value
25 Mean net book value
26 Rem. book value w/o revaluation
27 Rem. book value with proportional value adjustments
30 Accumulated ordinary depreciation
31 Cumulative special depreciation
32 Accumulated ordinary and special depreciation
ZA Free for user modification
ZB Free for user modification
ZC Free for user modification
ZD Free for user modification
ZE Free for user modification
ZF Free for user modification
ZG Free for user modification
ZH Free for user modification
ZI Free for user modification
ZJ Free for user modification
ZK Free for user modification
ZL Free for user modification
ZM Free for user modification
ZN Free for user modification
ZO Free for user modification
ZP Free for user modification
ZQ Free for user modification
ZR Free for user modification
ZS Free for user modification
ZT Free for user modification
ZU Free for user modification
ZV Free for user modification
ZW Free for user modification
ZX Free for user modification
ZY Free for user modification
ZZ Free for user modification
J_1AAAFABZ Base Value for Revaluation of Depreciation CHAR 2 0 J_1AAAFABZ
01 Accumulated ordinary depreciation
02 Cumulative special depreciation
03 Accumulated ordinary and special depreciation
04 Revaluated accumulated ordinary depreciation
ZA Free for user modification
ZB Free for user modification
ZC Free for user modification
ZD Free for user modification
ZE Free for user modification
ZF Free for user modification
ZG Free for user modification
ZH Free for user modification
ZI Free for user modification
ZJ Free for user modification
ZK Free for user modification
ZL Free for user modification
ZM Free for user modification
ZN Free for user modification
ZO Free for user modification
ZP Free for user modification
ZQ Free for user modification
ZR Free for user modification
ZS Free for user modification
ZT Free for user modification
ZU Free for user modification
ZV Free for user modification
ZW Free for user modification
ZX Free for user modification
ZY Free for user modification
ZZ Free for user modification

J_1AAA2 foreign key relationships

Table Field Check Table Check Field
0 J_1AAA2 BUKRS T001 Company Codes BUKRS
1 J_1AAA2 J_1AABASEA FAAV_DEPR_AREA Generated Table for View DEPR_AREA
0 J_1AAA2 J_1AAINDEX J_1AINFT20 Inflation: Index Definition MANDT
1 J_1AAA2 J_1AAPCMET J_1AAA2M Methods fore period control of transactions MANDT
1 J_1AAA2 J_1AAPCMET J_1AAA2M Methods fore period control of transactions J_1AAPCMET
0 J_1AAA2 J_1ATBEDEP J_1AINFT04 Time base definition MANDT
0 J_1AAA2 J_1ATBEDEP J_1AINFT04 Time base definition J_1ATBEDEP
1 J_1AAA2 MANDT T000 Clients MANDT