SAP ABAP Table ICL_BW_ITEM (Extract Structure for Claim Items incl. Evaluation)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_EXTRACT (Package) FS-CM: Claims Management: Data Extracts

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_BW_ITEM	Table Relationship Diagram
Short Description	Extract Structure for Claim Items incl. Evaluation

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	Generated Table for View
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_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	ICLSUBCL
6	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
7	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
8	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
9	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
10	ITEMCAT	☐	ICL_ITEMCAT	ICL_ITEMCAT	CHAR	2	0	Claim Item Category	TICL139
11	ITEMTYPE	☐	ICL_ITEMTYPE	ICL_IOBTYPE	CHAR	3	0	Claim Item Object Type	TICL164
12	ITEMUSE	☐	ICL_ITEMUSE	ICL_ITEMUSE	CHAR	2	0	Usage Type of Claim Item	TICL332
13	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
14	BENTYPE	☐	ICL_BENTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type	TICL055
15	RCOVTYPE	☐	ICL_RCOVTYPE	ICL_COVTYPE	CHAR	10	0	Benefit Coverage Type	*
16	XWAITPERIOD	☐	ICL_XWAITPERIOD	XFELD	CHAR	1	0	Probationary Periods Ignored
17	COVERAGE	☐	ICL_POLM	ICL_POLM	CHAR	4	0	Coverage	*
18	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
19	SERVCAT	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
20	SCPOSID_EXT	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
21	STATUS	☐	ICL_SCLITEMS	ICL_SCLITEMS	CHAR	2	0	Status of Claim Item
22	REJREASON	☐	ICL_REJREASON	ICL_REJREASON	CHAR	2	0	Claim Item Rejection Reason	TICL043
23	MODIFIED	☐	ICL_MODIFIED	XFELD	CHAR	1	0	Modified
24	PROCURED	☐	ICL_PROCURED	XFELD	CHAR	1	0	Ordered
25	CALCULATED	☐	ICL_CALCULATED	XFELD	CHAR	1	0	Calculated
26	DESCRIPTION	☐	ICL_DPDESC	TEXT40	CHAR	40	0	Claim Item Description
27	DAILY	☐	ICL_DAILY		NUMC	1	0	Daily
28	WEEKLY	☐	ICL_WEEKLY		NUMC	1	0	Weekly
29	MONTHLY	☐	ICL_MONTHLY		NUMC	2	0	Monthly
30	TOTAL	☐	ICL_TOTAL		NUMC	3	0	Total
31	VALIDFROM	☐	ICL_VALIDFROM	DATE	DATS	8	0	Claim Item: Valid From
32	VALIDTO	☐	ICL_VALIDTO	DATE	DATS	8	0	Claim Item: Valid To
33	STARTDATE	☐	ICL_STARTDATE	DATE	DATS	8	0	Start Date
34	ENDDATE	☐	ICL_ENDDATE	DATUM	DATS	8	0	End Date
35	DNUMBER	☐	ICL_NUMBER	DEC5	DEC	5	0	Number
36	EVALUATION	☐	ICL_EVALUATION1	ICL_EVALUATION	NUMC	2	0	Valid claim item evaluation	*
37	EVALCAT	☐	ICL_EVALCAT	ICL_EVALCAT	CHAR	2	0	Evaluation Category	*
38	EVALBASE	☐	ICL_EVALBASE	ICL_EVALBASE	CHAR	3	0	Type of Evaluator	TICL026
39	FACTOR	☐	ICLH_FACTOR	ICLH_FACTOR	DEC	7	4	Factor
40	ACV	☐	ICL_ACV	ICL_ITAMT	CURR	15	2	Actual Cash Value
41	ACVPERCENT	☐	ICL_ACVPER	ICL_PERCENT	DEC	5	2	Proportion of Actual Cash Value to Original Cash Value in %
42	CALCEXPRESSION	☐	ICL_CALC_EXPRESSION	BRF_EXPRESSION	CHAR	20	0	BRF Expression for Calculating Payout Amount	*
43	PERDAY	☐	ICL_PERDAY	ICL_ITAMT	CURR	15	2	Amount per Day
44	XDISCOUNTUSED	☐	ICL_XDISCOUNTUSED	BOOLE	CHAR	1	0	Discount Amount from Table Applied with Invoice
45	XDISCOUNTPERCENT	☐	ICL_XDISCOUNTPERCENT	BOOLE	CHAR	1	0	Discount Amount Without Reference to Percent Discount
46	XDISC_2B_APPLIED	☐	ICL_XDISC_2B_APPLIED	BOOLE	CHAR	1	0	Indicator: Discount to Be Applied
47	GROSNET	☐	ICL_GROSNET	XFELD	CHAR	1	0	Flag: Amount Is Net Amount
48	TXCOD	☐	ICL_TXCOD	MWSKZ	CHAR	2	0	Tax Code	*
49	SUBCLREF	☐	ICL_SUBCLREF	ICL_SUBCL	CHAR	3	0	Subclaim to Which a Claim Item Is Assigned	*
50	PROCUREMENT	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	ICLPROCURE
51	ITEM_REF	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
52	DAMAGEDOBJ	☐	ICL_DAMOBJ	ICL_DAMOBJ	NUMC	4	0	Damaged Object	ICLDAMOBJ
53	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
54	REFNO	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
55	PDREF	☐	ICL_PDREF	ICL_PDREF_DOMAIN	CHAR	10	0	Reference to Purchasing Document
56	PDPOS	☐	ICL_PDPOS	ICL_PDPOS	NUMC	10	0	Reference to Item Number in Purchasing Document
57	REF_LOCCAT	☐	ICL_EXTSVCS_REFCAT	ICL_EXTSVCS_REFCAT	CHAR	2	0	Category of Reference Location for External Services	*
58	PTYPE	☐	ICL_PTYPE	ICL_PTYPE	CHAR	4	0	Transaction Type in Procurement Process	*
59	XGENEROS	☐	ICL_XGENEROS	XFELD	CHAR	1	0	Flag: Ex Gratia Payment?
60	ADDITIONAL_ITEM	☐	ICL_ITEM_SPLIT_D	ICL_ITEM_SPLIT_DO	CHAR	1	0	Additional Claim Item
61	ADDIT_ITEM_SUM	☐	ICL_ITEM_SUM_D	XFELD	CHAR	1	0	Total of Additional Claim Items
62	REMUN_TYPE	☐	ICL_REMUN_TYPE_D_PE	ICL_REMUN_TYPE_D_PE	CHAR	4	0	Remuneration Category	ICL_CREMUNTYPE
63	EVDATE	☐	ICL_EVDATE	DATE	DATS	8	0	Valuation Date
64	LIABRATE	☐	ICL_LIABRATEI	ICL_PERCENT	DEC	5	2	Liability Rate in Percent
65	CLMDAMOUNT	☐	ICL_CLMDAMOUNT	ICL_ITAMTS	CURR	15	2	Claimed Amount
66	XARCHDOC	☐	ICL_XARCHDOC	XFELD	CHAR	1	0	Archived Document Assigned?
67	OC	☐	ICL_OC	ICL_ITAMT	CURR	15	2	Original Value
68	RC	☐	ICL_RC	ICL_ITAMT	CURR	15	2	Original Cash Value
69	INUMBER	☐	ICL_NUMBER	DEC5	DEC	5	0	Number
70	AGE	☐	ICL_ITEMAGE	NUMC2	NUMC	2	0	Age of Item in Years
71	RCORACV	☐	ICL_RCORACV	ICL_RCORACV	CHAR	1	0	Flag: Use Actual Cash Value or Original Cash Value
72	CATALOGID	☐	ICL_CATALOGID	ICL_CATALOGID	CHAR	4	0	Catalog ID	*
73	CATALOGITEM	☐	ICL_CATALOGITEM	CHAR40	CHAR	40	0	Catalog Item Number
74	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
75	MATGROUP	☐	ICL_MATGROUP	CHAR10	CHAR	10	0	EBP: Material Group
76	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
77	VENDOR_CATALOG	☐	ICL_SUPPL	BU_PARTNER	CHAR	10	0	Supplier	*
78	VENDORMAT	☐	ICL_VENDORMAT	CHAR22	CHAR	22	0	Product Number of Vendor
79	MANUFACTCODE	☐	ICL_MANUFACTCODE	CHAR10	CHAR	10	0	EBP: Manufacturer Code
80	MANUFACTMAT	☐	ICL_MANUFACTMAT	CHAR40	CHAR	40	0	EBP: Part Number of Manufacturer
81	SERVICE	☐	ICL_SERVICE	XFELD	CHAR	1	0	EBP: Service Flag
82	CUST_FIELD1	☐	ICL_CUST_FIELD1	CHAR10	CHAR	10	0	BBP: Catalog - Customer Field 1
83	CUST_FIELD2	☐	ICL_CUST_FIELD2	CHAR10	CHAR	10	0	BBP: Catalog - Customer Field 2
84	CUST_FIELD3	☐	ICL_CUST_FIELD3	CHAR10	CHAR	10	0	BBP: Catalog - Customer Field 3
85	CUST_FIELD4	☐	ICL_CUST_FIELD4	CHAR20	CHAR	20	0	BBP: Catalog - Customer Field 4
86	CUST_FIELD5	☐	ICL_CUST_FIELD5	CHAR50	CHAR	50	0	BBP: Catalog - Customer Field 5
87	I_EVALUATION	☐	ICL_EVALUATION	ICL_EVALUATION	NUMC	2	0	Claim Item Evaluation	*
88	I_CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
89	I_CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
90	I_DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
91	I_EVAMOUNT	☐	ICL_EVAMOUNT	ICL_ITAMTS	CURR	15	2	Evaluated Amount
92	I_EVAMTPERUNIT	☐	ICL_EVAMTPERUNIT	ICL_ITAMT	CURR	15	2	Amount per Unit
93	I_EVQUANTITY	☐	ICL_EVQUANTITY	ICL_LIMAMT	QUAN	10	3	Claim Item: Number (Days, Visits, Area) for Evaluation
94	I_EVQUANUNIT	☐	ICL_EVQUANUNIT	MEINS	UNIT	3	0	Claim Item: Unit of Measurement	T006
95	I_EVCURR	☐	ICL_EVCURR	WAERS	CUKY	5	0	Currency of Evaluated Amount	TCURC
96	EVAMTPERUNIT	☐	ICL_EVAMTPERUNIT	ICL_ITAMT	CURR	15	2	Amount per Unit
97	EVQUANTITY	☐	ICL_EVQUANTITY	ICL_LIMAMT	QUAN	10	3	Claim Item: Number (Days, Visits, Area) for Evaluation
98	EVQUANUNIT	☐	ICL_EVQUANUNIT	MEINS	UNIT	3	0	Claim Item: Unit of Measurement	*
99	EVAMOUNT	☐	ICL_EVAMOUNT	ICL_ITAMTS	CURR	15	2	Evaluated Amount
100	EVCURR	☐	ICL_EVCURR	WAERS	CUKY	5	0	Currency of Evaluated Amount	*
101	DISCOUNTPERCENT	☐	ICL_DISCOUNTPERCENT	ICL_PERCENT	DEC	5	2	Discount on Total Invoice Amount in Percent
102	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
103	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
104	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
105	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
106	REPAIRSHOP	☐	ICL_REPAIRSHOP	BU_PARTNER	CHAR	10	0	Repair Shop	*
107	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_BW_ITEM	BENTYPE	TICL055	BENTYPE
2	ICL_BW_ITEM	CHANGEDBY	USR02	BNAME
3	ICL_BW_ITEM	CLAIM	ICLCLAIM	CLAIM
4	ICL_BW_ITEM	CLAIMTYPE	TICL011	CLTYPE
5	ICL_BW_ITEM	CLIENT	T000	MANDT
6	ICL_BW_ITEM	DAMAGEDOBJ	ICLDAMOBJ	DAMAGEDOBJ
7	ICL_BW_ITEM	EVALBASE	TICL026	EVALBASE
8	ICL_BW_ITEM	ITEMCAT	TICL139	ITEMCAT	KEY	1	CN
9	ICL_BW_ITEM	ITEMTYPE	TICL164	ITEMTYPE
10	ICL_BW_ITEM	ITEMUSE	TICL332	ITEMUSE	KEY	1	CN
11	ICL_BW_ITEM	I_CHANGEDBY	USR02	BNAME
12	ICL_BW_ITEM	I_EVCURR	TCURC	WAERS
13	ICL_BW_ITEM	I_EVQUANUNIT	T006	MSEHI
14	ICL_BW_ITEM	PROCUREMENT	ICLPROCURE	PROCUREMENT
15	ICL_BW_ITEM	REJREASON	TICL043	REJREASON
16	ICL_BW_ITEM	REMUN_TYPE	ICL_CREMUNTYPE	REMUN_TYPE	KEY	1	CN
17	ICL_BW_ITEM	SUBCLAIM	ICLSUBCL	SUBCLAIM

History

Last changed by/on	SAP	20110901
SAP Release Created in	464