SAP ABAP Table IICL_SUBROGATION_DETAIL (Subrogation Items in Subrogation Case (Detail))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	IICL_SUBROGATION_DETAIL	Table Relationship Diagram
Short Description	Subrogation Items in Subrogation Case (Detail)

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 Payment Item
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	ICLCLAIM
5	SUBCLAIM	☐	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	ICLSUBCL
6	PAYMENT	☐	ICL_PAYMENT	ICL_PAYMENT	NUMC	5	0	Number of Claim Payment	ICLPAY
7	PAYMENTITEM	☐	ICL_PAYMENTITEM	ICL_PAYMENTITEM	NUMC	3	0	Claim Payment Item	*
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE	☐				0	0	Attributes of ICLPAYI
13	ITEMSUBCL	☐	ICL_ITEMSUBCLAIM	CHAR3	CHAR	3	0	Subclaim to Which a Payment Item Is Assigned
14	PAYITEMCAT	☐	ICL_PAYITEMCAT	ICL_PAYITEMCAT	CHAR	1	0	Claim Payment Item Category
15	PAMPAID	☐	ICL_SCLITEMAP	ICL_ITAMTS	CURR	15	2	Payment Amount
16	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
17	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
18	PYMTYPE	☐	ICL_PYMTYPE	ICL_PYMTYPE	CHAR	4	0	Tax Category	TICL551
19	PAYTYPEI	☐	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
20	TREASONSET	☐	ICL_PAYREASONSET	ICL_PAYREASONSET	CHAR	2	0	Payment Reason Group	TICL067
21	TREASON	☐	ICL_PAYREASON	ICL_PAYREASON	CHAR	4	0	Payment Reason	TICL066
22	GROSS_NET	☐	ICL_GROSS_NET	ICL_GROSS_NET	CHAR	1	0	Tax Category of Amount (Gross/Net)
23	TXCOD	☐	ICL_TXCOD	MWSKZ	CHAR	2	0	Tax Code	*
24	REQUESTED	☐	ICL_REQUESTED	ICL_ITAMTS	CURR	15	2	Amount Requested
25	POSTDATEI	☐	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
26	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	ICLITEM
27	REFNO	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
28	PAYITY	☐	ICL_PAYITY	ICL_PAYITY	CHAR	10	0	Payment Item Type	TICL291
29	REPID	☐	ICL_REPID		CHAR	10	0	Coinsurance Key
30	VALIDFROM	☐	ICL_PAYVALIDFROM	DATE	DATS	8	0	Payment Item: Valid From
31	VALIDTO	☐	ICL_PAYVALIDTO	DATE	DATS	8	0	Payment Item: Valid To
32	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
33	CDDOCITEM	☐	ICL_DOCITEM	ICL_DOCITEM	NUMC	4	0	Item Number in Payment Plan Document
34	REQUESTED_ORIG	☐	ICL_REQUESTED_ORIG	ICL_ITAMTS	CURR	15	2	Original Amount Requested
35	.INCLUDE	☐				0	0	Joint GUI Fields (Payments and Subrogation)
36	TREASONN	☐	ICL_TREASONN	TEXT60	CHAR	60	0	Name of Payment Reason
37	.INCLUDE	☐				0	0	Assignment of Payment Item to Subclaim/Coverage Type
38	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	*
39	SUBCLTYPE_NAME	☐	ICL_SUBCLTYPEN	TEXT25	CHAR	25	0	Subclaim Type Name
40	SUBCLTYPEDESC	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
41	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
42	COVTYPE_NAME	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
43	.INCLUDE	☐				0	0	Subrogation Item - GUI Fields Only (Derived from DB)
44	BENTYPE_NAME	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
45	ITEMTYPE	☐	ICL_ITEMTYPE	ICL_IOBTYPE	CHAR	3	0	Claim Item Object Type	*
46	ITEMTYPE_NAME	☐	ICL_ITEMTYPEN	TEXT30	CHAR	30	0	Claim Item Type Description
47	TREASONSETN	☐	ICL_PAYREASONSEN	TEXT50	CHAR	50	0	Name of Transaction Reason Code Class
48	CLAIMANT	☐	ICL_CLAIMANT	BU_PARTNER	CHAR	10	0	Claimant	*
49	CLAIMANTN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
50	INSCOMP	☐	ICL_INSCOMP	BU_PARTNER	CHAR	10	0	Insurance Company of Participant	*
51	INSCOMPN	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
52	XSUBRO	☐	ICL_SUBCL03	ICL_SUBCL03	CHAR	1	0	Subrogation/Recovery Status
53	PAIDLOSS	☐	ICL_PAIDLOSS	ICL_AMOUNT	CURR	15	2	Payments Made
54	DEDUCTIBLE	☐	ICL_DEDUCT	ICL_ITAMTS	CURR	15	2	Deductible
55	INCURREDLOSS	☐	ICL_INCURREDLOSS	ICL_ITAMTS	CURR	15	2	Losses Incurred To Date
56	INITIAL_RESERVE	☐	ICL_RESERVEFI	ICL_ITAMTS	CURR	15	2	Initial Reserve
57	SUBROPOT	☐	ICL_SUBROPOT	ICL_ITAMTS	CURR	15	2	Subrogation Potential
58	EXP_REIMB	☐	ICL_EXP_REIMB	ICL_ITAMTS	CURR	15	2	Expected Deductible to be Reimbursed
59	SUBRONEG	☐	ICL_SUBRONEG	ICL_ITAMTS	CURR	15	2	Negotiated Subrogation Amount
60	PAMRECEIVED	☐	ICL_RECEIVED	ICL_ITAMTS	CURR	15	2	Amount Received To Date Including Deductible
61	RECOVERED_LOSS	☐	ICL_RECOVERED_LOSS	ICL_ITAMTS	CURR	15	2	Recovered Loss
62	REIMB_DEDUCTIBLE	☐	ICL_REIMB_DED	ICL_ITAMTS	CURR	15	2	Portion of Deductible to Be Reimbursed

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	IICL_SUBROGATION_DETAIL	BENTYPE	TICL055	BENTYPE
2	IICL_SUBROGATION_DETAIL	CHANGEDBY	USR02	BNAME
3	IICL_SUBROGATION_DETAIL	CLAIM	ICLCLAIM	CLAIM
4	IICL_SUBROGATION_DETAIL	CLIENT	T000	MANDT
5	IICL_SUBROGATION_DETAIL	ITEM	ICLITEM	ITEM
6	IICL_SUBROGATION_DETAIL	PAYITY	TICL291	PAYITY
7	IICL_SUBROGATION_DETAIL	PAYMENT	ICLPAY	PAYMENT
8	IICL_SUBROGATION_DETAIL	PYMTYPE	TICL551	PYMTYPE
9	IICL_SUBROGATION_DETAIL	SUBCLAIM	ICLSUBCL	SUBCLAIM
10	IICL_SUBROGATION_DETAIL	TREASON	TICL066	TREASON	REF	C	CN
11	IICL_SUBROGATION_DETAIL	TREASONSET	TICL067	TREASONSET	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in