SAP ABAP Table ICSITEMAU (Damaged Vehicle)

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	ICSITEMAU	Table Relationship Diagram
Short Description	Damaged Vehicle

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_DAMOBJAU	ICL_DAMOBJ	NUMC	4	0	Damaged vehicle	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	Attribute/s of ICLITEMAU
10	PROPMAKE	☐	ICL_IOBMA	ICL_IOBMA	CHAR	4	0	Make of Insurable Object	ICLPROPMA
11	PROPMODEL	☐	ICL_IOBMODEL	ICL_IOBMODEL	CHAR	4	0	Insurable Object Model	ICLPROPMO
12	MODELTY	☐	ICL_IOBTY	ICL_IOBTY	CHAR	4	0	Insurable Object Category	ICLPROPTY
13	VIN	☐	ICL_VIN	CHAR17	CHAR	17	0	Vehicle Identification Number
14	PLATECOUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
15	PLATEREGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
16	PLATENO	☐	ICL_LICENSE	CHAR12	CHAR	12	0	License Plate Number
17	CONSTYEAR	☐	ICL_CONSTYEAR	BU_YEAR	NUMC	4	0	Construction Year of Insured Vehicle
18	FIRSTREG	☐	ICL_NOLDOAU04	DATS	DATS	8	0	Date of First Registration
19	CAPACITY	☐	ICL_CAPACITY	ICL_CAPACITY	QUAN	4	0	Engine Capacity of Insured Vehicle
20	CAPUNIT	☐	ICL_CAPUNIT	MEINS	UNIT	3	0	Unit for Cubic Capacity	T006
21	COLOR	☐	ICL_COLOR	CHAR10	CHAR	10	0	Color
22	GEAR	☐	ICL_GEAR	ICL_GEAR	CHAR	1	0	Gear Type
23	XTHIRDPARTY	☐	ICL_XLIAB	XFELD	CHAR	1	0	Flag: Liability?
24	LOCATION	☐	ICL_SCIAUADR	AD_ADDRNUM	CHAR	10	0	Location where damaged object can be seen	ADRC
25	INSPDATE	☐	ICL_INSPDATE	DATE	DATS	8	0	Inspection Date
26	WHENSEEN	☐	ICL_ITEMAU10	TEXT15	CHAR	15	0	Note on Inspection
27	PURPTRIP	☐	ICL_PURPTRIP	ICL_IOBUSE	CHAR	2	0	Purpose of Trip	*
28	LEASING	☐	ICL_LEASING	ICL_LEASING	CHAR	1	0	Flag: Paid/Leased/Security Certificate
29	XPERM	☐	ICL_ITEMAU01	XFELD	CHAR	1	0	Flag: Driving with permission?
30	XDAM	☐	ICL_ITEMAU02	XFELD	CHAR	1	0	Flag: Object Damaged?
31	XVEHICIT	☐	ICL_ITEMAU03	XFELD	CHAR	1	0	Flag: Vehicle Cited?
32	XDRIVCIT	☐	ICL_ITEMAU04	XFELD	CHAR	1	0	Flag: Driver Cited?
33	XPVENDOR	☐	ICL_ITEMAU05	XFELD	CHAR	1	0	Flag: Willing to Use Preferred Vendor?
34	XPARKED	☐	ICL_ITEMAU06	XFELD	CHAR	1	0	Vehicle Was Parked When Loss Occurred
35	XPRE	☐	ICL_ITEMAU07	XFELD	CHAR	1	0	Flag: Preexisting Damage?
36	DRIVABLE	☐	ICL_ITEMAUDR	XFELD	CHAR	1	0	Damaged Vehicle Is Not Roadworthy
37	MILEAGE	☐	ICL_MILEAGE	ICL_QUAN6	QUAN	6	0	Mileage
38	MILEAGEUNIT	☐	ICL_MILEAGEUNIT	MEINS	UNIT	3	0	Unit for mileage	T006
39	TREADF	☐	ICL_TREADF	ICL_TREAD	QUAN	2	0	Tread of Front Tires
40	TREADR	☐	ICL_TREADR	ICL_TREAD	QUAN	2	0	Tread of Rear Tires
41	TREADUNIT	☐	ICL_TREADUNIT	MEINS	UNIT	3	0	Tread Unit	T006
42	PCV	☐	ICL_PCV	ICL_ITAMT	CURR	15	2	Value of Object at Contract Conclusion
43	PCVCURR	☐	ICL_PCVCURR	WAERS	CUKY	5	0	Currency of Value at Conclusion of Policy	TCURC
44	OWPHREL	☐	ICL_OWPHREL	ICL_OWPHREL	CHAR	1	0	Relationship between Owner and PH
45	XTOTDAMAGE	☐	ICL_ITEMAU11	XFELD	CHAR	1	0	Flag: Total Loss
46	XSTOLEN	☐	ICL_ITEMPP01	XFELD	CHAR	1	0	Flag: Stolen?
47	XRECOVERED	☐	ICL_ITEMWA02	XFELD	CHAR	1	0	Flag: Stolen Object Recovered?
48	RECOVERDATE	☐	ICL_RECOVERDATE	DATS	DATS	8	0	Recovery Date of Object
49	.INCLUDE	☐				0	0	Attributes of Auto License Plate in ICLITEMAU
50	MONTH_FROM	☐	ICL_MONTHFROM	ICL_MONTH	NUMC	2	0	Month From Which Seasonal License Plate Issued
51	MONTH_TO	☐	ICL_MONTHTO	ICL_MONTH	NUMC	2	0	Month up to Which Seasonal License Plate Issued
52	OWNERCHANGE	☐	ICL_OWNERCHANGE	DATS	DATS	8	0	Last Change of Vehicle Owner: Date
53	GENERALINSP	☐	ICL_INSPECTION	ICL_INSPECTION	CHAR	7	0	Next Mandatory Technical Inspection
54	.INCLUDE	☐				0	0	Attributes of ICLITEMAU Salvage
55	CURR	☐	ICL_ACVCURR	WAERS	CUKY	5	0	Currency of Actual Cash Value	TCURC
56	SALVVALUE	☐	ICL_SALVVALUE	ICL_RESAMOUNT	CURR	15	2	Salvage Value as Amount of Money
57	ESTACV	☐	ICL_SALVESTACV	ICL_RESAMOUNT	CURR	15	2	Salvage: Average Salvage Potential
58	EVALDATE	☐	ICL_SALVEVALDT	ICL_SALVEVALDT	DATS	8	0	Evaluation Date for Salvage
59	DETERMDATE	☐	ICL_SALVDETRDT	ICL_SALVDETRDT	DATS	8	0	Date: Damaged Objected Determined as Salvage
60	DATEATRPR	☐	ICL_DTATRPR	ICL_DTATRPT	DATS	8	0	Salvage: Arrival Date at Repair Shop
61	RPTDTOCB	☐	ICL_RPTDTOCB	ICL_RPTDTOCB	DATS	8	0	Date Reported to Police
62	SOLDDATE	☐	ICL_SALVSOLDD	DATE	DATS	8	0	Date Salvage Item Sold
63	XOWNERRET	☐	ICL_SALVOWNRET	XFELD	CHAR	1	0	Flag: Retained by Owner?
64	HISTRATE	☐	ICL_HISTRATEI	ICL_PERCENT	DEC	5	2	History Rate in Percent
65	DAILYRATE	☐	ICL_DAILYRATESALV	ICL_RESAMOUNT	CURR	15	2	Salvage: Daily Standing Charges at Salvage Yard
66	ASSIGNDATE	☐	ICL_ASSIGNDT	ICL_ASSIGNDT	DATS	8	0	Salvage: Date Assigned to Salvage Company
67	RETRVDATE	☐	ICL_RETRVDT	ICL_RETRVDT	DATS	8	0	Salvage: Arrival Date at Salvage Yard
68	SETTLEDATE	☐	ICL_SETTLEMENTDT	ICL_SETTLEMENTDT	DATS	8	0	Salvage: Settlement Date
69	STOCKNUM	☐	ICL_SALVSTOCK	ICL_SALVSTOCK	CHAR	8	0	Salvage: Stock Number
70	YARDLOC	☐	ICL_SALVYARDLOC	ICL_SALVYARDLOC	CHAR	8	0	Salvage: Salvage Yard Location
71	TITLETOSALV	☐	ICL_SALVTITLEST	ICL_SALVTITLEST	DATS	8	0	Date on Which Title Was Transferred to Salvor
72	TITLEFMSALV	☐	ICL_SALVTITLERC	ICL_SALVTITLERC	DATS	8	0	Date on Which Title Was Received by Salvor
73	TITLETOSTATE	☐	ICL_TITLTOSTAT	ICL_TITLTOSTAT	DATS	8	0	Date: Title Sent To State
74	TITLEFMSTATE	☐	ICL_TITLFRMST	ICL_TITLFRMST	DATS	8	0	Date on Which Title Received by State
75	TITLERECV	☐	ICL_TITLTOINS	ICL_TITLTOINS	DATS	8	0	Date on Which Insurer Received Title
76	CERTFICATEDT	☐	ICL_PROVCERTDT	ICL_PROVCERTDT	DATS	8	0	Salvage: Certificate Date
77	.INCLUDE	☐				0	0	Claim Items - External Reference Numbers
78	REFNO	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
79	PDREF	☐	ICL_PDREF	ICL_PDREF_DOMAIN	CHAR	10	0	Reference to Purchasing Document
80	PDPOS	☐	ICL_PDPOS	ICL_PDPOS	NUMC	10	0	Reference to Item Number in Purchasing Document
81	REF_LOCCAT	☐	ICL_EXTSVCS_REFCAT	ICL_EXTSVCS_REFCAT	CHAR	2	0	Category of Reference Location for External Services	*
82	PTYPE	☐	ICL_PTYPE	ICL_PTYPE	CHAR	4	0	Transaction Type in Procurement Process	*
83	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	ICSITEMAU	CAPUNIT	T006	MSEHI
2	ICSITEMAU	CHANGEDBY	USR02	BNAME
3	ICSITEMAU	CLAIM	ICLCLAIM	CLAIM
4	ICSITEMAU	CLIENT	T000	MANDT
5	ICSITEMAU	CURR	TCURC	WAERS
6	ICSITEMAU	DAMAGEDOBJ	ICLDAMOBJ	DAMAGEDOBJ
7	ICSITEMAU	LOCATION	ADRC	ADDRNUMBER
8	ICSITEMAU	MILEAGEUNIT	T006	MSEHI	REF	C	CN
9	ICSITEMAU	MODELTY	ICLPROPTY	MODELTY
10	ICSITEMAU	PCVCURR	TCURC	WAERS
11	ICSITEMAU	PLATECOUNTRY	T005	LAND1
12	ICSITEMAU	PLATEREGION	T005S	BLAND
13	ICSITEMAU	PROPMAKE	ICLPROPMA	PROPMAKE
14	ICSITEMAU	PROPMODEL	ICLPROPMO	PROPMODEL
15	ICSITEMAU	TREADUNIT	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in