SAP ABAP Table ICL_REPREIMB_CLAIM_ALV (Claim ALV)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_REPREIMB_CLAIM_ALV	Table Relationship Diagram
Short Description	Claim ALV

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

History

Last changed by/on	SAP	20110901
SAP Release Created in