SAP ANLB Depreciation terms Table
Overview
ANLB is a standard SAP S/4HANA table that stores Depreciation terms data. There are total 49 fields in the ANLB table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ANLB belongs to Basic Functions (FI-AA-AA) module and is located in the package Assets: Master Data (AA).
In addition, following links provide an overview of foreign key relationships, if any, that link ANLB to other SAP tables and standard CDS views available based on ANLB table in S/4HANA 2020.
Techincal Settings of ANLB
Below are technical details of the table ANLB
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ANLB Fields
The following table gives you an overview of the fields available in ANLB
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| BUKRS | Company Code | BUKRS | FAAV_COMP_CODE | CHAR | 4 |
| ANLN1 | Main Asset Number | ANLN1 | ANLH | CHAR | 12 |
| ANLN2 | Asset Subnumber | ANLN2 | ANLA | CHAR | 4 |
| AFABE | Real depreciation area | AFABE_D | FAAV_DEPR_AREA | NUMC | 2 |
| BDATU | Date Validity Ends | BDATU | DATS | 8 | |
| ADATU | Date for Beginning of Validity | ADATU | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Changed On | AEDAT_ANLA | DATS | 8 | |
| XLOEV | Indicator: Account Marked for Deletion? | XLOEV | CHAR | 1 | |
| XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | |
| FELEI | Screen Layout for Asset Accounting | FELEI | T082A | CHAR | 4 |
| XNEGA | Indicator: Negative Values Allowed | XNEGA | CHAR | 1 | |
| XGWGK | Low-value asset amount and quantity check | XGWGK | NUMC | 1 | |
| XUNTA | Indicator: Depreciate Main Asset Number Totally | XUNTA | CHAR | 1 | |
| AFABG | Depreciation Calculation Start Date | AFABG | DATS | 8 | |
| ZINBG | Start Date for Interest Calculation | DZINBG | DATS | 8 | |
| SAFBG | Start date for special depreciation | SAFBG | DATS | 8 | |
| INVSL | Investment Support Key | INVSL | T085 | CHAR | 2 |
| AFASL | Depreciation key | AFASL | T090NA | CHAR | 4 |
| NDJAR | Planned Useful Life in Years | NDJAR | NUMC | 3 | |
| NDPER | Planned useful life in periods | NDPER | NUMC | 3 | |
| NAPRZ | Ordinary Depreciation Percentage Rate | NAPRZ | DEC | 7 | |
| SAPRZ | Special Depreciation Percentage Rate | SAPRZ | DEC | 7 | |
| WBIND | Index series for replacement values | WBIND | T094A | CHAR | 5 |
| ALIND | Index Series for Replacement Values by Age | ALIND | T094A | CHAR | 5 |
| APROP | Variable depreciation portion | APROP | DEC | 7 | |
| UMJAR | Depreciation key for the changeover year | UMJAR | NUMC | 4 | |
| NDURJ | Original useful life in years | NDURJ | NUMC | 3 | |
| NDURP | Original useful life in periods | NDURP | NUMC | 3 | |
| SCHRW | Asset scrap value | SCHRW | CURR | 23 | |
| LGJAN | Last Fiscal Year for the Annual Values in Asset Acct. | LGJAN | NUMC | 4 | |
| PERFY | Period Scaling in Depreciation Start Year | PERFY | NUMC | 3 | |
| ANUPD | Indicator: Type of change to table | ANUPD | CHAR | 1 | |
| AUFWTG | Revaluation | AUFWTG | NUMC | 2 | |
| XAFBE | Indicator: Depreciation area is deactivated | XAFBE | CHAR | 1 | |
| ANLGR | Group Asset | ANLGR | ANLH | CHAR | 12 |
| ANLGR2 | Subnumber of Group Asset | ANLGR2 | ANLA | CHAR | 4 |
| VYEAR | Acquisition Year of the Asset (Manually Changeable) | VYEAR | NUMC | 4 | |
| VMNTH | Asset Accounting: Acquis. Month (in Depreciation Area) | VMNTH | NUMC | 3 | |
| INBDA | Asset Accounting: Date of Operating Readiness | INBDA | DATS | 8 | |
| ABGDAT_B | Value date of last retirement for the depreciation area | ABGDAT_B | DATS | 8 | |
| DEAKT_B | Deactivation Date of Depreciation area | DEAKT_B | DATS | 8 | |
| J_1AARVKEY | Revaluation Key | J_1AARVKEY | J_1AAA2 | CHAR | 4 |
| J_1AALTDAT | Last Revaluation Date | J_1AALTDAT | DATS | 8 | |
| J_1AALTIDX | Last Index Used | J_1AALTIDX | CHAR | 5 | |
| UMPER | Changeover Period of Depreciation Key | UMPER | NUMC | 3 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ANLB
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ANLB | AFABE | 1: CN | FAAV_DEPR_AREA |
| ANLB | AFASL | 1: N | T090NA |
| ANLB | ALIND | 1: CN | T094A |
| ANLB | ANLGR | C: CN | ANLH |
| ANLB | ANLGR2 | C: CN | ANLA |
| ANLB | ANLN1 | 1: 1 | ANLH |
| ANLB | ANLN2 | 1: 1 | ANLA |
| ANLB | BUKRS | 1: CN | FAAV_COMP_CODE |
| ANLB | FELEI | 1: CN | T082A |
| ANLB | INVSL | C: CN | T085 |
| ANLB | J_1AARVKEY | 1: CN | J_1AAA2 |
| ANLB | WBIND | 1: CN | T094A |