SAP ABAP Table ISSR_COLL_AMOUNT (ISSR: Hilfsstruktur für Ermittlung der umbuchbaren Anlagen)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FS-SR (Application Component) Regulatory reporting for insurance companies
     ⤷ VVSRFISL (Package) Statutory Reporting for Insurance from FI-SL

Basic Data

Table Category	INTTAB	Structure
Structure	ISSR_COLL_AMOUNT	Table Relationship Diagram
Short Description	ISSR: Hilfsstruktur für Ermittlung der umbuchbaren Anlagen

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	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_IFPTYP
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	.INCLUDE	☐				0	0	ISSR: Länderabhängige Datenfelder DS-Umbuchung Deutschland
15	STOCKBAV	☐	ISSR_STOCKBAV	ISSR_STOCKBAV	CHAR	1	0	BAV Stock Indicator	TISSR_STOCKBAV
16	STOCKFA	☐	ISSR_STOCKFA	ISSR_STOCKFA	CHAR	1	0	Tax office stock indicator	TISSR_STOCKFA
17	DV	☐	ISSR_DV	ISSR_DV	CHAR	5	0	Premium reserve fund list number	TISSR_DV_PT
18	DVUA	☐	ISSR_UA	ISSR_UA	CHAR	2	0	Subsection number of premium reserve fund list	TISSR_DVUAB
19	ABS54AVAG	☐	ISSR_ABS54AVAG	ISSR_ABS54AVAG	CHAR	6	0	Asset Type According to Regulatory Accounting Requirements	TISSR_ANLARTB
20	NW101	☐	ISSR_NW101	ISSR_NW101	CHAR	4	0	BAV asset group stmt 101	V_TISSR_NW101_PR
21	NW102	☐	ISSR_NW102	ISSR_NW102	CHAR	5	0	BAV Asset Group Statement 102 (Germany Only)	V_TISSR_NW102_PR
22	NW201	☐	ISSR_NW201	ISSR_NW201	CHAR	5	0	BAV asset group stmt 201	V_TISSR_NW201_PR
23	NW600	☐	ISSR_NW600	ISSR_NW600	CHAR	4	0		V_TISSR_NW600_PR
24	NW670	☐	ISSR_NW670	ISSR_NW670	CHAR	10	0	Anlagen R30NW670	TISSR_BAV_NW670B
25	NW671	☐	ISSR_NW671	ISSR_NW671	CHAR	10	0	Anlagen R30NW671	TISSR_BAV_NW671B
26	R59703	☐	ISSR_R59703	ISSR_R59703	CHAR	1	0		TISSR_BAV_R5973
27	R59704	☐	ISSR_R59704	ISSR_R59704	CHAR	2	0		TISSR_BAV_R5974
28	R59705	☐	ISSR_R59705	ISSR_R59705	CHAR	2	0	Indicator for R5/97 appendix 5	TISSR_BAV_R5975
29	R59706	☐	ISSR_R59706	ISSR_R59706	CHAR	1	0	Indicator for R5/97 appendix 6 - Collateral	TISSR_BAV_R5976
30	R59708	☐	ISSR_R59708	ISSR_R59708	CHAR	1	0	Indicator for R5/97 appendix 8	TISSR_BAV_R5978
31	R59710_1	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TISSR_BAV_59710B
32	R59710_2	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TISSR_BAV_59710B
33	R59710_3	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TISSR_BAV_59710B
34	R59710_4	☐	ISSR_R59710	VVX_R97_10	CHAR	4	0	Indicator for R5/97 appendix 10	TISSR_BAV_59710B
35	ANRWERT	☐	ISSR_ANRWERT	WERTV9	CURR	17	2	Accepted Value
36	ANRWERTWHR	☐	ISSR_ANRWERTWHR	WAERS	CUKY	5	0	Currency of accepted value_FISO	TCURC
37	VERKEHRSW	☐	ISSR_VERKEHRSW	WERTV9	CURR	17	2
38	VERKEHRSWWHR	☐	ISSR_VERKEHRSWWHR	WAERS	CUKY	5	0		TCURC
39	BEDECKWHR	☐	ISSR_COVER_PROV_CURR	WAERS	CUKY	5	0	ISSR: Erfüllungs- und Bedeckungswährung	TCURC
40	GENAKTZ	☐	ISSR_ANLAGEN_GENAKTZ	TEXT32	CHAR	32	0	Aktenzeichen der Genehmigung der Anlage
41	GENDAT	☐	ISSR_ANLAGEN_GENDAT	DATUM	DATS	8	0	Genehmigungsdatum der Anlage durch Ausichtsbehörde
42	ANRWERTDAT	☐	ISSR_ANRWERTDAT	DATUM	DATS	8	0	Date for Fixing the Accepted Value
43	ANRWERTAKTZ	☐	ISSR_ANRWERTAKTZ	TEXT32	CHAR	32	0	BAV file character_accepted value
44	AUFBLAND	☐	ISSR_COUNTRY_OF_SITUS	LAND1	CHAR	3	0		T005
45	AUFBWORT	☐	ISSR_AUFORT	TEXT22	CHAR	22	0
46	DURCHR_FONDS	☐	ISSR_DURCHR_FONDS	ISSR_DURCHR_FONDS	CHAR	1	0	Fremdmittelaufnahme ist laut Satzung nicht erlaubt
47	IDENTNR	☐	ISSR_IDENTNR	CHAR22	CHAR	22	0
48	IDENTNRH	☐	ISSR_IDENTNRH	CHAR30	CHAR	30	0	BAV hist. identifications number
49	RANTYP	☐	ISSR_RANTYP	RANTYP	CHAR	1	0	External System ID for Capital Investment Type for Reporting
50	VVKEY	☐	VVKEY	VVKEYBAV	CHAR	34	0	DARWIN universal key (no client)	*
51	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
52	NUMB_PER_ASSET	☐	NUMC05	NUMC5	NUMC	5	0	Numeric field length 5
53	.INCLUDE	☐				0	0	ISSR: Informationen zur Erfassung des Datensatzes
54	ECOMPONENT	☐	ISSR_ARBGB	ISSR_ARGB	CHAR	4	0		TISSR_ARGB
55	EPGM	☐	ISSR_DESCRIPTION	ISSR_DESCRIPTION	CHAR	60	0
56	ENAME	☐	UNAME	UNAME	CHAR	12	0	User Name
57	EDATUM	☐	DATUM	DATUM	DATS	8	0	Date
58	ETIME	☐	SYUZEIT	SYTIME	TIMS	6	0	System Time
59	NEW_EXT_ID	☐	ISSR_ASSET_ID	ISSR_ASSET_ID	CHAR	13	0		*
60	MASTER_REC_KEY	☐	ISSR_STAMMS_KENN	ISSR_STAMMS_KENN	CHAR	3	0	ISSR: Stammsatzkennung für Stammdatentabelle ISSR_RPI_MFT
61	FLG_SECONDARY	☐	ISSR_FLG_SECONDARY_ASSET	ISSR_FLG_SECONDARY_ASSET	CHAR	1	0	Kennzeichen 'Anlage ist nachrangig'
62	SIGN_IDENT	☐	ISSR_IDENT	ISSR_IDENT	NUMC	1	0
63	FLG_INVESTMENT	☐	ISSR_INVESTMENT	ISSR_INVESTMENT	CHAR	1	0	Kennzeichen 'Kapitalanlage ist Beteiligung'	TISSR_INVESTMENT
64	ASSET_TYPE	☐	ISSR_ASSET_TYPE	ISSR_ASSET_TYPE	CHAR	1	0	Kennzeichen Anlagevermögen/Umlaufvermögen	TISSR_ASSET_TYPE
65	RVAL_AREA	☐	ISSR_VAL_AREA	ISSR_VAL_AREA	CHAR	3	0		TISSR_MAVAAR
66	RTCUR_SEL	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
67	TSL_SEL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
68	HSL_SEL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
69	KSL_SEL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
70	MSL_SEL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
71	ASL_SEL	☐	QUAN2	MENG8	QUAN	15	3	Additional Quantity
72	HWCUR_SEL	☐	ISSR_HSLCUR	WAERS	CUKY	5	0	Local Currency	TCURC
73	NWBTR_SEL	☐	ISSR_NSL	WERTV9	CURR	17	2
74	NWCUR_SEL	☐	ISSR_NSLCUR	WAERS	CUKY	5	0	Nominal currency	TCURC
75	HSL_ACT	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
76	HWCUR_ACT	☐	ISSR_HSLCUR	WAERS	CUKY	5	0	Local Currency	TCURC
77	NWBTR_ACT	☐	ISSR_NSL	WERTV9	CURR	17	2
78	NWCUR_ACT	☐	ISSR_NSLCUR	WAERS	CUKY	5	0	Nominal currency	TCURC
79	RTCUR_ACT	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	TCURC
80	TSL_ACT	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
81	KSL_ACT	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
82	MSL_ACT	☐	QUAN1	MENG8	QUAN	15	3	Quantity
83	ASL_ACT	☐	QUAN2	MENG8	QUAN	15	3	Additional Quantity
84	BUDAT_ACT	☐	ISSR_BUDAT	DATUM	DATS	8	0	Gueltig Ab-Datum Meldewesen -Stamm
85	STATUS	☐	ISSR_TOOLTIP	ISSR_TOOLTIP	CHAR	70	0	ISSR: Feld zur Aufnahme der Ikone + Text der Länge 60
86	STATUS_TP	☐	ISSR_TOOLTIP	ISSR_TOOLTIP	CHAR	70	0	ISSR: Feld zur Aufnahme der Ikone + Text der Länge 60
87	MARK	☐			CHAR	1	0
88	SL_ID_CHANGEONLY	☐	ISSR_SL_CHANGE_IDNR	ISSR_SL_CHANGE_IDNR	CHAR	1	0	Kn.: Bewegungen auf SL-Ledgern durch reine ID-Änderung

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISSR_COLL_AMOUNT	ABS54AVAG	TISSR_ANLARTB	ABS54AVAG	KEY	1	CN
2	ISSR_COLL_AMOUNT	ANRWERTWHR	TCURC	WAERS	KEY	1	CN
3	ISSR_COLL_AMOUNT	ASSET_TYPE	TISSR_ASSET_TYPE	ASSET_TYPE	KEY	1	CN
4	ISSR_COLL_AMOUNT	AUFBLAND	T005	LAND1	KEY	1	CN
5	ISSR_COLL_AMOUNT	BEDECKWHR	TCURC	WAERS	KEY	1	CN
6	ISSR_COLL_AMOUNT	BUKRS	T001	BUKRS	KEY	1	CN
7	ISSR_COLL_AMOUNT	COUNTRY_VAR	TISSR_MARECO	COUNTRY_VAR	KEY	1	CN
8	ISSR_COLL_AMOUNT	DV	TISSR_DV_PT	DV	KEY	1	CN
9	ISSR_COLL_AMOUNT	DVUA	TISSR_DVUAB	DVUA	KEY	1	CN
10	ISSR_COLL_AMOUNT	ECOMPONENT	TISSR_ARGB	ARBGB	KEY	1	CN
11	ISSR_COLL_AMOUNT	FLG_INVESTMENT	TISSR_INVESTMENT	FLG_INVESTMENT	KEY	1	CN
12	ISSR_COLL_AMOUNT	HWCUR_ACT	TCURC	WAERS	KEY	1	CN
13	ISSR_COLL_AMOUNT	HWCUR_SEL	TCURC	WAERS	KEY	1	CN
14	ISSR_COLL_AMOUNT	MANDT	T000	MANDT	KEY	1	CN
15	ISSR_COLL_AMOUNT	NW101	V_TISSR_NW101_PR	NW101	KEY	1	CN
16	ISSR_COLL_AMOUNT	NW102	V_TISSR_NW102_PR	NW102	KEY	1	CN
17	ISSR_COLL_AMOUNT	NW201	V_TISSR_NW201_PR	NW201	KEY	1	CN
18	ISSR_COLL_AMOUNT	NW600	V_TISSR_NW600_PR	NW600	KEY	1	CN
19	ISSR_COLL_AMOUNT	NW670	TISSR_BAV_NW670B	NW670	KEY	1	CN
20	ISSR_COLL_AMOUNT	NW671	TISSR_BAV_NW671B	NW671	KEY	1	CN
21	ISSR_COLL_AMOUNT	NWCUR_ACT	TCURC	WAERS	KEY	1	CN
22	ISSR_COLL_AMOUNT	NWCUR_SEL	TCURC	WAERS	KEY	1	CN
23	ISSR_COLL_AMOUNT	PRODUCT_CATEGORY	TISSR_IFPCAT	PRODUCT_CATEGORY	KEY	1	CN
24	ISSR_COLL_AMOUNT	PRODUCT_TYPE	TISSR_IFPTYP	ISSR_PRODUCTTYPE	KEY	1	CN
25	ISSR_COLL_AMOUNT	R59703	TISSR_BAV_R5973	R59703	KEY	1	CN
26	ISSR_COLL_AMOUNT	R59704	TISSR_BAV_R5974	R59704	KEY	1	CN
27	ISSR_COLL_AMOUNT	R59705	TISSR_BAV_R5975	R59705	KEY	1	CN
28	ISSR_COLL_AMOUNT	R59706	TISSR_BAV_R5976	R59706	KEY	1	CN
29	ISSR_COLL_AMOUNT	R59708	TISSR_BAV_R5978	R59708	KEY	1	CN
30	ISSR_COLL_AMOUNT	R59710_1	TISSR_BAV_59710B	R59710	KEY	1	CN
31	ISSR_COLL_AMOUNT	R59710_2	TISSR_BAV_59710B	R59710	KEY	1	CN
32	ISSR_COLL_AMOUNT	R59710_3	TISSR_BAV_59710B	R59710	KEY	1	CN
33	ISSR_COLL_AMOUNT	R59710_4	TISSR_BAV_59710B	R59710	KEY	1	CN
34	ISSR_COLL_AMOUNT	RTCUR_ACT	TCURC	WAERS	KEY	1	CN
35	ISSR_COLL_AMOUNT	RTCUR_SEL	TCURC	WAERS	KEY	1	CN
36	ISSR_COLL_AMOUNT	RVAL_AREA	TISSR_MAVAAR	VAL_AREA	KEY	1	CN
37	ISSR_COLL_AMOUNT	SPARTE	TISSR_SPARTE	SPARTE	KEY	1	CN
38	ISSR_COLL_AMOUNT	STOCKBAV	TISSR_STOCKBAV	STOCKBAV	KEY	1	CN
39	ISSR_COLL_AMOUNT	STOCKFA	TISSR_STOCKFA	STOCKFA	KEY	1	CN
40	ISSR_COLL_AMOUNT	VERKEHRSWWHR	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110