1. Home
  2. Resources
  3. SAP Tables
  4. ANLB - Depreciation terms

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
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
X Yes
NULL No
XSPEB Indicator: Is Account Blocked for Posting? XSPEB CHAR 1 0
X Yes
NULL No
FELEI Screen layout for Asset Accounting FELEI T082A CHAR 4 0
XNEGA Indicator: Negative values allowed XNEGA CHAR 1 0
X Yes
NULL No
XGWGK Low-value asset amount and quantity check XGWGK NUMC 1 0
0 No maximum amount check
1 Value based maximum amount check
2 Check maximum amount with quantity
XUNTA Indicator: Depreciate main asset number totally XUNTA CHAR 1 0
X Yes
NULL No
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
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
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
0
ANUPD Indicator: Type of change to table ANUPD CHAR 1 0
D Delete
I Insert
U Update
NULL No changes
AUFWTG Revaluation AUFWTG NUMC 2 0
XAFBE Indicator: Depreciation area is deactivated XAFBE CHAR 1 0
X Yes
NULL No
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
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