SAP ABAP Table ICSCLAIM (Claim)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSCLAIM	Table Relationship Diagram
Short Description	Claim

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	CLAIM	☑	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
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	Attributes of ICLCLAIM
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	ACHANGEDBY	☐	ICL_ACHANGEDBY	XUBNAME	CHAR	12	0	Whole Claim Last Changed By	USR02
13	ACHANGETIME	☐	ICL_ACHANGETIME	ICL_TIMESTAMP	DEC	15	0	Whole Claim Last Changed At
14	EXCLAIMNOCAT	☐	ICL_CLAIMNOCAT	ICL_CLAIMNOCAT	CHAR	1	0	External Number Category
15	EXCLAIMNO	☐	ICL_CLAIMNO	ICL_CLAIMNO	CHAR	20	0	External Number
16	STATUS	☐	ICL_CLSTATUS	ICL_STATUS	CHAR	2	0	Status of Claim	TICL140
17	STATUSCHG	☐	ICL_STATUSCHG	ICL_TIMESTAMP	DEC	15	0	Time of Last Status Change
18	STHANDLER	☐	ICL_STHANDLER	XFELD	CHAR	1	0	"Claim Handling" Process Active
19	STNOCLAIM	☐	ICL_STNOCLAIM	XFELD	CHAR	1	0	No Claim Made
20	STCLOSED	☐	ICL_STCLOSED	XFELD	CHAR	1	0	"Close (Sub)Claim" Process Executed
21	STATREASON	☐	ICL_FORMSET	ICL_FORMSET	CHAR	2	0	Reason for Changing the Status	*
22	LOSSTYPE	☐	ICL_LOSSTYPE	ICL_LOSSTYPE	CHAR	4	0	Incident Type of a Claim	TICL062
23	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
24	CLTYPEG	☐	ICL_CLTYPEG	ICL_CLTYPEG	NUMC	5	0	Generation of Internal Claim Type	TICL011
25	CLTYPEV	☐	ICL_CLTYPEV	ICL_CLTYPEV	NUMC	5	0	Internal Claim Type Version	TICL003
26	LOSSEVENT	☐	ICL_LOSSEVENT	ICL_CCEVENT	CHAR	17	0	Cumulative Event	ICLCCEVENT
27	POLPROD	☐	ICL_POLPROD	ICL_POLPROD	CHAR	6	0	Policy Product	TICL320
28	GENERAT	☐	ICL_GENERAT	ICL_GENERAT	NUMC	5	0	Policy Product Generation	TICL320
29	VERSION	☐	ICL_POLPRODV	ICL_CUST_VERSION	NUMC	5	0	Policy Product Version	TICL321
30	LRENEWAL	☐	ICL_LRENEWAL	ICL_TIMESTAMP	DEC	15	0	Last Renewal of Contract Before Claim Date/Time
31	POLICY	☐	ICL_POLICY	ICL_POLICY	CHAR	17	0	Contract Number
32	LOSSCAUSE	☐	ICL_LOSSCAUSE	ICL_LOSSCAUSE	CHAR	3	0	Cause of Loss/Claim	TICL009
33	PERIL	☐	ICL_PERIL	ICL_PERIL	CHAR	4	0	Peril
34	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
35	TIMELOSS	☐	ICL_LOSSTIME	TIME	TIMS	6	0	Time of Claim/Loss
36	LTIMEZONE	☐	ICL_LTIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Claim/Loss Event	TTZZ
37	XDATEESTIM	☐	ICL_XLOSSDATE	XFELD	CHAR	1	0	Date Is Estimate
38	DATECHANGER	☐	ICL_DATECHANGER	ICL_DATECHANGER	CHAR	2	0	Reason for Changing Claim Date	TICL029
39	LOSSREPCOMPA	☐	ICL_LOSSREPCOMPA	DATE	DATS	8	0	Date Claim Reported to Insurance Company
40	LOSSREPAGENT	☐	ICL_LOSSREPAGENT	DATE	DATS	8	0	Date Claim Reported to Agent
41	LOSSADDRESS	☐	ICL_LOSSADDRESS	AD_ADDRNUM	CHAR	10	0	Loss Location	ADRC
42	XAUTHREP	☐	ICL_XAUTHREP	XFELD	CHAR	1	0	Claim/Loss Reported to Authority
43	XSENSITIVE	☐	ICL_CLAIMSENS	XFELD	CHAR	1	0	Sensitive Claim?
44	COMPLEX	☐	ICL_COMPLEX	ICL_COMPLEX	CHAR	1	0	Complexity of Claim/Subclaim	TICL027
45	JURISCOUNTRY	☐	ICL_JURICOUNTRY	LAND1	CHAR	3	0	Jurisdiction Country	T005
46	JURISREGION	☐	ICL_JURISREGION	REGIO	CHAR	3	0	Jurisdiction Region	T005S
47	ASSIGN_STATE	☐	ICL_ASSIGN_STATE	ICL_ASSIGN_STATE	CHAR	2	0	Assignment Status of a Claim Subobject
48	OWNERTYPE	☐	ICL_OWNERTYPE	OTYPE	CHAR	2	0	Object Type of Claim Handler	T778O
49	OWNER	☐	ICL_CLAIMOWNER	ICL_CLAIMOWNER	CHAR	12	0	ID of Claim Handler
50	OWNERTYPE_GRP	☐	ICL_OWNERTYPE2	OTYPE	CHAR	2	0	Object Type of Claim Handler Group	*
51	OWNER_GRP	☐	ICL_CLAIMOWNER2	ICL_CLAIMOWNER	CHAR	12	0	Claim Handler Group
52	XCUMUL	☐	ICL_XCUMUL	XFELD	CHAR	1	0	Claim Assigned to an Aggregate
53	VIEWFAULT	☐	ICL_VIEWFAULTI	ICL_VIEWFAULT	CHAR	1	0	Fault of Policyholder from Point of View of Insurer	TICL081
54	VIEWFAULTPH	☐	ICL_VIEWFAULTPH	ICL_VIEWFAULT	CHAR	1	0	Party at Fault from Point of View of Policyholder	TICL081
55	TPNO	☐	ICL_TPNO	NUMC2	NUMC	2	0	Third Party Count (NOT USED)
56	XTPKNOWN	☐	ICL_TPKNOWN	XFELD	CHAR	1	0	Flag: Third Party Known?
57	COVERED	☐	ICL_COVERED	ICL_COVERED	CHAR	1	0	Indication of Compensability
58	AUTHCLM	☐	ICL_AUTHCLM	ICL_AUTHCLM	CHAR	4	0	Authorization Group for Claims (VIP)	TICL113
59	XCLAIMB	☐	ICL_XCLAIMB	XFELD	CHAR	1	0	Entry in ICLCLAIMB Exists
60	XNONOTIF	☐	ICL_XNONOTIF	XFELD	CHAR	1	0	Processing Not Possible in Notification Mode
61	XRESERVE	☐	ICL_XRESERVE	XFELD	CHAR	1	0	At Least One Reserve Exists in Claim
62	BENTREE	☐	ICL_BENTREE	ICL_BENTREE	CHAR	8	0	Benefit Type Tree	*
63	BENTREEG	☐	ICL_BENTREEG	ICL_BENTREEG	NUMC	5	0	Generation of Benefit Type Tree	*
64	BENTREEV	☐	ICL_BENTREEV	ICL_BENTREEV	NUMC	5	0	Version of Benefit Type Tree	*
65	WF_EXEC_TIME	☐	ICL_WF_EXECUTION_TIME	ICL_TIMESTAMP	DEC	15	0	Execution Time Workflow
66	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
67	XDUMMYCLAIM	☐	ICL_XDUMMYCLAIM	XFELD	CHAR	1	0	Flag: Dummy Claim
68	VERCHNGUTC	☐	ICL_VERCHNGUTC	ICL_TIMESTAMP	DEC	15	0	UTC Time of Change for Reading Version
69	OPENDATE	☐	ICL_OPENDATE	DATE	DATS	8	0	Opened On
70	XWITHOUT_PRODUCT	☐	ICL_XWITHOUTPRODUCT_D	BOOLE	CHAR	1	0	Indicator for Working Without Product Customizing
71	MAX_ITEMNR	☐	ICL_SCLITEM_NR_MAX	ICL_SCLITEM	CHAR	4	0	Current Highest Claim Item Number	*
72	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSCLAIM	ACHANGEDBY	USR02	BNAME
2	ICSCLAIM	AUTHCLM	TICL113	AUTHCLM	REF	1	CN
3	ICSCLAIM	CHANGEDBY	USR02	BNAME
4	ICSCLAIM	CLAIMTYPE	TICL011	CLTYPE
5	ICSCLAIM	CLIENT	T000	MANDT
6	ICSCLAIM	CLTYPEG	TICL011	VERSION
7	ICSCLAIM	CLTYPEV	TICL003	VERSION
8	ICSCLAIM	COMPLEX	TICL027	COMPLEX
9	ICSCLAIM	CREATEDBY	USR02	BNAME
10	ICSCLAIM	DATECHANGER	TICL029	DATECHANGER
11	ICSCLAIM	GENERAT	TICL320	VERSION
12	ICSCLAIM	JURISCOUNTRY	T005	LAND1
13	ICSCLAIM	JURISREGION	T005S	BLAND
14	ICSCLAIM	LOSSADDRESS	ADRC	ADDRNUMBER
15	ICSCLAIM	LOSSCAUSE	TICL009	LOSSCAUSE
16	ICSCLAIM	LOSSEVENT	ICLCCEVENT	CCEVENT
17	ICSCLAIM	LOSSTYPE	TICL062	LOSSTYPE
18	ICSCLAIM	LTIMEZONE	TTZZ	TZONE
19	ICSCLAIM	OWNERTYPE	T778O	OTYPE
20	ICSCLAIM	POLPROD	TICL320	POLPROD
21	ICSCLAIM	STATUS	TICL140	STATUS
22	ICSCLAIM	VERSION	TICL321	VERSION
23	ICSCLAIM	VIEWFAULT	TICL081	VIEWFAULT
24	ICSCLAIM	VIEWFAULTPH	TICL081	VIEWFAULT

History

Last changed by/on	SAP	20110901
SAP Release Created in