SAP ABAP Table ICL_ITEMAU (Extended ICLITEMAU (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	INTTAB	Structure
Structure	ICL_ITEMAU	Table Relationship Diagram
Short Description	Extended ICLITEMAU (Damaged Vehicle)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_ITEMAU	CAPUNIT	T006	MSEHI
2	ICL_ITEMAU	CHANGEDBY	USR02	BNAME
3	ICL_ITEMAU	CLAIM	ICLCLAIM	CLAIM
4	ICL_ITEMAU	CLIENT	T000	MANDT
5	ICL_ITEMAU	CURR	TCURC	WAERS
6	ICL_ITEMAU	DAMAGEDOBJ	ICLDAMOBJ	DAMAGEDOBJ
7	ICL_ITEMAU	LOCATION	ADRC	ADDRNUMBER
8	ICL_ITEMAU	MILEAGEUNIT	T006	MSEHI	REF	C	CN
9	ICL_ITEMAU	MODELTY	ICLPROPTY	MODELTY
10	ICL_ITEMAU	PCVCURR	TCURC	WAERS
11	ICL_ITEMAU	PLATECOUNTRY	T005	LAND1
12	ICL_ITEMAU	PLATEREGION	T005S	BLAND
13	ICL_ITEMAU	PROPMAKE	ICLPROPMA	PROPMAKE
14	ICL_ITEMAU	PROPMODEL	ICLPROPMO	PROPMODEL
15	ICL_ITEMAU	PURPTRIP	TICL303	PROPUSE	REF	C	CN
16	ICL_ITEMAU	TREADUNIT	T006	MSEHI	REF	C	CN

History

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