SAP Table ANLB stores Depreciation termsdata

  

In this post, I will try and describe everything you need to know about the SAP anlb table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for ANLB what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from ANLB....Right lets get started!


SAP ANLB dictionary attributes

Object Name: ANLB
Dictionary Type: Transparent table
Description: Depreciation terms


ANLB field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTEST
BUKRSBUKRSCHAR4(0) T001Company CodeBUKRSBUKFBC_T001BUKRS
ANLN1ANLN1CHAR12(0) ANLHMain Asset NumberANLN1AN1AA
ANLN2ANLN2CHAR4(0) ANLAAsset SubnumberANLN2AN2AA
AFABEAFABE_DNUMC2(0) T093Real depreciation areaAFABEAFBAB
BDATUBDATUDATS8(0) Date validity endsDATUMAA
ADATUADATUDATS8(0) Date for beginning of validityDATUMADTABA
ERNAMERNAMCHAR12(0) Name of Person who Created the ObjectUSNAMSAP
ERDATERDATDATS8(0) Date on Which Record Was CreatedDATUMSAP
AENAMAENAMCHAR12(0) Name of Person Who Changed ObjectUSNAMSAP
AEDATAEDAT_ANLADATS8(0) Changed onDATUMAA
XLOEVXLOEVCHAR1(0) Indicator: Account marked for deletion?XFELDFB
XSPEBXSPEBCHAR1(0) Indicator: Is Account Blocked for Posting?XFELDFB
FELEIFELEICHAR4(0) T082AScreen layout for Asset AccountingFELEIAA
XNEGAXNEGACHAR1(0) Indicator: Negative values allowedXFELDABA
XGWGKXGWGKNUMC1(0) Low-value asset amount and quantity checkXGWGKAA
XUNTAXUNTACHAR1(0) Indicator: Depreciate main asset number totallyXFELDABA
AFABGAFABGDATS8(0) Depreciation calculation start dateDATUMABA
ZINBGDZINBGDATS8(0) Start date for interest calculationDATUMABA
SAFBGSAFBGDATS8(0) Start date for special depreciationDATUMABA
INVSLINVSLCHAR2(0) T085Investment support keyINVSLAB
AFASLAFASLCHAR4(0) T090NADepreciation keyAFASLABSH_AFASLAFASL
NDJARNDJARNUMC3(0) Planned useful life in yearsJARAFABA
NDPERNDPERNUMC3(0) Planned useful life in periodsPERAFABA
NAPRZNAPRZDEC7(4) Ordinary depreciation percentage rateAFPROZABA
SAPRZSAPRZDEC7(4) Special depreciation percentage rateAFPROZABA
WBINDWBINDCHAR5(0) T094AIndex series for replacement valuesWBINDABA
ALINDALINDCHAR5(0) T094AIndex series for replacement values by ageWBINDABA
APROPAPROPDEC7(4) Variable depreciation portionDEC3_4ABA
UMJARUMJARNUMC4(0) Depreciation key for the changeover yearGJAHRABA
NDURJNDURJNUMC3(0) Original useful life in yearsJARAFABA
NDURPNDURPNUMC3(0) Original useful life in periodsPERAFABA
SCHRWSCHRWCURR13(2) Asset scrap valueANLKWERTABA
LGJANLGJANNUMC4(0) Last fiscal year for the annual values in Asset Acct.GJAHRAA
PERFYPERFYNUMC3(0) Period scaling in depreciation start yearPERAFAB
ANUPDANUPDCHAR1(0) Indicator: Type of change to tableANUPDAA
AUFWTGAUFWTGNUMC2(0) *RevaluationAUFWTGAB
XAFBEXAFBECHAR1(0) Indicator: Depreciation area is deactivatedXFELDAB
ANLGRANLGRCHAR12(0) ANLHGroup assetANLN1AN1
ANLGR2ANLGR2CHAR4(0) ANLASubnumber of group assetANLN2
VYEARVYEARNUMC4(0) Acquisition year of the asset (manually changeable)GJAHR
VMNTHVMNTHNUMC3(0) Asset Accounting: Acquis. month (in depreciation area)POPER
INBDAINBDADATS8(0) Asset Accounting: Date of operating readinessDATUM
ABGDAT_BABGDAT_BDATS8(0) Value date of last retirement for the depreciation areaDATUMAB
J_1AARVKEYJ_1AARVKEYCHAR4(0) J_1AAA2Revaluation KeyJ_1AARVKEY
J_1AALTDATJ_1AALTDATDATS8(0) Last Revaluation DateDATUM
J_1AALTIDXJ_1AALTIDXCHAR5(0) *Last Index UsedJ_1AINDXP
SCHRW_PROZSCHRW_PROZDEC14(11) Scrap Value as Percentage of APC
UMPERUMPERNUMC3(0) Changeover Period of Depreciation KeyPERAFABA