SAP Table ANLAV stores Asset Reporting: ANLA Fields Plus Cost Center...data

  

In this post, I will try and describe everything you need to know about the SAP anlav 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 ANLAV 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 ANLAV....Right lets get started!


SAP ANLAV dictionary attributes

Object Name: ANLAV
Dictionary Type: Structure
Description: Asset Reporting: ANLA Fields Plus Cost Center...


ANLAV 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
ANLKLANLKLCHAR8(0) ANKAAsset ClassANLKLANKAASH_ANLKAANLKL
GEGSTGEGSTCHAR8(0) Technical asset numberGEGSTAB
ANEQKANEQKNUMC1(0) Indicator: Historical managementANEQKAA
ANEQSANEQSNUMC1(0) Completeness indicator for the assetANEQSAA
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
XSPEBXSPEB_ANLACHAR1(0) Indicator: Asset Locked to Acquisition PostingsXFELDAA
FELEIFELEICHAR4(0) T082AScreen layout for Asset AccountingFELEIAA
KTOGRKTOGRCHAR8(0) T095AAccount determinationKTOGRAB
XOPVWXOPVWCHAR1(0) Indicator: Open item management?XFELDFB
ANLTPANLTPNUMC1(0) Asset CategoryANLTPAA
ZUJHRDZUJAHRNUMC4(0) Fiscal year in which first acquisition was postedGJAHRAA
ZUPERDZUPERNUMC3(0) Period in which first acquisition was postedPOPERAA
ZUGDTDZUGDATDATS8(0) Asset value date of the first postingDATUMAA
AKTIVAKTIVDDATS8(0) Asset capitalization dateDATUMAA
ABGDTABGDATDATS8(0) Asset value date for the last retirementDATUMAB
DEAKTDEAKTDATS8(0) Deactivation dateDATUMAA
GPLABGPLABDATS8(0) Planned retirement dateDATUMAA
BSTDTBSTDTDATS8(0) Asset purchase order dateDATUMAA
ORD41ORD41CHAR4(0) T087Evaluation group 1ORD4XAA
ORD42ORD42CHAR4(0) T087Evaluation group 2ORD4XAA
ORD43ORD43CHAR4(0) T087Evaluation group 3ORD4XAA
ORD44ORD44CHAR4(0) T087Evaluation group 4ORD4XAB
ANLUEANLUECHAR12(0) T087UAsset super numberANLUEAAH_T087UANLUE
LIFNRLIFNRCHAR10(0) LFA1Account Number of Vendor or CreditorLIFNRLIFFBKRED_CLIFNR
LAND1LAND1CHAR3(0) T005Country KeyLAND1LNDFB
LIEFELIEFECHAR30(0) Name of asset supplierTEXT30AA
HERSTHERSTCHAR30(0) Manufacturer of assetTEXT30AA
EIGKZEIGKZCHAR1(0) T097Property indicatorEIGKZAA
AIBN1AIBN1CHAR12(0) ANLHOriginal asset that was transferredANLN1AA
AIBN2AIBN2CHAR4(0) ANLAOriginal asset that was transferredANLN2AA
AIBDTAIBDTDATS8(0) Original acquisition date of AuC/ transferred assetDATUMAA
URJHRURJHRNUMC4(0) Fiscal year of original acquisitionGJAHRAA
URWRTURWRTCURR13(2) Original acquisition valueANLKWERTAA
ANTEIANTEIDEC5(2) In-house production percentagePRZ32AA
PROJNPROJNCHAR16(0) Old: Project number : No longer used --> PS_POSNRPROJNKP
EAUFNEAUFNCHAR12(0) AUFKInvestment orderAUFNRAB
MEINSMEINSUNIT3(0) T006Base Unit of MeasureMEINSMG
MENGEMENGE_DQUAN13(3) QuantityMENG13MG
TYPBZTYPBZ_ANLACHAR15(0) Asset type nameTYPBZ_ANLAAA
IZWEKIZWEKCHAR2(0) T087IReason for investmentIZWEKAA
INKENINKENCHAR1(0) Inventory indicatorXFELDAA
IVDATIVDAT_ANLADATS8(0) Last inventory dateDATUMAA
INVZUINVZU_ANLACHAR15(0) Supplementary inventory specificationsINVZU_ANLAAA
VMGLIVMGLICHAR4(0) T092Property classification keyVMGLIAA
XVRMWXVRMWCHAR1(0) Manual net worth tax valueXFELDAA
WRTMAWRTMACURR13(2) Manual net worth tax valueANLKWERTAA
EHWRTEHWRTCURR13(2) Assessed valueANLKWERTAA
AUFLAAUFLA_ANLADATS8(0) Date of conveyanceDATUMAA
EHWZUEHWZU_ANLADATS8(0) Date of last notice of assessmentDATUMAA
EHWNREHWNR_ANLACHAR16(0) Tax number of the notice of assessmentEHWNR_ANLAAA
GRUVOGRUVO_ANLADATS8(0) Land Register ofDATUMAA
GREINGREIN_ANLADATS8(0) Land register entry onDATUMAA
GRBNDGRBND_ANLACHAR5(0) Land register volumeGRBND_ANLAAA
GRBLTGRBLT_ANLACHAR5(0) Land register pageGRBLT_ANLAAA
GRLFDGRLFD_ANLACHAR4(0) Land register entry: Sequence numberGRLFD_ANLAAA
FLURKFLURK_ANLACHAR4(0) Land register map numberCHAR4AA
FLURNFLURN_ANLACHAR10(0) Plot numberCHAR10AA
FIAMTFIAMTCHAR25(0) Local tax officeTEXT25AA
STADTORT01_ANLACHAR25(0) MunicipalityTEXT25AA
GRUNDGRUNDCHAR3(0) T098Reason for manual valuation of net assetsGRUNDAA
FEINSFEINSUNIT3(0) T006Area unitMEINSFEHAA
GRUFLGRUFLQUAN13(3) Surface areaMENG13AA
INVNRINVNR_ANLACHAR25(0) Inventory numberINVNR_ANLAAA
VBUNDRASSCCHAR6(0) T880Company ID of trading partnerRCOMPPGSFG
TXT50TXA50_ANLTCHAR50(0) Asset descriptionTEXT50AA
TXA50TXA50_ANLTCHAR50(0) Asset descriptionTEXT50AA
XLTXIDXLTXIDCHAR1(0) Indicator: Long text activeXFELDAB
XVERIDXVERIDCHAR1(0) Long text indicator:Property valuesXFELDAB
XTCHIDXTCHIDCHAR1(0) Indicator: Technical view long textXFELDAB
XKALIDXKALIDCHAR1(0) Indicator: Long text activeXFELDAB
XHERIDXHERIDCHAR1(0) Indicator: Long text for manufacturer/originXFELDAB
XLEAIDXLEAIDCHAR1(0) Indicator: Leasing data long textXFELDAB
LEAFILEAFICHAR10(0) LFA1Leasing companyLIFNRAA
LVDATLVDATDATS8(0) Leasing agreement dateDATUMAA
LKDATLKDATDATS8(0) Leasing agreement notice dateDATUMAA
LEABGLEABGDATS8(0) Lease start dateDATUMAA
LEJARLEJARNUMC3(0) Length of lease in yearsJARAFABA
LEPERLEPERNUMC3(0) Length of lease in periodsPERAFAA
LRYTHLRYTHNUMC3(0) Lease payment cyclePERAFAA
LEGEBLEGEBCURR13(2) Periodic lease payment paid to leasing company/lessorANLKWERTAA
LBASWLBASWCURR13(2) Leasing base value as newANLKWERTAA
LKAUFLKAUFCURR13(2) Leased asset purchase priceANLKWERTAA
LZINSLZINSDEC7(4) Leasing interest rate (capital lease)AFPROZAA
LTZBWLTZBWDATS8(0) Posting date of the last lease paymentDATUMAA
LKUZALKUZACURR13(2) Total of posted leasing paymentsANLKWERTAA
LKUZILKUZICURR13(2) Total leasing interest postedANLKWERTAA
LLAVBLLAVBCURR13(2) Total of long-term leasing liabilityANLKWERTAA
LEANZLEANZDEC5(0) Number of lease paymentsDEC5AA
LVTNRLVTNRCHAR15(0) Leasing agreement numberCHAR15AA
LETXTLETXTCHAR50(0) Leasing data textTEXT50AA
AIMMOAIMMONUMC1(0) Indicator: real estateAIMMOAA
OBJNROBJNRCHAR18(0) Object number (forecast)OBJNROBNMP
OBARTIM_OBARTCHAR2(0) Allowed object types for cap. inv. programsIM_OBART
PSPHIPS_PSPHINUMC8(0) PROJCurrent number of the appropriate projectPS_PSPNRCN
PRNAMIM_PRNAMCHAR8(0) IMTPInvestment program nameIM_PRNAMIMT
PRPOSIM_POSNRNUMC8(0) IMPRPosition numberIM_POSNR
PRGJRGJAHRNUMC4(0) Fiscal YearGJAHRGJRFB
IMAPOIMA_POSNRCHAR12(0) IMAKInternal number for appropriation requestIMA_POSNRIAFIIMAPOSNR
IMAPEIMA_POSIDCHAR24(0) Appropriation Request Number (Formatted for Coding Mask)IMA_POSIDIAGIIMAPOSID
IMAVAIMA_VARNTCHAR4(0) Variant of Appropriation RequestIMA_VARNTIAVSVARNTVARNT
IMAGNIM_GNJHRNUMC4(0) Approval year of the investment programGJAHRGJR
LFDNRIM_LFDNRNUMC3(0) Sequence numberNUMC3
LFDHIIM_LFDHINUMC6(0) Consecutive no. within hierarchyNUMC6
LEARTLEARTCHAR2(0) T083LLeasing typeLEASARTAA
LVORSLVORSCHAR1(0) Advance paymentsXFELDAA
GDLGRPGDLGRPCHAR8(0) T087GEvaluation group 5GDLGRP
POSNRAM_POSIDCHAR24(0) WBS element investment projectPS_POSIDPRPOSID
PSPIDAM_PSPIDCHAR24(0) Project definitionPS_PSPIDCNPRSPSPID
XERWRTXERWRTCHAR1(0) Indicator: Ignore memo valueXFELD
XAFABCHXAFABCHCHAR1(0) Asset acquired usedXFELD
XANLGRXANLGRCHAR1(0) Indicator: asset class managed as group assetXFELD
XINVMIM_XINVMCHAR1(0) Asset under Construction for Investment MeasuresXFELDFB
SERNRAM_SERNRCHAR18(0) Serial numberGERNRSERINST
UMWKZAM_UMWKZCHAR5(0) T087KReason for environmental investmentAM_UMWKZ
LRVDATAM_LRVDATDATS8(0) Date of last revaluationDATUM
BDATUBDATUDATS8(0) Date validity endsDATUMAA
ADATUADATUDATS8(0) Date for beginning of validityDATUMADTABA
KOSTLKOSTLCHAR10(0) CSKSCost CenterKOSTLKOSKS
WERKSWERKS_DCHAR4(0) T001WPlantWERKSWRKKCH_T001W_CWERKS
GSBERGSBERCHAR4(0) TGSBBusiness AreaGSBERGSBFB
LSTARLSTARCHAR6(0) CSLAActivity TypeLSTARLARKSLART_EMPTYLSTAR
MSFAKMSFAKDEC3(2) Multiple-shift factor for multiple shift operationMSFAKABA
XSTILXSTILCHAR1(0) Asset shutdownXFELDABA
STORTSTORTCHAR10(0) T499SAsset locationAP_STANDTEST
CAUFNCAUFNCHAR12(0) AUFKInternal orderAUFNRAB
RAUMNRAUMNRCHAR8(0) RoomCHAR8INST
IAUFNIAUFNCHAR12(0) AUFKMaintenance orderAUFNRAB
IPROJPROJNCHAR16(0) Old: Project number : No longer used --> PS_POSNRPROJNKP
TPLNRTPLNRCHAR30(0) IFLOTFunctional LocationTPLNRIFLINSTIFLMTPLNR
TXJCDTXJCDCHAR15(0) TTXJTax JurisdictionTXJCDTXJFB
IPSNRAM_IPSNRNUMC8(0) PRPSWBS element - maintenance projectPS_POSNR
KTANSWKTANSWCHAR10(0) SKA1Bal. sheet account: Acquisition and production costsSAKNRABB
ERGSOAM_ERGSOCHAR10(0) AA: Balance sheet item (debit)ERGSL
ERGHBAM_ERGHBCHAR10(0) FI-AA: Balance sheet item (credit)ERGSL
KHINRKHINRCHAR12(0) Standard Hierarchy AreaSETNRKSS
ANLN0ANLN0CHAR12(0) ANLHReporting: Asset main numberANLN1AN1AA
WRTTPAM_WRTTPCHAR1(0) Asset-value typeAM_WRTTP
KFZKZAM_KFZKZCHAR15(0) License plate no. of vehichleAM_KFZKZ
PERNRPERNR_DNUMC8(0) Personnel NumberPERNRPERPB
KOSTLVKOSTLVCHAR10(0) CSKSCost center responsible for assetKOSTL
ANLHTXTANLHTXTCHAR50(0) Asset main number textTEXT50
ADDRNUMAD_ADDRNUMCHAR10(0) *Address numberAD_ADDRNUMADR
KTSAKANFIAA_KTSAKANCHAR10(0) APC balance sheet account in significant lengthCHAR10
KTAUFWKTAUFWCHAR10(0) *Reconciliation account: RevaluationSAKNRABB
KTAUFANFIAA_KTAUFANCHAR10(0) Balance Sheet Account Revaluation to Significant LengthCHAR10
POSNR2AM_POSID2CHAR24(0) WBS Element (Costs for Depreciation)PS_POSIDPRPOSID
PSPID2AM_PSPID2CHAR24(0) Project Definition for DepreciationPS_PSPIDCNPRSPSPID
HAS_TDDPHAS_TDDPCHAR1(0) Asset Has Time-Dependent Valuation Parameters in ANLBZABOOLE
LAST_REORG_DATEFAA_LAST_REORGDATS8(0) Date of Last ReorganizationDATUM
FISTLFISTLCHAR16(0) *Funds CenterFISTLFIS
GEBERBP_GEBERCHAR10(0) *FundBP_GEBERFIC
FKBERFKBERCHAR16(0) *Functional AreaFKBERFBE
GRANT_NBRGM_GRANT_NBRCHAR20(0) GrantGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERICGRANT_NUMBER
GEBER2BP_GEBER2CHAR10(0) *Fund for APC Account AssignmentsBP_GEBERFIC
FKBER2FKBER2CHAR16(0) *Functional Area for APC Account AssignmentsFKBERFBE
GRANT_NBR2GM_GRANT_NBR2CHAR20(0) Grant for APC Account AssignmentsGM_GRANT_NBR
FISTL2FISTL2CHAR16(0) *Funds Center for APC Account AssignmentsFISTLFIS
IMKEYIMKEYCHAR8(0) Internal Key for Real Estate ObjectIMKEYFVV
PS_PSP_PNR2PS_PSP_PNR2NUMC8(0) *WBS Element (Costs)PS_POSNR
BUDGET_PDFM_BUDGET_PERIODCHAR10(0) *FM: Budget PeriodFM_BUDGET_PERIODBUDPER
BUDGET_PD2FM_BUDGET_PERIOD2CHAR10(0) *Budget Period for APC Account AssignmentsFM_BUDGET_PERIODBUDPER
SEGMENTFB_SEGMENTCHAR10(0) FAGL_SEGMSegment for Segmental ReportingFB_SEGMENT
PRCTRPRCTRCHAR10(0) *Profit CenterPRCTRPRCKEPRCTR_EMPTYPRCTR
GLO_RUS_DEPGRJ_3RFAMORTGRCHAR4(0) J_3RFDEPRGROUPDepreciation GroupORD4X
GLO_RUS_OKOFJ_3RFOKOFCHAR9(0) J_3RFTOKOFOKOF CodeCHAR009
GLO_RUS_SERNRJ_3RFSERNRCHAR32(0) Serial NumberCHAR32
GLO_RUS_PRECCTJ_3RPRECCCHAR30(0) Precious materials codesCHAR30
GLO_RUS_PRECQJ_3RPRECQCHAR40(0) Quantities list of countable precious materialsCHAR40
GLO_RUS_PRECWJ_3RPRECWCHAR50(0) Weights list of precious materials
GLO_RUS_TTX_TYPEJ_3RTYPVCHAR5(0) J_3RTTYPVEHTransport Type
GLO_RUS_TTX_VINFLEET_VINCHAR30(0) Manufacturer Vehicle Identification Number for Fleet ObjectFLEET_VIN
GLO_RUS_TTX_MNFDJ_3RTBAUJJDATS8(0) Manufacturing Date
GLO_RUS_TTX_ECOCLASSJ_3R_ECOCLASSNUMC1(0) Ecological ClassNUMC1
GLO_RUS_ECOCLASSJ_3R_ECOCLASSNUMC1(0) Ecological ClassNUMC1
GLO_RUS_ECO_CLSJ_3R_ECO_CLSCHAR1(0) Ecological ClassJ_3R_ECO_CLS
GLO_RUS_PRT_TYPEJ_3RFPROPTYPECHAR1(0) J_3RFPROPTYPESProperty TypeCHAR1
GLO_RUS_SHD_RSNJ_3RSTOPREASONCHAR4(0) J_3RFSTOPREASONShutdown ReasonCHAR4
GLO_RUS_SHD_DOCNJ_3RFSHDDOCNCHAR32(0) Shutdown DocumentCHAR32
GLO_RUS_PLD_CHCKJ_3RFPLDCHCKCHAR1(0) Asset PledgedXFELD
GLO_RUS_PLD_AMNTJ_3RFPLDAMNTCURR13(2) Pledge AmountCURRV13
GLO_RUS_PLD_RCPNJ_3RFPLDRCPNCHAR10(0) PledgeeCHAR10
GLO_RUS_DOCNUMJ_3RFDOCNUMCHAR32(0) Document NumberCHAR32
GLO_RUS_ICNMBJ_3RFICNMBCHAR25(0) Inventory Card Number
GLO_RUS_TXB_TYPEUNIT_POWERUNIT3(0) T006Power unitMEINS
GLO_RUS_TXB_UNITJ_3RTXBUNITQUAN13(3) Tax Base UnitGLO_RUS_TXB_UNIT
GLO_RUS_TTX_EXMPJ_3RTNOTXCHAR5(0) J_3RTNTVEHTransport Tax Exemption Code
GLO_RUS_TTX_PRVGJ_3RTPREFCHAR5(0) J_3RTPRTAXTransport Tax Reduction Code
GLO_RUS_TTX_STLDJ_3RTDTBRADATS8(0) Date Stolen
GLO_RUS_TTX_RTRDJ_3RTDTBRBDATS8(0) Return Date
GLO_RUS_TTX_RGSDJ_3RTREGDATS8(0) Registration Date
GLO_RUS_TTX_RMVDJ_3RTREMDATS8(0) Cancellation Date
GLO_RUS_TTX_OKT1J_3RTOKATO1CHAR2(0) OKATO Code (Part 1)CHAR02
GLO_RUS_TTX_OKT2J_3RTOKATO2CHAR3(0) OKATO Code (Part 2)CHAR03
GLO_RUS_TTX_OKT3J_3RTOKATO3CHAR3(0) OKATO Code (Part 3)CHAR03
GLO_RUS_TTX_OKT4J_3RTOKATO4CHAR3(0) OKATO Code (Part 4)CHAR03
GLO_RUS_TTX_LNUMLICENSE_NUMCHAR15(0) License plate numberLICENSE_NUM
GLO_RUS_TTX_AMTREDUCTIONJ_3R_AMTREDUCTIONCHAR5(0) Transport tax amount reduction codeCHAR5
GLO_RUS_AMTREDJ_3R_AMTREDUCTIONCHAR5(0) Transport tax amount reduction codeCHAR5
GLO_RUS_PRT_OKT1J_3RFOKATO1CHAR2(0) J_3RFOKATOOKATO Code (Part 1)CHAR02
GLO_RUS_PRT_OKT2J_3RFOKATO2CHAR3(0) J_3RFOKATOOKATO Code (Part 2)CHAR03
GLO_RUS_PRT_OKT3J_3RFOKATO3CHAR3(0) J_3RFOKATOOKATO Code (Part 3)CHAR03
GLO_RUS_PRT_OKT4J_3RFOKATO4CHAR3(0) J_3RFOKATOOKATO Code (Part 4)CHAR03
GLO_RUS_PRT_EXMPJ_3RFEXEMPTIONCHAR4(0) J_3RFPRTEXEMPProperty Tax Exemption CodeCHAR04
GLO_RUS_PRT_PRVGJ_3RFPRIVILEGECHAR4(0) J_3RFPRTXPRIVProperty Tax ReductionCHAR04
GLO_RUS_PRT_AMTRJ_3RFAMOUNTREDCHAR4(0) J_3RFPRTXAMTRProperty tax amount reduction codeCHAR04
.INCLU--AP0(0)
VNAMEJV_NAMECHAR6(0) *Joint VentureJV_NAMEJVVFGJ
EGRUPJV_EGROUPCHAR3(0) *Equity groupJV_EGROUPGJEFGJ
RECIDJV_RECINDCHAR2(0) *Recovery IndicatorJV_RECINDFGJ
ETYPEJV_ETYPECHAR3(0) *Equity typeJV_ETYPEFGJ