SAP table ANLA (Asset Master Record Segment)

SAP table ANLA (Asset Master Record Segment) is part of the Asset Accounting (FI-AA) module and stores key details about fixed assets. It includes general master data, such as asset descriptions, asset classes, acquisition dates, and other information related to the management and categorization of fixed assets in an organization. The data in ANLA is used for asset lifecycle tracking, financial reporting, and compliance purposes.

SAP table ANLA has 4 primary key fields being MANDT,BUKRS,ANLN1,ANLN2.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
BUKRS Company Code CHAR 4 0 FAAV_COMP_CODE BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
ANLKL Asset Class CHAR 8 0 FAAV_ASSET_CLASS ANLKL
GEGST Technical Asset Number CHAR 8 0 GEGST
ANLAR Asset types CHAR 5 0 ANLAR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Changed On DATS 8 0 AEDAT_ANLA
XLOEV Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
XSPEB Indicator: Asset Locked to Acquisition Postings CHAR 1 0 XSPEB_ANLA
FELEI Screen Layout for Asset Accounting CHAR 4 0 FELEI
KTOGR Account Determination CHAR 8 0 FAAV_ACCOUNT_DET KTOGR
XOPVW Asset under construct. with line item settlement CHAR 1 0 OPVWA
ANLTP Asset Category NUMC 1 0 ANLTP
0 Capitalized asset
1 Leased asset
2 Financial asset
ZUJHR Fiscal Year in Which First Acquisition Was Posted NUMC 4 0 DZUJAHR
ZUPER Period in Which First Acquisition Was Posted NUMC 3 0 DZUPER
ZUGDT Asset Value Date of the First Posting DATS 8 0 DZUGDAT
AKTIV Asset Capitalization Date DATS 8 0 AKTIVD
ABGDT Asset Value Date for the Last Retirement DATS 8 0 ABGDAT
DEAKT Deactivation Date DATS 8 0 DEAKT
GPLAB Planned Retirement Date DATS 8 0 GPLAB
BSTDT Asset Purchase Order Date DATS 8 0 BSTDT
ORD41 Evaluation group 1 CHAR 4 0 T087 ORD41
ORD42 Evaluation Group 2 CHAR 4 0 T087 ORD42
ORD43 Evaluation Group 3 CHAR 4 0 T087 ORD43
ORD44 Evaluation group 4 CHAR 4 0 T087 ORD44
ANLUE Asset Super Number CHAR 12 0 T087U ANLUE
ZUAWA Key for sorting according to assignment numbers CHAR 3 0 TZUN DZUAWA
ANEQK Indicator: Historical management NUMC 1 0 ANEQK
0 Asset managed without history
1 Asset managed with history
ANEQS Completeness indicator for the asset NUMC 1 0 ANEQS
0 Asset is complete
1 Asset is incomplete, but can be posted
2 Asset is incomplete and cannot be posted (dep., retmt)
3 Asset is incomplete (cst ctr, int.order, activ.type missing)
4 Asset is incomplete (investment account assignment missing)
LIFNR Account number of vendor (other key word) CHAR 10 0 LFA1 AM_LIFNR
LAND1 Asset's Country/Region of Origin CHAR 3 0 T005 AM_LAND1
LIEFE Name of asset supplier CHAR 30 0 LIEFE
HERST Manufacturer of Asset CHAR 30 0 HERST
EIGKZ Property Indicator CHAR 1 0 T097 EIGKZ
AIBN1 Original Asset That Was Transferred CHAR 12 0 AIBN1
AIBN2 Original Asset That Was Transferred CHAR 4 0 AIBN2
AIBDT Original Acquisition Date of AuC/ Transferred Asset DATS 8 0 AIBDT
URJHR Fiscal Year of Original Acquisition NUMC 4 0 URJHR
URWRT Original Acquisition Value CURR 23 2 URWRT
ANTEI In-house production percentage DEC 5 2 ANTEI
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
EAUFN Investment Order CHAR 12 0 AM_AUFNR
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MENGE Quantity QUAN 13 3 AM_MENGE
TYPBZ Asset Type Name CHAR 15 0 TYPBZ_ANLA
IZWEK Reason for Investment CHAR 2 0 T087I IZWEK
INKEN Inventory Indicator CHAR 1 0 INKEN
IVDAT Last Inventory Date DATS 8 0 IVDAT_ANLA
INVZU Supplementary Inventory Specifications CHAR 15 0 INVZU_ANLA
VMGLI Property classification key CHAR 4 0 T092 VMGLI
XVRMW Manual net worth tax value CHAR 1 0 XVRMW
WRTMA Manual net worth tax value CURR 23 2 WRTMA
EHWRT Assessed Value CURR 23 2 EHWRT
AUFLA Date of conveyance DATS 8 0 AUFLA_ANLA
EHWZU Date of last notice of assessment DATS 8 0 EHWZU_ANLA
EHWNR Tax Number of the Notice of Assessment CHAR 16 0 EHWNR_ANLA
GRUVO Land Register of DATS 8 0 GRUVO_ANLA
GREIN Land Register Entry on DATS 8 0 GREIN_ANLA
GRBND Land Register Volume CHAR 5 0 GRBND_ANLA
GRBLT Land Register Page CHAR 5 0 GRBLT_ANLA
GRLFD Land Register Entry: Sequence Number CHAR 4 0 GRLFD_ANLA
FLURK Land Register Map Number CHAR 4 0 FLURK_ANLA
FLURN Plot Number CHAR 10 0 FLURN_ANLA
FIAMT Local Tax Office CHAR 25 0 FIAMT
STADT Municipality CHAR 25 0 ORT01_ANLA
GRUND Reason for Manual Valuation of Net Assets CHAR 3 0 T098 GRUND
FEINS Area Unit UNIT 3 0 T006 FEINS
GRUFL Surface Area QUAN 13 3 GRUFL
INVNR Inventory Number CHAR 25 0 INVNR_ANLA
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
SPRAS Language Key LANG 1 0 T002 SPRAS
TXT50 Asset Description CHAR 50 0 TXA50_ANLT
TXA50 Additional Asset Description CHAR 50 0 TXA50_MORE
XLTXID Indicator: Long Text Active CHAR 1 0 XLTXID
XVERID Long text indicator:Property values CHAR 1 0 XVERID
XTCHID Indicator: Technical View Long Text CHAR 1 0 XTCHID
XKALID Indicator: Long Text Active CHAR 1 0 XKALID
XHERID Indicator: Long text for manufacturer/origin CHAR 1 0 XHERID
XLEAID Indicator: Leasing Data Long Text CHAR 1 0 XLEAID
LEAFI Leasing company CHAR 10 0 LFA1 LEAFI
LVDAT Leasing agreement date DATS 8 0 LVDAT
LKDAT Leasing agreement notice date DATS 8 0 LKDAT
LEABG Lease start date DATS 8 0 LEABG
LEJAR Length of Lease in Years NUMC 3 0 LEJAR
LEPER Length of lease in periods NUMC 3 0 LEPER
LRYTH Lease payment cycle NUMC 3 0 LRYTH
LEGEB Periodic lease payment paid to leasing company/lessor CURR 23 2 LEGEB
LBASW Leasing base value as new CURR 23 2 LBASW
LKAUF Leased asset purchase price CURR 23 2 LKAUF
LMZIN Leasing monthly interest rate (Capital Lease) DEC 7 4 LMZIN
LZINS Leasing Interest Rate (Capital Lease) DEC 7 4 LZINS
LTZBW Posting date of the last lease payment DATS 8 0 LTZBW
LKUZA Total of posted leasing payments CURR 23 2 LKUZA
LKUZI Total leasing interest posted CURR 23 2 LKUZI
LLAVB Total of long-term leasing liability CURR 23 2 LLAVB
LEANZ Number of Lease Payments DEC 5 0 LEANZ
LVTNR Leasing agreement number CHAR 15 0 LVTNR
LETXT Leasing data text CHAR 50 0 LETXT
XAKTIV Indicator: Capitalize Fixed Asset CHAR 1 0 XAKTIV
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
LBLNR No. of Last Document with Which Posting to Asset Was Made CHAR 10 0 LBLNR
XV0DT Change date: View 0 DATS 8 0 XV0DT
XV0NM Name of person in charge, who changed View0 CHAR 12 0 XV0NM
XV1DT Change date: View 1 DATS 8 0 XV1DT
XV1NM Name of person in charge, who changed view 1 CHAR 12 0 XV1NM
XV2DT Change date: View 2 DATS 8 0 XV2DT
XV2NM Name of the person in charge, who changed view 2 CHAR 12 0 XV2NM
XV3DT Change date: View 3 DATS 8 0 XV3DT
XV3NM Name of the person in charge, who changed view 3 CHAR 12 0 XV3NM
XV4DT Change date: View 4 DATS 8 0 XV4DT
XV4NM Name of the person in charge, who changed view 4 CHAR 12 0 XV4NM
XV5DT Change date:View 5 DATS 8 0 XV5DT
XV5NM Name of the person in charge who changed view 5 CHAR 12 0 XV5NM
XV6DT Change date:View 6 DATS 8 0 XV6DT
XV6NM Name of the person in charge who changed view 6 CHAR 12 0 XV6NM
AIMMO Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
LEART Leasing type CHAR 2 0 T083L LEART
LVORS Advance payments CHAR 1 0 LVORS
GDLGRP Evaluation Group 5 CHAR 8 0 T087G GDLGRP
POSNR WBS element investment project NUMC 8 0 PRPS AM_POSNR
XERWRT Indicator: Ignore memo value CHAR 1 0 XERWRT
XAFABCH Asset acquired used CHAR 1 0 XAFABCH
XANLGR Indicator: Asset is a group asset CHAR 1 0 XANLGR_1
MCOA1 Search Term for Matchcode Search CHAR 30 0 MCOA1
XINVM Asset under Construction for Investment Measures CHAR 1 0 IM_XINVM
SERNR Serial number CHAR 18 0 AM_SERNR
UMWKZ Reason for Environmental Investment CHAR 5 0 T087K AM_UMWKZ
LRVDAT Date of Last Revaluation DATS 8 0 AM_LRVDAT
ACT_CHANGE_PM Change Asset Master Record from Equipment Master CHAR 1 0 AAPM_ACT_CHANGE_PM
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA CHAR 1 0 HAS_TDDP
LAST_REORG_DATE Date of Last Reorganization DATS 8 0 FAA_LAST_REORG
LDT_DATE Legacy Data Transfer Date DATS 8 0 FAA_LDT_DATE
LDT_SEQNO Legacy Data Transfer - sequence number NUMC 5 0 FAA_LDT_SEQNO
SDM_STATUS Silent Data Migration Status CHAR 2 0 FAA_SDM_STATUS
not processed
01 ANLA transfered
11 TECH_LEDGER: Currency Conversion finished
12 TECH_LEDGER: Retirement Indicator Enrichment done
13 TECH_LEDGER: Currency Adjustment finished
18 TECH_LEDGER: Processing finished, no migration
19 TECH_LEDGER: Processing finished, migrated to ACDOCA
20 Derived Areas exist and migration is required
21 Derived Areas entries waiting for AFABN to be posted
22 Derived Areas completely migrated
DUMMY_FAA_ASSET_INCL_EEW_PS Data Element for Extension Include: Asset Worklist CHAR 1 0 FAA_ASSET_INCL_EEW
INTERNAL_CODE Internal code CHAR 10 0 /ATL/INTERNAL_CODE
APPROVAL_NUMBER Approval document number CHAR 15 0 /ATL/APPROVAL_NUMBER
APPROVAL_VERSION Approval version CHAR 3 0 /ATL/APPROVAL_VERSION
BOGUS_ANLN1 bogus asset number CHAR 12 0 /ATL/BOGUS_ANLN1
ASSET_VERSION Asset version CHAR 3 0 /ATL/ASSET_VERSION

ANLA foreign key relationships

Table Field Check Table Check Field
0 ANLA ANLKL FAAV_ASSET_CLASS Generated Table for View MANDT
1 ANLA ANLN1 ANLH Main asset number BUKRS
1 ANLA ANLN1 ANLH Main asset number ANLN1
0 ANLA ANLUE T087U Asset group number / asset group MANDT
0 ANLA ANLUE T087U Asset group number / asset group ANLUE
1 ANLA EIGKZ T097 Property indicator MANDT
1 ANLA EIGKZ T097 Property indicator EIGKZ
0 ANLA FEINS T006 Units of Measurement MANDT
1 ANLA GDLGRP T087G Evaluation group 8 places MANDT
0 ANLA GRUND T098 Basis manual property evaluation MANDT
1 ANLA IZWEK T087I Reason for investment MANDT
1 ANLA IZWEK T087I Reason for investment IZWEK
0 ANLA KTOGR FAAV_ACCOUNT_DET Generated Table for View MANDT
1 ANLA LAND1 T005 Countries MANDT
1 ANLA LAND1 T005 Countries LAND1
0 ANLA LEAFI LFA1 Supplier Master (General Section) MANDT
0 ANLA LEAFI LFA1 Supplier Master (General Section) LIFNR
1 ANLA LEART T083L Leasing types MANDT
1 ANLA LEART T083L Leasing types LEART
0 ANLA LIFNR LFA1 Supplier Master (General Section) MANDT
0 ANLA LIFNR LFA1 Supplier Master (General Section) LIFNR
1 ANLA MEINS T006 Units of Measurement MANDT
1 ANLA MEINS T006 Units of Measurement MSEHI
0 ANLA OBJNR ONR00 General Object Number MANDT
1 ANLA ORD41 T087 Evaluation groups MANDT
1 ANLA ORD41 T087 Evaluation groups ORDNR
1 ANLA ORD41 T087 Evaluation groups ORD4X
0 ANLA ORD42 T087 Evaluation groups MANDT
0 ANLA ORD42 T087 Evaluation groups ORDNR
0 ANLA ORD42 T087 Evaluation groups ORD4X
1 ANLA ORD43 T087 Evaluation groups MANDT
1 ANLA ORD43 T087 Evaluation groups ORDNR
1 ANLA ORD43 T087 Evaluation groups ORD4X
0 ANLA ORD44 T087 Evaluation groups MANDT
0 ANLA ORD44 T087 Evaluation groups ORDNR
0 ANLA ORD44 T087 Evaluation groups ORD4X
1 ANLA POSNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 ANLA POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 ANLA SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 ANLA UMWKZ T087K Reason for investment protecting the environment MANDT
0 ANLA VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 ANLA VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 ANLA VMGLI T092 Property classification key MANDT