SAP ABAP View V_ANLAVS ("Insurance Data for Asset")

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_ANLAVS
Short Description	"Insurance Data for Asset"
Root table	ANLV	Insurance data

Table

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

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	ANLV	MANDT	JR	EQ			AND	0	0
3	ANLA	BUKRS	JL	EQ				0	0
4	ANLV	BUKRS	JR	EQ			AND	0	0
5	ANLA	ANLN1	JL	EQ				0	0
6	ANLV	ANLN1	JR	EQ			AND	0	0
7	ANLA	ANLN2	JL	EQ				0	0
8	ANLV	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				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	ANLV	MANDT		☐	MANDT	☐	Client
2	BUKRS	ANLV	BUKRS		☐	BUKRS	☐	Company Code
3	ANLN1	ANLV	ANLN1		☐	ANLN1	☐	Main Asset Number
4	ANLN2	ANLV	ANLN2		☐	ANLN2	☐	Asset Subnumber
5	VRSLFD	ANLV	VRSLFD		☐	VRSLFD	☐	Sequence number for insurance data FI-AA
6	BDATU	ANLZ	BDATU		☐	BDATU	☐	Date validity ends
7	ANLKL	ANLA	ANLKL		☐	ANLKL	☐	Asset Class
8	GEGST	ANLA	GEGST		☐	GEGST	☐	Technical asset number
9	ANLAR	ANLA	ANLAR		☐	ANLAR	☐	Asset types
10	ERNAM	ANLA	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
11	ERDAT	ANLA	ERDAT		☐	ERDAT	☐	Date on which the record was created
12	AENAM	ANLA	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
13	AEDAT	ANLA	AEDAT		☐	AEDAT_ANLA	☐	Changed on
14	XLOEV	ANLA	XLOEV		☐	XLOEV	☐	Indicator: Account marked for deletion?
15	XSPEB	ANLA	XSPEB		☐	XSPEB_ANLA	☐	Indicator: Asset Locked to Acquisition Postings
16	FELEI	ANLA	FELEI		☐	FELEI	☐	Screen layout for Asset Accounting
17	KTOGR	ANLA	KTOGR		☐	KTOGR	☐	Account determination
18	XOPVW	ANLA	XOPVW		☐	OPVWA	☐	Asset under construct. with line item settlement
19	ANLTP	ANLA	ANLTP		☐	ANLTP	☐	Asset Category
20	ZUJHR	ANLA	ZUJHR		☐	DZUJAHR	☐	Fiscal year in which first acquisition was posted
21	ZUPER	ANLA	ZUPER		☐	DZUPER	☐	Period in which first acquisition was posted
22	ZUGDT	ANLA	ZUGDT		☐	DZUGDAT	☐	Asset value date of the first posting
23	AKTIV	ANLA	AKTIV		☐	AKTIVD	☐	Asset capitalization date
24	ABGDT	ANLA	ABGDT		☐	ABGDAT	☐	Asset value date for the last retirement
25	DEAKT	ANLA	DEAKT		☐	DEAKT	☐	Deactivation date
26	GPLAB	ANLA	GPLAB		☐	GPLAB	☐	Planned retirement date
27	BSTDT	ANLA	BSTDT		☐	BSTDT	☐	Asset purchase order date
28	ORD41	ANLA	ORD41		☐	ORD41	☐	Evaluation group 1
29	ORD42	ANLA	ORD42		☐	ORD42	☐	Evaluation group 2
30	ORD43	ANLA	ORD43		☐	ORD43	☐	Evaluation group 3
31	ORD44	ANLA	ORD44		☐	ORD44	☐	Evaluation group 4
32	ANLUE	ANLA	ANLUE		☐	ANLUE	☐	Asset super number
33	ZUAWA	ANLA	ZUAWA		☐	DZUAWA	☐	Key for sorting according to assignment numbers
34	ANEQK	ANLA	ANEQK		☐	ANEQK	☐	Indicator: Historical management
35	ANEQS	ANLA	ANEQS		☐	ANEQS	☐	Completeness indicator for the asset
36	LIFNR	ANLA	LIFNR		☐	AM_LIFNR	☐	Account number of vendor (other key word)
37	LAND1	ANLA	LAND1		☐	AM_LAND1	☐	Asset's country of origin
38	LIEFE	ANLA	LIEFE		☐	LIEFE	☐	Name of asset supplier
39	HERST	ANLA	HERST		☐	HERST	☐	Manufacturer of asset
40	EIGKZ	ANLA	EIGKZ		☐	EIGKZ	☐	Property indicator
41	AIBN1	ANLA	AIBN1		☐	AIBN1	☐	Original asset that was transferred
42	AIBN2	ANLA	AIBN2		☐	AIBN2	☐	Original asset that was transferred
43	AIBDT	ANLA	AIBDT		☐	AIBDT	☐	Original acquisition date of AuC/ transferred asset
44	URJHR	ANLA	URJHR		☐	URJHR	☐	Fiscal year of original acquisition
45	URWRT	ANLA	URWRT		☐	URWRT	☐	Original acquisition value
46	ANTEI	ANLA	ANTEI		☐	ANTEI	☐	In-house production percentage
47	PROJN	ANLA	PROJN		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
48	EAUFN	ANLA	EAUFN		☐	AM_AUFNR	☐	Investment Order
49	MEINS	ANLA	MEINS		☐	MEINS	☐	Base Unit of Measure
50	MENGE	ANLA	MENGE		☐	AM_MENGE	☐	Quantity
51	TYPBZ	ANLA	TYPBZ		☐	TYPBZ_ANLA	☐	Asset type name
52	IZWEK	ANLA	IZWEK		☐	IZWEK	☐	Reason for investment
53	INKEN	ANLA	INKEN		☐	INKEN	☐	Inventory indicator
54	IVDAT	ANLA	IVDAT		☐	IVDAT_ANLA	☐	Last inventory date
55	INVZU	ANLA	INVZU		☐	INVZU_ANLA	☐	Supplementary inventory specifications
56	VMGLI	ANLA	VMGLI		☐	VMGLI	☐	Property classification key
57	XVRMW	ANLA	XVRMW		☐	XVRMW	☐	Manual net worth tax value
58	WRTMA	ANLA	WRTMA		☐	WRTMA	☐	Manual net worth tax value
59	EHWRT	ANLA	EHWRT		☐	EHWRT	☐	Assessed value
60	AUFLA	ANLA	AUFLA		☐	AUFLA_ANLA	☐	Date of conveyance
61	EHWZU	ANLA	EHWZU		☐	EHWZU_ANLA	☐	Date of last notice of assessment
62	EHWNR	ANLA	EHWNR		☐	EHWNR_ANLA	☐	Tax number of the notice of assessment
63	GRUVO	ANLA	GRUVO		☐	GRUVO_ANLA	☐	Land Register of
64	GREIN	ANLA	GREIN		☐	GREIN_ANLA	☐	Land register entry on
65	GRBND	ANLA	GRBND		☐	GRBND_ANLA	☐	Land register volume
66	GRBLT	ANLA	GRBLT		☐	GRBLT_ANLA	☐	Land register page
67	GRLFD	ANLA	GRLFD		☐	GRLFD_ANLA	☐	Land register entry: Sequence number
68	FLURK	ANLA	FLURK		☐	FLURK_ANLA	☐	Land register map number
69	FLURN	ANLA	FLURN		☐	FLURN_ANLA	☐	Plot number
70	FIAMT	ANLA	FIAMT		☐	FIAMT	☐	Local tax office
71	STADT	ANLA	STADT		☐	ORT01_ANLA	☐	Municipality
72	GRUND	ANLA	GRUND		☐	GRUND	☐	Reason for manual valuation of net assets
73	FEINS	ANLA	FEINS		☐	FEINS	☐	Area unit
74	GRUFL	ANLA	GRUFL		☐	GRUFL	☐	Surface area
75	INVNR	ANLA	INVNR		☐	INVNR_ANLA	☐	Inventory number
76	VBUND	ANLA	VBUND		☐	RASSC	☐	Company ID of trading partner
77	SPRAS	ANLA	SPRAS		☐	SPRAS	☐	Language Key
78	TXT50	ANLA	TXT50		☐	TXA50_ANLT	☐	Asset description
79	TXA50	ANLA	TXA50		☐	TXA50_MORE	☐	Additional asset description
80	XLTXID	ANLA	XLTXID		☐	XLTXID	☐	Indicator: Long text active
81	XVERID	ANLA	XVERID		☐	XVERID	☐	Long text indicator:Property values
82	XTCHID	ANLA	XTCHID		☐	XTCHID	☐	Indicator: Technical view long text
83	XKALID	ANLA	XKALID		☐	XKALID	☐	Indicator: Long text active
84	XHERID	ANLA	XHERID		☐	XHERID	☐	Indicator: Long text for manufacturer/origin
85	XLEAID	ANLA	XLEAID		☐	XLEAID	☐	Indicator: Leasing data long text
86	LEAFI	ANLA	LEAFI		☐	LEAFI	☐	Leasing company
87	LVDAT	ANLA	LVDAT		☐	LVDAT	☐	Leasing agreement date
88	LKDAT	ANLA	LKDAT		☐	LKDAT	☐	Leasing agreement notice date
89	LEABG	ANLA	LEABG		☐	LEABG	☐	Lease start date
90	LEJAR	ANLA	LEJAR		☐	LEJAR	☐	Length of lease in years
91	LEPER	ANLA	LEPER		☐	LEPER	☐	Length of lease in periods
92	LRYTH	ANLA	LRYTH		☐	LRYTH	☐	Lease payment cycle
93	LEGEB	ANLA	LEGEB		☐	LEGEB	☐	Periodic lease payment paid to leasing company/lessor
94	LBASW	ANLA	LBASW		☐	LBASW	☐	Leasing base value as new
95	LKAUF	ANLA	LKAUF		☐	LKAUF	☐	Leased asset purchase price
96	LMZIN	ANLA	LMZIN		☐	LMZIN	☐	Leasing monthly interest rate (Capital Lease)
97	LZINS	ANLA	LZINS		☐	LZINS	☐	Leasing interest rate (capital lease)
98	LTZBW	ANLA	LTZBW		☐	LTZBW	☐	Posting date of the last lease payment
99	LKUZA	ANLA	LKUZA		☐	LKUZA	☐	Total of posted leasing payments
100	LKUZI	ANLA	LKUZI		☐	LKUZI	☐	Total leasing interest posted
101	LLAVB	ANLA	LLAVB		☐	LLAVB	☐	Total of long-term leasing liability
102	LEANZ	ANLA	LEANZ		☐	LEANZ	☐	Number of lease payments
103	LVTNR	ANLA	LVTNR		☐	LVTNR	☐	Leasing agreement number
104	LETXT	ANLA	LETXT		☐	LETXT	☐	Leasing data text
105	ANUPD	ANLA	ANUPD		☐	ANUPD	☐	Indicator: Type of change to table
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	HAS_TDDP	ANLA	HAS_TDDP		☐	HAS_TDDP	☐	Asset Has Time-Dependent Valuation Parameters in ANLBZA
136	LAST_REORG_DATE	ANLA	LAST_REORG_DATE		☐	FAA_LAST_REORG	☐	Date of Last Reorganization
137	ADATU	ANLZ	ADATU		☐	ADATU	☐	Date for beginning of validity
138	KOSTL	ANLZ	KOSTL		☐	KOSTL	☐	Cost Center
139	WERKS	ANLZ	WERKS		☐	WERKS_D	☐	Plant
140	GSBER	ANLZ	GSBER		☐	GSBER	☐	Business Area
141	LSTAR	ANLZ	LSTAR		☐	LSTAR	☐	Activity Type
142	MSFAK	ANLZ	MSFAK		☐	MSFAK	☐	Multiple-shift factor for multiple shift operation
143	XSTIL	ANLZ	XSTIL		☐	XSTIL	☐	Asset shutdown
144	STORT	ANLZ	STORT		☐	STORT	☐	Asset location
145	CAUFN	ANLZ	CAUFN		☐	CAUFN	☐	Internal order
146	PLAN1	ANLZ	PLAN1		☐	PLAN1	☐	no longer used
147	PLAN2	ANLZ	PLAN2		☐	PLAN2	☐	No longer used
148	RAUMN	ANLZ	RAUMN		☐	RAUMNR	☐	Room
149	IAUFN	ANLZ	IAUFN		☐	IAUFN	☐	Maintenance order
150	IPROJ	ANLZ	IPROJ		☐	PROJN	☐	Old: Project number : No longer used --> PS_POSNR
151	TPLKZ	ANLZ	TPLKZ		☐	FILL03	☐	Unused field length 3
152	TPLNR	ANLZ	TPLNR		☐	TPLNR	☐	Functional Location
153	TXJCD	ANLZ	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
154	IPSNR	ANLZ	IPSNR		☐	AM_IPSNR	☐	WBS element - maintenance project
155	KFZKZ	ANLZ	KFZKZ		☐	AM_KFZKZ	☐	License plate no. of vehichle
156	PERNR	ANLZ	PERNR		☐	PERNR_D	☐	Personnel Number
157	KOSTLV	ANLZ	KOSTLV		☐	KOSTLV	☐	Cost center responsible for asset
158	GEBER	ANLZ	GEBER		☐	BP_GEBER	☐	Fund
159	FKBER	ANLZ	FKBER		☐	FKBER	☐	Functional Area
160	GRANT_NBR	ANLZ	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
161	FISTL	ANLZ	FISTL		☐	FISTL	☐	Funds Center
162	GEBER2	ANLZ	GEBER2		☐	BP_GEBER2	☐	Fund for APC Account Assignments
163	FKBER2	ANLZ	FKBER2		☐	FKBER2	☐	Functional Area for APC Account Assignments
164	GRANT_NBR2	ANLZ	GRANT_NBR2		☐	GM_GRANT_NBR2	☐	Grant for APC Account Assignments
165	FISTL2	ANLZ	FISTL2		☐	FISTL2	☐	Funds Center for APC Account Assignments
166	IMKEY	ANLZ	IMKEY		☐	IMKEY	☐	Internal Key for Real Estate Object
167	PS_PSP_PNR2	ANLZ	PS_PSP_PNR2		☐	PS_PSP_PNR2	☐	WBS Element (Costs)
168	VSART	ANLV	VSART		☐	VSART_ANLA	☐	Asset insurance type
169	VSIND	ANLV	VSIND		☐	VSIND	☐	Insurance index series
170	VRSBA	ANLV	VRSBA		☐	VRSBA	☐	Base insurable value
171	VSBAJ	ANLV	VSBAJ		☐	VSBAJ	☐	Base insurable value: Fiscal year update
172	VSGES	ANLV	VSGES		☐	AVGES	☐	Insurance companies
173	VSMAN	ANLV	VSMAN		☐	VSMAN	☐	Update insurable value manually
174	VRSMA	ANLV	VRSMA		☐	VRSMA	☐	Manual insurable value
175	VRSJH	ANLV	VRSJH		☐	VRSJH	☐	Maintenance year for manual insurable value
176	VRSJA	ANLV	VRSJA		☐	VRSJA	☐	Old maintenance year for manual insurable value
177	VRSBG	ANLV	VRSBG		☐	VRSBG	☐	Insurance start date
178	VSTAR	ANLV	VSTAR		☐	AVTAR	☐	Insurance rate FI-AA
179	VSSTX	ANLV	VSSTX		☐	VSSTX	☐	Insurance policy number
180	XVRSID	ANLV	XVRSID		☐	XVRSID	☐	Indicator: Insurance long text
181	VSZTX	ANLV	VSZTX		☐	VSZTX	☐	Supplementary insurance text
182	LNRAN	ANLV	LNRAN		☐	LNRAN	☐	Sequence Number of Asset Line Items in Fiscal Year
183	BUDGET_PD	ANLZ	BUDGET_PD		☐	FM_BUDGET_PERIOD	☐	FM: Budget Period
184	BUDGET_PD2	ANLZ	BUDGET_PD2		☐	FM_BUDGET_PERIOD2	☐	Budget Period for APC Account Assignments
185	SEGMENT	ANLZ	SEGMENT		☐	FB_SEGMENT	☐	Segment for Segmental Reporting
186	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