SAP ABAP View V_VZBAVV (View of VZBAVF and VZBAVV - BAV Master Data)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CML (Application Component) Loans Management
     FTLC (Package) Customizing Treasury: Loan management
Basic Data
View Type D Database View 
Database View V_VZBAVV  
Short Description View of VZBAVF and VZBAVV - BAV Master Data    
Root table VZBAVF   BAV Master Data Without History Management 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VZBAVF VZBAVF
2 VZBAVV  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VZBAVF MANDT JL EQ 0 0
2 VZBAVV MANDT JR EQ AND 0 0
3 VZBAVF RANTYP JL EQ 0 0
4 VZBAVV RANTYP JR EQ AND 0 0
5 VZBAVF VVKEY JL EQ 0 0
6 VZBAVV VVKEY JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VZBAVF MANDT   MANDT Client
2 RANTYP VZBAVF RANTYP   RANTYP Contract Type
3 VVKEY VZBAVF VVKEY   VVKEY DARWIN universal key (no client)
4 DGUEL_AB VZBAVV DGUEL_AB   DGUEL_AB Entry effective from
5 JBAVG VZBAVF JBAVG   JBAVG BAV approval
6 XAKTZBAV VZBAVF XAKTZBAV   XAKTZBAV BAV file number
7 DBAVGEN VZBAVF DBAVGEN   DBAVGEN Date of BAV authorization
8 SGBAV VZBAVF SGBAV   SGBAV BAV asset group (C11/74) indicator
9 SBAV501 VZBAVF SBAV501   SBAV501 *** Internal usage ***
10 SBILK VZBAVF SBILK   SBILK Balance Sheet Indicator
11 JARW VZBAVF JARW   JARW *** Not used ***
12 DARWGEN VZBAVF DARWGEN   DARWGEN Date for fixing the accepted value
13 XAKTZARW VZBAVF XAKTZARW   XAKTZARW BAV file character_accepted value
14 XAUFORT VZBAVF XAUFORT   XAUFORT Storage location
15 DERWMEL VZBAVF DERWMEL   DERWMEL Date when the acquistion was reported to FISO
16 BVWERT VZBAVV BVWERT   BVWERT Current market value_BAV
17 SVWHR VZBAVV SVWHR   SVWHR Market value currency_FISO
18 SNW101 VZBAVF SNW101   VVSNW101 *** Internal usage ***
19 SNW102 VZBAVF SNW102   VVSNW102 *** Internal usage ***
20 SNW201 VZBAVF SNW201   VVSNW201 *** Internal usage ***
21 SMW102 VZBAVF SMW102   VVSMW102 BAV asset group stmt 102
22 SNW600 VZBAVV SNW600   VVSNW600 Asset group BAV stmt 101, 201 and 600
23 SJBUE VZBAVF SJBUE   VVSJBUE Asset group R11/76, Asset 6 (yearly stock overview)
24 SNEU_ANL VZBAVF SNEU_ANL   VVSNEU_ANL Asset group R11/76, appendix 3 and 4
25 XR5_91_1 VZBAVF XR5_91_1   VVXR5_91_1 Indicator R5/91, appendix 1
26 XR5_91_2 VZBAVF XR5_91_2   VVXR5_91_2 Indicator R5/91, appendix 1
27 XR5_91_3 VZBAVF XR5_91_3   VVXR5_91_3 Indicator R5/91, appendix 3
28 SUDEC VZBAVV SUDEC   SUDEC Insurance Line of Business Indicator
29 SSKZB VZBAVV SSKZB   SSKZB BAV stock indicator
30 SDVNR VZBAVV SDVNR   SDVNR Key for BAV List in TZBAV
31 SDV VZBAVV SDV   VVSDV Premium reserve fund list number
32 SUABNDV VZBAVV SUABNDV   SUABNDV *** Internal usage ***
33 SUABT VZBAVV SUABT   VVSUABT Subsection number of premium reserve fund list
34 SOEFFKL VZBAVV SOEFFKL   SOEFFKL Indicator BAV opening clause
35 RINUM VZBAVV RINUM   RINUM BAV identification number
36 SSKZF VZBAVV SSKZF   SSKZF Tax office stock indicator
37 RINUMH VZBAVV RINUMH   RINUMH BAV hist. identifications number
38 RERF VZBAVV RERF   RERF Entered by
39 DAEND VZBAVV DAEND   DAEND Changed on
40 TAEND VZBAVV TAEND   TAEND Time changed
41 SAART VZBAVV SAART   VVSAART Asset Type According to Regulatory Accounting Requirements
42 XDECK VZBAVF XDECK   VVXDECK Indicator for eligibility for premium reserve fund
43 XARW VZBAVF XARW   VVXARW BAV approval of accepted value
44 XTREU1 VZBAVF XTREU1   VVXTREU1 Trustee inflow/outflow list indicator
45 X_R97_03 VZBAVF X_R97_03   VVX_R97_03 Indicator for circular R5/97 appendix 3 and 4
46 X_R97_05 VZBAVF X_R97_05   VVX_R97_05 Indicator for R5/97 appendix 5
47 X_R97_06 VZBAVF X_R97_06   VVX_R97_06 Indicator for R5/97 appendix 6 - Collateral
48 X_R97_08 VZBAVF X_R97_08   VVX_R97_08 Indicator for R5/97 appendix 8
49 X_R97_101 VZBAVF X_R97_101   VVX_R97_10 Indicator for R5/97 appendix 10
50 X_R97_102 VZBAVF X_R97_102   VVX_R97_10 Indicator for R5/97 appendix 10
51 X_R97_103 VZBAVF X_R97_103   VVX_R97_10 Indicator for R5/97 appendix 10
52 X_R97_104 VZBAVF X_R97_104   VVX_R97_10 Indicator for R5/97 appendix 10
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class S   System table, maint. only by SAP, change = modification 
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20110901 
SAP Release Created in