SAP ABAP Table ANLA (Asset Master Record Segment)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ AA (Package) Application Development R/3 Assets: Master Data

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ANLA	Table Relationship Diagram
Short Description	Asset Master Record Segment

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T093C
3	ANLN1	☑	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
4	ANLN2	☑	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber
5	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
6	GEGST	☐	GEGST	GEGST	CHAR	8	0	Technical asset number
7	ANLAR	☐	ANLAR	CHAR5	CHAR	5	0	Asset types
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
10	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
11	AEDAT	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
12	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
13	XSPEB	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
14	FELEI	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting	*
15	KTOGR	☐	KTOGR	KTOGR	CHAR	8	0	Account determination	T095A
16	XOPVW	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
17	ANLTP	☐	ANLTP	ANLTP	NUMC	1	0	Asset Category
18	ZUJHR	☐	DZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
19	ZUPER	☐	DZUPER	POPER	NUMC	3	0	Period in which first acquisition was posted
20	ZUGDT	☐	DZUGDAT	DATUM	DATS	8	0	Asset value date of the first posting
21	AKTIV	☐	AKTIVD	DATUM	DATS	8	0	Asset capitalization date
22	ABGDT	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
23	DEAKT	☐	DEAKT	DATUM	DATS	8	0	Deactivation date
24	GPLAB	☐	GPLAB	DATUM	DATS	8	0	Planned retirement date
25	BSTDT	☐	BSTDT	DATUM	DATS	8	0	Asset purchase order date
26	ORD41	☐	ORD41	ORD4X	CHAR	4	0	Evaluation group 1	T087
27	ORD42	☐	ORD42	ORD4X	CHAR	4	0	Evaluation group 2	T087
28	ORD43	☐	ORD43	ORD4X	CHAR	4	0	Evaluation group 3	T087
29	ORD44	☐	ORD44	ORD4X	CHAR	4	0	Evaluation group 4	T087
30	ANLUE	☐	ANLUE	ANLUE	CHAR	12	0	Asset super number	T087U
31	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
32	ANEQK	☐	ANEQK	ANEQK	NUMC	1	0	Indicator: Historical management
33	ANEQS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
34	LIFNR	☐	AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
35	LAND1	☐	AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
36	LIEFE	☐	LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
37	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
38	EIGKZ	☐	EIGKZ	EIGKZ	CHAR	1	0	Property indicator	T097
39	AIBN1	☐	AIBN1	ANLN1	CHAR	12	0	Original asset that was transferred	*
40	AIBN2	☐	AIBN2	ANLN2	CHAR	4	0	Original asset that was transferred	*
41	AIBDT	☐	AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
42	URJHR	☐	URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
43	URWRT	☐	URWRT	ANLKWERT	CURR	13	2	Original acquisition value
44	ANTEI	☐	ANTEI	PRZ32	DEC	5	2	In-house production percentage
45	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
46	EAUFN	☐	AM_AUFNR	AUFNR	CHAR	12	0	Investment Order	*
47	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
48	MENGE	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
49	TYPBZ	☐	TYPBZ_ANLA	TYPBZ_ANLA	CHAR	15	0	Asset type name
50	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
51	INKEN	☐	INKEN	XFELD	CHAR	1	0	Inventory indicator
52	IVDAT	☐	IVDAT_ANLA	DATUM	DATS	8	0	Last inventory date
53	INVZU	☐	INVZU_ANLA	INVZU_ANLA	CHAR	15	0	Supplementary inventory specifications
54	VMGLI	☐	VMGLI	VMGLI	CHAR	4	0	Property classification key	T092
55	XVRMW	☐	XVRMW	XFELD	CHAR	1	0	Manual net worth tax value
56	WRTMA	☐	WRTMA	ANLKWERT	CURR	13	2	Manual net worth tax value
57	EHWRT	☐	EHWRT	ANLKWERT	CURR	13	2	Assessed value
58	AUFLA	☐	AUFLA_ANLA	DATUM	DATS	8	0	Date of conveyance
59	EHWZU	☐	EHWZU_ANLA	DATUM	DATS	8	0	Date of last notice of assessment
60	EHWNR	☐	EHWNR_ANLA	EHWNR_ANLA	CHAR	16	0	Tax number of the notice of assessment
61	GRUVO	☐	GRUVO_ANLA	DATUM	DATS	8	0	Land Register of
62	GREIN	☐	GREIN_ANLA	DATUM	DATS	8	0	Land register entry on
63	GRBND	☐	GRBND_ANLA	GRBND_ANLA	CHAR	5	0	Land register volume
64	GRBLT	☐	GRBLT_ANLA	GRBLT_ANLA	CHAR	5	0	Land register page
65	GRLFD	☐	GRLFD_ANLA	GRLFD_ANLA	CHAR	4	0	Land register entry: Sequence number
66	FLURK	☐	FLURK_ANLA	CHAR4	CHAR	4	0	Land register map number
67	FLURN	☐	FLURN_ANLA	CHAR10	CHAR	10	0	Plot number
68	FIAMT	☐	FIAMT	TEXT25	CHAR	25	0	Local tax office
69	STADT	☐	ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
70	GRUND	☐	GRUND	GRUND	CHAR	3	0	Reason for manual valuation of net assets	T098
71	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
72	GRUFL	☐	GRUFL	MENG13	QUAN	13	3	Surface area
73	INVNR	☐	INVNR_ANLA	INVNR_ANLA	CHAR	25	0	Inventory number
74	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
75	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
76	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
77	TXA50	☐	TXA50_MORE	TEXT50	CHAR	50	0	Additional asset description
78	XLTXID	☐	XLTXID	XFELD	CHAR	1	0	Indicator: Long text active
79	XVERID	☐	XVERID	XFELD	CHAR	1	0	Long text indicator:Property values
80	XTCHID	☐	XTCHID	XFELD	CHAR	1	0	Indicator: Technical view long text
81	XKALID	☐	XKALID	XFELD	CHAR	1	0	Indicator: Long text active
82	XHERID	☐	XHERID	XFELD	CHAR	1	0	Indicator: Long text for manufacturer/origin
83	XLEAID	☐	XLEAID	XFELD	CHAR	1	0	Indicator: Leasing data long text
84	LEAFI	☐	LEAFI	LIFNR	CHAR	10	0	Leasing company	LFA1
85	LVDAT	☐	LVDAT	DATUM	DATS	8	0	Leasing agreement date
86	LKDAT	☐	LKDAT	DATUM	DATS	8	0	Leasing agreement notice date
87	LEABG	☐	LEABG	DATUM	DATS	8	0	Lease start date
88	LEJAR	☐	LEJAR	JARAF	NUMC	3	0	Length of lease in years
89	LEPER	☐	LEPER	PERAF	NUMC	3	0	Length of lease in periods
90	LRYTH	☐	LRYTH	PERAF	NUMC	3	0	Lease payment cycle
91	LEGEB	☐	LEGEB	ANLKWERT	CURR	13	2	Periodic lease payment paid to leasing company/lessor
92	LBASW	☐	LBASW	ANLKWERT	CURR	13	2	Leasing base value as new
93	LKAUF	☐	LKAUF	ANLKWERT	CURR	13	2	Leased asset purchase price
94	LMZIN	☐	LMZIN	AFPROZ	DEC	7	4	Leasing monthly interest rate (Capital Lease)
95	LZINS	☐	LZINS	AFPROZ	DEC	7	4	Leasing interest rate (capital lease)
96	LTZBW	☐	LTZBW	DATUM	DATS	8	0	Posting date of the last lease payment
97	LKUZA	☐	LKUZA	ANLKWERT	CURR	13	2	Total of posted leasing payments
98	LKUZI	☐	LKUZI	ANLKWERT	CURR	13	2	Total leasing interest posted
99	LLAVB	☐	LLAVB	ANLKWERT	CURR	13	2	Total of long-term leasing liability
100	LEANZ	☐	LEANZ	DEC5	DEC	5	0	Number of lease payments
101	LVTNR	☐	LVTNR	CHAR15	CHAR	15	0	Leasing agreement number
102	LETXT	☐	LETXT	TEXT50	CHAR	50	0	Leasing data text
103	XAKTIV	☐	XAKTIV	XFELD	CHAR	1	0	Indicator: Capitalize fixed asset
104	ANUPD	☐	ANUPD	ANUPD	CHAR	1	0	Indicator: Type of change to table
105	LBLNR	☐	LBLNR	BELNR	CHAR	10	0	No. of last document with which posting to asset was made
106	XV0DT	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
107	XV0NM	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
108	XV1DT	☐	XV1DT	DATUM	DATS	8	0	Change date: View 1
109	XV1NM	☐	XV1NM	USNAM	CHAR	12	0	Name of person in charge, who changed view 1
110	XV2DT	☐	XV2DT	DATUM	DATS	8	0	Change date: View 2
111	XV2NM	☐	XV2NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 2
112	XV3DT	☐	XV3DT	DATUM	DATS	8	0	Change date: View 3
113	XV3NM	☐	XV3NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 3
114	XV4DT	☐	XV4DT	DATUM	DATS	8	0	Change date: View 4
115	XV4NM	☐	XV4NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 4
116	XV5DT	☐	XV5DT	DATUM	DATS	8	0	Change date:View 5
117	XV5NM	☐	XV5NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 5
118	XV6DT	☐	XV6DT	DATUM	DATS	8	0	Change date:View 6
119	XV6NM	☐	XV6NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 6
120	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
121	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
122	LEART	☐	LEART	LEASART	CHAR	2	0	Leasing type	T083L
123	LVORS	☐	LVORS	XFELD	CHAR	1	0	Advance payments
124	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
125	POSNR	☐	AM_POSNR	PS_POSNR	NUMC	8	0	WBS element investment project	PRPS
126	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
127	XAFABCH	☐	XAFABCH	XFELD	CHAR	1	0	Asset acquired used
128	XANLGR	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
129	MCOA1	☐	MCOA1	CHAR30	CHAR	30	0	Search term for matchcode search
130	XINVM	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
131	SERNR	☐	AM_SERNR	GERNR	CHAR	18	0	Serial number
132	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
133	LRVDAT	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
134	ACT_CHANGE_PM	☐	AAPM_ACT_CHANGE_PM	AAPM_ACT	CHAR	1	0	Change Asset Master Record from Equipment Master
135	HAS_TDDP	☐	HAS_TDDP	BOOLE	CHAR	1	0	Asset Has Time-Dependent Valuation Parameters in ANLBZA
136	LAST_REORG_DATE	☐	FAA_LAST_REORG	DATUM	DATS	8	0	Date of Last Reorganization

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ANLA	ANLKL	ANKA	ANLKL	REF	1	N
2	ANLA	ANLN1	ANLH	ANLN1	KEY	1	1
3	ANLA	ANLUE	T087U	ANLUE	REF	1	CN
4	ANLA	BUKRS	T093C	BUKRS	KEY	1	N
5	ANLA	EIGKZ	T097	EIGKZ	REF	1	CN
6	ANLA	FEINS	T006	MSEHI	REF	1	CN
7	ANLA	GDLGRP	T087G	GDLGRP	REF	C	CN
8	ANLA	GRUND	T098	GRUND	REF	1	CN
9	ANLA	IZWEK	T087I	IZWEK	KEY	1	CN
10	ANLA	KTOGR	T095A	KTOGR	REF	1	CN
11	ANLA	LAND1	T005	LAND1	REF	1	CN
12	ANLA	LEAFI	LFA1	LIFNR	REF	1	C
13	ANLA	LEART	T083L	LEART	REF	C	CN
14	ANLA	LIFNR	LFA1	LIFNR	REF	1	C
15	ANLA	MEINS	T006	MSEHI	REF	1	CN
16	ANLA	OBJNR	ONR00	OBJNR	REF	C	C
17	ANLA	ORD41	T087	ORD4X	REF	1	CN
18	ANLA	ORD42	T087	ORD4X	REF	1	CN
19	ANLA	ORD43	T087	ORD4X	REF	1	CN
20	ANLA	ORD44	T087	ORD4X	REF	1	CN
21	ANLA	POSNR	PRPS	PSPNR	REF	C	CN
22	ANLA	SPRAS	T002	SPRAS	REF	1	N
23	ANLA	UMWKZ	T087K	UMWKZ	REF	1	CN
24	ANLA	VBUND	T880	RCOMP	REF	1	CN
25	ANLA	VMGLI	T092	VMGLI	REF	1	CN
26	ANLA	ZUAWA	TZUN	ZUAWA	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in