SAP ABAP Table V_ANLBAZ (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_ANLBAZ	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	ANLGR	☑	ANLGR	ANLN1	CHAR	12	0	Group asset	ANLH
4	ANLGR2	☑	ANLGR2	ANLN2	CHAR	4	0	Subnumber of group asset	ANLA
5	ANLN1	☑	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
6	ANLN2	☑	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
7	AFABE	☑	AFABE_D	AFABE	NUMC	2	0	Real depreciation area	T093
8	ANLB_BDATU	☑	BDATU	DATUM	DATS	8	0	Date validity ends
9	BDATU	☑	BDATU	DATUM	DATS	8	0	Date validity ends
10	ADATU	☐	ADATU	DATUM	DATS	8	0	Date for beginning of validity
11	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
12	ANLAR	☐	ANLAR	CHAR5	CHAR	5	0	Asset types
13	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
14	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
15	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
16	AEDAT	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
17	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
18	XSPEB	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
19	FELEI	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting
20	GEGST	☐	GEGST	GEGST	CHAR	8	0	Technical asset number
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	LBLNR	☐	LBLNR	BELNR	CHAR	10	0	No. of last document with which posting to asset was made
111	XV0DT	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
112	XV0NM	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
113	XV1DT	☐	XV1DT	DATUM	DATS	8	0	Change date: View 1
114	XV1NM	☐	XV1NM	USNAM	CHAR	12	0	Name of person in charge, who changed view 1
115	XV2DT	☐	XV2DT	DATUM	DATS	8	0	Change date: View 2
116	XV2NM	☐	XV2NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 2
117	XV3DT	☐	XV3DT	DATUM	DATS	8	0	Change date: View 3
118	XV3NM	☐	XV3NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 3
119	XV4DT	☐	XV4DT	DATUM	DATS	8	0	Change date: View 4
120	XV4NM	☐	XV4NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 4
121	XV5DT	☐	XV5DT	DATUM	DATS	8	0	Change date:View 5
122	XV5NM	☐	XV5NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 5
123	XV6DT	☐	XV6DT	DATUM	DATS	8	0	Change date:View 6
124	XV6NM	☐	XV6NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 6
125	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
126	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
127	LEART	☐	LEART	LEASART	CHAR	2	0	Leasing type	T083L
128	LVORS	☐	LVORS	XFELD	CHAR	1	0	Advance payments
129	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
130	POSNR	☐	AM_POSNR	PS_POSNR	NUMC	8	0	WBS element investment project	PRPS
131	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
132	XAFABCH	☐	XAFABCH	XFELD	CHAR	1	0	Asset acquired used
133	XANLGR	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
134	XINVM	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
135	SERNR	☐	AM_SERNR	GERNR	CHAR	18	0	Serial number
136	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
137	LRVDAT	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
138	HAS_TDDP	☐	HAS_TDDP	BOOLE	CHAR	1	0	Asset Has Time-Dependent Valuation Parameters in ANLBZA
139	LAST_REORG_DATE	☐	FAA_LAST_REORG	DATUM	DATS	8	0	Date of Last Reorganization
140	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
141	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
142	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
143	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
144	MSFAK	☐	MSFAK	MSFAK	DEC	3	2	Multiple-shift factor for multiple shift operation
145	XSTIL	☐	XSTIL	XFELD	CHAR	1	0	Asset shutdown
146	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
147	CAUFN	☐	CAUFN	AUFNR	CHAR	12	0	Internal order	AUFK
148	PLAN1	☐	PLAN1	CHAR12	CHAR	12	0	no longer used
149	PLAN2	☐	PLAN2	CHAR4	CHAR	4	0	No longer used
150	RAUMN	☐	RAUMNR	CHAR8	CHAR	8	0	Room
151	IAUFN	☐	IAUFN	AUFNR	CHAR	12	0	Maintenance order	AUFK
152	IPROJ	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
153	TPLKZ	☐	FILL03	CHAR03	CHAR	3	0	Unused field length 3
154	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location
155	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
156	IPSNR	☐	AM_IPSNR	PS_POSNR	NUMC	8	0	WBS element - maintenance project	PRPS
157	KFZKZ	☐	AM_KFZKZ	AM_KFZKZ	CHAR	15	0	License plate no. of vehichle
158	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
159	KOSTLV	☐	KOSTLV	KOSTL	CHAR	10	0	Cost center responsible for asset
160	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
161	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
162	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
163	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
164	GEBER2	☐	BP_GEBER2	BP_GEBER	CHAR	10	0	Fund for APC Account Assignments
165	FKBER2	☐	FKBER2	FKBER	CHAR	16	0	Functional Area for APC Account Assignments
166	GRANT_NBR2	☐	GM_GRANT_NBR2	GM_GRANT_NBR	CHAR	20	0	Grant for APC Account Assignments
167	FISTL2	☐	FISTL2	FISTL	CHAR	16	0	Funds Center for APC Account Assignments
168	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
169	PS_PSP_PNR2	☐	PS_PSP_PNR2	PS_POSNR	NUMC	8	0	WBS Element (Costs)
170	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period
171	BUDGET_PD2	☐	FM_BUDGET_PERIOD2	FM_BUDGET_PERIOD	CHAR	10	0	Budget Period for APC Account Assignments
172	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
173	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_ANLBAZ	AFABE	T093	AFABER	REF	1	CN
2	V_ANLBAZ	ANLGR	ANLH	ANLN1	REF	C	CN
3	V_ANLBAZ	ANLGR2	ANLA	ANLN2	REF	C	CN
4	V_ANLBAZ	ANLKL	ANKA	ANLKL	REF	1	N
5	V_ANLBAZ	ANLN1	ANLH	ANLN1	KEY	1	1
6	V_ANLBAZ	ANLN2	ANLA	ANLN2	KEY	1	1
7	V_ANLBAZ	ANLUE	T087U	ANLUE	REF	1	CN
8	V_ANLBAZ	BUKRS	T001	BUKRS	KEY	1	CN
9	V_ANLBAZ	CAUFN	AUFK	AUFNR	REF	C	CN
10	V_ANLBAZ	EIGKZ	T097	EIGKZ	REF	1	CN
11	V_ANLBAZ	FEINS	T006	MSEHI	REF	1	CN
12	V_ANLBAZ	GDLGRP	T087G	GDLGRP	REF	C	CN
13	V_ANLBAZ	GRUND	T098	GRUND	REF	1	CN
14	V_ANLBAZ	GSBER	TGSB	GSBER	REF	1	CN
15	V_ANLBAZ	IAUFN	AUFK	AUFNR	REF	C	CN
16	V_ANLBAZ	IPSNR	PRPS	PSPNR	REF	C	CN
17	V_ANLBAZ	IZWEK	T087I	IZWEK	KEY	1	CN
18	V_ANLBAZ	KTOGR	T095A	KTOGR	REF	1	CN
19	V_ANLBAZ	LAND1	T005	LAND1	REF	1	CN
20	V_ANLBAZ	LEAFI	LFA1	LIFNR	REF	1	C
21	V_ANLBAZ	LEART	T083L	LEART	REF	C	CN
22	V_ANLBAZ	LIFNR	LFA1	LIFNR	REF	1	C
23	V_ANLBAZ	MEINS	T006	MSEHI	REF	1	CN
24	V_ANLBAZ	OBJNR	ONR00	OBJNR	REF	C	C
25	V_ANLBAZ	ORD41	T087	ORD4X	REF	1	CN
26	V_ANLBAZ	ORD42	T087	ORD4X	REF	1	CN
27	V_ANLBAZ	ORD43	T087	ORD4X	REF	1	CN
28	V_ANLBAZ	ORD44	T087	ORD4X	REF	1	CN
29	V_ANLBAZ	POSNR	PRPS	PSPNR	REF	C	CN
30	V_ANLBAZ	SEGMENT	FAGL_SEGM	SEGMENT
31	V_ANLBAZ	SPRAS	T002	SPRAS	REF	1	N
32	V_ANLBAZ	STORT	T499S	STAND	REF	1	CN
33	V_ANLBAZ	TXJCD	TTXJ	TXJCD	REF	1	CN
34	V_ANLBAZ	UMWKZ	T087K	UMWKZ	REF	1	CN
35	V_ANLBAZ	VBUND	T880	RCOMP	REF	1	CN
36	V_ANLBAZ	VMGLI	T092	VMGLI	REF	1	CN
37	V_ANLBAZ	WERKS	T001W	WERKS	REF	1	CN
38	V_ANLBAZ	ZUAWA	TZUN	ZUAWA	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in