SAP table ANLB (Depreciation terms)

SAP table ANLB has 6 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,AFABE,BDATU.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 FAAV_COMP_CODE BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
AFABE Real depreciation area NUMC 2 0 FAAV_DEPR_AREA AFABE_D
BDATU Date Validity Ends DATS 8 0 BDATU
ADATU Date for Beginning of Validity DATS 8 0 ADATU
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Changed On DATS 8 0 AEDAT_ANLA
XLOEV Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
XSPEB Indicator: Is Account Blocked for Posting? CHAR 1 0 XSPEB
FELEI Screen Layout for Asset Accounting CHAR 4 0 T082A FELEI
XNEGA Indicator: Negative Values Allowed CHAR 1 0 XNEGA
XGWGK LVA: Maximum amount check and quantity check NUMC 1 0 XGWGK
0 No maximum amount check
1 Value based maximum amount check
2 Check maximum amount with quantity
XUNTA Indicator: Depreciate Main Asset Number Totally CHAR 1 0 XUNTA
AFABG Depreciation Calculation Start Date DATS 8 0 AFABG
ZINBG Start Date for Interest Calculation DATS 8 0 DZINBG
SAFBG Start date for special depreciation DATS 8 0 SAFBG
INVSL Investment Support Key CHAR 2 0 T085 INVSL
AFASL Depreciation key CHAR 4 0 T090NA AFASL
NDJAR Planned Useful Life in Years NUMC 3 0 NDJAR
NDPER Planned useful life in periods NUMC 3 0 NDPER
NAPRZ Ordinary Depreciation Percentage Rate DEC 7 4 NAPRZ
SAPRZ Special Depreciation Percentage Rate DEC 7 4 SAPRZ
WBIND Index series for replacement values CHAR 5 0 T094A WBIND
ALIND Index Series for Replacement Values by Age CHAR 5 0 T094A ALIND
APROP Variable depreciation portion DEC 7 4 APROP
UMJAR Depreciation key for the changeover year NUMC 4 0 UMJAR
NDURJ Original useful life in years NUMC 3 0 NDURJ
NDURP Original Useful Life in Periods NUMC 3 0 NDURP
SCHRW Asset scrap value CURR 23 2 SCHRW
LGJAN Last Fiscal Year for the Annual Values in Asset Acct. NUMC 4 0 LGJAN
PERFY Period Scaling in Depreciation Start Year NUMC 3 0 PERFY
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
AUFWTG Revaluation NUMC 2 0 AUFWTG
XAFBE Indicator: Depreciation area is deactivated CHAR 1 0 XAFBE
ANLGR Group Asset CHAR 12 0 ANLH ANLGR
ANLGR2 Subnumber of Group Asset CHAR 4 0 ANLA ANLGR2
VYEAR Acquisition Year of the Asset (Manually Changeable) NUMC 4 0 VYEAR
VMNTH Asset Accounting: Acquis. Month (in Depreciation Area) NUMC 3 0 VMNTH
INBDA Asset Accounting: Date of Operating Readiness DATS 8 0 INBDA
ABGDAT_B Value date of last retirement for the depreciation area DATS 8 0 ABGDAT_B
DEAKT_B Deactivation Date of Depreciation area DATS 8 0 DEAKT_B
J_1AARVKEY Revaluation Key CHAR 4 0 J_1AAA2 J_1AARVKEY
J_1AALTDAT Last Revaluation Date DATS 8 0 J_1AALTDAT
J_1AALTIDX Last Index Used CHAR 5 0 J_1AALTIDX
SCHRW_PROZ Scrap Value as Percentage of APC DEC 14 11 SCHRW_PROZ
UMPER Changeover Period of Depreciation Key NUMC 3 0 UMPER

ANLB foreign key relationships

Table Field Check Table Check Field
0 ANLB AFABE FAAV_DEPR_AREA Generated Table for View DEPR_AREA
1 ANLB AFASL T090NA Depreciation Keys MANDT
1 ANLB AFASL T090NA Depreciation Keys AFAPL
1 ANLB AFASL T090NA Depreciation Keys AFASL
0 ANLB ANLGR ANLH Main asset number BUKRS
0 ANLB ANLGR ANLH Main asset number ANLN1
1 ANLB ANLGR2 ANLA Asset Master Record Segment BUKRS
1 ANLB ANLGR2 ANLA Asset Master Record Segment ANLN1
1 ANLB ANLGR2 ANLA Asset Master Record Segment ANLN2
0 ANLB ANLN1 ANLH Main asset number BUKRS
0 ANLB ANLN1 ANLH Main asset number ANLN1
1 ANLB ANLN2 ANLA Asset Master Record Segment BUKRS
1 ANLB ANLN2 ANLA Asset Master Record Segment ANLN1
1 ANLB ANLN2 ANLA Asset Master Record Segment ANLN2
0 ANLB FELEI T082A Field string asset master record maintenance MANDT
0 ANLB FELEI T082A Field string asset master record maintenance FEGTB
1 ANLB INVSL T085 Investment support measures MANDT
1 ANLB INVSL T085 Investment support measures AFAPL
1 ANLB INVSL T085 Investment support measures INVSL
0 ANLB J_1AARVKEY J_1AAA2 Revaluation Key BUKRS