SAP ABAP Table ROXE390112 (ISSR: Feste und variable Daten Meldewesen)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR-DE (Application Component) Germany
     ⤷ VVSRFISL_BI (Package) BaFin BI-Extraktoren für das Versicherungsmeldewesen

Basic Data

Table Category	INTTAB	Structure
Structure	ROXE390112	Table Relationship Diagram
Short Description	ISSR: Feste und variable Daten Meldewesen

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	ISSR_MFT_GUID	☑	ISSR_FLOW_NR	ISSR_CHAR_GUID	CHAR	32	0
3	MW_GUID	☑	ISSR_FLOW_NR	ISSR_CHAR_GUID	CHAR	32	0
4	COUNTRY_VAR	☑	ISSR_REP_COUNTRY	ISSR_REP_COUNTRY	CHAR	4	0		TISSR_MARECO
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	PRODUCT_CATEGORY	☐	ISSR_PRODUCT_CATEGORY	ISSR_PRODUCT_CATEGORY	CHAR	3	0		TISSR_IFPCAT
7	PRODUCT_TYPE	☐	ISSR_PRODUCT_TYPE	ISSR_PRODUCT_TYPE	CHAR	8	0		TISSR_IFB_RTPT
8	ASSET_NR	☐	ISSR_ASSET_NR	ISSR_ASSET_NR	CHAR	13	0	Capital Investment Number for Regulatory Reporting
9	SEC_ACCOUNT	☐	ISSR_SECURITY_ACCOUNT	ISSR_SECURITY_ACCOUNT	CHAR	10	0	Securities Account
10	ACCOUNT_GRP	☐	ISSR_ACCOUNT_GRP	ISSR_ACCOUNT_GRP	CHAR	10	0
11	BUDAT	☐	ISSR_BUDAT	DATUM	DATS	8	0	Gueltig Ab-Datum Meldewesen -Stamm
12	NUMB_TP_DAY	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
13	SPARTE	☐	ISSR_VERS_SPARTE	ISSR_VERS_SPARTE	CHAR	2	0	Insurance Line of Business Indicator	TISSR_SPARTE
14	STOCKBAV	☐	ISSR_STOCKBAV	ISSR_STOCKBAV	CHAR	1	0	BAV Stock Indicator	TISSR_STOCKBAV
15	STOCKFA	☐	ISSR_STOCKFA	ISSR_STOCKFA	CHAR	1	0	Tax office stock indicator	TISSR_STOCKFA
16	DV	☐	ISSR_DV	ISSR_DV	CHAR	5	0	Premium reserve fund list number	TISSR_DV_PT
17	DVUA	☐	ISSR_UA	ISSR_UA	CHAR	2	0	Subsection number of premium reserve fund list	TISSR_DVUAB
18	ABS54AVAG	☐	ISSR_ABS54AVAG	ISSR_ABS54AVAG	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	TISSR_ANLARTB
19	NW101	☐	ISSR_NW101	ISSR_NW101	CHAR	4	0	BAV asset group stmt 101	V_TISSR_NW101_PR
20	NW102	☐	ISSR_NW102	ISSR_NW102	CHAR	5	0	BAV Asset Group Statement 102 (Germany Only)	V_TISSR_NW102_PR
21	NW201	☐	ISSR_NW201	ISSR_NW201	CHAR	5	0	BAV asset group stmt 201	V_TISSR_NW201_PR
22	NW600	☐	ISSR_NW600	ISSR_NW600	CHAR	4	0		V_TISSR_NW600_PR
23	NW670	☐	ISSR_NW670	ISSR_NW670	CHAR	10	0	Anlagen R30NW670	TISSR_BAV_NW670B
24	NW671	☐	ISSR_NW671	ISSR_NW671	CHAR	10	0	Anlagen R30NW671	TISSR_BAV_NW671B
25	R59703	☐	ISSR_R59703	ISSR_R59703	CHAR	1	0		TISSR_BAV_R5973B
26	R59704	☐	ISSR_R59704	ISSR_R59704	CHAR	2	0		TISSR_BAV_R5974B
27	R59705	☐	ISSR_R59705	ISSR_R59705	CHAR	2	0	Indicator for R5/97 appendix 5	TISSR_BAV_R5975B
28	R59706	☐	ISSR_R59706	ISSR_R59706	CHAR	1	0	Indicator for R5/97 appendix 6 - Collateral	TISSR_BAV_R5976B
29	R59708	☐	ISSR_R59708	ISSR_R59708	CHAR	1	0	Indicator for R5/97 appendix 8	TISSR_BAV_R5978B
30	R59710_1	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	V_TISSR_R597101
31	R59710_2	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	V_TISSR_R597102
32	R59710_3	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	V_TISSR_R597103
33	R59710_4	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	V_TISSR_R597104
34	ANRWERT	☐	ISSR_ANRWERT	WERTV9	CURR	17	2	Accepted Value
35	ANRWERTWHR	☐	ISSR_ANRWERTWHR	WAERS	CUKY	5	0	Currency of accepted value_FISO	TCURC
36	VERKEHRSW	☐	ISSR_VERKEHRSW	WERTV9	CURR	17	2
37	VERKEHRSWWHR	☐	ISSR_VERKEHRSWWHR	WAERS	CUKY	5	0		TCURC
38	BEDECKWHR	☐	ISSR_COVER_PROV_CURR	WAERS	CUKY	5	0	ISSR: Erfüllungs- und Bedeckungswährung	TCURC
39	GENAKTZ	☐	ISSR_ANLAGEN_GENAKTZ	TEXT32	CHAR	32	0	Aktenzeichen der Genehmigung der Anlage
40	GENDAT	☐	ISSR_ANLAGEN_GENDAT	DATUM	DATS	8	0	Genehmigungsdatum der Anlage durch Ausichtsbehörde
41	ANRWERTDAT	☐	ISSR_ANRWERTDAT	DATUM	DATS	8	0	Date for Fixing the Accepted Value
42	ANRWERTAKTZ	☐	ISSR_ANRWERTAKTZ	TEXT32	CHAR	32	0	BAV file character_accepted value
43	AUFBLAND	☐	ISSR_COUNTRY_OF_SITUS	LAND1	CHAR	3	0		T005
44	AUFBWORT	☐	ISSR_AUFORT	TEXT22	CHAR	22	0
45	DURCHR_FONDS	☐	ISSR_DURCHR_FONDS	ISSR_DURCHR_FONDS	CHAR	1	0	Fremdmittelaufnahme ist laut Satzung nicht erlaubt
46	IDENTNR	☐	ISSR_IDENTNR	CHAR22	CHAR	22	0
47	IDENTNRH	☐	ISSR_IDENTNRH	CHAR30	CHAR	30	0	BAV hist. identifications number
48	RANTYP	☐	ISSR_RANTYP	RANTYP	CHAR	1	0	External System ID for Capital Investment Type for Reporting
49	VVKEY	☐	ISSR_VVKEY	ISSR_VVKEY	CHAR	34	0
50	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
51	NUMB_PER_ASSET	☐	NUMC05	NUMC5	NUMC	5	0	Numeric field length 5
52	ECOMPONENT	☐	ISSR_ARBGB	ISSR_ARGB	CHAR	4	0		TISSR_ARGB
53	EPGM	☐	ISSR_DESCRIPTION	ISSR_DESCRIPTION	CHAR	60	0
54	ENAME	☐	UNAME	UNAME	CHAR	12	0	User Name
55	EDATUM	☐	DATUM	DATUM	DATS	8	0	Date
56	ETIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
57	MASTER_REC_KEY	☐	ISSR_STAMMS_KENN	ISSR_STAMMS_KENN	CHAR	3	0	ISSR: Stammsatzkennung für Stammdatentabelle ISSR_RPI_MFT
58	FLG_SECONDARY	☐	ISSR_FLG_SECONDARY_ASSET	ISSR_FLG_SECONDARY_ASSET	CHAR	1	0	Kennzeichen 'Anlage ist nachrangig'
59	SIGN_IDENT	☐	ISSR_IDENT	ISSR_IDENT	NUMC	1	0
60	SL_ID_CHANGEONLY	☐	ISSR_SL_CHANGE_IDNR	ISSR_SL_CHANGE_IDNR	CHAR	1	0	Kn.: Bewegungen auf SL-Ledgern durch reine ID-Änderung
61	FLG_INVESTMENT	☐	ISSR_INVESTMENT	ISSR_INVESTMENT	CHAR	1	0	Kennzeichen 'Kapitalanlage ist Beteiligung'	TISSR_INVESTMENT
62	ASSET_TYPE	☐	ISSR_ASSET_TYPE	ISSR_ASSET_TYPE	CHAR	1	0	Kennzeichen Anlagevermögen/Umlaufvermögen	TISSR_ASSET_TYPE

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXE390112	ABS54AVAG	TISSR_ANLARTB	ABS54AVAG	KEY	1	CN
2	ROXE390112	ANRWERTWHR	TCURC	WAERS	KEY	1	CN
3	ROXE390112	ASSET_TYPE	TISSR_ASSET_TYPE	ASSET_TYPE	KEY	1	CN
4	ROXE390112	AUFBLAND	T005	LAND1	KEY	1	CN
5	ROXE390112	BEDECKWHR	TCURC	WAERS	KEY	1	CN
6	ROXE390112	BUKRS	T001	BUKRS	KEY	1	CN
7	ROXE390112	COUNTRY_VAR	TISSR_MARECO	COUNTRY_VAR	KEY	1	CN
8	ROXE390112	DV	TISSR_DV_PT	DV	KEY	1	CN
9	ROXE390112	DVUA	TISSR_DVUAB	DVUA	KEY	1	CN
10	ROXE390112	ECOMPONENT	TISSR_ARGB	ARBGB	KEY	1	CN
11	ROXE390112	FLG_INVESTMENT	TISSR_INVESTMENT	FLG_INVESTMENT	KEY	1	CN
12	ROXE390112	MANDT	T000	MANDT	KEY	1	CN
13	ROXE390112	NW101	V_TISSR_NW101_PR	NW101	KEY	1	CN
14	ROXE390112	NW102	V_TISSR_NW102_PR	NW102	KEY	1	CN
15	ROXE390112	NW201	V_TISSR_NW201_PR	NW201	KEY	1	CN
16	ROXE390112	NW600	V_TISSR_NW600_PR	NW600	KEY	1	CN
17	ROXE390112	NW670	TISSR_BAV_NW670B	NW670	KEY	1	CN
18	ROXE390112	NW671	TISSR_BAV_NW671B	NW671	KEY	1	CN
19	ROXE390112	PRODUCT_CATEGORY	TISSR_IFPCAT	PRODUCT_CATEGORY	KEY	1	CN
20	ROXE390112	PRODUCT_TYPE	TISSR_IFB_RTPT	ISSR_PRODUCTTYPE	KEY	1	CN
21	ROXE390112	R59703	TISSR_BAV_R5973B	R59703	KEY	1	CN
22	ROXE390112	R59704	TISSR_BAV_R5974B	R59704	KEY	1	CN
23	ROXE390112	R59705	TISSR_BAV_R5975B	R59705	KEY	1	CN
24	ROXE390112	R59706	TISSR_BAV_R5976B	R59706		1	CN
25	ROXE390112	R59708	TISSR_BAV_R5978B	R59708	KEY	1	CN
26	ROXE390112	R59710_1	V_TISSR_R597101	R59710
27	ROXE390112	R59710_2	V_TISSR_R597102	R59710	KEY	1	CN
28	ROXE390112	R59710_3	V_TISSR_R597103	R59710	KEY	1	CN
29	ROXE390112	R59710_4	V_TISSR_R597104	R59710	KEY	1	CN
30	ROXE390112	SPARTE	TISSR_SPARTE	SPARTE	KEY	1	CN
31	ROXE390112	STOCKBAV	TISSR_STOCKBAV	STOCKBAV	KEY	1	CN
32	ROXE390112	STOCKFA	TISSR_STOCKFA	STOCKFA	KEY	1	CN
33	ROXE390112	VERKEHRSWWHR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in