SAP ABAP View ICL_BS_MULT_B (Claim Bundle + Participants + Country (Coll.Subro/Recovery))

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_EVENT (Package) FS-CM: Claim Bundle

Basic Data

View Type	D	Database View
Database View	ICL_BS_MULT_B
Short Description	Claim Bundle + Participants + Country (Coll.Subro/Recovery)
Root table	ICLCCEVENT	Claim Bundle

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLCCEVENT	ICLCCEVENT
2	TICL001
3	TICL001T
4	TICL002
5	TICL002T
6	TICL177T
7	ICLCCEVENTB
8	ICLCCEVENTR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TICL001	CLIENT	JL	EQ				0	0
2	ICLCCEVENT	CLIENT	JR	EQ			AND	0	0
3	TICL001	CCTYPE	JL	EQ				0	0
4	ICLCCEVENT	CCTYPE	JR	EQ			AND	0	0
5	TICL001T	CLIENT	JL	EQ				0	0
6	TICL001	CLIENT	JR	EQ			AND	0	0
7	TICL001T	CCTYPE	JL	EQ				0	0
8	TICL001	CCTYPE	JR	EQ			AND	0	0
9	TICL002	CLIENT	JL	EQ				0	0
10	ICLCCEVENT	CLIENT	JR	EQ			AND	0	0
11	TICL002	CCTYPE	JL	EQ				0	0
12	ICLCCEVENT	CCTYPE	JR	EQ			AND	0	0
13	TICL002	SUBTYPE	JL	EQ				0	0
14	ICLCCEVENT	SUBTYPE	JR	EQ			AND	0	0
15	TICL002T	CLIENT	JL	EQ				0	0
16	TICL002	CLIENT	JR	EQ			AND	0	0
17	TICL002T	CCTYPE	JL	EQ				0	0
18	TICL002	CCTYPE	JR	EQ			AND	0	0
19	TICL002T	SUBTYPE	JL	EQ				0	0
20	TICL002	SUBTYPE	JR	EQ			AND	0	0
21	TICL002T	LANGU	JL	EQ				0	0
22	TICL001T	LANGU	JR	EQ			AND	0	0
23	TICL001	CLIENT	JL	EQ				0	0
24	TICL177T	CLIENT	JR	EQ			AND	0	0
25	TICL001	CCTYPE	JL	EQ				0	0
26	TICL177T	CCTYPE	JR	EQ			AND	0	0
27	ICLCCEVENT	CLIENT	JL	EQ				0	0
28	ICLCCEVENTB	CLIENT	JR	EQ			AND	0	0
29	ICLCCEVENT	ACTIVE	JL	EQ				0	0
30	ICLCCEVENTB	ACTIVE	JR	EQ			AND	0	0
31	ICLCCEVENT	CCEVENT	JL	EQ				0	0
32	ICLCCEVENTB	CCEVENT	JR	EQ			AND	0	0
33	ICLCCEVENT	CLIENT	JL	EQ				0	0
34	ICLCCEVENTR	CLIENT	JR	EQ			AND	0	0
35	ICLCCEVENT	ACTIVE	JL	EQ				0	0
36	ICLCCEVENTR	ACTIVE	JR	EQ			AND	0	0
37	ICLCCEVENT	CCEVENT	JL	EQ				0	0
38	ICLCCEVENTR	CCEVENT	JR	EQ			AND	0	0
39	ICLCCEVENT	DELETED		NE	'X'		AND	0	0
40	ICLCCEVENTB	DELETED		NE	'X'		AND	0	0
41	ICLCCEVENTR	DELETED		NE	'X'		AND	0	0
42	TICL001	TYPE		EQ	'4'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ICLCCEVENT	CLIENT		☐	MANDT	☐	Client
2	ACTIVE	ICLCCEVENT	ACTIVE		☐	ICL_ACTIVE	☐	Table entry is active (A) or in suspense (S)
3	CCEVENT	ICLCCEVENT	CCEVENT		☐	ICL_CCEVENT	☐	Claim Bundle
4	CCTYPE	ICLCCEVENT	CCTYPE		☐	ICL_CCEVENTCAT	☐	Claim Bundle Type
5	SUBTYPE	ICLCCEVENT	SUBTYPE		☐	ICL_CCEVENTTY	☐	Subtype of Claim Bundle Type
6	CCSBRTYPE	ICLCCEVENT	CCSBRTYPE		☐	ICL_CCSBRTYPE	☐	Subrogation Claim Type in Subrogation
7	BPARTNER	ICLCCEVENTB	BPARTNER		☐	ICL_PART	☐	Claim Participant
8	ROLE	ICLCCEVENTB	ROLE		☐	ICL_ROLE	☐	Participant Role Key
9	DESCRIP	ICLCCEVENTB	DESCRIP		☐	ICL_DESCRIP	☐	Participant in Claim: Description
10	COUNTRY	ICLCCEVENTR	COUNTRY		☐	LAND1	☐	Country Key
11	REGION	ICLCCEVENTR	REGION		☐	REGIO	☐	Region (State, Province, County)
12	COUNTY	ICLCCEVENTR	COUNTY		☐	COUNC	☐	County Code
13	CITY	ICLCCEVENTR	CITY		☐	CITY_CODE	☐	City Code for City/Street File
14	LANGU	TICL001T	LANGU		☐	LANGU	☐	Language Key
15	LANGU2	TICL177T	LANGU		☐	LANGU	☐	Language Key
16	SUBTYPE2	TICL177T	SUBTYPE		☐	ICL_CCEVENTTY	☐	Subtype of Claim Bundle Type
17	CCSBRTYPE2	TICL177T	CCSBRTYPE		☐	ICL_CCSBRTYPE	☐	Subrogation Claim Type in Subrogation
18	CCTYPEN	TICL001T	CCTYPEN		☐	ICL_CCEVENTCATN	☐	Name of Claim Bundle Type
19	NAME	TICL002T	NAME		☐	ICL_CCEVENTTYN	☐	Name of Subtype of Claim Bundle Type
20	CCSBRTYPEN	TICL177T	CCSBRTYPEN		☐	ICL_CCSBRTYPEN	☐	Name of Subrogation Claim Type
21	RANGEFROM	ICLCCEVENT	RANGEFROM		☐	ICL_CCEVENTFROM	☐	Event Period: Date From
22	STATUS	ICLCCEVENT	STATUS		☐	ICLE_BUNDLE_STATUS_D	☐	Status of Claim Bundle
23	TYPE	TICL001	TYPE		☐	ICLE_CCEVENTTYP	☐	Category of Claim Bundle Type
24	CREATEDBY	ICLCCEVENT	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
25	CHANGEDBY	ICLCCEVENT	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
26	CHANGETIME	ICLCCEVENT	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time

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	20130529
SAP Release Created in	600