ICLITEMAU SAP (Damaged Vehicle) Table details
Dictionary Type: Table
Description: Damaged Vehicle
Description: Damaged Vehicle
Table field list including key, data, relationships and ABAP select examples
ICLITEMAU is a standard SAP Table which is used to store Damaged Vehicle data and is available within R/3 SAP systems depending on the version and release level.
The ICLITEMAU table consists of various fields, each holding specific information or linking keys about Damaged Vehicle data available in SAP. These include ACTIVE (Table entry is active (A) or in suspense (S)), CLAIM (Number of Claim), DAMAGEDOBJ (Damaged vehicle), CHANGETIME (Changed: Date + Time).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ICLITEMAU table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ACTIVE | Table entry is active (A) or in suspense (S) | ICL_ACTIVE | CHAR | 1 | ICL_ACTIVE | ||||
CLAIM | Number of Claim | ICL_CLAIM | CHAR | 17 | ICLCLAIM | ALPHA | ICL_CLAIM | ICL_CLAIM | ICL_CLAIMNO_COL |
DAMAGEDOBJ | Damaged vehicle | ICL_DAMOBJAU | NUMC | 4 | ICLDAMOBJ | ICL_DAMOBJ | |||
CHANGETIME | Changed: Date + Time | ICL_CHANGEUTC1 | DEC | 15 | TSTAM | ICL_TIMESTAMP | |||
CHANGEDBY | Changed By | ICL_CHANGEDBY | CHAR | 12 | USR02 | XUBNAME | |||
DELETED | Database Line Status (Original, Changed, Deleted) | ICL_RECSTATUS | CHAR | 1 | ICL_RECSTATUS | ||||
PROPMAKE | Make of Insured Object | ICL_IOBMA | CHAR | 4 | ICLPROPMA | ICL_IOBMA | |||
PROPMODEL | Insured Object Model | ICL_IOBMODEL | CHAR | 4 | ICLPROPMO | ICL_IOBMODEL | |||
MODELTY | Category of Insured Object | ICL_IOBTY | CHAR | 4 | ICLPROPTY | ICL_IOBTY | |||
VIN | Vehicle Identification Number | ICL_VIN | CHAR | 17 | CHAR17 | ||||
PLATECOUNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
PLATEREGION | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
PLATENO | License Plate Number | ICL_LICENSE | CHAR | 12 | CHAR12 | ||||
CONSTYEAR | Construction Year of Insured Vehicle | ICL_CONSTYEAR | NUMC | 4 | BU_YEAR | ||||
FIRSTREG | Date of First Registration | ICL_NOLDOAU04 | DATS | 8 | DATS | ||||
CAPACITY | Engine Capacity of Insured Vehicle | ICL_CAPACITY | QUAN | 4 | ICL_CAPACITY | ||||
CAPUNIT | Unit for Cubic Capacity | ICL_CAPUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
COLOR | Color | ICL_COLOR | CHAR | 10 | CHAR10 | ||||
GEAR | Gear Type | ICL_GEAR | CHAR | 1 | ICL_GEAR | ||||
XTHIRDPARTY | Flag: Liability? | ICL_XLIAB | CHAR | 1 | XFELD | ||||
LOCATION | Location where damaged object can be seen | ICL_SCIAUADR | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
INSPDATE | Inspection Date | ICL_INSPDATE | DATS | 8 | DATE | ||||
WHENSEEN | Note on Inspection | ICL_ITEMAU10 | CHAR | 15 | TEXT15 | ||||
PURPTRIP | Purpose of Trip | ICL_PURPTRIP | CHAR | 2 | TICL303 | ICL_IOBUSE | |||
LEASING | Flag: Paid/Leased/Security Certificate | ICL_LEASING | CHAR | 1 | ICL_LEASING | ||||
XPERM | Flag: Driving with permission? | ICL_ITEMAU01 | CHAR | 1 | XFELD | ||||
XDAM | Flag: Object Damaged? | ICL_ITEMAU02 | CHAR | 1 | XFELD | ||||
XVEHICIT | Flag: Vehicle Cited? | ICL_ITEMAU03 | CHAR | 1 | XFELD | ||||
XDRIVCIT | Flag: Driver Cited? | ICL_ITEMAU04 | CHAR | 1 | XFELD | ||||
XPVENDOR | Flag: Willing to Use Preferred Vendor? | ICL_ITEMAU05 | CHAR | 1 | XFELD | ||||
XPARKED | Vehicle Was Parked When Loss Occurred | ICL_ITEMAU06 | CHAR | 1 | XFELD | ||||
XPRE | Flag: Preexisting Damage? | ICL_ITEMAU07 | CHAR | 1 | XFELD | ||||
DRIVABLE | Damaged Vehicle Is Not Roadworthy | ICL_ITEMAUDR | CHAR | 1 | XFELD | ||||
MILEAGE | Mileage | ICL_MILEAGE | QUAN | 6 | ICL_QUAN6 | ||||
MILEAGEUNIT | Unit for mileage | ICL_MILEAGEUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ICL_MILEAGEUNIT | |
TREADF | Tread of Front Tires | ICL_TREADF | QUAN | 2 | ICL_TREAD | ||||
TREADR | Tread of Rear Tires | ICL_TREADR | QUAN | 2 | ICL_TREAD | ||||
TREADUNIT | Tread Unit | ICL_TREADUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PCV | Value of Object at Contract Conclusion | ICL_PCV | CURR | 15(2) | ICL_ITAMT | ||||
PCVCURR | Currency of Value at Conclusion of Policy | ICL_PCVCURR | CUKY | 5 | TCURC | WAERS | |||
OWPHREL | Relationship between Owner and PH | ICL_OWPHREL | CHAR | 1 | ICL_OWPHREL | ||||
XTOTDAMAGE | Flag: Total Loss | ICL_ITEMAU11 | CHAR | 1 | XFELD | ||||
XSTOLEN | Flag: Stolen? | ICL_ITEMPP01 | CHAR | 1 | XFELD | ||||
XRECOVERED | Flag: Stolen Object Recovered? | ICL_ITEMWA02 | CHAR | 1 | XFELD | ||||
RECOVERDATE | Recovery Date of Object | ICL_RECOVERDATE | DATS | 8 | DATS | ||||
MONTH_FROM | Month From Which Seasonal License Plate Issued | ICL_MONTHFROM | NUMC | 2 | ICL_MONTH | ||||
MONTH_TO | Month up to Which Seasonal License Plate Issued | ICL_MONTHTO | NUMC | 2 | ICL_MONTH | ||||
OWNERCHANGE | Last Change of Vehicle Owner: Date | ICL_OWNERCHANGE | DATS | 8 | DATS | ||||
GENERALINSP | Next Mandatory Technical Inspection | ICL_INSPECTION | CHAR | 7 | INSPE | ICL_INSPECTION | |||
CURR | Currency of Actual Cash Value | ICL_ACVCURR | CUKY | 5 | TCURC | WAERS | |||
SALVVALUE | Salvage Value as Amount of Money | ICL_SALVVALUE | CURR | 15(2) | ICL_RESAMOUNT | ||||
ESTACV | Salvage: Average Salvage Potential | ICL_SALVESTACV | CURR | 15(2) | ICL_RESAMOUNT | ||||
EVALDATE | Evaluation Date for Salvage | ICL_SALVEVALDT | DATS | 8 | ICL_SALVEVALDT | ||||
DETERMDATE | Date: Damaged Objected Determined as Salvage | ICL_SALVDETRDT | DATS | 8 | ICL_SALVDETRDT | ||||
DATEATRPR | Salvage: Arrival Date at Repair Shop | ICL_DTATRPR | DATS | 8 | ICL_DTATRPT | ||||
RPTDTOCB | Date Reported to Police | ICL_RPTDTOCB | DATS | 8 | ICL_RPTDTOCB | ||||
SOLDDATE | Date Salvage Item Sold | ICL_SALVSOLDD | DATS | 8 | DATE | ||||
XOWNERRET | Flag: Retained by Owner? | ICL_SALVOWNRET | CHAR | 1 | XFELD | ||||
HISTRATE | History Rate in Percent | ICL_HISTRATEI | DEC | 5(2) | ICL_PERCENT | ||||
DAILYRATE | Salvage: Daily Standing Charges at Salvage Yard | ICL_DAILYRATESALV | CURR | 15(2) | ICL_RESAMOUNT | ||||
ASSIGNDATE | Salvage: Date Assigned to Salvage Company | ICL_ASSIGNDT | DATS | 8 | ICL_ASSIGNDT | ||||
RETRVDATE | Salvage: Arrival Date at Salvage Yard | ICL_RETRVDT | DATS | 8 | ICL_RETRVDT | ||||
SETTLEDATE | Salvage: Settlement Date | ICL_SETTLEMENTDT | DATS | 8 | ICL_SETTLEMENTDT | ||||
STOCKNUM | Salvage: Stock Number | ICL_SALVSTOCK | CHAR | 8 | ICL_SALVSTOCK | ||||
YARDLOC | Salvage: Salvage Yard Location | ICL_SALVYARDLOC | CHAR | 8 | ICL_SALVYARDLOC | ||||
TITLETOSALV | Date on Which Title Was Transferred to Salvor | ICL_SALVTITLEST | DATS | 8 | ICL_SALVTITLEST | ||||
TITLEFMSALV | Date on Which Title Was Received by Salvor | ICL_SALVTITLERC | DATS | 8 | ICL_SALVTITLERC | ||||
TITLETOSTATE | Date: Title Sent To State | ICL_TITLTOSTAT | DATS | 8 | ICL_TITLTOSTAT | ||||
TITLEFMSTATE | Date on Which Title Received by State | ICL_TITLFRMST | DATS | 8 | ICL_TITLFRMST | ||||
TITLERECV | Date on Which Insurer Received Title | ICL_TITLTOINS | DATS | 8 | ICL_TITLTOINS | ||||
CERTFICATEDT | Salvage: Certificate Date | ICL_PROVCERTDT | DATS | 8 | ICL_PROVCERTDT | ||||
REFNO | External Reference Number | ICL_SCLITEMREF | CHAR | 15 | ICL_SCLITEMREF | ||||
PDREF | Reference to Purchasing Document | ICL_PDREF | CHAR | 10 | ICL_PDREF_DOMAIN | ||||
PDPOS | Reference to Item Number in Purchasing Document | ICL_PDPOS | NUMC | 10 | ICL_PDPOS | ||||
REF_LOCCAT | Reference Location for External Services | ICL_EXTSVCS_REFCAT | CHAR | 2 | Assigned to domain | ICL_EXTSVCS_REFCAT | |||
PTYPE | Transaction Type in Procurement Process | ICL_PTYPE | CHAR | 4 | Assigned to domain | ICL_PTYPE | |||
SEL_LOCATION | Location of Damaged Object | ICL_INSPLOC | CHAR | 1 | ICL_INSPLOC |
Key field | Non-key field |
How do I retrieve data from SAP table ICLITEMAU using ABAP code
The following ABAP code Example will allow you to do a basic selection on ICLITEMAU to SELECT all data from the tableDATA: WA_ICLITEMAU TYPE ICLITEMAU.
SELECT SINGLE *
FROM ICLITEMAU
INTO CORRESPONDING FIELDS OF WA_ICLITEMAU
WHERE...
How to access SAP table ICLITEMAU
Within an ECC or HANA version of SAP you can also view further information about ICLITEMAU and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects