SAP ABAP Table ICL_SUBROREQITEM_S_UI (Subrogation/Recovery Receivable Item incl.Fields of User IF)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_SUBROGATION_UI (Package) Claims: Subrogation: User Interface Layer

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_SUBROREQITEM_S_UI	Table Relationship Diagram
Short Description	Subrogation/Recovery Receivable Item incl.Fields of User IF

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	Subrogation/Recovery Receivable Item: Persistent/Log.Flds
2	.INCLUDE	☐				0	0	Claim Payment Item
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	ICLCLAIM
6	SUBCLAIM	☐	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	ICLSUBCL
7	PAYMENT	☐	ICL_PAYMENT	ICL_PAYMENT	NUMC	5	0	Number of Claim Payment	ICLPAY
8	PAYMENTITEM	☐	ICL_PAYMENTITEM	ICL_PAYMENTITEM	NUMC	3	0	Claim Payment Item	*
9	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
10	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
11	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
12	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
13	.INCLUDE	☐				0	0	Attributes of ICLPAYI
14	ITEMSUBCL	☐	ICL_ITEMSUBCLAIM	CHAR3	CHAR	3	0	Subclaim to Which a Payment Item Is Assigned
15	PAYITEMCAT	☐	ICL_PAYITEMCAT	ICL_PAYITEMCAT	CHAR	1	0	Claim Payment Item Category
16	PAMPAID	☐	ICL_SCLITEMAP	ICL_ITAMTS	CURR	15	2	Payment Amount
17	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
18	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
19	PYMTYPE	☐	ICL_PYMTYPE	ICL_PYMTYPE	CHAR	4	0	Tax Category	TICL551
20	PAYTYPEI	☐	ICL_PAYTYPE	ICL_PAYTYPE	CHAR	1	0	Payment Type (Final Payment, Payment After Closure of Claim)
21	TREASONSET	☐	ICL_PAYREASONSET	ICL_PAYREASONSET	CHAR	2	0	Payment Reason Group	TICL067
22	TREASON	☐	ICL_PAYREASON	ICL_PAYREASON	CHAR	4	0	Payment Reason	TICL066
23	GROSS_NET	☐	ICL_GROSS_NET	ICL_GROSS_NET	CHAR	1	0	Tax Category of Amount (Gross/Net)
24	TXCOD	☐	ICL_TXCOD	MWSKZ	CHAR	2	0	Tax Code	*
25	REQUESTED	☐	ICL_REQUESTED	ICL_ITAMTS	CURR	15	2	Amount Requested
26	POSTDATEI	☐	ICL_POSTDATE	DATE	DATS	8	0	Posting Date
27	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	ICLITEM
28	REFNO	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
29	PAYITY	☐	ICL_PAYITY	ICL_PAYITY	CHAR	10	0	Payment Item Type	TICL291
30	REPID	☐	ICL_REPID		CHAR	10	0	Coinsurance Key
31	VALIDFROM	☐	ICL_PAYVALIDFROM	DATE	DATS	8	0	Payment Item: Valid From
32	VALIDTO	☐	ICL_PAYVALIDTO	DATE	DATS	8	0	Payment Item: Valid To
33	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
34	CDDOCITEM	☐	ICL_DOCITEM	ICL_DOCITEM	NUMC	4	0	Item Number in Payment Plan Document
35	REQUESTED_ORIG	☐	ICL_REQUESTED_ORIG	ICL_ITAMTS	CURR	15	2	Original Amount Requested
36	ITEMSUBCLTXT	☐	ICL_SUBCLTXT	CHAR30	CHAR	30	0	Long Text for Subclaim Consisting of Subclaim Type/Claimant
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	INCURREDLOSS	☐	ICL_INCURREDLOSS	ICL_ITAMTS	CURR	15	2	Losses Incurred To Date
44	SUBCLAIM_REF	☐	ICL_SUBCL_REF_PAYI_D_AL	ICL_SUBCL	CHAR	3	0	Original Subclaim	*
45	PAYMENT_REF	☐	ICL_PAYMENT_REF_PAYI_D_AL	ICL_PAYMENT	NUMC	5	0	Number of Original Claim Payment	*
46	PAYMENTITEM_REF	☐	ICL_PAYMENTITEM_REF_PAYI_D_AL	ICL_PAYMENTITEM	NUMC	3	0	Original Claim Payment Item	*
47	PAYITEMCATN	☐	ICL_PAYITEMCATN	DDTEXT	CHAR	60	0	Name of Category of Claim Payment Item
48	TREASONN	☐	ICL_TREASONN	TEXT60	CHAR	60	0	Name of Payment Reason
49	BENTYPENAME	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
50	XSELECT	☐	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
51	CELLTAB	☐	LVC_T_STYL		TTYP	0	0

Foreign Keys

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

History

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