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

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_ICLITEMEV
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			AND	0	0
11	ICLITEM	EVALUATION	JL	EQ				0	0
12	ICLITEMEV	EVALUATION	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ICLITEM	CLIENT		☐	MANDT	☐	Client
2	ACTIVE	ICLITEM	ACTIVE		☐	ICL_ACTIVE	☐	Table entry is active (A) or in suspense (S)
3	CLAIM	ICLITEM	CLAIM		☐	ICL_CLAIM	☐	Number of Claim
4	SUBCLAIM	ICLITEM	SUBCLAIM		☐	ICL_SUBCL	☐	Subclaim
5	ITEM	ICLITEM	ITEM		☐	ICL_SCLITEM	☐	Claim Item
6	EVALUATION	ICLITEM	EVALUATION		☐	ICL_EVALUATION1	☐	Valid claim item evaluation
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	BENTYPE	ICLITEM	BENTYPE		☐	ICL_BENTYPE	☐	Benefit Type
11	ITEMTYPE	ICLITEM	ITEMTYPE		☐	ICL_ITEMTYPE	☐	Claim Item Object Type
12	DAMAGEDOBJ	ICLITEM	DAMAGEDOBJ		☐	ICL_DAMOBJ	☐	Damaged Object
13	STATUS	ICLITEM	STATUS		☐	ICL_SCLITEMS	☐	Status of Claim Item
14	REJREASON	ICLITEM	REJREASON		☐	ICL_REJREASON	☐	Claim Item Rejection Reason
15	DESCRIPTION	ICLITEM	DESCRIPTION		☐	ICL_DPDESC	☐	Claim Item Description
16	REFNO	ICLITEM	REFNO		☐	ICL_SCLITEMREF	☐	External Reference Number
17	XGENEROS	ICLITEM	XGENEROS		☐	ICL_XGENEROS	☐	Flag: Ex Gratia Payment?
18	PROCUREMENT	ICLITEM	PROCUREMENT		☐	ICL_PROCUREMENT	☐	ID of Claim Item Grouping
19	PDREF	ICLITEM	PDREF		☐	ICL_PDREF	☐	Reference to Purchasing Document
20	PDPOS	ICLITEM	PDPOS		☐	ICL_PDPOS	☐	Reference to Item Number in Purchasing Document
21	I_EVALUATION	ICLITEMEV	EVALUATION		☐	ICL_EVALUATION	☐	Claim Item Evaluation
22	I_CHANGETIME	ICLITEMEV	CHANGETIME		☐	ICL_CHANGEUTC1	☐	Changed: UTC Date+Time
23	I_CHANGEDBY	ICLITEMEV	CHANGEDBY		☐	ICL_CHANGEDBY	☐	Changed By
24	I_DELETED	ICLITEMEV	DELETED		☐	ICL_RECSTATUS	☐	Database Line Status (Original, Changed, Deleted)
25	EVALCAT	ICLITEMEV	EVALCAT		☐	ICL_EVALCAT	☐	Evaluation Category
26	EVAMOUNT	ICLITEMEV	EVAMOUNT		☐	ICL_EVAMOUNT	☐	Evaluated Amount
27	EVCURR	ICLITEMEV	EVCURR		☐	ICL_EVCURR	☐	Currency of Evaluated Amount
28	GROSNET	ICLITEMEV	GROSNET		☐	ICL_GROSNET	☐	Flag: Amount Is Net Amount
29	EVDATE	ICLITEMEV	EVDATE		☐	ICL_EVDATE	☐	Valuation Date
30	LIABRATE	ICLITEMEV	LIABRATE		☐	ICL_LIABRATEI	☐	Liability Rate in Percent
31	EVALBASE	ICLITEMEV	EVALBASE		☐	ICL_EVALBASE	☐	Type of Evaluator
32	CLMDAMOUNT	ICLITEMEV	CLMDAMOUNT		☐	ICL_CLMDAMOUNT	☐	Claimed Amount
33	EVAMTPERUNIT	ICLITEMEV	EVAMTPERUNIT		☐	ICL_EVAMTPERUNIT	☐	Amount per Unit
34	EVQUANTITY	ICLITEMEV	EVQUANTITY		☐	ICL_EVQUANTITY	☐	Claim Item: Number (Days, Visits, Area) for Evaluation
35	EVQUANUNIT	ICLITEMEV	EVQUANUNIT		☐	ICL_EVQUANUNIT	☐	Claim Item: Unit of Measurement
36	XARCHDOC	ICLITEMEV	XARCHDOC		☐	ICL_XARCHDOC	☐	Archived Document Assigned?
37	DNUMBER	ICLITEMEV	DNUMBER		☐	ICL_DNUMBER	☐	Number of Days
38	STARTDATE	ICLITEMEV	STARTDATE		☐	ICL_STARTDATE	☐	Start Date
39	ENDDATE	ICLITEMEV	ENDDATE		☐	ICL_ENDDATE	☐	End Date
40	PERDAY	ICLITEMEV	PERDAY		☐	ICL_PERDAY	☐	Amount per Day
41	OC	ICLITEMEV	OC		☐	ICL_OC	☐	Original Value
42	RC	ICLITEMEV	RC		☐	ICL_RC	☐	Original Cash Value
43	ACV	ICLITEMEV	ACV		☐	ICL_ACV	☐	Actual Cash Value
44	INUMBER	ICLITEMEV	INUMBER		☐	ICL_NUMBER	☐	Number
45	AGE	ICLITEMEV	AGE		☐	ICL_ITEMAGE	☐	Age of Item in Years
46	ACVPERCENT	ICLITEMEV	ACVPERCENT		☐	ICL_ACVPER	☐	Proportion of Actual Cash Value to Original Cash Value in %
47	RCORACV	ICLITEMEV	RCORACV		☐	ICL_RCORACV	☐	Flag: Use Actual Cash Value or Original Cash Value
48	CATALOGID	ICLITEMEV	CATALOGID		☐	ICL_CATALOGID	☐	Catalog ID
49	CATALOGITEM	ICLITEMEV	CATALOGITEM		☐	ICL_CATALOGITEM	☐	Catalog Item Number
50	MATNR	ICLITEMEV	MATNR		☐	MATNR	☐	Material Number
51	MATGROUP	ICLITEMEV	MATGROUP		☐	ICL_MATGROUP	☐	EBP: Material Group
52	PRICE_UNIT	ICLITEMEV	PRICE_UNIT		☐	EPEIN	☐	Price unit
53	VENDOR_CATALOG	ICLITEMEV	VENDOR_CATALOG		☐	ICL_SUPPL	☐	Supplier
54	VENDORMAT	ICLITEMEV	VENDORMAT		☐	ICL_VENDORMAT	☐	Product Number of Vendor
55	MANUFACTCODE	ICLITEMEV	MANUFACTCODE		☐	ICL_MANUFACTCODE	☐	EBP: Manufacturer Code
56	MANUFACTMAT	ICLITEMEV	MANUFACTMAT		☐	ICL_MANUFACTMAT	☐	EBP: Part Number of Manufacturer
57	SERVICE	ICLITEMEV	SERVICE		☐	ICL_SERVICE	☐	EBP: Service Flag
58	CUST_FIELD1	ICLITEMEV	CUST_FIELD1		☐	ICL_CUST_FIELD1	☐	BBP: Catalog - Customer Field 1
59	CUST_FIELD2	ICLITEMEV	CUST_FIELD2		☐	ICL_CUST_FIELD2	☐	BBP: Catalog - Customer Field 2
60	CUST_FIELD3	ICLITEMEV	CUST_FIELD3		☐	ICL_CUST_FIELD3	☐	BBP: Catalog - Customer Field 3
61	CUST_FIELD4	ICLITEMEV	CUST_FIELD4		☐	ICL_CUST_FIELD4	☐	BBP: Catalog - Customer Field 4
62	CUST_FIELD5	ICLITEMEV	CUST_FIELD5		☐	ICL_CUST_FIELD5	☐	BBP: Catalog - Customer Field 5

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	464