SAP table T090NA (Depreciation Keys)

SAP table T090NA has 3 primary key fields being MANDT,AFAPL,AFASL.

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
AFAPL Chart of Depreciaton for Asset Valuation CHAR 4 0 T096 AFAPL
AFASL Depreciation key CHAR 4 0 AFASL
XAKTIV Status of Depreciation Key CHAR 1 0 XAKTIV_RSL
Inactive
M Migrated
X Active
METHBT Maximum Amount Method CHAR 3 0 T090NH_METH METHBT
ANHWSL Cutoff Value Keys CHAR 3 0 T091 ANHWSL
XNAAUS No Ord. Depreciation with Special Depreciation CHAR 1 0 XNAAUS
XZIAUS No Interest If there Is No Depreciation Planned CHAR 1 0 XZIAUS
XNAZUG Acquisition in Year of Capitalization Only CHAR 1 0 XNAZUG_NEW
XPERGJ Period control per fiscal year CHAR 1 0 XPERGJ
PROZST Number of Places That Percentage Rate Is Rounded To NUMC 1 0 PROZST
XDAILY Depreciation Calculation to Exact Day CHAR 1 0 XDAILY
XRAFA Do not reduce depreciation in shortened fiscal year CHAR 1 0 XRAFA

T090NA foreign key relationships

Table Field Check Table Check Field
0 T090NA AFAPL T096 Chart of depreciation MANDT
1 T090NA ANHWSL T091 Cut-off value key ANHWSL
0 T090NA MANDT T000 Clients MANDT
1 T090NA METHBT T090NH_METH Maximum Amount Method MANDT
1 T090NA METHBT T090NH_METH Maximum Amount Method METHBT