ANLB SAP (Depreciation terms) Table details
Dictionary Type: Table
Description: Depreciation terms
Description: Depreciation terms
Table field list including key, data, relationships and ABAP select examples
ANLB is a standard SAP Table which is used to store Depreciation terms data and is available within R/3 SAP systems depending on the version and release level.
The ANLB table consists of various fields, each holding specific information or linking keys about Depreciation terms data available in SAP. These include BUKRS (Company Code), ANLN1 (Main Asset Number), ANLN2 (Asset Subnumber), AFABE (Real depreciation area).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ANLB table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
AFABE | Real depreciation area | AFABE_D | NUMC | 2 | T093 | AFABE | AFB | ||
BDATU | Date validity ends | BDATU | DATS | 8 | DATUM | ||||
ADATU | Date for beginning of validity | ADATU | DATS | 8 | DATUM | ADT | |||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed on | AEDAT_ANLA | DATS | 8 | DATUM | ||||
XLOEV | Indicator: Account marked for deletion? | XLOEV | CHAR | 1 | XFELD | ||||
XSPEB | Indicator: Is Account Blocked for Posting? | XSPEB | CHAR | 1 | XFELD | ||||
FELEI | Screen layout for Asset Accounting | FELEI | CHAR | 4 | T082A | FELEI | |||
XNEGA | Indicator: Negative values allowed | XNEGA | CHAR | 1 | XFELD | ||||
XGWGK | Low-value asset amount and quantity check | XGWGK | NUMC | 1 | XGWGK | ||||
XUNTA | Indicator: Depreciate main asset number totally | XUNTA | CHAR | 1 | XFELD | ||||
AFABG | Depreciation calculation start date | AFABG | DATS | 8 | DATUM | ||||
ZINBG | Start date for interest calculation | DZINBG | DATS | 8 | DATUM | ||||
SAFBG | Start date for special depreciation | SAFBG | DATS | 8 | DATUM | ||||
INVSL | Investment support key | INVSL | CHAR | 2 | T085 | INVSL | |||
AFASL | Depreciation key | AFASL | CHAR | 4 | T090NA | AFASL | SH_AFASL | ||
NDJAR | Planned useful life in years | NDJAR | NUMC | 3 | JARAF | ||||
NDPER | Planned useful life in periods | NDPER | NUMC | 3 | PERAF | ||||
NAPRZ | Ordinary depreciation percentage rate | NAPRZ | DEC | 7(4) | AFPROZ | ||||
SAPRZ | Special depreciation percentage rate | SAPRZ | DEC | 7(4) | AFPROZ | ||||
WBIND | Index series for replacement values | WBIND | CHAR | 5 | T094A | WBIND | |||
ALIND | Index series for replacement values by age | ALIND | CHAR | 5 | T094A | WBIND | |||
APROP | Variable depreciation portion | APROP | DEC | 7(4) | DEC3_4 | ||||
UMJAR | Depreciation key for the changeover year | UMJAR | NUMC | 4 | GJAHR | GJAHR | |||
NDURJ | Original useful life in years | NDURJ | NUMC | 3 | JARAF | ||||
NDURP | Original useful life in periods | NDURP | NUMC | 3 | PERAF | ||||
SCHRW | Asset scrap value | SCHRW | CURR | 13(2) | ANLKWERT | ||||
LGJAN | Last fiscal year for the annual values in Asset Acct. | LGJAN | NUMC | 4 | GJAHR | GJAHR | |||
PERFY | Period scaling in depreciation start year | PERFY | NUMC | 3 | PERAF | ||||
ANUPD | Indicator: Type of change to table | ANUPD | CHAR | 1 | ANUPD | ||||
AUFWTG | Revaluation | AUFWTG | NUMC | 2 | Assigned to domain | AUFWTG | |||
XAFBE | Indicator: Depreciation area is deactivated | XAFBE | CHAR | 1 | XFELD | ||||
ANLGR | Group asset | ANLGR | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLGR2 | Subnumber of group asset | ANLGR2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | ||
VYEAR | Acquisition year of the asset (manually changeable) | VYEAR | NUMC | 4 | GJAHR | GJAHR | |||
VMNTH | Asset Accounting: Acquis. month (in depreciation area) | VMNTH | NUMC | 3 | POPER | ||||
INBDA | Asset Accounting: Date of operating readiness | INBDA | DATS | 8 | DATUM | ||||
ABGDAT_B | Value date of last retirement for the depreciation area | ABGDAT_B | DATS | 8 | DATUM | ||||
J_1AARVKEY | Revaluation Key | J_1AARVKEY | CHAR | 4 | J_1AAA2 | J_1AARVKEY | |||
J_1AALTDAT | Last Revaluation Date | J_1AALTDAT | DATS | 8 | DATUM | ||||
J_1AALTIDX | Last Index Used | J_1AALTIDX | CHAR | 5 | Assigned to domain | J_1AINDXP | |||
SCHRW_PROZ | Scrap Value as Percentage of APC | SCHRW_PROZ | DEC | 14(11) | |||||
UMPER | Changeover Period of Depreciation Key | UMPER | NUMC | 3 | PERAF |
Key field | Non-key field |
How do I retrieve data from SAP table ANLB using ABAP code
The following ABAP code Example will allow you to do a basic selection on ANLB to SELECT all data from the tableDATA: WA_ANLB TYPE ANLB.
SELECT SINGLE *
FROM ANLB
INTO CORRESPONDING FIELDS OF WA_ANLB
WHERE...
How to access SAP table ANLB
Within an ECC or HANA version of SAP you can also view further information about ANLB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects