SAP ABAP View ICL_BS_LAND_B (Country and Region (Collective Subrogation/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_LAND_B
Short Description	Country and Region (Collective Subrogation/Recovery)
Root table	ICLCCEVENT	Claim Bundle

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLCCEVENT	ICLCCEVENT
2	ICLCCEVENTR
3	TICL001
4	T005
5	T005T
6	T005S
7	T005U

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLCCEVENT	CLIENT	JL	EQ				0	0
2	ICLCCEVENTR	CLIENT	JR	EQ			AND	0	0
3	ICLCCEVENT	ACTIVE	JL	EQ				0	0
4	ICLCCEVENTR	ACTIVE	JR	EQ			AND	0	0
5	ICLCCEVENT	CCEVENT	JL	EQ				0	0
6	ICLCCEVENTR	CCEVENT	JR	EQ			AND	0	0
7	TICL001	CLIENT	JL	EQ				0	0
8	ICLCCEVENT	CLIENT	JR	EQ			AND	0	0
9	TICL001	CCTYPE	JL	EQ				0	0
10	ICLCCEVENT	CCTYPE	JR	EQ			AND	0	0
11	T005	MANDT	JL	EQ				0	0
12	ICLCCEVENTR	CLIENT	JR	EQ			AND	0	0
13	T005	LAND1	JL	EQ				0	0
14	ICLCCEVENTR	COUNTRY	JR	EQ			AND	0	0
15	T005	MANDT	JL	EQ				0	0
16	T005T	MANDT	JR	EQ			AND	0	0
17	T005	LAND1	JL	EQ				0	0
18	T005T	LAND1	JR	EQ			AND	0	0
19	T005S	MANDT	JL	EQ				0	0
20	ICLCCEVENTR	CLIENT	JR	EQ			AND	0	0
21	T005S	LAND1	JL	EQ				0	0
22	ICLCCEVENTR	COUNTRY	JR	EQ			AND	0	0
23	T005S	BLAND	JL	EQ				0	0
24	ICLCCEVENTR	REGION	JR	EQ			AND	0	0
25	T005S	MANDT	JL	EQ				0	0
26	T005U	MANDT	JR	EQ			AND	0	0
27	T005S	LAND1	JL	EQ				0	0
28	T005U	LAND1	JR	EQ			AND	0	0
29	T005S	BLAND	JL	EQ				0	0
30	T005U	BLAND	JR	EQ			AND	0	0
31	ICLCCEVENTR	DELETED		NE	'X'		AND	0	0
32	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	COUNTRY	ICLCCEVENTR	COUNTRY		☐	LAND1	☐	Country Key
5	REGION	ICLCCEVENTR	REGION		☐	REGIO	☐	Region (State, Province, County)
6	CITY	ICLCCEVENTR	CITY		☐	CITY_CODE	☐	City Code for City/Street File
7	COUNTY	ICLCCEVENTR	COUNTY		☐	COUNC	☐	County Code
8	LANGU	T005T	SPRAS		☐	SPRAS	☐	Language Key
9	LANG2	T005U	SPRAS		☐	SPRAS	☐	Language Key
10	COUNTRYN	T005T	LANDX		☐	LANDX	☐	Country Name
11	REGIONN	T005U	BEZEI		☐	BEZEI20	☐	Description
12	TYPE	TICL001	TYPE		☐	ICLE_CCEVENTTYP	☐	Category of Claim Bundle Type
13	CCTYPE	ICLCCEVENT	CCTYPE		☐	ICL_CCEVENTCAT	☐	Claim Bundle Type
14	SUBTYPE	ICLCCEVENT	SUBTYPE		☐	ICL_CCEVENTTY	☐	Subtype of Claim Bundle Type
15	CCSBRTYPE	ICLCCEVENT	CCSBRTYPE		☐	ICL_CCSBRTYPE	☐	Subrogation Claim Type in Subrogation
16	RANGEFROM	ICLCCEVENT	RANGEFROM		☐	ICL_CCEVENTFROM	☐	Event Period: Date From
17	STATUS	ICLCCEVENT	STATUS		☐	ICLE_BUNDLE_STATUS_D	☐	Status of Claim Bundle
18	CREATEDBY	ICLCCEVENT	CREATEDBY		☐	ICL_CREATEDBY	☐	Created By
19	CHANGEDBY	ICLCCEVENTR	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
20	CHANGETIME	ICLCCEVENTR	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	20140121
SAP Release Created in	600