SAP ABAP Table ICL_SUBROREQITEM_S_AL (Subrogation/Recovery Receivable Item: Persistent/Log.Flds)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_SUBROGATION_AL (Package) Claims: Subrogation: Application Logic Layer

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_SUBROREQITEM_S_AL	Table Relationship Diagram
Short Description	Subrogation/Recovery Receivable Item: Persistent/Log.Flds

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	ITEMSUBCLTXT	☐	ICL_SUBCLTXT	CHAR30	CHAR	30	0	Long Text for Subclaim Consisting of Subclaim Type/Claimant
36	.INCLUDE	☐				0	0	Assignment of Payment Item to Subclaim/Coverage Type
37	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	*
38	SUBCLTYPE_NAME	☐	ICL_SUBCLTYPEN	TEXT25	CHAR	25	0	Subclaim Type Name
39	SUBCLTYPEDESC	☐	ICL_SUBCLDESCRIP	TEXT20	CHAR	20	0	Name of Claim/Subclaim
40	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
41	COVTYPE_NAME	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
42	INCURREDLOSS	☐	ICL_INCURREDLOSS	ICL_ITAMTS	CURR	15	2	Losses Incurred To Date
43	SUBCLAIM_REF	☐	ICL_SUBCL_REF_PAYI_D_AL	ICL_SUBCL	CHAR	3	0	Original Subclaim	*
44	PAYMENT_REF	☐	ICL_PAYMENT_REF_PAYI_D_AL	ICL_PAYMENT	NUMC	5	0	Number of Original Claim Payment	*
45	PAYMENTITEM_REF	☐	ICL_PAYMENTITEM_REF_PAYI_D_AL	ICL_PAYMENTITEM	NUMC	3	0	Original Claim Payment Item	*

Foreign Keys

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

History

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