SAP ABAP Table V_ICLITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_ICLITEM	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	V_ICLITEM	BENTYPE	TICL055	BENTYPE
2	V_ICLITEM	CHANGEDBY	USR02	BNAME
3	V_ICLITEM	CLAIM	ICLCLAIM	CLAIM
4	V_ICLITEM	CLIENT	T000	MANDT
5	V_ICLITEM	DAMAGEDOBJ	ICLDAMOBJ	DAMAGEDOBJ
6	V_ICLITEM	EVALBASE	TICL026	EVALBASE
7	V_ICLITEM	EVALUATION	ICLITEMEV	EVALUATION
8	V_ICLITEM	EVCURR	TCURC	WAERS
9	V_ICLITEM	ITEMCAT	TICL139	ITEMCAT	KEY	1	CN
10	V_ICLITEM	ITEMTYPE	TICL164	ITEMTYPE
11	V_ICLITEM	ITEMUSE	TICL332	ITEMUSE	KEY	1	CN
12	V_ICLITEM	I_CHANGEDBY	USR02	BNAME
13	V_ICLITEM	I_EVCURR	TCURC	WAERS
14	V_ICLITEM	I_EVQUANUNIT	T006	MSEHI
15	V_ICLITEM	PROCUREMENT	ICLPROCURE	PROCUREMENT
16	V_ICLITEM	REJREASON	TICL043	REJREASON
17	V_ICLITEM	REMUN_TYPE	ICL_CREMUNTYPE	REMUN_TYPE	KEY	1	CN
18	V_ICLITEM	SUBCLAIM	ICLSUBCL	SUBCLAIM