SAP ABAP View V_ICLITEM (Database View for BW-Extraction of ICLITEM and ICLITEMEV)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_ICLITEM
Short Description	Database View for BW-Extraction of ICLITEM and ICLITEMEV
Root table	ICLITEM	Claim Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLITEM	ICLITEM
2	ICLITEMEV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLITEM	CLIENT	JL	EQ				0	0
2	ICLITEMEV	CLIENT	JR	EQ			AND	0	0
3	ICLITEM	ACTIVE	JL	EQ				0	0
4	ICLITEMEV	ACTIVE	JR	EQ			AND	0	0
5	ICLITEM	CLAIM	JL	EQ				0	0
6	ICLITEMEV	CLAIM	JR	EQ			AND	0	0
7	ICLITEM	SUBCLAIM	JL	EQ				0	0
8	ICLITEMEV	SUBCLAIM	JR	EQ			AND	0	0
9	ICLITEM	ITEM	JL	EQ				0	0
10	ICLITEMEV	ITEM	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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