SAP ABAP View V_ANLSUM_5 (View on ANLA, ANLZ, ANLB, ANLP)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-AA-IS (Application Component) Information System
     ⤷ AA_HDB (Package) ERP Acceleration Asset Accounting

Basic Data

View Type	D	Database View
Database View	V_ANLSUM_5
Short Description	View on ANLA, ANLZ, ANLB, ANLP
Root table	ANLA	Asset Master Record Segment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ANLA	ANLA
2	ANLZ
3	ANLB
4	ANLP

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	ANLB	MANDT	JR	EQ			AND	0	0
11	ANLA	BUKRS	JL	EQ				0	0
12	ANLB	BUKRS	JR	EQ			AND	0	0
13	ANLA	ANLN1	JL	EQ				0	0
14	ANLB	ANLN1	JR	EQ			AND	0	0
15	ANLA	ANLN2	JL	EQ				0	0
16	ANLB	ANLN2	JR	EQ			AND	0	0
17	ANLB	MANDT	JL	EQ				0	0
18	ANLP	MANDT	JR	EQ			AND	0	0
19	ANLB	BUKRS	JL	EQ				0	0
20	ANLP	BUKRS	JR	EQ			AND	0	0
21	ANLB	ANLN1	JL	EQ				0	0
22	ANLP	ANLN1	JR	EQ			AND	0	0
23	ANLB	ANLN2	JL	EQ				0	0
24	ANLP	ANLN2	JR	EQ			AND	0	0
25	ANLB	AFABE	JL	EQ				0	0
26	ANLP	AFABER	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ANLA	MANDT		☐	MANDT	☐	Client
2	BUKRS	ANLA	BUKRS		☐	BUKRS	☐	Company Code
3	ANLN1	ANLA	ANLN1		☐	ANLN1	☐	Main Asset Number
4	ANLN2	ANLA	ANLN2		☐	ANLN2	☐	Asset Subnumber
5	BDATU	ANLZ	BDATU		☐	BDATU	☐	Date validity ends
6	AFABE	ANLB	AFABE		☐	AFABE_D	☐	Real depreciation area
7	GJAHR	ANLP	GJAHR		☐	GJAHR	☐	Fiscal Year
8	ANLKL	ANLA	ANLKL		☐	ANLKL	☐	Asset Class
9	GEGST	ANLA	GEGST		☐	GEGST	☐	Technical asset number
10	ANLAR	ANLA	ANLAR		☐	ANLAR	☐	Asset types
11	ERNAM	ANLA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
12	ERDAT	ANLA	ERDAT		☐	ERDAT	☐	Date on which the record was created
13	AENAM	ANLA	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
14	AEDAT	ANLA	AEDAT		☐	AEDAT_ANLA	☐	Changed on
15	XLOEV	ANLA	XLOEV		☐	XLOEV	☐	Indicator: Account marked for deletion?
16	XSPEB	ANLA	XSPEB		☐	XSPEB_ANLA	☐	Indicator: Asset Locked to Acquisition Postings
17	FELEI	ANLA	FELEI		☐	FELEI	☐	Screen layout for Asset Accounting
18	KTOGR	ANLA	KTOGR		☐	KTOGR	☐	Account determination
19	XOPVW	ANLA	XOPVW		☐	OPVWA	☐	Asset under construct. with line item settlement
20	ANLTP	ANLA	ANLTP		☐	ANLTP	☐	Asset Category
21	ZUJHR	ANLA	ZUJHR		☐	DZUJAHR	☐	Fiscal year in which first acquisition was posted
22	ZUPER	ANLA	ZUPER		☐	DZUPER	☐	Period in which first acquisition was posted
23	ZUGDT	ANLA	ZUGDT		☐	DZUGDAT	☐	Asset value date of the first posting
24	AKTIV	ANLA	AKTIV		☐	AKTIVD	☐	Asset capitalization date
25	ABGDT	ANLA	ABGDT		☐	ABGDAT	☐	Asset value date for the last retirement
26	DEAKT	ANLA	DEAKT		☐	DEAKT	☐	Deactivation date
27	GPLAB	ANLA	GPLAB		☐	GPLAB	☐	Planned retirement date
28	BSTDT	ANLA	BSTDT		☐	BSTDT	☐	Asset purchase order date
29	ORD41	ANLA	ORD41		☐	ORD41	☐	Evaluation group 1
30	ORD42	ANLA	ORD42		☐	ORD42	☐	Evaluation group 2
31	ORD43	ANLA	ORD43		☐	ORD43	☐	Evaluation group 3
32	ORD44	ANLA	ORD44		☐	ORD44	☐	Evaluation group 4
33	ANLUE	ANLA	ANLUE		☐	ANLUE	☐	Asset super number
34	ZUAWA	ANLA	ZUAWA		☐	DZUAWA	☐	Key for sorting according to assignment numbers
35	ANEQK	ANLA	ANEQK		☐	ANEQK	☐	Indicator: Historical management
36	ANEQS	ANLA	ANEQS		☐	ANEQS	☐	Completeness indicator for the asset
37	LIFNR	ANLA	LIFNR		☐	AM_LIFNR	☐	Account number of vendor (other key word)
38	LAND1	ANLA	LAND1		☐	AM_LAND1	☐	Asset's country of origin
39	LIEFE	ANLA	LIEFE		☐	LIEFE	☐	Name of asset supplier
40	HERST	ANLA	HERST		☐	HERST	☐	Manufacturer of asset
41	EIGKZ	ANLA	EIGKZ		☐	EIGKZ	☐	Property indicator
42	AIBN1	ANLA	AIBN1		☐	AIBN1	☐	Original asset that was transferred
43	AIBN2	ANLA	AIBN2		☐	AIBN2	☐	Original asset that was transferred
44	AIBDT	ANLA	AIBDT		☐	AIBDT	☐	Original acquisition date of AuC/ transferred asset
45	URJHR	ANLA	URJHR		☐	URJHR	☐	Fiscal year of original acquisition
46	URWRT	ANLA	URWRT		☐	URWRT	☐	Original acquisition value
47	ANTEI	ANLA	ANTEI		☐	ANTEI	☐	In-house production percentage
48	PROJN	ANLA	PROJN		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
49	EAUFN	ANLA	EAUFN		☐	AM_AUFNR	☐	Investment Order
50	MEINS	ANLA	MEINS		☐	MEINS	☐	Base Unit of Measure
51	MENGE	ANLA	MENGE		☐	AM_MENGE	☐	Quantity
52	TYPBZ	ANLA	TYPBZ		☐	TYPBZ_ANLA	☐	Asset type name
53	IZWEK	ANLA	IZWEK		☐	IZWEK	☐	Reason for investment
54	INKEN	ANLA	INKEN		☐	INKEN	☐	Inventory indicator
55	IVDAT	ANLA	IVDAT		☐	IVDAT_ANLA	☐	Last inventory date
56	INVZU	ANLA	INVZU		☐	INVZU_ANLA	☐	Supplementary inventory specifications
57	VMGLI	ANLA	VMGLI		☐	VMGLI	☐	Property classification key
58	XVRMW	ANLA	XVRMW		☐	XVRMW	☐	Manual net worth tax value
59	WRTMA	ANLA	WRTMA		☐	WRTMA	☐	Manual net worth tax value
60	EHWRT	ANLA	EHWRT		☐	EHWRT	☐	Assessed value
61	AUFLA	ANLA	AUFLA		☐	AUFLA_ANLA	☐	Date of conveyance
62	EHWZU	ANLA	EHWZU		☐	EHWZU_ANLA	☐	Date of last notice of assessment
63	EHWNR	ANLA	EHWNR		☐	EHWNR_ANLA	☐	Tax number of the notice of assessment
64	GRUVO	ANLA	GRUVO		☐	GRUVO_ANLA	☐	Land Register of
65	GREIN	ANLA	GREIN		☐	GREIN_ANLA	☐	Land register entry on
66	GRBND	ANLA	GRBND		☐	GRBND_ANLA	☐	Land register volume
67	GRBLT	ANLA	GRBLT		☐	GRBLT_ANLA	☐	Land register page
68	GRLFD	ANLA	GRLFD		☐	GRLFD_ANLA	☐	Land register entry: Sequence number
69	FLURK	ANLA	FLURK		☐	FLURK_ANLA	☐	Land register map number
70	FLURN	ANLA	FLURN		☐	FLURN_ANLA	☐	Plot number
71	FIAMT	ANLA	FIAMT		☐	FIAMT	☐	Local tax office
72	STADT	ANLA	STADT		☐	ORT01_ANLA	☐	Municipality
73	GRUND	ANLA	GRUND		☐	GRUND	☐	Reason for manual valuation of net assets
74	FEINS	ANLA	FEINS		☐	FEINS	☐	Area unit
75	GRUFL	ANLA	GRUFL		☐	GRUFL	☐	Surface area
76	INVNR	ANLA	INVNR		☐	INVNR_ANLA	☐	Inventory number
77	VBUND	ANLA	VBUND		☐	RASSC	☐	Company ID of trading partner
78	SPRAS	ANLA	SPRAS		☐	SPRAS	☐	Language Key
79	TXT50	ANLA	TXT50		☐	TXA50_ANLT	☐	Asset description
80	TXA50	ANLA	TXA50		☐	TXA50_MORE	☐	Additional asset description
81	XLTXID	ANLA	XLTXID		☐	XLTXID	☐	Indicator: Long text active
82	XVERID	ANLA	XVERID		☐	XVERID	☐	Long text indicator:Property values
83	XTCHID	ANLA	XTCHID		☐	XTCHID	☐	Indicator: Technical view long text
84	XKALID	ANLA	XKALID		☐	XKALID	☐	Indicator: Long text active
85	XHERID	ANLA	XHERID		☐	XHERID	☐	Indicator: Long text for manufacturer/origin
86	XLEAID	ANLA	XLEAID		☐	XLEAID	☐	Indicator: Leasing data long text
87	LEAFI	ANLA	LEAFI		☐	LEAFI	☐	Leasing company
88	LVDAT	ANLA	LVDAT		☐	LVDAT	☐	Leasing agreement date
89	LKDAT	ANLA	LKDAT		☐	LKDAT	☐	Leasing agreement notice date
90	LEABG	ANLA	LEABG		☐	LEABG	☐	Lease start date
91	LEJAR	ANLA	LEJAR		☐	LEJAR	☐	Length of lease in years
92	LEPER	ANLA	LEPER		☐	LEPER	☐	Length of lease in periods
93	LRYTH	ANLA	LRYTH		☐	LRYTH	☐	Lease payment cycle
94	LEGEB	ANLA	LEGEB		☐	LEGEB	☐	Periodic lease payment paid to leasing company/lessor
95	LBASW	ANLA	LBASW		☐	LBASW	☐	Leasing base value as new
96	LKAUF	ANLA	LKAUF		☐	LKAUF	☐	Leased asset purchase price
97	LMZIN	ANLA	LMZIN		☐	LMZIN	☐	Leasing monthly interest rate (Capital Lease)
98	LZINS	ANLA	LZINS		☐	LZINS	☐	Leasing interest rate (capital lease)
99	LTZBW	ANLA	LTZBW		☐	LTZBW	☐	Posting date of the last lease payment
100	LKUZA	ANLA	LKUZA		☐	LKUZA	☐	Total of posted leasing payments
101	LKUZI	ANLA	LKUZI		☐	LKUZI	☐	Total leasing interest posted
102	LLAVB	ANLA	LLAVB		☐	LLAVB	☐	Total of long-term leasing liability
103	LEANZ	ANLA	LEANZ		☐	LEANZ	☐	Number of lease payments
104	LVTNR	ANLA	LVTNR		☐	LVTNR	☐	Leasing agreement number
105	LETXT	ANLA	LETXT		☐	LETXT	☐	Leasing data text
106	XAKTIV	ANLA	XAKTIV		☐	XAKTIV	☐	Indicator: Capitalize fixed asset
107	LBLNR	ANLA	LBLNR		☐	LBLNR	☐	No. of last document with which posting to asset was made
108	XV0DT	ANLA	XV0DT		☐	XV0DT	☐	Change date: View 0
109	XV0NM	ANLA	XV0NM		☐	XV0NM	☐	Name of person in charge, who changed View0
110	XV1DT	ANLA	XV1DT		☐	XV1DT	☐	Change date: View 1
111	XV1NM	ANLA	XV1NM		☐	XV1NM	☐	Name of person in charge, who changed view 1
112	XV2DT	ANLA	XV2DT		☐	XV2DT	☐	Change date: View 2
113	XV2NM	ANLA	XV2NM		☐	XV2NM	☐	Name of the person in charge, who changed view 2
114	XV3DT	ANLA	XV3DT		☐	XV3DT	☐	Change date: View 3
115	XV3NM	ANLA	XV3NM		☐	XV3NM	☐	Name of the person in charge, who changed view 3
116	XV4DT	ANLA	XV4DT		☐	XV4DT	☐	Change date: View 4
117	XV4NM	ANLA	XV4NM		☐	XV4NM	☐	Name of the person in charge, who changed view 4
118	XV5DT	ANLA	XV5DT		☐	XV5DT	☐	Change date:View 5
119	XV5NM	ANLA	XV5NM		☐	XV5NM	☐	Name of the person in charge who changed view 5
120	XV6DT	ANLA	XV6DT		☐	XV6DT	☐	Change date:View 6
121	XV6NM	ANLA	XV6NM		☐	XV6NM	☐	Name of the person in charge who changed view 6
122	AIMMO	ANLA	AIMMO		☐	AIMMO	☐	Indicator: real estate
123	OBJNR	ANLA	OBJNR		☐	J_OBJNR	☐	Object number
124	LEART	ANLA	LEART		☐	LEART	☐	Leasing type
125	LVORS	ANLA	LVORS		☐	LVORS	☐	Advance payments
126	GDLGRP	ANLA	GDLGRP		☐	GDLGRP	☐	Evaluation group 5
127	POSNR	ANLA	POSNR		☐	AM_POSNR	☐	WBS element investment project
128	XERWRT	ANLA	XERWRT		☐	XERWRT	☐	Indicator: Ignore memo value
129	XAFABCH	ANLA	XAFABCH		☐	XAFABCH	☐	Asset acquired used
130	XANLGR	ANLA	XANLGR		☐	XANLGR_1	☐	Indicator: Asset is a group asset
131	XINVM	ANLA	XINVM		☐	IM_XINVM	☐	Asset under Construction for Investment Measures
132	SERNR	ANLA	SERNR		☐	AM_SERNR	☐	Serial number
133	UMWKZ	ANLA	UMWKZ		☐	AM_UMWKZ	☐	Reason for environmental investment
134	LRVDAT	ANLA	LRVDAT		☐	AM_LRVDAT	☐	Date of last revaluation
135	ADATU	ANLZ	ADATU		☐	ADATU	☐	Date for beginning of validity
136	KOSTL	ANLZ	KOSTL		☐	KOSTL	☐	Cost Center
137	WERKS	ANLZ	WERKS		☐	WERKS_D	☐	Plant
138	GSBER	ANLZ	GSBER		☐	GSBER	☐	Business Area
139	LSTAR	ANLZ	LSTAR		☐	LSTAR	☐	Activity Type
140	MSFAK	ANLZ	MSFAK		☐	MSFAK	☐	Multiple-shift factor for multiple shift operation
141	XSTIL	ANLZ	XSTIL		☐	XSTIL	☐	Asset shutdown
142	STORT	ANLZ	STORT		☐	STORT	☐	Asset location
143	CAUFN	ANLZ	CAUFN		☐	CAUFN	☐	Internal order
144	RAUMN	ANLZ	RAUMN		☐	RAUMNR	☐	Room
145	IAUFN	ANLZ	IAUFN		☐	IAUFN	☐	Maintenance order
146	IPROJ	ANLZ	IPROJ		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
147	TXJCD	ANLZ	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
148	IPSNR	ANLZ	IPSNR		☐	AM_IPSNR	☐	WBS element - maintenance project
149	KFZKZ	ANLZ	KFZKZ		☐	AM_KFZKZ	☐	License plate no. of vehichle
150	PERNR	ANLZ	PERNR		☐	PERNR_D	☐	Personnel Number
151	KOSTLV	ANLZ	KOSTLV		☐	KOSTLV	☐	Cost center responsible for asset
152	TPLNR	ANLZ	TPLNR		☐	TPLNR	☐	Functional Location
153	GEBER	ANLZ	GEBER		☐	BP_GEBER	☐	Fund
154	FKBER	ANLZ	FKBER		☐	FKBER	☐	Functional Area
155	GRANT_NBR	ANLZ	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
156	FISTL	ANLZ	FISTL		☐	FISTL	☐	Funds Center
157	GEBER2	ANLZ	GEBER2		☐	BP_GEBER2	☐	Fund for APC Account Assignments
158	FKBER2	ANLZ	FKBER2		☐	FKBER2	☐	Functional Area for APC Account Assignments
159	GRANT_NBR2	ANLZ	GRANT_NBR2		☐	GM_GRANT_NBR2	☐	Grant for APC Account Assignments
160	FISTL2	ANLZ	FISTL2		☐	FISTL2	☐	Funds Center for APC Account Assignments
161	IMKEY	ANLZ	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
162	PS_PSP_PNR2	ANLZ	PS_PSP_PNR2		☐	PS_PSP_PNR2	☐	WBS Element (Costs)
163	FELEI_B	ANLB	FELEI		☐	FELEI	☐	Screen layout for Asset Accounting
164	XNEGA	ANLB	XNEGA		☐	XNEGA	☐	Indicator: Negative values allowed
165	XGWGK	ANLB	XGWGK		☐	XGWGK	☐	Low-value asset amount and quantity check
166	XUNTA	ANLB	XUNTA		☐	XUNTA	☐	Indicator: Depreciate main asset number totally
167	AFABG	ANLB	AFABG		☐	AFABG	☐	Depreciation calculation start date
168	ZINBG	ANLB	ZINBG		☐	DZINBG	☐	Start date for interest calculation
169	SAFBG	ANLB	SAFBG		☐	SAFBG	☐	Start date for special depreciation
170	INVSL	ANLB	INVSL		☐	INVSL	☐	Investment support key
171	AFASL	ANLB	AFASL		☐	AFASL	☐	Depreciation key
172	NDJAR	ANLB	NDJAR		☐	NDJAR	☐	Planned useful life in years
173	NDPER	ANLB	NDPER		☐	NDPER	☐	Planned useful life in periods
174	NAPRZ	ANLB	NAPRZ		☐	NAPRZ	☐	Ordinary depreciation percentage rate
175	SAPRZ	ANLB	SAPRZ		☐	SAPRZ	☐	Special depreciation percentage rate
176	WBIND	ANLB	WBIND		☐	WBIND	☐	Index series for replacement values
177	ALIND	ANLB	ALIND		☐	ALIND	☐	Index series for replacement values by age
178	APROP	ANLB	APROP		☐	APROP	☐	Variable depreciation portion
179	UMJAR	ANLB	UMJAR		☐	UMJAR	☐	Depreciation key for the changeover year
180	NDURJ	ANLB	NDURJ		☐	NDURJ	☐	Original useful life in years
181	NDURP	ANLB	NDURP		☐	NDURP	☐	Original useful life in periods
182	SCHRW	ANLB	SCHRW		☐	SCHRW	☐	Asset scrap value
183	LGJAN	ANLB	LGJAN		☐	LGJAN	☐	Last fiscal year for the annual values in Asset Acct.
184	AUFWTG	ANLB	AUFWTG		☐	AUFWTG	☐	Revaluation
185	XAFBE	ANLB	XAFBE		☐	XAFBE	☐	Indicator: Depreciation area is deactivated
186	ANLGR	ANLB	ANLGR		☐	ANLGR	☐	Group asset
187	ANLGR2	ANLB	ANLGR2		☐	ANLGR2	☐	Subnumber of group asset
188	VYEAR	ANLB	VYEAR		☐	VYEAR	☐	Acquisition year of the asset (manually changeable)
189	VMNTH	ANLB	VMNTH		☐	VMNTH	☐	Asset Accounting: Acquis. month (in depreciation area)
190	INBDA	ANLB	INBDA		☐	INBDA	☐	Asset Accounting: Date of operating readiness
191	ABGDAT_B	ANLB	ABGDAT_B		☐	ABGDAT_B	☐	Value date of last retirement for the depreciation area
192	PERAF	ANLP	PERAF		☐	PERAF	☐	Depreciation calculation period
193	AFBNR	ANLP	AFBNR		☐	AFBNR	☐	Sequence number of depreciation posting run in the period
194	AUFWP	ANLP	AUFWP		☐	AUFWP	☐	Planned revaluation on replacement value
195	AUFWB	ANLP	AUFWB		☐	AUFWB	☐	Revaluation posted on replacement value
196	AUFWZ	ANLP	AUFWZ		☐	AUFWZ	☐	Revaluation on replacement value to be posted
197	NAFAP	ANLP	NAFAP		☐	NAFAP	☐	Planned ordinary depreciation for the year
198	NAFAG	ANLP	NAFAG		☐	NAFAG	☐	Ordinary depreciation posted in the current year
199	NAFAZ	ANLP	NAFAZ		☐	NAFAZ	☐	Ordinary depreciation to be posted
200	SAFAP	ANLP	SAFAP		☐	SAFAP	☐	Planned special depreciation for the year
201	SAFAG	ANLP	SAFAG		☐	SAFAG	☐	Special depreciation posted in the current fiscal year
202	SAFAZ	ANLP	SAFAZ		☐	SAFAZ	☐	Special depreciation to be posted
203	AAFAP	ANLP	AAFAP		☐	AAFAP	☐	Scheduled unplanned depreciation for the year
204	AAFAG	ANLP	AAFAG		☐	AAFAG	☐	Unplanned depreciation posted for the year
205	AAFAZ	ANLP	AAFAZ		☐	AAFAZ	☐	Unplanned depreciation to be posted
206	MAFAP	ANLP	MAFAP		☐	MAFAP	☐	Planned transfer of reserves for the year
207	MAFAG	ANLP	MAFAG		☐	MAFAG	☐	Acquisition value reducing depreciation posted for the year
208	MAFAZ	ANLP	MAFAZ		☐	MAFAZ	☐	Transferred reserves to be posted for the year
209	ZINSP	ANLP	ZINSP		☐	DZINSP	☐	Interest planned for the year
210	ZINSG	ANLP	ZINSG		☐	DZINSG	☐	Interest posted for the year
211	ZINSZ	ANLP	ZINSZ		☐	DZINZB	☐	Interest for the year to be posted
212	AUFNP	ANLP	AUFNP		☐	AUFNP	☐	Planned revaluation of accumulated ordinary depreciation
213	AUFNG	ANLP	AUFNG		☐	AUFNG	☐	Posted revaluation of accumulated ordinary depreciation
214	AUFNZ	ANLP	AUFNZ		☐	AUFNZ	☐	Revaluation to be posted on cum. ordinary depreciation
215	ANSWL	ANLP	ANSWL		☐	ANSWL	☐	Transactions for the year affecting asset values
216	INVZM	ANLP	INVZM		☐	INVZM	☐	Investment grant for the year

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	606