SAP ABAP Table V_ANLAB (Generated Table for View)

Basic Data

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

History

Last changed by/on	SAP	20130529
SAP Release Created in