ICSITEMAU

Damaged Vehicle | #transactional | Component: Claims Management
Column Name Description
CLIENT FK Client
ACTIVE Table entry is active (A) or in suspense (S) Show values
CLAIM FK Number of Claim
DAMAGEDOBJ FK Damaged vehicle
CHANGETIME Changed: Date + Time
Column Name Description
💲 Currency of Value at Conclusion of Policy (PCVCURR):
PCV Value of Object at Contract Conclusion
💲 Currency of Actual Cash Value (CURR):
SALVVALUE Salvage Value as Amount of Money
ESTACV Salvage: Average Salvage Potential
DAILYRATE Salvage: Daily Standing Charges at Salvage Yard
Column Name Description
📏 Unit for Cubic Capacity (ICLITEMAU.CAPUNIT):
CAPACITY Engine Capacity of Insured Vehicle
📏 Unit for mileage (ICLITEMAU.MILEAGEUNIT):
MILEAGE Mileage
📏 Tread Unit (ICLITEMAU.TREADUNIT):
TREADF Tread of Front Tires
TREADR Tread of Rear Tires
Column Name Description
FIRSTREG Date of First Registration
INSPDATE Inspection Date
RECOVERDATE Recovery Date of Object
OWNERCHANGE Last Change of Vehicle Owner: Date
EVALDATE Evaluation Date for Salvage
DETERMDATE Date: Damaged Objected Determined as Salvage
DATEATRPR Salvage: Arrival Date at Repair Shop
RPTDTOCB Date Reported to Police
SOLDDATE Date Salvage Item Sold
ASSIGNDATE Salvage: Date Assigned to Salvage Company
RETRVDATE Salvage: Arrival Date at Salvage Yard
SETTLEDATE Salvage: Settlement Date
TITLETOSALV Date on Which Title Was Transferred to Salvor
TITLEFMSALV Date on Which Title Was Received by Salvor
TITLETOSTATE Date: Title Sent To State
TITLEFMSTATE Date on Which Title Received by State
TITLERECV Date on Which Insurer Received Title
CERTFICATEDT Salvage: Certificate Date
Column Name Description
ACTIVE Table entry is active (A) or in suspense (S) Show values
DELETED Database Line Status (Original, Changed, Deleted) Show values
GEAR Gear Type Show values
XTHIRDPARTY Flag: Liability? Show values
LEASING Flag: Paid/Leased/Security Certificate Show values
XPERM Flag: Driving with permission? Show values
XDAM Flag: Object Damaged? Show values
XVEHICIT Flag: Vehicle Cited? Show values
XDRIVCIT Flag: Driver Cited? Show values
XPVENDOR Flag: Willing to Use Preferred Vendor? Show values
XPARKED Vehicle Was Parked When Loss Occurred Show values
XPRE Flag: Preexisting Damage? Show values
DRIVABLE Damaged Vehicle Is Not Roadworthy Show values
OWPHREL Relationship between Owner and PH Show values
XTOTDAMAGE Flag: Total Loss Show values
XSTOLEN Flag: Stolen? Show values
XRECOVERED Flag: Stolen Object Recovered? Show values
MONTH_FROM Month From Which Seasonal License Plate Issued Show values
MONTH_TO Month up to Which Seasonal License Plate Issued Show values
XOWNERRET Flag: Retained by Owner? Show values
SEL_LOCATION Location of Damaged Object Show values
Column Name Description Domain name
VIN Vehicle Identification Number CHAR17
PLATENO License Plate Number CHAR12
CONSTYEAR Construction Year of Insured Vehicle BU_YEAR
COLOR Color CHAR10
WHENSEEN Note on Inspection TEXT15
GENERALINSP Next Mandatory Technical Inspection ICL_INSPECTION
HISTRATE History Rate in Percent ICL_PERCENT
STOCKNUM Salvage: Stock Number ICL_SALVSTOCK
YARDLOC Salvage: Salvage Yard Location ICL_SALVYARDLOC
REFNO External Reference Number ICL_SCLITEMREF
PDREF Reference to Purchasing Document ICL_PDREF_DOMAIN
PDPOS Reference to Item Number in Purchasing Document ICL_PDPOS
REF_LOCCAT Reference Location for External Services ICL_EXTSVCS_REFCAT
PTYPE Transaction Type in Procurement Process ICL_PTYPE
Master Data Relations Join Conditions
Unit for Cubic Capacity
  • ICSITEMAU.CLIENT == T006.MANDT
  • ICSITEMAU.CAPUNIT == T006.MSEHI
Changed By
  • ICSITEMAU.CLIENT == USR02.MANDT
  • ICSITEMAU.CHANGEDBY == USR02.BNAME
Client ICSITEMAU.CLIENT == T000.MANDT
Currency of Actual Cash Value
  • ICSITEMAU.CLIENT == TCURC.MANDT
  • ICSITEMAU.CURR == TCURC.WAERS
Location where damaged object can be seen
  • Location where damaged object can be seen
  • ?
  • ?
  • ICSITEMAU.CLIENT == ADRC.CLIENT
  • ICSITEMAU.LOCATION == ADRC.ADDRNUMBER
  • ICSITEMAU.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • ICSITEMAU.[column in domain "AD_NATION"] == ADRC.NATION
Unit for mileage
  • ICSITEMAU.CLIENT == T006.MANDT
  • ICSITEMAU.MILEAGEUNIT == T006.MSEHI
Category of Insured Object
  • ?
  • Insured Object Model
  • Make of Insured Object
  • Category of Insured Object
Currency of Value at Conclusion of Policy
  • ICSITEMAU.CLIENT == TCURC.MANDT
  • ICSITEMAU.PCVCURR == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • ICSITEMAU.PLATECOUNTRY == T005.LAND1
  • ICSITEMAU.CLIENT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • ICSITEMAU.CLIENT == T005S.MANDT
  • ICSITEMAU.PLATECOUNTRY == T005S.LAND1
  • ICSITEMAU.PLATEREGION == T005S.BLAND
Insured Object Model
  • ?
  • Insured Object Model
  • Client
  • Make of Insured Object
  • ICSITEMAU.[column in domain "ICL_IOBCAT"] == ICLPROPMO.PROPCAT
  • ICSITEMAU.PROPMODEL == ICLPROPMO.PROPMODEL
  • ICSITEMAU.CLIENT == ICLPROPMO.CLIENT
  • ICSITEMAU.PROPMAKE == ICLPROPMO.PROPMAKE
Tread Unit
  • ICSITEMAU.CLIENT == T006.MANDT
  • ICSITEMAU.TREADUNIT == T006.MSEHI
Other Relations | to Master Data Relations ↑ Join Conditions
Make of Insured Object
  • ?
  • Make of Insured Object
  • Client
  • ICSITEMAU.[column in domain "ICL_IOBCAT"] == ICLPROPMA.PROPCAT
  • ICSITEMAU.PROPMAKE == ICLPROPMA.PROPMAKE
  • ICSITEMAU.CLIENT == ICLPROPMA.CLIENT