SAP ABAP Table ICLE_BULKSBR_REQI_ALV_S (Collective Subrogation/Recovery: ALV Subro/R Receivable Item)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_EVENT (Package) FS-CM: Claim Bundle

Basic Data

Table Category	INTTAB	Structure
Structure	ICLE_BULKSBR_REQI_ALV_S	Table Relationship Diagram
Short Description	Collective Subrogation/Recovery: ALV Subro/R Receivable 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	.INCLUDE	☐				0	0	Coll.Subrogation/Recovery: Subro/Recovery Receivable Item
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	BUNDLE	☐	ICL_CCEVENT	ICL_CCEVENT	CHAR	17	0	Claim Bundle	*
37	BILLING	☐	ICL_BULKSBR	ICL_BULKSBR	CHAR	3	0	Number of Collective Subrogation/Recovery Settlement	*
38	REQITEM_NR	☐	ICLE_BSR_REQ_ITEM	ICL_PAYMENTITEM	NUMC	3	0	Collective Subrogation/Recovery: Receivable Item	*
39	COVTYPEN	☐	ICL_COVTYPEN	TEXT50	CHAR	50	0	Name of Coverage Type
40	BENTYPEN	☐	ICL_BENTYPEN	ICL_BENTYPEN	CHAR	80	0	Benefit Type Name
41	REF_PAYITEM	☐	ICLE_REF_PAYITEM_BULKSBR_REQ_D	CHAR40	CHAR	40	0	Coll.Subrogatn/Recovery: Ref.of Receivable Item to Payt Item
42	ITSUBCL	☐	ICL_ITEMSUBCLAIM	CHAR3	CHAR	3	0	Subclaim to Which a Payment Item Is Assigned
43	PAYI_AMT	☐	ICLE_BSR_PAID_AMT_D	ICL_ITAMTS	CURR	15	2	Coll.Subrogation/Recovery: Amount of Associated Payment Item
44	RECEIVED	☐	ICLE_BSR_RECEIVED_AMT_D	ICL_ITAMTS	CURR	15	2	Collective Subrogation/Recovery Receivable Itm: Amt Receivd
45	CELLTAB_EDIT	☐	LVC_T_STYL		TTYP	0	0
46	CELLTAB_COLOR	☐	LVC_T_SCOL		TTYP	0	0

Foreign Keys

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

History

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