SAP ANLA Asset Master Record Segment Table data and field list

ANLA is a standard SAP Table which is used to store Asset Master Record Segment data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ANLA table consists of various fields, each holding specific information or linking keys about Asset Master Record Segment data available in SAP. These include BUKRS (Company Code), ANLN1 (Main Asset Number), ANLN2 (Asset Subnumber), ANLKL (Asset Class)... 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. .

ANLA table Technical Details:

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 ANLA table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ANLA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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

Key field

Non-key field

< ANKV_SVE - ANKA and ANKV fields are saved ANLA0 - Intro. Table Logical Database ADA >

How do I retrieve data from SAP table ANLA using ABAP code

The following ABAP code Example will allow you to do a basic selection on ANLA to SELECT all data from the table
DATA: WA_ANLA TYPE ANLA.

SELECT SINGLE *
FROM ANLA
INTO CORRESPONDING FIELDS OF WA_ANLA
WHERE...

How to access SAP table ANLA

Within an ECC or HANA version of SAP you can also view further information about ANLA and the data within it using relevant transactions such as

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