SAP ABAP Table ICL_ITEMEQ (Extended ICLITEMEQ (Damaged Object))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_ITEMEQ	Table Relationship Diagram
Short Description	Extended ICLITEMEQ (Damaged Object)

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	Damaged Item
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	DAMAGEDOBJ	☐	ICL_DAMOBJEQ	ICL_DAMOBJ	NUMC	4	0	Damaged Item	ICLDAMOBJ
6	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
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	.INCLUDE	☐				0	0	Attributes of ICLITEMEQ
11	MAKE	☐	ICL_IOBMA	ICL_IOBMA	CHAR	4	0	Make of Insurable Object	ICLPROPMA
12	MODEL	☐	ICL_IOBMODEL	ICL_IOBMODEL	CHAR	4	0	Insurable Object Model	ICLPROPMO
13	CONSTYEAR	☐	ICL_PEQUIP02	BU_YEAR	NUMC	4	0	Construction Year of (Home Contents) Item
14	SERIALNO	☐	ICL_PEQUIP01	ICL_PEQUIP01	CHAR	12	0	Serial Number of (Home Contents) Item
15	LOCATION	☐	ICL_SCIAUADR	AD_ADDRNUM	CHAR	10	0	Location where damaged object can be seen	ADRC
16	LOSSTYPE	☐	ICL_ITEMAULT	ICL_ITEMAULT	CHAR	1	0	Scope of Loss	TICL101
17	PROPUSE	☐	ICL_IOBUSEL	ICL_IOBUSE	CHAR	2	0	Use at Time of Loss/Claim	TICL303
18	XDAMAGED	☐	ICL_ITEMES01	XFELD	CHAR	1	0	Flag: Damaged?
19	XRECOVERED	☐	ICL_ITEMWA02	XFELD	CHAR	1	0	Flag: Stolen Object Recovered?
20	XPVENDOR	☐	ICL_ITEMAU05	XFELD	CHAR	1	0	Flag: Willing to Use Preferred Vendor?
21	XSTOLEN	☐	ICL_ITEMPP01	XFELD	CHAR	1	0	Flag: Stolen?
22	XRENTAL	☐	ICL_ITEMPP02	XFELD	CHAR	1	0	Flag: Rental?
23	OPERABLE	☐	ICL_ITEMEQ01	ICL_UYN	CHAR	1	0	Home Contents/Object Operable?
24	ESTREPAIRDATE	☐	ICL_ITEMEQ02	DATE	DATS	8	0	Estimated Repair Date
25	ACTREPAIRDATE	☐	ICL_ITEMEQ03	DATE	DATS	8	0	Actual Repair Date
26	WHENSEEN	☐	ICL_ITEMEQ04	TEXT25	CHAR	25	0	Note on Inspection
27	XTOTDAMAGE	☐	ICL_ITEMAU11	XFELD	CHAR	1	0	Flag: Total Loss
28	.INCLUDE	☐				0	0	Attributes of ICLITEMEQ - Salvage
29	XOWNERRET	☐	ICL_SALVOWNRET	XFELD	CHAR	1	0	Flag: Retained by Owner?
30	EVALDATE	☐	ICL_SALVEVALDT	ICL_SALVEVALDT	DATS	8	0	Evaluation Date for Salvage
31	DETERMDATE	☐	ICL_SALVDETRDT	ICL_SALVDETRDT	DATS	8	0	Date: Damaged Objected Determined as Salvage
32	ESTACV	☐	ICL_SALVESTACV	ICL_RESAMOUNT	CURR	15	2	Salvage: Average Salvage Potential
33	SALVVALUE	☐	ICL_SALVVALUE	ICL_RESAMOUNT	CURR	15	2	Salvage Value as Amount of Money
34	CURR	☐	ICL_ACVCURR	WAERS	CUKY	5	0	Currency of Actual Cash Value	TCURC
35	HISTRATE	☐	ICL_HISTRATEI	ICL_PERCENT	DEC	5	2	History Rate in Percent
36	ASSIGNDATE	☐	ICL_ASSIGNDT	ICL_ASSIGNDT	DATS	8	0	Salvage: Date Assigned to Salvage Company
37	RETRVDATE	☐	ICL_RETRVDT	ICL_RETRVDT	DATS	8	0	Salvage: Arrival Date at Salvage Yard
38	SETTLEDATE	☐	ICL_SETTLEMENTDT	ICL_SETTLEMENTDT	DATS	8	0	Salvage: Settlement Date
39	SOLDDATE	☐	ICL_SALVSOLDD	DATE	DATS	8	0	Date Salvage Item Sold
40	TITLERECV	☐	ICL_TITLTOINS	ICL_TITLTOINS	DATS	8	0	Date on Which Insurer Received Title
41	NOTE	☐	ICL_SALVAGE_NOTE	TEXT50	CHAR	50	0	Note on Salvage
42	SEL_LOCATION	☐	ICL_INSPLOC	ICL_INSPLOC	CHAR	1	0	Location of Damaged Object
43	MAKENAME	☐	ICL_IOBMAN	TEXT25	CHAR	25	0	Name of Object Make
44	MODELNAME	☐	ICL_IOBMODELN	TEXT30	CHAR	30	0	Name of Insurable Object Model
45	XSETINGM	☐	ICLITEM01	CHAR01	CHAR	1	0	Flag: Place Value of Object in Global Memory

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_ITEMEQ	CHANGEDBY	USR02	BNAME
2	ICL_ITEMEQ	CLAIM	ICLCLAIM	CLAIM
3	ICL_ITEMEQ	CLIENT	T000	MANDT
4	ICL_ITEMEQ	CURR	TCURC	WAERS
5	ICL_ITEMEQ	DAMAGEDOBJ	ICLDAMOBJ	DAMAGEDOBJ
6	ICL_ITEMEQ	LOCATION	ADRC	ADDRNUMBER
7	ICL_ITEMEQ	LOSSTYPE	TICL101	LOSSTYPE	KEY	1	CN
8	ICL_ITEMEQ	MAKE	ICLPROPMA	PROPMAKE
9	ICL_ITEMEQ	MODEL	ICLPROPMO	PROPMODEL
10	ICL_ITEMEQ	PROPUSE	TICL303	PROPUSE

History

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