SAP ABAP Table VZBAVV1 (Database View of BAV Master Data with Additional Fields)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR-DE (Application Component) Germany
     ⤷ VVSRG (Package) Statutory Reporting Germany

Basic Data

Table Category	INTTAB	Structure
Structure	VZBAVV1	Table Relationship Diagram
Short Description	Database View of BAV Master Data with Additional Fields

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	RANTYP	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
3	VVKEY	☐	VVKEY	VVKEYBAV	CHAR	34	0	DARWIN universal key (no client)	VZBAVF
4	DGUEL_AB	☐	DGUEL_AB	DATUM	DATS	8	0	Entry effective from
5	JBAVG	☐	JBAVG	KENZX	CHAR	1	0	BAV approval
6	XAKTZBAV	☐	XAKTZBAV	TEXT32	CHAR	32	0	BAV file number
7	DBAVGEN	☐	DBAVGEN	DATUM	DATS	8	0	Date of BAV authorization
8	SGBAV	☐	SGBAV	SGBAV	NUMC	3	0	BAV asset group (C11/74) indicator	*
9	SBAV501	☐	SBAV501	SBAV501	CHAR	4	0	*** Internal usage ***	*
10	SBILK	☐	SBILK	SBILK	CHAR	2	0	Balance Sheet Indicator	*
11	JARW	☐	JARW	JANEI	CHAR	1	0	*** Not used ***
12	DARWGEN	☐	DARWGEN	DATUM	DATS	8	0	Date for fixing the accepted value
13	XAKTZARW	☐	XAKTZARW	TEXT20	CHAR	20	0	BAV file character_accepted value
14	XAUFORT	☐	XAUFORT	TEXT22	CHAR	22	0	Storage location
15	DERWMEL	☐	DERWMEL	DATUM	DATS	8	0	Date when the acquistion was reported to FISO
16	BVWERT	☐	BVWERT	WERTV7	CURR	13	2	Current market value_BAV
17	SVWHR	☐	SVWHR	WAERS	CUKY	5	0	Market value currency_FISO	TCURC
18	SNW101	☐	VVSNW101	VVSNW101	NUMC	2	0	*** Internal usage ***	*
19	SNW102	☐	VVSNW102	VVSNW102	CHAR	7	0	*** Internal usage ***	*
20	SNW201	☐	VVSNW201	VVSNW201	CHAR	7	0	*** Internal usage ***	*
21	SMW102	☐	VVSMW102	VVSMW102	CHAR	5	0	BAV asset group stmt 102	*
22	SNW600	☐	VVSNW600	VVSNW600	CHAR	4	0	Asset group BAV stmt 101, 201 and 600	TZ29P
23	SJBUE	☐	VVSJBUE	VVSJBUE	CHAR	6	0	Asset group R11/76, Asset 6 (yearly stock overview)	*
24	SNEU_ANL	☐	VVSNEU_ANL	VVSNEU_ANL	CHAR	9	0	Asset group R11/76, appendix 3 and 4	*
25	XR5_91_1	☐	VVXR5_91_1	VVXR5_91_1	CHAR	2	0	Indicator R5/91, appendix 1
26	XR5_91_2	☐	VVXR5_91_2	KENZX	CHAR	1	0	Indicator R5/91, appendix 1
27	XR5_91_3	☐	VVXR5_91_3	KENZX	CHAR	1	0	Indicator R5/91, appendix 3
28	SUDEC	☐	SUDEC	SUDEC	NUMC	2	0	Insurance Line of Business Indicator	TW05
29	SSKZB	☐	SSKZB	SSKZB	NUMC	1	0	BAV stock indicator	TZ11
30	SDVNR	☐	SDVNR	SDVNR	CHAR	4	0	Key for BAV List in TZBAV	TW09B
31	SUABNDV	☐	SUABNDV	SUABNDV	NUMC	2	0	*** Internal usage ***	TW10B
32	SOEFFKL	☐	SOEFFKL	JANEI	CHAR	1	0	Indicator BAV opening clause
33	RINUM	☐	RINUM	RINUM	CHAR	22	0	BAV identification number
34	SSKZF	☐	SSKZF	SSKZF	NUMC	1	0	Tax office stock indicator	TZ13
35	RINUMH	☐	RINUMH	CHAR30	CHAR	30	0	BAV hist. identifications number
36	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
37	DAEND	☐	DAEND	DATUM	DATS	8	0	Changed on
38	TAEND	☐	TAEND	UZEIT	TIMS	6	0	Time changed
39	SAART	☐	VVSAART	VVSAART	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	*
40	DGUEL_BIS	☐	DGUEL_BIS	DATUM	DATS	8	0	Conditions valid to
41	SOEFFKL2	☐	SOEFFKL	JANEI	CHAR	1	0	Indicator BAV opening clause
42	ZUGANG	☐	KZZUG	KZZUG	CHAR	1	0	Receipt indicator
43	ABGANG	☐	KZABG	XFELD	CHAR	1	0	Indicator: movement type is a goods issue
44	SUMBSUAB	☐	SUMBSUAB	SUABNDV	NUMC	2	0	Transfer to sub-section	*
45	SUMBSSKZF	☐	SUMBSSKZF	SSKZF	NUMC	1	0	Transfer acc. to tax authority stock indicator	*
46	SUMBSSKZB	☐	SUMBSSKZB	SSKZB	NUMC	1	0	Transfer acc. to BAV stock indicator	*
47	XDECK	☐	VVXDECK	KENZX	CHAR	1	0	Indicator for eligibility for premium reserve fund
48	XARW	☐	VVXARW	KENZX	CHAR	1	0	BAV approval of accepted value
49	SDV	☐	VVSDV	VVSDVNR	CHAR	2	0	Premium reserve fund list number	TZ30
50	SUABT	☐	VVSUABT	VVSUABT	CHAR	2	0	Subsection number of premium reserve fund list	TZ31
51	X_R97_03	☐	VVX_R97_03	VVX_R97_03	CHAR	2	0	Indicator for circular R5/97 appendix 3 and 4	TZ36
52	X_R97_05	☐	VVX_R97_05	VVX_R97_05	CHAR	2	0	Indicator for R5/97 appendix 5	TZ37
53	X_R97_06	☐	VVX_R97_06	VVX_R97_06	CHAR	1	0	Indicator for R5/97 appendix 6 - Collateral
54	X_R97_08	☐	VVX_R97_08	VVX_R97_08	CHAR	1	0	Indicator for R5/97 appendix 8	TZ38
55	X_R97_101	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
56	X_R97_102	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
57	X_R97_103	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
58	X_R97_104	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZBAVV1	MANDT	T000	MANDT
2	VZBAVV1	SDV	TZ30	SDV	KEY	1	CN
3	VZBAVV1	SDVNR	TW09B	SDVNR
4	VZBAVV1	SNW600	TZ29P	SNW600	KEY	1	CN
5	VZBAVV1	SSKZB	TZ11	SSKZB
6	VZBAVV1	SSKZF	TZ13	SSKZF
7	VZBAVV1	SUABNDV	TW10B	SUABNDV
8	VZBAVV1	SUABT	TZ31	SUABT	KEY	1	CN
9	VZBAVV1	SUDEC	TW05	SUDEC
10	VZBAVV1	SVWHR	TCURC	WAERS
11	VZBAVV1	VVKEY	VZBAVF	VVKEY
12	VZBAVV1	X_R97_03	TZ36	X_R97_03		1	CN
13	VZBAVV1	X_R97_05	TZ37	X_R97_05		1	CN
14	VZBAVV1	X_R97_08	TZ38	X_R97_08		1	CN
15	VZBAVV1	X_R97_101	TZ39B	X_R97_10	KEY	1	CN
16	VZBAVV1	X_R97_102	TZ39B	X_R97_10	KEY	1	CN
17	VZBAVV1	X_R97_103	TZ39B	X_R97_10	KEY	1	CN
18	VZBAVV1	X_R97_104	TZ39B	X_R97_10	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in