Follow us on LinkedIn for your next SAP project

SAP Table ANLB

Depreciation terms

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.

ANLB table fields

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

ANLB foreign key relationships

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