SAP ABAP Table ICLE_BULKSBR_SCR (Collective Subrogatn: Completely Formatted Bundle Data f.GUI)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICLE_BULKSBR_SCR	Table Relationship Diagram
Short Description	Collective Subrogatn: Completely Formatted Bundle Data f.GUI

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	.INCLUDE	☐				0	0	Claim Bundle
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
4	CCEVENT	☐	ICL_CCEVENT	ICL_CCEVENT	CHAR	17	0	Claim Bundle	*
5	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
6	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
7	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
8	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
9	.INCLUDE	☐				0	0	Claim Bundle
10	.INCLUDE	☐				0	0	Organizational Include (Short Version)
11	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
12	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
13	CCTYPE	☐	ICL_CCEVENTCAT	ICL_CCEVENTCAT	CHAR	2	0	Claim Bundle Type	TICL001
14	SUBTYPE	☐	ICL_CCEVENTTY	ICL_CCEVENTTY	CHAR	2	0	Subtype of Claim Bundle Type	TICL002
15	CURR	☐	ICL_CCEVENTCUR	WAERS	CUKY	5	0	Currency of Claim Bundle Reserve	TCURC
16	LIMIT	☐	ICL_CCEVENTLIM	ICL_TOAMT	CURR	17	2	Claim Bundle Compensation Reserve
17	LIMITE	☐	ICL_CCEVENTLIME		CURR	17	2	Claim Bundle Expenses Reserve
18	CODE	☐	ICL_CCEVENTCODE	CHAR12	CHAR	12	0	External Name for Claim Bundle
19	NAME	☐	ICL_CCEVENTNAME	TEXT20	CHAR	20	0	Name of Claim Bundle
20	RANGEFROM	☐	ICL_CCEVENTFROM	DATE	DATS	8	0	Event Period: Date From
21	RANGETO	☐	ICL_CCEVENTTO	DATE	DATS	8	0	Event Period: Date To
22	HOTLINE	☐	ICL_CCEVENTTEL	CHAR30	CHAR	30	0	Coordinator phone number
23	LOCATYPE	☐	ICL_CCEVENTLOCA	ICL_LOCTYPE	NUMC	1	0	Define Location via Region '1', Postal Code '2', Address '3'
24	STATUS	☐	ICLE_BUNDLE_STATUS_D	ICL_STATUS	CHAR	2	0	Status of Claim Bundle	TICL140
25	BUNDLECAUSE	☐	ICL_BUNDLECAUSE	ICL_BUNDLECAUSE	CHAR	3	0	Reason for Creation of Claim Bundle	TICL012
26	OWNER	☐	ICL_BUNDLEOWNER	XUBNAME	CHAR	12	0	Claim Bundle Handler	USR02
27	INVOICEREF_BULK	☐	ICL_INVOICEREF_BULK	CHAR16	CHAR	16	0	External Collective Invoice Number
28	EXTERNALREF_BULK	☐	ICL_EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	CHAR	20	0	External Collective Reference
29	ISSUEDATE	☐	ICL_ISSUEDATE_INVBULK	DATS	DATS	8	0	Collective Invoice Date
30	AMOUNT_TOTAL	☐	ICL_AMOUNT_BULKINV_TOTAL	ICL_AMOUNT	CURR	15	2	Net Total Amount of Collective Invoice (acc. to Coll.Inv.)
31	PAYMENTLEVEL	☐	ICL_PAYMENTLEVEL	ICL_PAYMENTLEVEL	NUMC	1	0	Payment Level of a Collective Invoice
32	DATASOURCE	☐	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin	TICL136
33	RECEIVEDATE	☐	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
34	CLMINPROCESS	☐	ICL_CLMSTATUS_INPROCESS	XFELD	CHAR	1	0	Dependent Claim Exists with Status "In Process"
35	RELEASED	☐	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
36	CANCEL	☐	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
37	INPROCESS	☐	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
38	CLMINPROC_CNTR	☐	ICL_CLMSTATUS_INPROCESS_CNTR	ICL_CLMSTATUS_INPROCESS_CNTR	INT4	10	0	Counter for Number of Open Claims
39	STHANDLER	☐	ICLE_STHANDLER	XFELD	CHAR	1	0	"Bundle Processing" Process Is Active
40	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
41	.INCLUDE	☐				0	0	Collective Subrogation: Special Attributes
42	CCSBRBNDL	☐	ICL_CCSBRBNDL	ICL_CCEVENT	CHAR	17	0	Number of Collective Subrogation/Recovery	ICLCCEVENT
43	CCSBRTYPE	☐	ICL_CCSBRTYPE	ICL_CCSBRTYPE	CHAR	2	0	Subrogation Claim Type in Subrogation	TICL177
44	CHREASONSBR	☐	ICL_CHREASONSBR	ICL_CHREASONSBR	CHAR	2	0	Change Reason for Status of Collective Subrogation/Recovery	TICL175
45	BILLINGDATE	☐	ICL_BILLINGDATE	DATE	DATS	8	0	Next Billing Date
46	RESUBDATE	☐	ICL_RESUBDATE	DATE	DATS	8	0	Date of Resubmission
47	SBRNOTIFDATE	☐	ICL_SBRNOTIFDATE	DATE	DATS	8	0	Date on Which Subrogation Claim Was Reported
48	.INCLUDE	☐				0	0	Collective Subrogation: Special Attributes (only for GUI)
49	BULKSBR	☐	ICL_BULKSBR	ICL_BULKSBR	CHAR	3	0	Number of Collective Subrogation/Recovery Settlement	*
50	CCTYPEN	☐	ICL_CCEVENTCATN	TEXT25	CHAR	25	0	Name of Claim Bundle Type
51	CCSUBTYPEN	☐	ICL_CCEVENTTYN	TEXT25	CHAR	25	0	Name of Subtype of Claim Bundle Type
52	INSURED	☐	ICL_INSURED	BU_PARTNER	CHAR	10	0	Insured Person	BUT000
53	DESCRIP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
54	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
55	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
56	LANDX	☐	LANDX	TEXT15	CHAR	15	0	Country Name
57	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
58	BEZEI	☐	BEZEI20	TEXT20	CHAR	20	0	Description
59	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
60	CLTYPEN	☐	ICL_CLTYPEN	TEXT30	CHAR	30	0	Internal Claim Type Name
61	POLPROD	☐	ICL_POLPROD	ICL_POLPROD	CHAR	6	0	Policy Product	TICL320
62	POLPRODN	☐	ICL_POLPRODN	TEXT30	CHAR	30	0	Name of Policy Product
63	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	TICL007
64	PLINEOFBUSN	☐	ICL_LINEOFBUSN	TEXT30	CHAR	30	0	Name of Insurance Line of Business
65	CCSBRTYPEN	☐	ICL_CCSBRTYPEN	TEXT40	CHAR	40	0	Name of Subrogation Claim Type
66	XSUBRO	☐	ICL_SUBCL03	ICL_SUBCL03	CHAR	1	0	Subrogation/Recovery Status
67	XSUBROTXT	☐	ICL_XSUBROTXT	TEXT25	CHAR	25	0	Subrogation Status (Text)
68	PAY_STATUS	☐	ICL_PAYMENT12	ICL_PAYMENT12	CHAR	2	0	Internal Payment Status (Database Status)
69	PAY_STATUSTXT	☐	ICL_STATUSTXT	DDTEXT	CHAR	60	0	Name of Status of Claim Payment
70	CHREASONSBRN	☐	ICL_CHREASONSBRN	TEXT40	CHAR	40	0	Name of Change Reason for the Subrogation Status
71	.INCLUDE	☐				0	0	Collective Subrogation: Special Attributes (only for GUI)
72	ACCEVT	☐	ICLE_ACCFORM	ICL_CCEVENT	CHAR	17	0	Accident Event	*
73	ACCDATE	☐	ICLE_ACCDATE	DATE	DATS	8	0	Accident Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLE_BULKSBR_SCR	BUNDLECAUSE	TICL012	BUNDLECAUSE
2	ICLE_BULKSBR_SCR	CCSBRBNDL	ICLCCEVENT	CCEVENT	REF	1	CN
3	ICLE_BULKSBR_SCR	CCSBRTYPE	TICL177	CCSBRTYPE	REF	1	CN
4	ICLE_BULKSBR_SCR	CCTYPE	TICL001	CCTYPE
5	ICLE_BULKSBR_SCR	CHANGEDBY	USR02	BNAME
6	ICLE_BULKSBR_SCR	CHREASONSBR	TICL175	CHREASONSBR	REF	1	CN
7	ICLE_BULKSBR_SCR	CLAIMTYPE	TICL011	CLTYPE	REF	1	CN
8	ICLE_BULKSBR_SCR	CLIENT	T000	MANDT
9	ICLE_BULKSBR_SCR	COUNTRY	T005	LAND1	REF	1	CN
10	ICLE_BULKSBR_SCR	CREATEDBY	USR02	BNAME
11	ICLE_BULKSBR_SCR	CURR	TCURC	WAERS
12	ICLE_BULKSBR_SCR	DATASOURCE	TICL136	DATASOURCE	KEY
13	ICLE_BULKSBR_SCR	INSURED	BUT000	PARTNER	REF	1	CN
14	ICLE_BULKSBR_SCR	OWNER	USR02	BNAME
15	ICLE_BULKSBR_SCR	PLINEOFBUS	TICL007	PLINEOFBUS	REF	1	CN
16	ICLE_BULKSBR_SCR	POLPROD	TICL320	POLPROD	REF	1	CN
17	ICLE_BULKSBR_SCR	REGION	T005S	BLAND	REF	1	CN
18	ICLE_BULKSBR_SCR	STATUS	TICL140	STATUS
19	ICLE_BULKSBR_SCR	SUBTYPE	TICL002	SUBTYPE

History

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