SAP ABAP View V_ANLHZ ("Asset Main Numbers")

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

View Type	D	Database View
Database View	V_ANLHZ
Short Description	"Asset Main Numbers"
Root table	ANLZ	Time-Dependent Asset Allocations

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ANLZ	ANLZ
2	ANLA
3	ANLH

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ANLA	MANDT	JL	EQ				0	0
2	ANLZ	MANDT	JR	EQ			AND	0	0
3	ANLA	BUKRS	JL	EQ				0	0
4	ANLZ	BUKRS	JR	EQ			AND	0	0
5	ANLA	ANLN1	JL	EQ				0	0
6	ANLZ	ANLN1	JR	EQ			AND	0	0
7	ANLA	ANLN2	JL	EQ				0	0
8	ANLZ	ANLN2	JR	EQ			AND	0	0
9	ANLA	MANDT	JL	EQ				0	0
10	ANLH	MANDT	JR	EQ			AND	0	0
11	ANLA	BUKRS	JL	EQ				0	0
12	ANLH	BUKRS	JR	EQ			AND	0	0
13	ANLA	ANLN1	JL	EQ				0	0
14	ANLH	ANLN1	JR	EQ			AND	0	0
15	ANLA	ANLN2	JL	EQ				0	0
16	ANLH	FUNTN	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in