T090NA (Depreciation Keys) 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 T090NA to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||
|
AFAPL
Chart of depreciaton for asset valuation
|
AFAPL | T096 |
CHAR
|
4 | 0 | |||||||||
|
AFASL
Depreciation key
|
AFASL |
CHAR
|
4 | 0 | ||||||||||
|
XAKTIV
Status of depreciation key
|
XAKTIV_RSL |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
METHBT
Maximum amount method
|
METHBT | T090NH_METH |
CHAR
|
3 | 0 | |||||||||
|
ANHWSL
Cutoff value key
|
ANHWSL | T091 |
CHAR
|
3 | 0 | |||||||||
|
XNAAUS
No ord. depreciation with special depreciation
|
XNAAUS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XZIAUS
No interest if there is no depreciation planned
|
XZIAUS |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XNAZUG
Acquisition in year of capitalization only
|
XNAZUG_NEW |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XPERGJ
Period control per fiscal year
|
XPERGJ |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
PROZST
Number of places that the percentage rate is rounded to
|
PROZST |
NUMC
|
1 | 0 | ||||||||||
|
XDAILY
Depreciation calculation to exact day
|
XDAILY |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
XRAFA
Do not reduce depreciation in shortened fiscal year
|
XRAFA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T090NA | AFAPL | T090NA | AFAPL |
T096
Chart of depreciation
|
AFAPL |
| T090NA | AFAPL | T090NA | MANDT |
T096
Chart of depreciation
|
MANDT |
| T090NA | ANHWSL | T090NA | MANDT |
T091
Cut-off value key
|
MANDT |
| T090NA | ANHWSL | T090NA | ANHWSL |
T091
Cut-off value key
|
ANHWSL |
| T090NA | MANDT | T090NA | MANDT |
T000
Clients
|
MANDT |
| T090NA | METHBT | T090NA | MANDT |
T090NH_METH
Maximum Amount Method
|
MANDT |
| T090NA | METHBT | T090NA | METHBT |
T090NH_METH
Maximum Amount Method
|
METHBT |