SAP ANLA Asset Master Record Segment Table

Overview

ANLA is a standard SAP S/4HANA table that stores Asset Master Record Segment data. There are total 145 fields in the ANLA table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ANLA belongs to Basic Functions (FI-AA-AA) module and is located in the package Assets: Master Data (AA).

In addition, following links provide an overview of foreign key relationships, if any, that link ANLA to other SAP tables and standard CDS views available based on ANLA table in S/4HANA 2020.

Foreign Key Relations
ANLA CDS Views

Techincal Settings of ANLA

Below are technical details of the table ANLA

Buffering not allowed
No buffering
Storage type is Column Store

List of ANLA Fields

The following table gives you an overview of the fields available in ANLA

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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ANLA

Table Name	Field	Cardinality	Check Table
ANLA	ANLKL	1: N	FAAV_ASSET_CLASS
ANLA	ANLN1	1: 1	ANLH
ANLA	ANLUE	1: CN	T087U
ANLA	BUKRS	1: CN	FAAV_COMP_CODE
ANLA	EIGKZ	1: CN	T097
ANLA	FEINS	1: CN	T006
ANLA	GDLGRP	C: CN	T087G
ANLA	GRUND	1: CN	T098
ANLA	IZWEK	1: CN	T087I
ANLA	KTOGR	1: CN	FAAV_ACCOUNT_DET
ANLA	LAND1	1: CN	T005
ANLA	LEAFI	1: C	LFA1
ANLA	LEART	C: CN	T083L
ANLA	LIFNR	1: C	LFA1
ANLA	MEINS	1: CN	T006
ANLA	OBJNR	C: C	ONR00
ANLA	ORD41	1: CN	T087
ANLA	ORD42	1: CN	T087
ANLA	ORD43	1: CN	T087
ANLA	ORD44	1: CN	T087
ANLA	POSNR	C: CN	PRPS
ANLA	SPRAS	1: N	T002
ANLA	UMWKZ	1: CN	T087K
ANLA	VBUND	1: CN	T880
ANLA	VMGLI	1: CN	T092
ANLA	ZUAWA	1: N	TZUN

SAP ANLA Asset Master Record Segment Table

Overview

Techincal Settings of ANLA

List of ANLA Fields

Foreign Key Relationships

Other References