SAP ABAP Table V_ANLAVS (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_ANLAVS	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	VRSLFD	☑	VRSLFD	NUM2	NUMC	2	0	Sequence number for insurance data FI-AA
6	BDATU	☑	BDATU	DATUM	DATS	8	0	Date validity ends
7	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
8	GEGST	☐	GEGST	GEGST	CHAR	8	0	Technical asset number
9	ANLAR	☐	ANLAR	CHAR5	CHAR	5	0	Asset types
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEDAT	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
14	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
15	XSPEB	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
16	FELEI	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting
17	KTOGR	☐	KTOGR	KTOGR	CHAR	8	0	Account determination	T095A
18	XOPVW	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
19	ANLTP	☐	ANLTP	ANLTP	NUMC	1	0	Asset Category
20	ZUJHR	☐	DZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
21	ZUPER	☐	DZUPER	POPER	NUMC	3	0	Period in which first acquisition was posted
22	ZUGDT	☐	DZUGDAT	DATUM	DATS	8	0	Asset value date of the first posting
23	AKTIV	☐	AKTIVD	DATUM	DATS	8	0	Asset capitalization date
24	ABGDT	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
25	DEAKT	☐	DEAKT	DATUM	DATS	8	0	Deactivation date
26	GPLAB	☐	GPLAB	DATUM	DATS	8	0	Planned retirement date
27	BSTDT	☐	BSTDT	DATUM	DATS	8	0	Asset purchase order date
28	ORD41	☐	ORD41	ORD4X	CHAR	4	0	Evaluation group 1	T087
29	ORD42	☐	ORD42	ORD4X	CHAR	4	0	Evaluation group 2	T087
30	ORD43	☐	ORD43	ORD4X	CHAR	4	0	Evaluation group 3	T087
31	ORD44	☐	ORD44	ORD4X	CHAR	4	0	Evaluation group 4	T087
32	ANLUE	☐	ANLUE	ANLUE	CHAR	12	0	Asset super number	T087U
33	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
34	ANEQK	☐	ANEQK	ANEQK	NUMC	1	0	Indicator: Historical management
35	ANEQS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
36	LIFNR	☐	AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
37	LAND1	☐	AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
38	LIEFE	☐	LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
39	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
40	EIGKZ	☐	EIGKZ	EIGKZ	CHAR	1	0	Property indicator	T097
41	AIBN1	☐	AIBN1	ANLN1	CHAR	12	0	Original asset that was transferred
42	AIBN2	☐	AIBN2	ANLN2	CHAR	4	0	Original asset that was transferred
43	AIBDT	☐	AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
44	URJHR	☐	URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
45	URWRT	☐	URWRT	ANLKWERT	CURR	13	2	Original acquisition value
46	ANTEI	☐	ANTEI	PRZ32	DEC	5	2	In-house production percentage
47	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
48	EAUFN	☐	AM_AUFNR	AUFNR	CHAR	12	0	Investment Order
49	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
50	MENGE	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
51	TYPBZ	☐	TYPBZ_ANLA	TYPBZ_ANLA	CHAR	15	0	Asset type name
52	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
53	INKEN	☐	INKEN	XFELD	CHAR	1	0	Inventory indicator
54	IVDAT	☐	IVDAT_ANLA	DATUM	DATS	8	0	Last inventory date
55	INVZU	☐	INVZU_ANLA	INVZU_ANLA	CHAR	15	0	Supplementary inventory specifications
56	VMGLI	☐	VMGLI	VMGLI	CHAR	4	0	Property classification key	T092
57	XVRMW	☐	XVRMW	XFELD	CHAR	1	0	Manual net worth tax value
58	WRTMA	☐	WRTMA	ANLKWERT	CURR	13	2	Manual net worth tax value
59	EHWRT	☐	EHWRT	ANLKWERT	CURR	13	2	Assessed value
60	AUFLA	☐	AUFLA_ANLA	DATUM	DATS	8	0	Date of conveyance
61	EHWZU	☐	EHWZU_ANLA	DATUM	DATS	8	0	Date of last notice of assessment
62	EHWNR	☐	EHWNR_ANLA	EHWNR_ANLA	CHAR	16	0	Tax number of the notice of assessment
63	GRUVO	☐	GRUVO_ANLA	DATUM	DATS	8	0	Land Register of
64	GREIN	☐	GREIN_ANLA	DATUM	DATS	8	0	Land register entry on
65	GRBND	☐	GRBND_ANLA	GRBND_ANLA	CHAR	5	0	Land register volume
66	GRBLT	☐	GRBLT_ANLA	GRBLT_ANLA	CHAR	5	0	Land register page
67	GRLFD	☐	GRLFD_ANLA	GRLFD_ANLA	CHAR	4	0	Land register entry: Sequence number
68	FLURK	☐	FLURK_ANLA	CHAR4	CHAR	4	0	Land register map number
69	FLURN	☐	FLURN_ANLA	CHAR10	CHAR	10	0	Plot number
70	FIAMT	☐	FIAMT	TEXT25	CHAR	25	0	Local tax office
71	STADT	☐	ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
72	GRUND	☐	GRUND	GRUND	CHAR	3	0	Reason for manual valuation of net assets	T098
73	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
74	GRUFL	☐	GRUFL	MENG13	QUAN	13	3	Surface area
75	INVNR	☐	INVNR_ANLA	INVNR_ANLA	CHAR	25	0	Inventory number
76	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
77	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
78	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
79	TXA50	☐	TXA50_MORE	TEXT50	CHAR	50	0	Additional asset description
80	XLTXID	☐	XLTXID	XFELD	CHAR	1	0	Indicator: Long text active
81	XVERID	☐	XVERID	XFELD	CHAR	1	0	Long text indicator:Property values
82	XTCHID	☐	XTCHID	XFELD	CHAR	1	0	Indicator: Technical view long text
83	XKALID	☐	XKALID	XFELD	CHAR	1	0	Indicator: Long text active
84	XHERID	☐	XHERID	XFELD	CHAR	1	0	Indicator: Long text for manufacturer/origin
85	XLEAID	☐	XLEAID	XFELD	CHAR	1	0	Indicator: Leasing data long text
86	LEAFI	☐	LEAFI	LIFNR	CHAR	10	0	Leasing company	LFA1
87	LVDAT	☐	LVDAT	DATUM	DATS	8	0	Leasing agreement date
88	LKDAT	☐	LKDAT	DATUM	DATS	8	0	Leasing agreement notice date
89	LEABG	☐	LEABG	DATUM	DATS	8	0	Lease start date
90	LEJAR	☐	LEJAR	JARAF	NUMC	3	0	Length of lease in years
91	LEPER	☐	LEPER	PERAF	NUMC	3	0	Length of lease in periods
92	LRYTH	☐	LRYTH	PERAF	NUMC	3	0	Lease payment cycle
93	LEGEB	☐	LEGEB	ANLKWERT	CURR	13	2	Periodic lease payment paid to leasing company/lessor
94	LBASW	☐	LBASW	ANLKWERT	CURR	13	2	Leasing base value as new
95	LKAUF	☐	LKAUF	ANLKWERT	CURR	13	2	Leased asset purchase price
96	LMZIN	☐	LMZIN	AFPROZ	DEC	7	4	Leasing monthly interest rate (Capital Lease)
97	LZINS	☐	LZINS	AFPROZ	DEC	7	4	Leasing interest rate (capital lease)
98	LTZBW	☐	LTZBW	DATUM	DATS	8	0	Posting date of the last lease payment
99	LKUZA	☐	LKUZA	ANLKWERT	CURR	13	2	Total of posted leasing payments
100	LKUZI	☐	LKUZI	ANLKWERT	CURR	13	2	Total leasing interest posted
101	LLAVB	☐	LLAVB	ANLKWERT	CURR	13	2	Total of long-term leasing liability
102	LEANZ	☐	LEANZ	DEC5	DEC	5	0	Number of lease payments
103	LVTNR	☐	LVTNR	CHAR15	CHAR	15	0	Leasing agreement number
104	LETXT	☐	LETXT	TEXT50	CHAR	50	0	Leasing data text
105	ANUPD	☐	ANUPD	ANUPD	CHAR	1	0	Indicator: Type of change to table
106	XAKTIV	☐	XAKTIV	XFELD	CHAR	1	0	Indicator: Capitalize fixed asset
107	LBLNR	☐	LBLNR	BELNR	CHAR	10	0	No. of last document with which posting to asset was made
108	XV0DT	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
109	XV0NM	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
110	XV1DT	☐	XV1DT	DATUM	DATS	8	0	Change date: View 1
111	XV1NM	☐	XV1NM	USNAM	CHAR	12	0	Name of person in charge, who changed view 1
112	XV2DT	☐	XV2DT	DATUM	DATS	8	0	Change date: View 2
113	XV2NM	☐	XV2NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 2
114	XV3DT	☐	XV3DT	DATUM	DATS	8	0	Change date: View 3
115	XV3NM	☐	XV3NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 3
116	XV4DT	☐	XV4DT	DATUM	DATS	8	0	Change date: View 4
117	XV4NM	☐	XV4NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 4
118	XV5DT	☐	XV5DT	DATUM	DATS	8	0	Change date:View 5
119	XV5NM	☐	XV5NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 5
120	XV6DT	☐	XV6DT	DATUM	DATS	8	0	Change date:View 6
121	XV6NM	☐	XV6NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 6
122	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
123	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
124	LEART	☐	LEART	LEASART	CHAR	2	0	Leasing type	T083L
125	LVORS	☐	LVORS	XFELD	CHAR	1	0	Advance payments
126	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
127	POSNR	☐	AM_POSNR	PS_POSNR	NUMC	8	0	WBS element investment project	PRPS
128	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
129	XAFABCH	☐	XAFABCH	XFELD	CHAR	1	0	Asset acquired used
130	XANLGR	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
131	XINVM	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
132	SERNR	☐	AM_SERNR	GERNR	CHAR	18	0	Serial number
133	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
134	LRVDAT	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
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	VSART	☐	VSART_ANLA	AVART	CHAR	2	0	Asset insurance type	T099
169	VSIND	☐	VSIND	WBIND	CHAR	5	0	Insurance index series	T094A
170	VRSBA	☐	VRSBA	ANLKWERT	CURR	13	2	Base insurable value
171	VSBAJ	☐	VSBAJ	GJAHR	NUMC	4	0	Base insurable value: Fiscal year update
172	VSGES	☐	AVGES	AVGES	CHAR	2	0	Insurance companies	T099A
173	VSMAN	☐	VSMAN	XFELD	CHAR	1	0	Update insurable value manually
174	VRSMA	☐	VRSMA	ANLKWERT	CURR	13	2	Manual insurable value
175	VRSJH	☐	VRSJH	GJAHR	NUMC	4	0	Maintenance year for manual insurable value
176	VRSJA	☐	VRSJA	GJAHR	NUMC	4	0	Old maintenance year for manual insurable value
177	VRSBG	☐	VRSBG	DATUM	DATS	8	0	Insurance start date
178	VSTAR	☐	AVTAR	AVTAR	CHAR	5	0	Insurance rate FI-AA	T099B
179	VSSTX	☐	VSSTX	CHAR15	CHAR	15	0	Insurance policy number
180	XVRSID	☐	XVRSID	XFELD	CHAR	1	0	Indicator: Insurance long text
181	VSZTX	☐	VSZTX	TEXT50	CHAR	50	0	Supplementary insurance text
182	LNRAN	☐	LNRAN	LNRAN	NUMC	5	0	Sequence Number of Asset Line Items in Fiscal Year	ANEK
183	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period
184	BUDGET_PD2	☐	FM_BUDGET_PERIOD2	FM_BUDGET_PERIOD	CHAR	10	0	Budget Period for APC Account Assignments
185	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
186	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_ANLAVS	ANLKL	ANKA	ANLKL	REF	1	N
2	V_ANLAVS	ANLN1	ANLH	ANLN1	KEY	1	1
3	V_ANLAVS	ANLN2	ANLA	ANLN2	KEY	1	1
4	V_ANLAVS	ANLUE	T087U	ANLUE	REF	1	CN
5	V_ANLAVS	BUKRS	T001	BUKRS	KEY	1	N
6	V_ANLAVS	CAUFN	AUFK	AUFNR	REF	C	CN
7	V_ANLAVS	EIGKZ	T097	EIGKZ	REF	1	CN
8	V_ANLAVS	FEINS	T006	MSEHI	REF	1	CN
9	V_ANLAVS	GDLGRP	T087G	GDLGRP	REF	C	CN
10	V_ANLAVS	GRUND	T098	GRUND	REF	1	CN
11	V_ANLAVS	GSBER	TGSB	GSBER	REF	1	CN
12	V_ANLAVS	IAUFN	AUFK	AUFNR	REF	C	CN
13	V_ANLAVS	IPSNR	PRPS	PSPNR	REF	C	CN
14	V_ANLAVS	IZWEK	T087I	IZWEK	KEY	1	CN
15	V_ANLAVS	KTOGR	T095A	KTOGR	REF	1	CN
16	V_ANLAVS	LAND1	T005	LAND1	REF	1	CN
17	V_ANLAVS	LEAFI	LFA1	LIFNR	REF	1	C
18	V_ANLAVS	LEART	T083L	LEART	REF	C	CN
19	V_ANLAVS	LIFNR	LFA1	LIFNR	REF	1	C
20	V_ANLAVS	LNRAN	ANEK	LNRAN
21	V_ANLAVS	MEINS	T006	MSEHI	REF	1	CN
22	V_ANLAVS	OBJNR	ONR00	OBJNR	REF	C	C
23	V_ANLAVS	ORD41	T087	ORD4X	REF	1	CN
24	V_ANLAVS	ORD42	T087	ORD4X	REF	1	CN
25	V_ANLAVS	ORD43	T087	ORD4X	REF	1	CN
26	V_ANLAVS	ORD44	T087	ORD4X	REF	1	CN
27	V_ANLAVS	POSNR	PRPS	PSPNR	REF	C	CN
28	V_ANLAVS	SEGMENT	FAGL_SEGM	SEGMENT
29	V_ANLAVS	SPRAS	T002	SPRAS	REF	1	N
30	V_ANLAVS	STORT	T499S	STAND	REF	1	CN
31	V_ANLAVS	TXJCD	TTXJ	TXJCD	REF	1	CN
32	V_ANLAVS	UMWKZ	T087K	UMWKZ	REF	1	CN
33	V_ANLAVS	VBUND	T880	RCOMP	REF	1	CN
34	V_ANLAVS	VMGLI	T092	VMGLI	REF	1	CN
35	V_ANLAVS	VSART	T099	VSART	REF	1	CN
36	V_ANLAVS	VSGES	T099A	VSGES	REF	1	CN
37	V_ANLAVS	VSIND	T094A	WBIND	REF	1	CN
38	V_ANLAVS	VSTAR	T099B	VSTAR	REF	1	CN
39	V_ANLAVS	WERKS	T001W	WERKS	REF	1	CN
40	V_ANLAVS	ZUAWA	TZUN	ZUAWA	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in