SAP ABAP Table ICL_MI_EDIT (Multiple Insurance Item)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_MULTIPLE_INSURANCE (Package) FS-CM: Multiple Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_MI_EDIT	Table Relationship Diagram
Short Description	Multiple Insurance Item

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	.INCLU-DP	☐				0	0	Distribution Plan
2	.INCLUDE	☐				0	0	Distribution Plan
3	CLIENTDP	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	ACTIVEDP	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
5	CLAIMDP	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
6	DIPL_IDDP	☐	ICL_MI_DIPL_ID	SYSUUID_C	CHAR	32	0	Distribution Plan ID
7	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
8	CHANGETIMEDP	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
9	CHANGEDBYDP	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
10	DELETEDDP	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
11	.INCLUDE	☐				0	0	Distribution Plan (Data Set ICLDIPL)
12	DIPL_NAMEDP	☐	ICL_MI_DIPL_NAME	ICL_MI_DIPL_NAME	CHAR	20	0	Name of Distribution Plan
13	DIPL_DESCRDP	☐	ICL_MI_DIPL_DESCR	ICL_MI_DIPL_DESCR	CHAR	100	0	Description of Distribution Plan
14	VALFR_TSDP	☐	ICL_MI_VALFR_TS	ICL_TIMESTAMP	DEC	15	0	Time Stamp From Which Distribution Plan Is Valid
15	VALTO_TSDP	☐	ICL_MI_VALTO_TS	ICL_TIMESTAMP	DEC	15	0	Time Stamp to Which Distribution Plan Is Valid
16	DIPLTYDP	☐	ICL_MI_DIPLTY	ICL_MI_DIPLTY	CHAR	10	0	Distribution Plan Type in Multiple Insurance	TICL285
17	PRIODP	☐	ICL_MI_PRIO	ICL_MI_PRIO	NUMC	2	0	Priority of Distribution Plan
18	CURRDP	☐	ICL_MI_CURR	WAERS	CUKY	5	0	Distribution Plan: Currency	TCURC
19	POLVNRDP	☐	ICL_POLVCNTR	ICL_POLVCNTR	NUMC	2	0	Counter of Contract Version	ICLPOL
20	COVTYPEDP	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	TICL322
21	XDIST_RESDP	☐	ICL_MI_DIST_RES	CHAR01	CHAR	1	0	Reserve Distribution Is Necessary
22	XFOREIGN_LEADDP	☐	ICL_MI_FOREIGN_LEAD	CHAR01	CHAR	1	0	Other Insurance Company Is Leading Insurer
23	VALFR_DADP	☐	ICL_MI_VALFR_DA		DATS	8	0	Date From Which Distribution Plan Is Valid
24	VALFR_TIDP	☐	ICL_MI_VALFR_TI		TIMS	6	0	Time From Which Distribution Plan Is Valid
25	VALFRDP	☐	ICL_MI_VALFR		CHAR	19	0	Date/Time from Which Distribution Plan Is Valid
26	VALTO_DADP	☐	ICL_MI_VALTO_DA		DATS	8	0	Date Up to Which Distribution Plan Is Valid
27	VALTO_TIDP	☐	ICL_MI_VALTO_TI		TIMS	6	0	Time to Which Distribution Plan Is Valid
28	VALTODP	☐	ICL_MI_VALTO		CHAR	19	0	Date/Time to Which Distribution Plan Is Valid
29	DIPLTY_DESCRDP	☐	ICL_MI_DIPLTY_DESCR	ICL_MI_DIPLTY_DESCR	CHAR	30	0	Description of Distribution Plan Type
30	COVTYPE_DESCRDP	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
31	.INCLU-DI	☐				0	0	Distribution Plan Item
32	.INCLUDE	☐				0	0	Distribution Plan Item
33	CLIENTDI	☐	MANDT	MANDT	CLNT	3	0	Client	T000
34	ACTIVEDI	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
35	CLAIMDI	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
36	DIPLIT_IDDI	☐	ICL_MI_DIPLIT_ID	SYSUUID_C	CHAR	32	0	Distribution Plan Item ID
37	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
38	CHANGETIMEDI	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
39	CHANGEDBYDI	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
40	DELETEDDI	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
41	.INCLUDE	☐				0	0	Distribution Plan Item (Data Set ICLDIPLIT)
42	SUBOBJECTDI	☐	ICL_SUBOBJECT	ICL_SUBOBJECT	CHAR	16	0	Claim Subobject
43	DIPL_IDDI	☐	ICL_MI_DIPL_ID	SYSUUID_C	CHAR	32	0	Distribution Plan ID	ICLDIPL
44	DIPLIT_NUMDI	☐	ICL_MI_DIPLIT_NUM	ICL_MI_DIPLIT_NUM	NUMC	3	0	Number of a Distribution Plan Item
45	PARTTYDI	☐	ICL_MI_PARTTY	ICL_MI_PARTTY	CHAR	10	0	Participation Type in Multiple Insurance	TICL286
46	SETTYDI	☐	ICL_MI_SETTY	ICL_MI_SETTY	CHAR	10	0	Settlement Type in Multiple Insurance	TICL287
47	X_OWN_SHAREDI	☐	ICL_MI_X_OWN_SHARE		CHAR	1	0	Flag for Share of Own Insurance in Multiple Insurance
48	SHARE_PRCDI	☐	ICL_MI_SHARE_PRC	ICL_PERCENT	DEC	5	2	Share of Participant in Multiple Insurance (Percentage)
49	SHARE_AMTDI	☐	ICL_MI_SHARE_AMT	ICL_ITAMT	CURR	15	2	Share of Participant in Multiple Insurance (Absolute)
50	REFDI	☐	ICL_MI_REF	ICL_MI_REF	CHAR	20	0	Reference
51	REPIDDI	☐	ICL_REPID		CHAR	10	0	Coinsurance Key	*
52	PARTNERDI	☐	ICL_MI_PARTNER	BU_PARTNER	CHAR	10	0	Participating BP in Multiple Insurance	*
53	PARTNER_DESCRDI	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
54	PARTTY_DESCRDI	☐	ICL_MI_PARTTY_DESCR	ICL_MI_PARTTY_DESCR	CHAR	30	0	Name of Participation Type
55	SETTY_DESCRDI	☐	ICL_MI_SETTY_DESCR	ICL_MI_SETTY_DESCR	CHAR	30	0	Description of Settlement Type
56	REPID_DESCRDI	☐	REPID_TEXT_VK	REPID_TEXT_VK	CHAR	40	0	Coinsurance Key Description
57	.INCLUDE	☐				0	0	Payment Item
58	.INCLUDE	☐				0	0	Claim Payment: Payment Items of a Payment
59	SEL	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
60	.INCLUDE	☐				0	0	Claim Payment Item
61	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
62	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
63	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
64	SUBCLAIM	☐	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	*
65	PAYMENT	☐	ICL_PAYMENT	ICL_PAYMENT	NUMC	5	0	Number of Claim Payment	*
66	PAYMENTITEM	☐	ICL_PAYMENTITEM	ICL_PAYMENTITEM	NUMC	3	0	Claim Payment Item	*
67	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
68	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
69	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
70	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
71	.INCLUDE	☐				0	0	Attributes of ICLPAYI
72	ITEMSUBCL	☐	ICL_ITEMSUBCLAIM	CHAR3	CHAR	3	0	Subclaim to Which a Payment Item Is Assigned
73	PAYITEMCAT	☐	ICL_PAYITEMCAT	ICL_PAYITEMCAT	CHAR	1	0	Claim Payment Item Category
74	PAMPAID	☐	ICL_SCLITEMAP	ICL_ITAMTS	CURR	15	2	Payment Amount
75	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	*
76	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
77	PYMTYPE	☐	ICL_PYMTYPE	ICL_PYMTYPE	CHAR	4	0	Tax Category	TICL551
78	PAYTYPEI	☐	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
79	TREASONSET	☐	ICL_PAYREASONSET	ICL_PAYREASONSET	CHAR	2	0	Payment Reason Group	TICL067
80	TREASON	☐	ICL_PAYREASON	ICL_PAYREASON	CHAR	4	0	Payment Reason	TICL066
81	GROSS_NET	☐	ICL_GROSS_NET	ICL_GROSS_NET	CHAR	1	0	Tax Category of Amount (Gross/Net)
82	TXCOD	☐	ICL_TXCOD	MWSKZ	CHAR	2	0	Tax Code	*
83	REQUESTED	☐	ICL_REQUESTED	ICL_ITAMTS	CURR	15	2	Amount Requested
84	POSTDATEI	☐	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
85	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
86	REFNO	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
87	PAYITY	☐	ICL_PAYITY	ICL_PAYITY	CHAR	10	0	Payment Item Type	TICL291
88	REPID	☐	ICL_REPID		CHAR	10	0	Coinsurance Key
89	VALIDFROM	☐	ICL_PAYVALIDFROM	DATE	DATS	8	0	Payment Item: Valid From
90	VALIDTO	☐	ICL_PAYVALIDTO	DATE	DATS	8	0	Payment Item: Valid To
91	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
92	CDDOCITEM	☐	ICL_DOCITEM	ICL_DOCITEM	NUMC	4	0	Item Number in Payment Plan Document
93	REQUESTED_ORIG	☐	ICL_REQUESTED_ORIG	ICL_ITAMTS	CURR	15	2	Original Amount Requested
94	TREASONN	☐	ICL_TREASONN	TEXT60	CHAR	60	0	Name of Payment Reason
95	DESCRIPTION	☐	ICL_CCDESC	TEXT132	CHAR	132	0	Description of Compensation Items
96	BENTYPENAME	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
97	PAMTYPE	☐	ICL_PAMTYPE	ICL_PAMTYPE	CHAR	1	0	Payment Amount Category of a Payment Item
98	CURR	☐	ICL_PAYMENTCUR	WAERS	CUKY	5	0	Claim Payment Currency	*
99	PAID	☐	ICL_PAID	BOOLE	CHAR	1	0	Has Claim Item Already Been Paid Out (Yes = "X")
100	FINALP	☐	ICL_FINALP	CHAR1	CHAR	1	0	Flag for Final Payment
101	HIERAR	☐	NUMC3	NUMC3	NUMC	3	0	Numc3, internal use
102	ITEMSUBCLTXT	☐	ICL_SUBCLTXT	CHAR30	CHAR	30	0	Long Text for Subclaim Consisting of Subclaim Type/Claimant
103	PYMTYPENAME	☐	ICL_PYMDESC	TEXT25	CHAR	25	0	Name of Tax Category
104	BPARTNER	☐	ICL_PPAYEE	BU_PARTNER	CHAR	10	0	Claim Payment Recipient	*
105	MAINTRANS	☐	ICL_MAINTRANS	ICL_MAINTRANS	CHAR	4	0	Main Transaction
106	SUBTRANS	☐	ICL_SUBTRANS	ICL_SUBTRANS	CHAR	4	0	Subtransaction
107	TAXRPTCT	☐	ICL_TAXRPTCT	QSSKZ	CHAR	2	0	Withholding Tax Code for Statutory Reporting	*
108	CURR_LOCAL	☐	ICL_PAYMENTCUR	WAERS	CUKY	5	0	Claim Payment Currency	*
109	PAMPAID_LOCAL	☐	ICL_PAMPAID	ICL_ITAMTS	CURR	15	2	Total Sum of Relevant Payment Orders
110	SKIP_BENTYPE_VALIDATION	☐	ICL_SKIP_VALIDATION	XFELD	CHAR	1	0	Skip Check
111	REF_BENTYPE	☐	ICL_REFBENTYPE	ICL_BENTYPE	CHAR	10	0	Referenced Benefit Type	*
112	.INCLUDE	☐				0	0	Assignment of Payment Item to Subclaim/Coverage Type
113	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	*
114	SUBCLTYPE_NAME	☐	ICL_SUBCLTYPEN	TEXT25	CHAR	25	0	Subclaim Type Name
115	SUBCLTYPEDESC	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
116	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
117	COVTYPE_NAME	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
118	.INCLUDE	☐				0	0	Subrogation Item - GUI Fields Only (Derived from DB)
119	BENTYPE_NAME	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
120	ITEMTYPE	☐	ICL_ITEMTYPE	ICL_IOBTYPE	CHAR	3	0	Claim Item Object Type	*
121	ITEMTYPE_NAME	☐	ICL_ITEMTYPEN	TEXT30	CHAR	30	0	Claim Item Type Description
122	TREASONSETN	☐	ICL_PAYREASONSEN	TEXT50	CHAR	50	0	Name of Transaction Reason Code Class
123	CLAIMANT	☐	ICL_CLAIMANT	BU_PARTNER	CHAR	10	0	Claimant	*
124	CLAIMANTN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
125	INSCOMP	☐	ICL_INSCOMP	BU_PARTNER	CHAR	10	0	Insurance Company of Participant	*
126	INSCOMPN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
127	XSUBRO	☐	ICL_SUBCL03	ICL_SUBCL03	CHAR	1	0	Subrogation/Recovery Status
128	PAIDLOSS	☐	ICL_PAIDLOSS	ICL_AMOUNT	CURR	15	2	Payments Made
129	DEDUCTIBLE	☐	ICL_DEDUCT	ICL_ITAMTS	CURR	15	2	Deductible
130	INCURREDLOSS	☐	ICL_INCURREDLOSS	ICL_ITAMTS	CURR	15	2	Losses Incurred To Date
131	INITIAL_RESERVE	☐	ICL_RESERVEFI	ICL_ITAMTS	CURR	15	2	Initial Reserve
132	SUBROPOT	☐	ICL_SUBROPOT	ICL_ITAMTS	CURR	15	2	Subrogation Potential
133	EXP_REIMB	☐	ICL_EXP_REIMB	ICL_ITAMTS	CURR	15	2	Expected Deductible to be Reimbursed
134	SUBRONEG	☐	ICL_SUBRONEG	ICL_ITAMTS	CURR	15	2	Negotiated Subrogation Amount
135	PAMRECEIVED	☐	ICL_RECEIVED	ICL_ITAMTS	CURR	15	2	Amount Received To Date Including Deductible
136	RECOVERED_LOSS	☐	ICL_RECOVERED_LOSS	ICL_ITAMTS	CURR	15	2	Recovered Loss
137	REIMB_DEDUCTIBLE	☐	ICL_REIMB_DED	ICL_ITAMTS	CURR	15	2	Portion of Deductible to Be Reimbursed
138	PAMTYPE_DESCR	☐	ICL_MI_PAMTYPE_DESCR	DDTEXT	CHAR	60	0	Amount Category
139	PAYITY_DESCR	☐	ICL_PAYITY_DESCR	ICL_PAYITY_DESCR	CHAR	30	0	Description of Payment Item Type
140	.INCLUDE	☐				0	0	Maintenance of Multiple Insurance Items
141	X_EDITED	☐	ICL_MI_X_EDITED		CHAR	1	0	Payment Amount Was Changed Manually
142	REPID_DESCR	☐	ICL_MI_REPID_DESCR_ALV		CHAR	40	0	Coinsurance Key Description
143	CT	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_MI_EDIT	CHANGEDBY	USR02	BNAME
2	ICL_MI_EDIT	CHANGEDBYDI	USR02	BNAME
3	ICL_MI_EDIT	CHANGEDBYDP	USR02	BNAME
4	ICL_MI_EDIT	CLAIMDI	ICLCLAIM	CLAIM
5	ICL_MI_EDIT	CLAIMDP	ICLCLAIM	CLAIM
6	ICL_MI_EDIT	CLIENT	T000	MANDT
7	ICL_MI_EDIT	CLIENTDI	T000	MANDT
8	ICL_MI_EDIT	CLIENTDP	T000	MANDT
9	ICL_MI_EDIT	COVTYPEDP	TICL322	COVTYPE
10	ICL_MI_EDIT	CURRDP	TCURC	WAERS
11	ICL_MI_EDIT	DIPLTYDP	TICL285	DIPLTY
12	ICL_MI_EDIT	DIPL_IDDI	ICLDIPL	DIPL_ID
13	ICL_MI_EDIT	PARTTYDI	TICL286	PARTTY
14	ICL_MI_EDIT	PAYITY	TICL291	PAYITY
15	ICL_MI_EDIT	POLVNRDP	ICLPOL	POLVNR
16	ICL_MI_EDIT	PYMTYPE	TICL551	PYMTYPE
17	ICL_MI_EDIT	SETTYDI	TICL287	SETTY
18	ICL_MI_EDIT	TREASON	TICL066	TREASON	REF	C	CN
19	ICL_MI_EDIT	TREASONSET	TICL067	TREASONSET	REF	C	CN

History

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