SAP ABAP Table ICL_BW_CLAIM (Extract Structure for Claim Data (ICLCLAIM))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_BW_CLAIM	Table Relationship Diagram
Short Description	Extract Structure for Claim Data (ICLCLAIM)

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

Foreign Keys

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

History

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