SAP ABAP Table ICSCCEVENT (Shadow Table Claim Bundle)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSCCEVENT	Table Relationship Diagram
Short Description	Shadow Table Claim Bundle

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CCEVENT	☑	ICL_CCEVENT	ICL_CCEVENT	CHAR	17	0	Claim Bundle	*
4	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
5	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
6	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
7	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
8	.INCLUDE	☐				0	0	Claim Bundle
9	.INCLUDE	☐				0	0	Organizational Include (Short Version)
10	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
11	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
12	CCTYPE	☐	ICL_CCEVENTCAT	ICL_CCEVENTCAT	CHAR	2	0	Claim Bundle Type	TICL001
13	SUBTYPE	☐	ICL_CCEVENTTY	ICL_CCEVENTTY	CHAR	2	0	Subtype of Claim Bundle Type	TICL002
14	CURR	☐	ICL_CCEVENTCUR	WAERS	CUKY	5	0	Currency of Claim Bundle Reserve	TCURC
15	LIMIT	☐	ICL_CCEVENTLIM	ICL_TOAMT	CURR	17	2	Claim Bundle Compensation Reserve
16	LIMITE	☐	ICL_CCEVENTLIME		CURR	17	2	Claim Bundle Expenses Reserve
17	CODE	☐	ICL_CCEVENTCODE	CHAR12	CHAR	12	0	External Name for Claim Bundle
18	NAME	☐	ICL_CCEVENTNAME	TEXT20	CHAR	20	0	Name of Claim Bundle
19	RANGEFROM	☐	ICL_CCEVENTFROM	DATE	DATS	8	0	Event Period: Date From
20	RANGETO	☐	ICL_CCEVENTTO	DATE	DATS	8	0	Event Period: Date To
21	HOTLINE	☐	ICL_CCEVENTTEL	CHAR30	CHAR	30	0	Coordinator phone number
22	LOCATYPE	☐	ICL_CCEVENTLOCA	ICL_LOCTYPE	NUMC	1	0	Define Location via Region '1', Postal Code '2', Address '3'
23	STATUS	☐	ICLE_BUNDLE_STATUS_D	ICL_STATUS	CHAR	2	0	Status of Claim Bundle	TICL140
24	BUNDLECAUSE	☐	ICL_BUNDLECAUSE	ICL_BUNDLECAUSE	CHAR	3	0	Reason for Creation of Claim Bundle	TICL012
25	OWNER	☐	ICL_BUNDLEOWNER	XUBNAME	CHAR	12	0	Claim Bundle Handler	USR02
26	INVOICEREF_BULK	☐	ICL_INVOICEREF_BULK	CHAR16	CHAR	16	0	External Collective Invoice Number
27	EXTERNALREF_BULK	☐	ICL_EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	CHAR	20	0	External Collective Reference
28	ISSUEDATE	☐	ICL_ISSUEDATE_INVBULK	DATS	DATS	8	0	Collective Invoice Date
29	AMOUNT_TOTAL	☐	ICL_AMOUNT_BULKINV_TOTAL	ICL_AMOUNT	CURR	15	2	Net Total Amount of Collective Invoice (acc. to Coll.Inv.)
30	PAYMENTLEVEL	☐	ICL_PAYMENTLEVEL	ICL_PAYMENTLEVEL	NUMC	1	0	Payment Level of a Collective Invoice
31	DATASOURCE	☐	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin	TICL136
32	RECEIVEDATE	☐	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
33	CLMINPROCESS	☐	ICL_CLMSTATUS_INPROCESS	XFELD	CHAR	1	0	Dependent Claim Exists with Status "In Process"
34	RELEASED	☐	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
35	CANCEL	☐	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
36	INPROCESS	☐	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
37	CLMINPROC_CNTR	☐	ICL_CLMSTATUS_INPROCESS_CNTR	ICL_CLMSTATUS_INPROCESS_CNTR	INT4	10	0	Counter for Number of Open Claims
38	STHANDLER	☐	ICLE_STHANDLER	XFELD	CHAR	1	0	"Bundle Processing" Process Is Active
39	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
40	.INCLUDE	☐				0	0	Collective Subrogation: Special Attributes
41	CCSBRBNDL	☐	ICL_CCSBRBNDL	ICL_CCEVENT	CHAR	17	0	Number of Collective Subrogation/Recovery	ICLCCEVENT
42	CCSBRTYPE	☐	ICL_CCSBRTYPE	ICL_CCSBRTYPE	CHAR	2	0	Subrogation Claim Type in Subrogation	TICL177
43	CHREASONSBR	☐	ICL_CHREASONSBR	ICL_CHREASONSBR	CHAR	2	0	Change Reason for Status of Collective Subrogation/Recovery	TICL175
44	BILLINGDATE	☐	ICL_BILLINGDATE	DATE	DATS	8	0	Next Billing Date
45	RESUBDATE	☐	ICL_RESUBDATE	DATE	DATS	8	0	Date of Resubmission
46	SBRNOTIFDATE	☐	ICL_SBRNOTIFDATE	DATE	DATS	8	0	Date on Which Subrogation Claim Was Reported

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSCCEVENT	BUNDLECAUSE	TICL012	BUNDLECAUSE
2	ICSCCEVENT	CCSBRBNDL	ICLCCEVENT	CCEVENT	REF	1	CN
3	ICSCCEVENT	CCSBRTYPE	TICL177	CCSBRTYPE	REF	1	CN
4	ICSCCEVENT	CCTYPE	TICL001	CCTYPE
5	ICSCCEVENT	CHANGEDBY	USR02	BNAME
6	ICSCCEVENT	CHREASONSBR	TICL175	CHREASONSBR	REF	1	CN
7	ICSCCEVENT	CLIENT	T000	MANDT
8	ICSCCEVENT	CREATEDBY	USR02	BNAME
9	ICSCCEVENT	CURR	TCURC	WAERS
10	ICSCCEVENT	DATASOURCE	TICL136	DATASOURCE	KEY
11	ICSCCEVENT	OWNER	USR02	BNAME
12	ICSCCEVENT	STATUS	TICL140	STATUS
13	ICSCCEVENT	SUBTYPE	TICL002	SUBTYPE

History

Last changed by/on	SAP	20110901
SAP Release Created in	471