ANLB SAP (Depreciation terms) Table details

Dictionary Type: Table
Description: Depreciation terms




ABAP Code to SELECT data from ANLB
Related tables to ANLB
Access table ANLB




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
ANLN1Main Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
AFABEReal depreciation area AFABE_DNUMC2T093AFABEAFB
BDATUDate validity ends BDATUDATS8DATUM
ADATUDate for beginning of validity ADATUDATS8DATUMADT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged on AEDAT_ANLADATS8DATUM
XLOEVIndicator: Account marked for deletion? XLOEVCHAR1XFELD
XSPEBIndicator: Is Account Blocked for Posting? XSPEBCHAR1XFELD
FELEIScreen layout for Asset Accounting FELEICHAR4T082AFELEI
XNEGAIndicator: Negative values allowed XNEGACHAR1XFELD
XGWGKLow-value asset amount and quantity check XGWGKNUMC1XGWGK
XUNTAIndicator: Depreciate main asset number totally XUNTACHAR1XFELD
AFABGDepreciation calculation start date AFABGDATS8DATUM
ZINBGStart date for interest calculation DZINBGDATS8DATUM
SAFBGStart date for special depreciation SAFBGDATS8DATUM
INVSLInvestment support key INVSLCHAR2T085INVSL
AFASLDepreciation key AFASLCHAR4T090NAAFASLSH_AFASL
NDJARPlanned useful life in years NDJARNUMC3JARAF
NDPERPlanned useful life in periods NDPERNUMC3PERAF
NAPRZOrdinary depreciation percentage rate NAPRZDEC7(4) AFPROZ
SAPRZSpecial depreciation percentage rate SAPRZDEC7(4) AFPROZ
WBINDIndex series for replacement values WBINDCHAR5T094AWBIND
ALINDIndex series for replacement values by age ALINDCHAR5T094AWBIND
APROPVariable depreciation portion APROPDEC7(4) DEC3_4
UMJARDepreciation key for the changeover year UMJARNUMC4GJAHRGJAHR
NDURJOriginal useful life in years NDURJNUMC3JARAF
NDURPOriginal useful life in periods NDURPNUMC3PERAF
SCHRWAsset scrap value SCHRWCURR13(2) ANLKWERT
LGJANLast fiscal year for the annual values in Asset Acct. LGJANNUMC4GJAHRGJAHR
PERFYPeriod scaling in depreciation start year PERFYNUMC3PERAF
ANUPDIndicator: Type of change to table ANUPDCHAR1ANUPD
AUFWTGRevaluation AUFWTGNUMC2Assigned to domainAUFWTG
XAFBEIndicator: Depreciation area is deactivated XAFBECHAR1XFELD
ANLGRGroup asset ANLGRCHAR12ANLHALPHAANLN1AN1
ANLGR2Subnumber of group asset ANLGR2CHAR4ANLAALPHAANLN2
VYEARAcquisition year of the asset (manually changeable) VYEARNUMC4GJAHRGJAHR
VMNTHAsset Accounting: Acquis. month (in depreciation area) VMNTHNUMC3POPER
INBDAAsset Accounting: Date of operating readiness INBDADATS8DATUM
ABGDAT_BValue date of last retirement for the depreciation area ABGDAT_BDATS8DATUM
J_1AARVKEYRevaluation Key J_1AARVKEYCHAR4J_1AAA2J_1AARVKEY
J_1AALTDATLast Revaluation Date J_1AALTDATDATS8DATUM
J_1AALTIDXLast Index Used J_1AALTIDXCHAR5Assigned to domainJ_1AINDXP
SCHRW_PROZScrap Value as Percentage of APC SCHRW_PROZDEC14(11)
UMPERChangeover Period of Depreciation Key UMPERNUMC3PERAF

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!