SAP table ANKB (Asset class: depreciation area)
SAP table ANKB has 5 primary key fields being MANDT,ANLKL,AFAPL,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
ANLKL
Asset Class
CHAR
8
0
ANKA
ANLKL
AFAPL
Chart of Depreciaton for Asset Valuation
CHAR
4
0
T096
AFAPL
AFABE
Depreciation Area Real or Derived
NUMC
2
0
T093
AFABER
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
XSPEB
Indicator: Lock Asset Class (Chart of Depreciation-Specif.)
CHAR
1
0
XSPEB_ANKB
XLOEV
Indicator: Class/Area Marked for Deletion
CHAR
1
0
XLOEV_ANKB
FELEI
Screen Layout for Asset Accounting
CHAR
4
0
T082A
FELEI
KTOGR
Account Determination
CHAR
8
0
T095A
KTOGR
XNEGA
Indicator: Negative Values Allowed
CHAR
1
0
XNEGA
XGWGK
LVA: Maximum amount check and quantity check
NUMC
1
0
XGWGK
Possible values
0
No maximum amount check
1
Value based maximum amount check
2
Check maximum amount with quantity
MINDJ
Minimum Useful Life in Years
NUMC
3
0
MINDJ
MINDP
Minimum Useful Life in Periods
NUMC
3
0
MINDP
MAXDJ
Maximum Useful Life in Years
NUMC
3
0
MAXDJ
MAXDP
Maximum Useful Life in Periods
NUMC
3
0
MAXDP
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
XUNTA
Indicator: Depreciate Main Asset Number Totally
CHAR
1
0
XUNTA
XAFBE
Indicator: Depreciation area is deactivated
CHAR
1
0
XAFBE
ANLGR
Group Asset
CHAR
12
0
ANLH
ANLGR
J_1AARVKEY
Revaluation Key
CHAR
4
0
J_1AAA2
J_1AARVKEY
ANKB foreign key relationships
Table
Field
Check Table
Check Field
0 ANKB
AFABE
T093
Real and derived depreciation areas
MANDT
0 ANKB
AFABE
T093
Real and derived depreciation areas
AFAPL
0 ANKB
AFABE
T093
Real and derived depreciation areas
AFABER
1 ANKB
AFAPL
T096
Chart of depreciation
MANDT
0 ANKB
AFASL
T090NA
Depreciation Keys
MANDT
0 ANKB
AFASL
T090NA
Depreciation Keys
AFAPL
0 ANKB
AFASL
T090NA
Depreciation Keys
AFASL
1 ANKB
ANLGR
ANLH
Main asset number
BUKRS
1 ANKB
ANLGR
ANLH
Main asset number
ANLN1
0 ANKB
ANLKL
ANKA
Asset classes: general data
ANLKL
1 ANKB
FELEI
T082A
Field string asset master record maintenance
MANDT
1 ANKB
FELEI
T082A
Field string asset master record maintenance
FEGTB
0 ANKB
INVSL
T085
Investment support measures
MANDT
0 ANKB
INVSL
T085
Investment support measures
AFAPL
0 ANKB
INVSL
T085
Investment support measures
INVSL
1 ANKB
J_1AARVKEY
J_1AAA2
Revaluation Key
BUKRS
0 ANKB
KTOGR
T095A
Account allocation
MANDT
0 ANKB
KTOGR
T095A
Account allocation
KTOGR