1. Home
  2. Resources
  3. SAP Tables
  4. T090NS - Multilevel Method

SAP Table T090NS

Multilevel Method

T090NS (Multilevel Method) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T090NS to other SAP tables.

T090NS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AFAPL Chart of depreciaton for asset valuation AFAPL T096 CHAR 4 0
METSTU Multilevel Method METSTU T090NSG CHAR 3 0
ZGJAHR Valid to vintage year DZGJAHR NUMC 4 0
DAUJAR Validity period in years DAUJAR NUMC 3 0
DAUPER Validity period in months DAUPER NUMC 3 0
0
BEZWKZ Base value key for depreciation calculation BEZWKZ CHAR 2 0
01 Acquisition value
02 Half of acquisition value
03 Replacement value
04 Half of replacement value
05 Limited replacement value
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
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)
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 AFPROZ DEC 7 4
XPDAUR Indicator: Calculate percentage from remaining useful life XPDAUR CHAR 1 0
X Yes
NULL No
KGPROZ Reduction of base value by an entered percentage rate KGPROZ DEC 7 4

T090NS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T090NS AFAPL T090NS MANDT T096 Chart of depreciation MANDT
T090NS AFAPL T090NS AFAPL T096 Chart of depreciation AFAPL
T090NS MANDT T090NS MANDT T000 Clients MANDT
T090NS METSTU T090NS METSTU T090NSG Multi-Level Method - Start of Validity METSTU
T090NS METSTU T090NS MANDT T090NSG Multi-Level Method - Start of Validity MANDT
T090NS METSTU T090NS AFAPL T090NSG Multi-Level Method - Start of Validity AFAPL