SAP table T090P (Dep. calc. key percentage records)

SAP table T090P has 5 primary key fields being MANDT,AFARSL,ZGJAHR,DAUJAR,DAUPER.

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 * MANDT
AFARSL Base Method CHAR 4 0 T090 AFARSL
ZGJAHR Valid to Vintage Year NUMC 4 0 DZGJAHR
DAUJAR Validity Period in Years NUMC 3 0 DAUJAR
DAUPER Validity Period in Months NUMC 3 0 DAUPER
BEZWKZ Base Value Key for Depreciation Calculation CHAR 2 0 BEZWKZ
01 Acquisition value
02 Half of acquisition value
03 Replacement value
04 Half of replacement value
05 Limited replacement value
06 Replacement value reduced by reserves
10 Acquisition value reduced by unplanned depreciation
11 Acquisition value reduced by special depreciation
12 Acquisition value reduced by unplanned dep. (w/o write-up)
13 Acquis. Value Reduced by Cumulated Unplanned Depreciation
14 Acquisition value reduced by reserves
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 Net book value with proportional value adjustments
28 Reduced base value (asset-specific reduction)
29 External base value from real estate leasing
30 Accumulated ordinary depreciation
31 Cumulative special depreciation
32 Accumulated ordinary and special depreciation
40 Acquisitions
51 Ordinary depreciation on the transaction
G1 Country-specific base value
G2 Country-specific base value
G3 Country-specific base value
G4 Country-specific base value
G5 Country-specific base value
G6 Country-specific base value
G7 Country-specific base value
G8 Country-specific base value
G9 Country-specific base value
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
AFPROZ Depreciation Percentage Rate DEC 7 4 AFPROZ
XPDAUR Indicator: Calculate Percentage from Remaining Useful Life CHAR 1 0 XPDAUR
KGPROZ Reduction of Base Value by an Entered Percentage Rate DEC 7 4 KGPROZ

T090P foreign key relationships

Table Field Check Table Check Field
0 T090P AFARSL T090 Depreciation calculation keys MANDT
0 T090P AFARSL T090 Depreciation calculation keys AFARSL