SAP ABAP Table V_ANLAZ (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_ANLAZ	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	T001
3	ANLN1	☑	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
4	ANLN2	☑	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
5	BDATU	☑	BDATU	DATUM	DATS	8	0	Date validity ends
6	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
7	GEGST	☐	GEGST	GEGST	CHAR	8	0	Technical asset number
8	ANLAR	☐	ANLAR	CHAR5	CHAR	5	0	Asset types
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	AEDAT	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
13	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
14	XSPEB	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
15	FELEI	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting
16	KTOGR	☐	KTOGR	KTOGR	CHAR	8	0	Account determination	T095A
17	XOPVW	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
18	ANLTP	☐	ANLTP	ANLTP	NUMC	1	0	Asset Category
19	ZUJHR	☐	DZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
20	ZUPER	☐	DZUPER	POPER	NUMC	3	0	Period in which first acquisition was posted
21	ZUGDT	☐	DZUGDAT	DATUM	DATS	8	0	Asset value date of the first posting
22	AKTIV	☐	AKTIVD	DATUM	DATS	8	0	Asset capitalization date
23	ABGDT	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
24	DEAKT	☐	DEAKT	DATUM	DATS	8	0	Deactivation date
25	GPLAB	☐	GPLAB	DATUM	DATS	8	0	Planned retirement date
26	BSTDT	☐	BSTDT	DATUM	DATS	8	0	Asset purchase order date
27	ORD41	☐	ORD41	ORD4X	CHAR	4	0	Evaluation group 1	T087
28	ORD42	☐	ORD42	ORD4X	CHAR	4	0	Evaluation group 2	T087
29	ORD43	☐	ORD43	ORD4X	CHAR	4	0	Evaluation group 3	T087
30	ORD44	☐	ORD44	ORD4X	CHAR	4	0	Evaluation group 4	T087
31	ANLUE	☐	ANLUE	ANLUE	CHAR	12	0	Asset super number	T087U
32	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
33	ANEQK	☐	ANEQK	ANEQK	NUMC	1	0	Indicator: Historical management
34	ANEQS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
35	LIFNR	☐	AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
36	LAND1	☐	AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
37	LIEFE	☐	LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
38	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
39	EIGKZ	☐	EIGKZ	EIGKZ	CHAR	1	0	Property indicator	T097
40	AIBN1	☐	AIBN1	ANLN1	CHAR	12	0	Original asset that was transferred
41	AIBN2	☐	AIBN2	ANLN2	CHAR	4	0	Original asset that was transferred
42	AIBDT	☐	AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
43	URJHR	☐	URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
44	URWRT	☐	URWRT	ANLKWERT	CURR	13	2	Original acquisition value
45	ANTEI	☐	ANTEI	PRZ32	DEC	5	2	In-house production percentage
46	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
47	EAUFN	☐	AM_AUFNR	AUFNR	CHAR	12	0	Investment Order
48	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
49	MENGE	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
50	TYPBZ	☐	TYPBZ_ANLA	TYPBZ_ANLA	CHAR	15	0	Asset type name
51	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
52	INKEN	☐	INKEN	XFELD	CHAR	1	0	Inventory indicator
53	IVDAT	☐	IVDAT_ANLA	DATUM	DATS	8	0	Last inventory date
54	INVZU	☐	INVZU_ANLA	INVZU_ANLA	CHAR	15	0	Supplementary inventory specifications
55	VMGLI	☐	VMGLI	VMGLI	CHAR	4	0	Property classification key	T092
56	XVRMW	☐	XVRMW	XFELD	CHAR	1	0	Manual net worth tax value
57	WRTMA	☐	WRTMA	ANLKWERT	CURR	13	2	Manual net worth tax value
58	EHWRT	☐	EHWRT	ANLKWERT	CURR	13	2	Assessed value
59	AUFLA	☐	AUFLA_ANLA	DATUM	DATS	8	0	Date of conveyance
60	EHWZU	☐	EHWZU_ANLA	DATUM	DATS	8	0	Date of last notice of assessment
61	EHWNR	☐	EHWNR_ANLA	EHWNR_ANLA	CHAR	16	0	Tax number of the notice of assessment
62	GRUVO	☐	GRUVO_ANLA	DATUM	DATS	8	0	Land Register of
63	GREIN	☐	GREIN_ANLA	DATUM	DATS	8	0	Land register entry on
64	GRBND	☐	GRBND_ANLA	GRBND_ANLA	CHAR	5	0	Land register volume
65	GRBLT	☐	GRBLT_ANLA	GRBLT_ANLA	CHAR	5	0	Land register page
66	GRLFD	☐	GRLFD_ANLA	GRLFD_ANLA	CHAR	4	0	Land register entry: Sequence number
67	FLURK	☐	FLURK_ANLA	CHAR4	CHAR	4	0	Land register map number
68	FLURN	☐	FLURN_ANLA	CHAR10	CHAR	10	0	Plot number
69	FIAMT	☐	FIAMT	TEXT25	CHAR	25	0	Local tax office
70	STADT	☐	ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
71	GRUND	☐	GRUND	GRUND	CHAR	3	0	Reason for manual valuation of net assets	T098
72	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
73	GRUFL	☐	GRUFL	MENG13	QUAN	13	3	Surface area
74	INVNR	☐	INVNR_ANLA	INVNR_ANLA	CHAR	25	0	Inventory number
75	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
76	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
77	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
78	TXA50	☐	TXA50_MORE	TEXT50	CHAR	50	0	Additional asset description
79	XLTXID	☐	XLTXID	XFELD	CHAR	1	0	Indicator: Long text active
80	XVERID	☐	XVERID	XFELD	CHAR	1	0	Long text indicator:Property values
81	XTCHID	☐	XTCHID	XFELD	CHAR	1	0	Indicator: Technical view long text
82	XKALID	☐	XKALID	XFELD	CHAR	1	0	Indicator: Long text active
83	XHERID	☐	XHERID	XFELD	CHAR	1	0	Indicator: Long text for manufacturer/origin
84	XLEAID	☐	XLEAID	XFELD	CHAR	1	0	Indicator: Leasing data long text
85	LEAFI	☐	LEAFI	LIFNR	CHAR	10	0	Leasing company	LFA1
86	LVDAT	☐	LVDAT	DATUM	DATS	8	0	Leasing agreement date
87	LKDAT	☐	LKDAT	DATUM	DATS	8	0	Leasing agreement notice date
88	LEABG	☐	LEABG	DATUM	DATS	8	0	Lease start date
89	LEJAR	☐	LEJAR	JARAF	NUMC	3	0	Length of lease in years
90	LEPER	☐	LEPER	PERAF	NUMC	3	0	Length of lease in periods
91	LRYTH	☐	LRYTH	PERAF	NUMC	3	0	Lease payment cycle
92	LEGEB	☐	LEGEB	ANLKWERT	CURR	13	2	Periodic lease payment paid to leasing company/lessor
93	LBASW	☐	LBASW	ANLKWERT	CURR	13	2	Leasing base value as new
94	LKAUF	☐	LKAUF	ANLKWERT	CURR	13	2	Leased asset purchase price
95	LMZIN	☐	LMZIN	AFPROZ	DEC	7	4	Leasing monthly interest rate (Capital Lease)
96	LZINS	☐	LZINS	AFPROZ	DEC	7	4	Leasing interest rate (capital lease)
97	LTZBW	☐	LTZBW	DATUM	DATS	8	0	Posting date of the last lease payment
98	LKUZA	☐	LKUZA	ANLKWERT	CURR	13	2	Total of posted leasing payments
99	LKUZI	☐	LKUZI	ANLKWERT	CURR	13	2	Total leasing interest posted
100	LLAVB	☐	LLAVB	ANLKWERT	CURR	13	2	Total of long-term leasing liability
101	LEANZ	☐	LEANZ	DEC5	DEC	5	0	Number of lease payments
102	LVTNR	☐	LVTNR	CHAR15	CHAR	15	0	Leasing agreement number
103	LETXT	☐	LETXT	TEXT50	CHAR	50	0	Leasing data text
104	XAKTIV	☐	XAKTIV	XFELD	CHAR	1	0	Indicator: Capitalize fixed asset
105	ANUPD	☐	ANUPD	ANUPD	CHAR	1	0	Indicator: Type of change to table
106	LBLNR	☐	LBLNR	BELNR	CHAR	10	0	No. of last document with which posting to asset was made
107	XV0DT	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
108	XV0NM	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
109	XV1DT	☐	XV1DT	DATUM	DATS	8	0	Change date: View 1
110	XV1NM	☐	XV1NM	USNAM	CHAR	12	0	Name of person in charge, who changed view 1
111	XV2DT	☐	XV2DT	DATUM	DATS	8	0	Change date: View 2
112	XV2NM	☐	XV2NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 2
113	XV3DT	☐	XV3DT	DATUM	DATS	8	0	Change date: View 3
114	XV3NM	☐	XV3NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 3
115	XV4DT	☐	XV4DT	DATUM	DATS	8	0	Change date: View 4
116	XV4NM	☐	XV4NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 4
117	XV5DT	☐	XV5DT	DATUM	DATS	8	0	Change date:View 5
118	XV5NM	☐	XV5NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 5
119	XV6DT	☐	XV6DT	DATUM	DATS	8	0	Change date:View 6
120	XV6NM	☐	XV6NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 6
121	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
122	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
123	LEART	☐	LEART	LEASART	CHAR	2	0	Leasing type	T083L
124	LVORS	☐	LVORS	XFELD	CHAR	1	0	Advance payments
125	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
126	POSNR	☐	AM_POSNR	PS_POSNR	NUMC	8	0	WBS element investment project	PRPS
127	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
128	XAFABCH	☐	XAFABCH	XFELD	CHAR	1	0	Asset acquired used
129	XANLGR	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
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
137	ADATU	☐	ADATU	DATUM	DATS	8	0	Date for beginning of validity
138	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
139	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
140	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
141	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
142	MSFAK	☐	MSFAK	MSFAK	DEC	3	2	Multiple-shift factor for multiple shift operation
143	XSTIL	☐	XSTIL	XFELD	CHAR	1	0	Asset shutdown
144	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
145	CAUFN	☐	CAUFN	AUFNR	CHAR	12	0	Internal order	AUFK
146	PLAN1	☐	PLAN1	CHAR12	CHAR	12	0	no longer used
147	PLAN2	☐	PLAN2	CHAR4	CHAR	4	0	No longer used
148	RAUMN	☐	RAUMNR	CHAR8	CHAR	8	0	Room
149	IAUFN	☐	IAUFN	AUFNR	CHAR	12	0	Maintenance order	AUFK
150	IPROJ	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
151	TPLKZ	☐	FILL03	CHAR03	CHAR	3	0	Unused field length 3
152	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location
153	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
154	IPSNR	☐	AM_IPSNR	PS_POSNR	NUMC	8	0	WBS element - maintenance project	PRPS
155	KFZKZ	☐	AM_KFZKZ	AM_KFZKZ	CHAR	15	0	License plate no. of vehichle
156	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
157	KOSTLV	☐	KOSTLV	KOSTL	CHAR	10	0	Cost center responsible for asset
158	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
159	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
160	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
161	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
162	GEBER2	☐	BP_GEBER2	BP_GEBER	CHAR	10	0	Fund for APC Account Assignments
163	FKBER2	☐	FKBER2	FKBER	CHAR	16	0	Functional Area for APC Account Assignments
164	GRANT_NBR2	☐	GM_GRANT_NBR2	GM_GRANT_NBR	CHAR	20	0	Grant for APC Account Assignments
165	FISTL2	☐	FISTL2	FISTL	CHAR	16	0	Funds Center for APC Account Assignments
166	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
167	PS_PSP_PNR2	☐	PS_PSP_PNR2	PS_POSNR	NUMC	8	0	WBS Element (Costs)
168	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period
169	BUDGET_PD2	☐	FM_BUDGET_PERIOD2	FM_BUDGET_PERIOD	CHAR	10	0	Budget Period for APC Account Assignments
170	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
171	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_ANLAZ	ANLKL	ANKA	ANLKL	REF	1	N
2	V_ANLAZ	ANLN1	ANLH	ANLN1	KEY	1	N
3	V_ANLAZ	ANLN2	ANLA	ANLN2	KEY	1	1
4	V_ANLAZ	ANLUE	T087U	ANLUE	REF	1	CN
5	V_ANLAZ	BUKRS	T001	BUKRS	KEY	1	N
6	V_ANLAZ	CAUFN	AUFK	AUFNR	REF	C	CN
7	V_ANLAZ	EIGKZ	T097	EIGKZ	REF	1	CN
8	V_ANLAZ	FEINS	T006	MSEHI	REF	1	CN
9	V_ANLAZ	GDLGRP	T087G	GDLGRP	REF	C	CN
10	V_ANLAZ	GRUND	T098	GRUND	REF	1	CN
11	V_ANLAZ	GSBER	TGSB	GSBER	REF	1	CN
12	V_ANLAZ	IAUFN	AUFK	AUFNR	REF	C	CN
13	V_ANLAZ	IPSNR	PRPS	PSPNR	REF	C	CN
14	V_ANLAZ	IZWEK	T087I	IZWEK	KEY	1	CN
15	V_ANLAZ	KTOGR	T095A	KTOGR	REF	1	CN
16	V_ANLAZ	LAND1	T005	LAND1	REF	1	CN
17	V_ANLAZ	LEAFI	LFA1	LIFNR	REF	1	C
18	V_ANLAZ	LEART	T083L	LEART	REF	C	CN
19	V_ANLAZ	LIFNR	LFA1	LIFNR	REF	1	C
20	V_ANLAZ	MEINS	T006	MSEHI	REF	1	CN
21	V_ANLAZ	OBJNR	ONR00	OBJNR	REF	C	C
22	V_ANLAZ	ORD41	T087	ORD4X	REF	1	CN
23	V_ANLAZ	ORD42	T087	ORD4X	REF	1	CN
24	V_ANLAZ	ORD43	T087	ORD4X	REF	1	CN
25	V_ANLAZ	ORD44	T087	ORD4X	REF	1	CN
26	V_ANLAZ	POSNR	PRPS	PSPNR	REF	C	CN
27	V_ANLAZ	SEGMENT	FAGL_SEGM	SEGMENT
28	V_ANLAZ	SPRAS	T002	SPRAS	REF	1	N
29	V_ANLAZ	STORT	T499S	STAND	REF	1	CN
30	V_ANLAZ	TXJCD	TTXJ	TXJCD	REF	1	CN
31	V_ANLAZ	UMWKZ	T087K	UMWKZ	REF	1	CN
32	V_ANLAZ	VBUND	T880	RCOMP	REF	1	CN
33	V_ANLAZ	VMGLI	T092	VMGLI	REF	1	CN
34	V_ANLAZ	WERKS	T001W	WERKS	REF	1	CN
35	V_ANLAZ	ZUAWA	TZUN	ZUAWA	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in