SAP ABAP Table ICSITEMEQ (Damaged Item)

Hierarchy

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

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSITEMEQ	Table Relationship Diagram
Short Description	Damaged Item

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in