SAP ABAP View V_ISSR_R5975_DB (Datenbankview für Konsistenzprüfung fiktive Zuführung Anl8)

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

View Type	D	Database View
Database View	V_ISSR_R5975_DB
Short Description	Datenbankview für Konsistenzprüfung fiktive Zuführung Anl8
Root table	TISSR_BAV_R5975B	Beziehung Produkttyp z. fiktiven Zuführung Anl.8 R30/2002

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TISSR_BAV_R5975B	TISSR_BAV_R5975B
2	TISSR_BAV_R5975
3	TISSR_IFPCAT
4	TISSR_ANLARTB
5	TISSR_ANLART

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TISSR_BAV_R5975	MANDT	JL	EQ				0	0
2	TISSR_BAV_R5975B	MANDT	JR	EQ			AND	0	0
3	TISSR_BAV_R5975	COUNTRY_VAR	JL	EQ				0	0
4	TISSR_BAV_R5975B	COUNTRY_VAR	JR	EQ			AND	0	0
5	TISSR_BAV_R5975	R59705	JL	EQ				0	0
6	TISSR_BAV_R5975B	R59705	JR	EQ			AND	0	0
7	TISSR_IFPCAT	MANDT	JL	EQ				0	0
8	TISSR_BAV_R5975B	MANDT	JR	EQ			AND	0	0
9	TISSR_IFPCAT	PRODUCT_CATEGORY	JL	EQ				0	0
10	TISSR_BAV_R5975B	PRODUCT_CATEGORY	JR	EQ			AND	0	0
11	TISSR_IFPCAT	MANDT	JL	EQ				0	0
12	TISSR_ANLARTB	MANDT	JR	EQ			AND	0	0
13	TISSR_IFPCAT	PRODUCT_CATEGORY	JL	EQ				0	0
14	TISSR_ANLARTB	PRODUCT_CATEGORY	JR	EQ			AND	0	0
15	TISSR_ANLART	MANDT	JL	EQ				0	0
16	TISSR_ANLARTB	MANDT	JR	EQ			AND	0	0
17	TISSR_ANLART	COUNTRY_VAR	JL	EQ				0	0
18	TISSR_ANLARTB	COUNTRY_VAR	JR	EQ			AND	0	0
19	TISSR_ANLART	ABS54AVAG	JL	EQ				0	0
20	TISSR_ANLARTB	ABS54AVAG	JR	EQ			AND	0	0
21	TISSR_ANLART	ASSET_TYPE_IND		EQ	'O'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TISSR_BAV_R5975B	MANDT		☐	MANDT	☐	Client
2	COUNTRY_VAR	TISSR_BAV_R5975B	COUNTRY_VAR		☐	ISSR_REP_COUNTRY	☐
3	PRODUCT_CATEGORY	TISSR_IFPCAT	PRODUCT_CATEGORY		☐	ISSR_PRODUCT_CATEGORY	☐
4	R59705	TISSR_BAV_R5975B	R59705		☐	ISSR_R59705	☐	Indicator for R5/97 appendix 5
5	ABS54AVAG	TISSR_ANLARTB	ABS54AVAG		☐	ISSR_ABS54AVAG	☐	Asset Type According to Regulatory Accounting Requirements
6	ASSET_TYPE_IND	TISSR_ANLART	ASSET_TYPE_IND		☐	ISSR_ASSET_TYPE_IND	☐	Zuordnung Kn. §1 AnlV zur Öffkl./Sondergenehmigung

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20040819
SAP Release Created in	500