SAP Table ANLA

Asset Master Record Segment

ANLA (Asset Master Record Segment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ANLA to other SAP tables.

ANLA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T093C CHAR 4 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
ANLKL Asset Class ANLKL ANKA CHAR 8 0
GEGST Technical asset number GEGST CHAR 8 0
ANLAR Asset types ANLAR CHAR 5 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed on AEDAT_ANLA DATS 8 0
XLOEV Indicator: Account marked for deletion? XLOEV CHAR 1 0
X Yes
NULL No
XSPEB Indicator: Asset Locked to Acquisition Postings XSPEB_ANLA CHAR 1 0
X Yes
NULL No
FELEI Screen layout for Asset Accounting FELEI CHAR 4 0
KTOGR Account determination KTOGR T095A CHAR 8 0
XOPVW Asset under construct. with line item settlement OPVWA CHAR 1 0
X Yes
NULL No
ANLTP Asset Category ANLTP NUMC 1 0
0 Capitalized asset
1 Leased asset
2 Financial asset
ZUJHR Fiscal year in which first acquisition was posted DZUJAHR NUMC 4 0
ZUPER Period in which first acquisition was posted DZUPER NUMC 3 0
ZUGDT Asset value date of the first posting DZUGDAT DATS 8 0
AKTIV Asset capitalization date AKTIVD DATS 8 0
ABGDT Asset value date for the last retirement ABGDAT DATS 8 0
DEAKT Deactivation date DEAKT DATS 8 0
GPLAB Planned retirement date GPLAB DATS 8 0
BSTDT Asset purchase order date BSTDT DATS 8 0
ORD41 Evaluation group 1 ORD41 T087 CHAR 4 0
ORD42 Evaluation group 2 ORD42 T087 CHAR 4 0
ORD43 Evaluation group 3 ORD43 T087 CHAR 4 0
ORD44 Evaluation group 4 ORD44 T087 CHAR 4 0
ANLUE Asset super number ANLUE T087U CHAR 12 0
ZUAWA Key for sorting according to assignment numbers DZUAWA TZUN CHAR 3 0
ANEQK Indicator: Historical management ANEQK NUMC 1 0
0 Asset managed without history
1 Asset managed with history
ANEQS Completeness indicator for the asset ANEQS NUMC 1 0
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) AM_LIFNR LFA1 CHAR 10 0
LAND1 Asset's country of origin AM_LAND1 T005 CHAR 3 0
LIEFE Name of asset supplier LIEFE CHAR 30 0
HERST Manufacturer of asset HERST CHAR 30 0
EIGKZ Property indicator EIGKZ T097 CHAR 1 0
AIBN1 Original asset that was transferred AIBN1 CHAR 12 0
AIBN2 Original asset that was transferred AIBN2 CHAR 4 0
AIBDT Original acquisition date of AuC/ transferred asset AIBDT DATS 8 0
URJHR Fiscal year of original acquisition URJHR NUMC 4 0
URWRT Original acquisition value URWRT CURR 13 2
ANTEI In-house production percentage ANTEI DEC 5 2
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
EAUFN Investment Order AM_AUFNR CHAR 12 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MENGE Quantity AM_MENGE QUAN 13 3
TYPBZ Asset type name TYPBZ_ANLA CHAR 15 0
IZWEK Reason for investment IZWEK T087I CHAR 2 0
INKEN Inventory indicator INKEN CHAR 1 0
X Yes
NULL No
IVDAT Last inventory date IVDAT_ANLA DATS 8 0
INVZU Supplementary inventory specifications INVZU_ANLA CHAR 15 0
VMGLI Property classification key VMGLI T092 CHAR 4 0
XVRMW Manual net worth tax value XVRMW CHAR 1 0
X Yes
NULL No
WRTMA Manual net worth tax value WRTMA CURR 13 2
EHWRT Assessed value EHWRT CURR 13 2
AUFLA Date of conveyance AUFLA_ANLA DATS 8 0
EHWZU Date of last notice of assessment EHWZU_ANLA DATS 8 0
EHWNR Tax number of the notice of assessment EHWNR_ANLA CHAR 16 0
GRUVO Land Register of GRUVO_ANLA DATS 8 0
GREIN Land register entry on GREIN_ANLA DATS 8 0
GRBND Land register volume GRBND_ANLA CHAR 5 0
GRBLT Land register page GRBLT_ANLA CHAR 5 0
GRLFD Land register entry: Sequence number GRLFD_ANLA CHAR 4 0
FLURK Land register map number FLURK_ANLA CHAR 4 0
FLURN Plot number FLURN_ANLA CHAR 10 0
FIAMT Local tax office FIAMT CHAR 25 0
STADT Municipality ORT01_ANLA CHAR 25 0
GRUND Reason for manual valuation of net assets GRUND T098 CHAR 3 0
FEINS Area unit FEINS T006 UNIT 3 0
GRUFL Surface area GRUFL QUAN 13 3
INVNR Inventory number INVNR_ANLA CHAR 25 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
SPRAS Language Key SPRAS T002 LANG 1 0
TXT50 Asset description TXA50_ANLT CHAR 50 0
TXA50 Additional asset description TXA50_MORE CHAR 50 0
XLTXID Indicator: Long text active XLTXID CHAR 1 0
X Yes
NULL No
XVERID Long text indicator:Property values XVERID CHAR 1 0
X Yes
NULL No
XTCHID Indicator: Technical view long text XTCHID CHAR 1 0
X Yes
NULL No
XKALID Indicator: Long text active XKALID CHAR 1 0
X Yes
NULL No
XHERID Indicator: Long text for manufacturer/origin XHERID CHAR 1 0
X Yes
NULL No
XLEAID Indicator: Leasing data long text XLEAID CHAR 1 0
X Yes
NULL No
LEAFI Leasing company LEAFI LFA1 CHAR 10 0
LVDAT Leasing agreement date LVDAT DATS 8 0
LKDAT Leasing agreement notice date LKDAT DATS 8 0
LEABG Lease start date LEABG DATS 8 0
LEJAR Length of lease in years LEJAR NUMC 3 0
LEPER Length of lease in periods LEPER NUMC 3 0
0
LRYTH Lease payment cycle LRYTH NUMC 3 0
0
LEGEB Periodic lease payment paid to leasing company/lessor LEGEB CURR 13 2
LBASW Leasing base value as new LBASW CURR 13 2
LKAUF Leased asset purchase price LKAUF CURR 13 2
LMZIN Leasing monthly interest rate (Capital Lease) LMZIN DEC 7 4
LZINS Leasing interest rate (capital lease) LZINS DEC 7 4
LTZBW Posting date of the last lease payment LTZBW DATS 8 0
LKUZA Total of posted leasing payments LKUZA CURR 13 2
LKUZI Total leasing interest posted LKUZI CURR 13 2
LLAVB Total of long-term leasing liability LLAVB CURR 13 2
LEANZ Number of lease payments LEANZ DEC 5 0
LVTNR Leasing agreement number LVTNR CHAR 15 0
LETXT Leasing data text LETXT CHAR 50 0
XAKTIV Indicator: Capitalize fixed asset XAKTIV CHAR 1 0
X Yes
NULL No
ANUPD Indicator: Type of change to table ANUPD CHAR 1 0
D Delete
I Insert
U Update
NULL No changes
LBLNR No. of last document with which posting to asset was made LBLNR CHAR 10 0
XV0DT Change date: View 0 XV0DT DATS 8 0
XV0NM Name of person in charge, who changed View0 XV0NM CHAR 12 0
XV1DT Change date: View 1 XV1DT DATS 8 0
XV1NM Name of person in charge, who changed view 1 XV1NM CHAR 12 0
XV2DT Change date: View 2 XV2DT DATS 8 0
XV2NM Name of the person in charge, who changed view 2 XV2NM CHAR 12 0
XV3DT Change date: View 3 XV3DT DATS 8 0
XV3NM Name of the person in charge, who changed view 3 XV3NM CHAR 12 0
XV4DT Change date: View 4 XV4DT DATS 8 0
XV4NM Name of the person in charge, who changed view 4 XV4NM CHAR 12 0
XV5DT Change date:View 5 XV5DT DATS 8 0
XV5NM Name of the person in charge who changed view 5 XV5NM CHAR 12 0
XV6DT Change date:View 6 XV6DT DATS 8 0
XV6NM Name of the person in charge who changed view 6 XV6NM CHAR 12 0
AIMMO Indicator: real estate AIMMO NUMC 1 0
0 Other asset without real estate management
1 Real estate - property or buildings
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
LEART Leasing type LEART T083L CHAR 2 0
LVORS Advance payments LVORS CHAR 1 0
X Yes
NULL No
GDLGRP Evaluation group 5 GDLGRP T087G CHAR 8 0
POSNR WBS element investment project AM_POSNR PRPS NUMC 8 0
XERWRT Indicator: Ignore memo value XERWRT CHAR 1 0
X Yes
NULL No
XAFABCH Asset acquired used XAFABCH CHAR 1 0
X Yes
NULL No
XANLGR Indicator: Asset is a group asset XANLGR_1 CHAR 1 0
X Yes
NULL No
MCOA1 Search term for matchcode search MCOA1 CHAR 30 0
XINVM Asset under Construction for Investment Measures IM_XINVM CHAR 1 0
X Yes
NULL No
SERNR Serial number AM_SERNR CHAR 18 0
UMWKZ Reason for environmental investment AM_UMWKZ T087K CHAR 5 0
LRVDAT Date of last revaluation AM_LRVDAT DATS 8 0
ACT_CHANGE_PM Change Asset Master Record from Equipment Master AAPM_ACT_CHANGE_PM CHAR 1 0
NULL No synchronization
1 Saving triggers a workflow
2 Direct synchronization after saving
3 Direct synchronization plus workflow
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA HAS_TDDP CHAR 1 0
X TRUE
NULL FALSE
LAST_REORG_DATE Date of Last Reorganization FAA_LAST_REORG DATS 8 0

ANLA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ANLA ANLKL ANLA MANDT ANKA Asset classes: general data MANDT
ANLA ANLKL ANLA ANLKL ANKA Asset classes: general data ANLKL
ANLA ANLN1 ANLA MANDT ANLH Main asset number MANDT
ANLA ANLN1 ANLA BUKRS ANLH Main asset number BUKRS
ANLA ANLN1 ANLA ANLN1 ANLH Main asset number ANLN1
ANLA ANLUE ANLA MANDT T087U Asset group number / asset group MANDT
ANLA ANLUE ANLA ANLUE T087U Asset group number / asset group ANLUE
ANLA BUKRS ANLA MANDT T093C Company codes in Asset Accounting MANDT
ANLA BUKRS ANLA BUKRS T093C Company codes in Asset Accounting BUKRS
ANLA EIGKZ ANLA MANDT T097 Property indicator MANDT
ANLA EIGKZ ANLA EIGKZ T097 Property indicator EIGKZ
ANLA FEINS ANLA MANDT T006 Units of Measurement MANDT
ANLA FEINS ANLA FEINS T006 Units of Measurement MSEHI
ANLA GDLGRP ANLA MANDT T087G Evaluation group 8 places MANDT
ANLA GDLGRP ANLA GDLGRP T087G Evaluation group 8 places GDLGRP
ANLA GRUND ANLA MANDT T098 Basis manual property evaluation MANDT
ANLA GRUND ANLA GRUND T098 Basis manual property evaluation GRUND
ANLA IZWEK ANLA MANDT T087I Reason for investment MANDT
ANLA IZWEK ANLA IZWEK T087I Reason for investment IZWEK
ANLA KTOGR ANLA MANDT T095A Account allocation MANDT
ANLA KTOGR ANLA KTOGR T095A Account allocation KTOGR
ANLA LAND1 ANLA MANDT T005 Countries MANDT
ANLA LAND1 ANLA LAND1 T005 Countries LAND1
ANLA LEAFI ANLA LEAFI LFA1 Vendor Master (General Section) LIFNR
ANLA LEAFI ANLA MANDT LFA1 Vendor Master (General Section) MANDT
ANLA LEART ANLA MANDT T083L Leasing types MANDT
ANLA LEART ANLA LEART T083L Leasing types LEART
ANLA LIFNR ANLA MANDT LFA1 Vendor Master (General Section) MANDT
ANLA LIFNR ANLA LIFNR LFA1 Vendor Master (General Section) LIFNR
ANLA MEINS ANLA MANDT T006 Units of Measurement MANDT
ANLA MEINS ANLA MEINS T006 Units of Measurement MSEHI
ANLA OBJNR ANLA MANDT ONR00 General Object Number MANDT
ANLA OBJNR ANLA OBJNR ONR00 General Object Number OBJNR
ANLA ORD41 ANLA MANDT T087 Evaluation groups MANDT
ANLA ORD41 '1' T087 Evaluation groups ORDNR
ANLA ORD41 ANLA ORD41 T087 Evaluation groups ORD4X
ANLA ORD42 ANLA ORD42 T087 Evaluation groups ORD4X
ANLA ORD42 ANLA MANDT T087 Evaluation groups MANDT
ANLA ORD42 '2' T087 Evaluation groups ORDNR
ANLA ORD43 ANLA MANDT T087 Evaluation groups MANDT
ANLA ORD43 '3' T087 Evaluation groups ORDNR
ANLA ORD43 ANLA ORD43 T087 Evaluation groups ORD4X
ANLA ORD44 '4' T087 Evaluation groups ORDNR
ANLA ORD44 ANLA ORD44 T087 Evaluation groups ORD4X
ANLA ORD44 ANLA MANDT T087 Evaluation groups MANDT
ANLA POSNR ANLA MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
ANLA POSNR ANLA POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
ANLA SPRAS ANLA SPRAS T002 Language Keys (Component BC-I18) SPRAS
ANLA UMWKZ ANLA MANDT T087K Reason for investment protecting the environment MANDT
ANLA UMWKZ ANLA UMWKZ T087K Reason for investment protecting the environment UMWKZ
ANLA VBUND ANLA MANDT T880 Global Company Data (for KONS Ledger) MANDT
ANLA VBUND ANLA VBUND T880 Global Company Data (for KONS Ledger) RCOMP
ANLA VMGLI ANLA VMGLI T092 Property classification key VMGLI
ANLA VMGLI ANLA MANDT T092 Property classification key MANDT
ANLA ZUAWA ANLA ZUAWA TZUN Rules for 'Allocation' Field Layout ZUAWA