SAP ABAP Table VISSR_DATA_GEN (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VISSR_DATA_GEN	Table Relationship Diagram
Short Description	Generated Table for View

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	SUDEC	☐	SUDEC	SUDEC	NUMC	2	0	Insurance Line of Business Indicator	TW05
6	SSKZB	☐	SSKZB	SSKZB	NUMC	1	0	BAV stock indicator	TZ11
7	RINUM	☐	RINUM	RINUM	CHAR	22	0	BAV identification number
8	SSKZF	☐	SSKZF	SSKZF	NUMC	1	0	Tax office stock indicator	TZ13
9	SAART	☐	VVSAART	VVSAART	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	TZ28
10	SDV	☐	VVSDV	VVSDVNR	CHAR	2	0	Premium reserve fund list number	TZ30
11	SUABT	☐	VVSUABT	VVSUABT	CHAR	2	0	Subsection number of premium reserve fund list	TZ31
12	SNW600	☐	VVSNW600	VVSNW600	CHAR	4	0	Asset group BAV stmt 101, 201 and 600	TZ29P
13	SMW102	☐	VVSMW102	VVSMW102	CHAR	5	0	BAV asset group stmt 102	TZ32
14	X_R97_03	☐	VVX_R97_03	VVX_R97_03	CHAR	2	0	Indicator for circular R5/97 appendix 3 and 4	TZ36
15	X_R97_05	☐	VVX_R97_05	VVX_R97_05	CHAR	2	0	Indicator for R5/97 appendix 5	TZ37
16	X_R97_06	☐	VVX_R97_06	VVX_R97_06	CHAR	1	0	Indicator for R5/97 appendix 6 - Collateral
17	X_R97_08	☐	VVX_R97_08	VVX_R97_08	CHAR	1	0	Indicator for R5/97 appendix 8	TZ38
18	X_R97_101	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
19	X_R97_102	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
20	X_R97_103	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
21	X_R97_104	☐	VVX_R97_10	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TZ39B
22	JDECK	☐	JDECK	JANEI	CHAR	1	0	Regulatory reporting BPV (hedge fund Y/N)
23	JBAVG	☐	JBAVG	KENZX	CHAR	1	0	BAV approval
24	BARWBAV	☐	BARWBAV	WERTV7	CURR	13	2	BAV accepted value
25	SAWHR	☐	SAWHR	WAERS	CUKY	5	0	Currency of accepted value_FISO	TCURC
26	BVWERT	☐	BVWERT	WERTV7	CURR	13	2	Current market value_BAV
27	SVWHR	☐	SVWHR	WAERS	CUKY	5	0	Market value currency_FISO	TCURC
28	BARW_VU	☐	BARW_VU	WERTV7	CURR	13	2	Accepted value_VU
29	SAWHR_VU	☐	SAWHR_VU	WAERS	CUKY	5	0	Currency of accepted value_VV	TCURC
30	XAKTZBAV	☐	XAKTZBAV	TEXT32	CHAR	32	0	BAV file number
31	DBAVGEN	☐	DBAVGEN	DATUM	DATS	8	0	Date of BAV authorization
32	DARWGEN	☐	DARWGEN	DATUM	DATS	8	0	Date for fixing the accepted value
33	XAKTZARW	☐	XAKTZARW	TEXT20	CHAR	20	0	BAV file character_accepted value
34	XAUFORT	☐	XAUFORT	TEXT22	CHAR	22	0	Storage location
35	DERWMEL	☐	DERWMEL	DATUM	DATS	8	0	Date when the acquistion was reported to FISO
36	XTREU1	☐	VVXTREU1	VVXTREU1	CHAR	1	0	Trustee inflow/outflow list indicator
37	SMWWHR	☐	VVSMWWHR	WAERS	CUKY	5	0	Settlement or cover provision currency (Regulat. reporting)	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VISSR_DATA_GEN	MANDT	T000	MANDT	KEY	1	CN
2	VISSR_DATA_GEN	SAART	TZ28	SAART
3	VISSR_DATA_GEN	SAWHR	TCURC	WAERS	KEY	1	CN
4	VISSR_DATA_GEN	SAWHR_VU	TCURC	WAERS	KEY	1	CN
5	VISSR_DATA_GEN	SDV	TZ30	SDV	KEY	1	CN
6	VISSR_DATA_GEN	SMW102	TZ32	SMW102	KEY	1	CN
7	VISSR_DATA_GEN	SMWWHR	TCURC	WAERS	KEY	1	CN
8	VISSR_DATA_GEN	SNW600	TZ29P	SNW600	KEY	1	CN
9	VISSR_DATA_GEN	SSKZB	TZ11	SSKZB	KEY	1	CN
10	VISSR_DATA_GEN	SSKZF	TZ13	SSKZF	KEY	1	CN
11	VISSR_DATA_GEN	SUABT	TZ31	SUABT	KEY	1	CN
12	VISSR_DATA_GEN	SUDEC	TW05	SUDEC	KEY	1	CN
13	VISSR_DATA_GEN	SVWHR	TCURC	WAERS	KEY	1	CN
14	VISSR_DATA_GEN	VVKEY	VZBAVF	VVKEY	KEY	1	CN
15	VISSR_DATA_GEN	X_R97_03	TZ36	X_R97_03	KEY	1	CN
16	VISSR_DATA_GEN	X_R97_05	TZ37	X_R97_05	KEY	1	CN
17	VISSR_DATA_GEN	X_R97_08	TZ38	X_R97_08	KEY	1	CN
18	VISSR_DATA_GEN	X_R97_101	TZ39B	X_R97_10	KEY	1	CN
19	VISSR_DATA_GEN	X_R97_102	TZ39B	X_R97_10	KEY	1	CN
20	VISSR_DATA_GEN	X_R97_103	TZ39B	X_R97_10	KEY	1	CN
21	VISSR_DATA_GEN	X_R97_104	TZ39B	X_R97_10	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in