SAP ABAP View V_ANLSUM_2 (View of ANLA, ANLZ, ANLB and ANEP)

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_ANLSUM_2
Short Description	View of ANLA, ANLZ, ANLB and ANEP
Root table	ANEP	Asset Line Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ANEP	ANEP
2	ANLA
3	ANLZ
4	ANLB
5	ANEK

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	ANEP	MANDT	JR	EQ			AND	0	0
3	ANLA	BUKRS	JL	EQ				0	0
4	ANEP	BUKRS	JR	EQ			AND	0	0
5	ANLA	ANLN1	JL	EQ				0	0
6	ANEP	ANLN1	JR	EQ			AND	0	0
7	ANLA	ANLN2	JL	EQ				0	0
8	ANEP	ANLN2	JR	EQ			AND	0	0
9	ANLA	MANDT	JL	EQ				0	0
10	ANLZ	MANDT	JR	EQ			AND	0	0
11	ANLA	BUKRS	JL	EQ				0	0
12	ANLZ	BUKRS	JR	EQ			AND	0	0
13	ANLA	ANLN1	JL	EQ				0	0
14	ANLZ	ANLN1	JR	EQ			AND	0	0
15	ANLA	ANLN2	JL	EQ				0	0
16	ANLZ	ANLN2	JR	EQ			AND	0	0
17	ANLB	MANDT	JL	EQ				0	0
18	ANEP	MANDT	JR	EQ			AND	0	0
19	ANLB	BUKRS	JL	EQ				0	0
20	ANEP	BUKRS	JR	EQ			AND	0	0
21	ANLB	ANLN1	JL	EQ				0	0
22	ANEP	ANLN1	JR	EQ			AND	0	0
23	ANLB	ANLN2	JL	EQ				0	0
24	ANEP	ANLN2	JR	EQ			AND	0	0
25	ANLB	AFABE	JL	EQ				0	0
26	ANEP	AFABE	JR	EQ			AND	0	0
27	ANEK	MANDT	JL	EQ				0	0
28	ANEP	MANDT	JR	EQ			AND	0	0
29	ANEK	BUKRS	JL	EQ				0	0
30	ANEP	BUKRS	JR	EQ			AND	0	0
31	ANEK	ANLN1	JL	EQ				0	0
32	ANEP	ANLN1	JR	EQ			AND	0	0
33	ANEK	ANLN2	JL	EQ				0	0
34	ANEP	ANLN2	JR	EQ			AND	0	0
35	ANEK	GJAHR	JL	EQ				0	0
36	ANEP	GJAHR	JR	EQ			AND	0	0
37	ANEK	LNRAN	JL	EQ				0	0
38	ANEP	LNRAN	JR	EQ				0	0

View Fields

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