ANLB (Depreciation terms) 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 ANLB to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||
|
ANLN1
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||||||
|
ANLN2
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||||||
|
AFABE
Real depreciation area
|
AFABE_D | T093 |
NUMC
|
2 | 0 | |||||||||||
|
BDATU
Date validity ends
|
BDATU |
DATS
|
8 | 0 | ||||||||||||
|
ADATU
Date for beginning of validity
|
ADATU |
DATS
|
8 | 0 | ||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||
|
ERDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||
|
AEDAT
Changed on
|
AEDAT_ANLA |
DATS
|
8 | 0 | ||||||||||||
|
XLOEV
Indicator: Account marked for deletion?
|
XLOEV |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XSPEB
Indicator: Is Account Blocked for Posting?
|
XSPEB |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
FELEI
Screen layout for Asset Accounting
|
FELEI | T082A |
CHAR
|
4 | 0 | |||||||||||
|
XNEGA
Indicator: Negative values allowed
|
XNEGA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XGWGK
Low-value asset amount and quantity check
|
XGWGK |
NUMC
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XUNTA
Indicator: Depreciate main asset number totally
|
XUNTA |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
AFABG
Depreciation calculation start date
|
AFABG |
DATS
|
8 | 0 | ||||||||||||
|
ZINBG
Start date for interest calculation
|
DZINBG |
DATS
|
8 | 0 | ||||||||||||
|
SAFBG
Start date for special depreciation
|
SAFBG |
DATS
|
8 | 0 | ||||||||||||
|
INVSL
Investment support key
|
INVSL | T085 |
CHAR
|
2 | 0 | |||||||||||
|
AFASL
Depreciation key
|
AFASL | T090NA |
CHAR
|
4 | 0 | |||||||||||
|
NDJAR
Planned useful life in years
|
NDJAR |
NUMC
|
3 | 0 | ||||||||||||
|
NDPER
Planned useful life in periods
|
NDPER |
NUMC
|
3 | 0 | ||||||||||||
|
||||||||||||||||
|
NAPRZ
Ordinary depreciation percentage rate
|
NAPRZ |
DEC
|
7 | 4 | ||||||||||||
|
SAPRZ
Special depreciation percentage rate
|
SAPRZ |
DEC
|
7 | 4 | ||||||||||||
|
WBIND
Index series for replacement values
|
WBIND | T094A |
CHAR
|
5 | 0 | |||||||||||
|
ALIND
Index series for replacement values by age
|
ALIND | T094A |
CHAR
|
5 | 0 | |||||||||||
|
APROP
Variable depreciation portion
|
APROP |
DEC
|
7 | 4 | ||||||||||||
|
UMJAR
Depreciation key for the changeover year
|
UMJAR |
NUMC
|
4 | 0 | ||||||||||||
|
NDURJ
Original useful life in years
|
NDURJ |
NUMC
|
3 | 0 | ||||||||||||
|
NDURP
Original useful life in periods
|
NDURP |
NUMC
|
3 | 0 | ||||||||||||
|
||||||||||||||||
|
SCHRW
Asset scrap value
|
SCHRW |
CURR
|
13 | 2 | ||||||||||||
|
LGJAN
Last fiscal year for the annual values in Asset Acct.
|
LGJAN |
NUMC
|
4 | 0 | ||||||||||||
|
PERFY
Period scaling in depreciation start year
|
PERFY |
NUMC
|
3 | 0 | ||||||||||||
|
||||||||||||||||
|
ANUPD
Indicator: Type of change to table
|
ANUPD |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
AUFWTG
Revaluation
|
AUFWTG |
NUMC
|
2 | 0 | ||||||||||||
|
XAFBE
Indicator: Depreciation area is deactivated
|
XAFBE |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
ANLGR
Group asset
|
ANLGR | ANLH |
CHAR
|
12 | 0 | |||||||||||
|
ANLGR2
Subnumber of group asset
|
ANLGR2 | ANLA |
CHAR
|
4 | 0 | |||||||||||
|
VYEAR
Acquisition year of the asset (manually changeable)
|
VYEAR |
NUMC
|
4 | 0 | ||||||||||||
|
VMNTH
Asset Accounting: Acquis. month (in depreciation area)
|
VMNTH |
NUMC
|
3 | 0 | ||||||||||||
|
INBDA
Asset Accounting: Date of operating readiness
|
INBDA |
DATS
|
8 | 0 | ||||||||||||
|
ABGDAT_B
Value date of last retirement for the depreciation area
|
ABGDAT_B |
DATS
|
8 | 0 | ||||||||||||
|
J_1AARVKEY
Revaluation Key
|
J_1AARVKEY | J_1AAA2 |
CHAR
|
4 | 0 | |||||||||||
|
J_1AALTDAT
Last Revaluation Date
|
J_1AALTDAT |
DATS
|
8 | 0 | ||||||||||||
|
J_1AALTIDX
Last Index Used
|
J_1AALTIDX |
CHAR
|
5 | 0 | ||||||||||||
|
SCHRW_PROZ
Scrap Value as Percentage of APC
|
SCHRW_PROZ |
DEC
|
14 | 11 | ||||||||||||
|
UMPER
Changeover Period of Depreciation Key
|
UMPER |
NUMC
|
3 | 0 | ||||||||||||
|
||||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ANLB | AFABE | ANLB | MANDT |
T093
Real and derived depreciation areas
|
MANDT |
| ANLB | AFABE | T093C | AFAPL |
T093
Real and derived depreciation areas
|
AFAPL |
| ANLB | AFABE | ANLB | AFABE |
T093
Real and derived depreciation areas
|
AFABER |
| ANLB | AFASL | ANLB | AFASL |
T090NA
Depreciation Keys
|
AFASL |
| ANLB | AFASL | SY | MANDT |
T090NA
Depreciation Keys
|
MANDT |
| ANLB | AFASL | T093C | AFAPL |
T090NA
Depreciation Keys
|
AFAPL |
| ANLB | ALIND | ANLB | ALIND |
T094A
Index series for replacement values
|
WBIND |
| ANLB | ALIND | ANLB | MANDT |
T094A
Index series for replacement values
|
MANDT |
| ANLB | ANLGR | ANLB | MANDT |
ANLH
Main asset number
|
MANDT |
| ANLB | ANLGR | ANLB | BUKRS |
ANLH
Main asset number
|
BUKRS |
| ANLB | ANLGR | ANLB | ANLGR |
ANLH
Main asset number
|
ANLN1 |
| ANLB | ANLGR2 | ANLB | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| ANLB | ANLGR2 | ANLB | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| ANLB | ANLGR2 | ANLB | ANLGR |
ANLA
Asset Master Record Segment
|
ANLN1 |
| ANLB | ANLGR2 | ANLB | ANLGR2 |
ANLA
Asset Master Record Segment
|
ANLN2 |
| ANLB | ANLN1 | ANLB | MANDT |
ANLH
Main asset number
|
MANDT |
| ANLB | ANLN1 | ANLB | BUKRS |
ANLH
Main asset number
|
BUKRS |
| ANLB | ANLN1 | ANLB | ANLN1 |
ANLH
Main asset number
|
ANLN1 |
| ANLB | ANLN2 | ANLB | ANLN1 |
ANLA
Asset Master Record Segment
|
ANLN1 |
| ANLB | ANLN2 | ANLB | ANLN2 |
ANLA
Asset Master Record Segment
|
ANLN2 |
| ANLB | ANLN2 | ANLB | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| ANLB | ANLN2 | ANLB | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| ANLB | BUKRS | ANLB | MANDT |
T001
Company Codes
|
MANDT |
| ANLB | BUKRS | ANLB | BUKRS |
T001
Company Codes
|
BUKRS |
| ANLB | FELEI | ANLB | MANDT |
T082A
Field string asset master record maintenance
|
MANDT |
| ANLB | FELEI | RA01M | FEG_B |
T082A
Field string asset master record maintenance
|
FEGTB |
| ANLB | FELEI | ANLB | FELEI |
T082A
Field string asset master record maintenance
|
FELEI |
| ANLB | INVSL | ANLB | MANDT |
T085
Investment support measures
|
MANDT |
| ANLB | INVSL | T093C | AFAPL |
T085
Investment support measures
|
AFAPL |
| ANLB | INVSL | ANLB | INVSL |
T085
Investment support measures
|
INVSL |
| ANLB | J_1AARVKEY | ANLB | J_1AARVKEY |
J_1AAA2
Revaluation Key
|
J_1AARVKEY |
| ANLB | J_1AARVKEY | * |
J_1AAA2
Revaluation Key
|
MANDT | |
| ANLB | J_1AARVKEY | * |
J_1AAA2
Revaluation Key
|
BUKRS | |
| ANLB | WBIND | ANLB | MANDT |
T094A
Index series for replacement values
|
MANDT |
| ANLB | WBIND | ANLB | WBIND |
T094A
Index series for replacement values
|
WBIND |