I_InsurClmInsuredVehInquiry

Insured Vehicle | view: IICLINSVEHINQ | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPOLOAU, ICLPROPMO, ICLPROPMA
Column Name Description
InsuranceContract FK Contract Number
InsurClmVehicle FK Insured Vehicle
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
InsurClmVIN Vehicle Identification Number CHAR17
InsurClmVehiclePlateNumber License Plate Number CHAR12
InsurClmVehicleModelYear Construction Year of Insured Vehicle BU_YEAR
InsurClmVehicleMfrTxt Name of Object Make TEXT25
InsurClmVehicleModelTxt Name of Object Model TEXT80
InsurClmInsrdVehMakeModelText null
Master Data Relations Join Conditions
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMINSUREDVEHINQUIRY.MANDT == TICL113.CLIENT
Internal Claim Type
  • Internal Claim Type
  • ?
  • Client
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMINSUREDVEHINQUIRY.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMINSUREDVEHINQUIRY.MANDT == TICL011.CLIENT
Insured Object Model
  • Make of Insured Object
  • Insured Object Model
  • ?
  • Client
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMVEHICLEMFR == ICLPROPMO.PROPMAKE
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMVEHICLEMODEL == ICLPROPMO.PROPMODEL
  • I_INSURCLMINSUREDVEHINQUIRY.[column in domain "ICL_IOBCAT"] == ICLPROPMO.PROPCAT
  • I_INSURCLMINSUREDVEHINQUIRY.MANDT == ICLPROPMO.CLIENT
Country/Region Key
  • Client
  • Country/Region Key
  • I_INSURCLMINSUREDVEHINQUIRY.MANDT == T005.MANDT
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMVEHICLEPLATECOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_INSURCLMINSUREDVEHINQUIRY.MANDT == T005S.MANDT
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMVEHICLEPLATECOUNTRY == T005S.LAND1
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMVEHICLEPLATEREGION == T005S.BLAND
Other Relations | to Master Data Relations ↑ Join Conditions
Make of Insured Object
  • Make of Insured Object
  • ?
  • Client
  • I_INSURCLMINSUREDVEHINQUIRY.INSURCLMVEHICLEMFR == ICLPROPMA.PROPMAKE
  • I_INSURCLMINSUREDVEHINQUIRY.[column in domain "ICL_IOBCAT"] == ICLPROPMA.PROPCAT
  • I_INSURCLMINSUREDVEHINQUIRY.MANDT == ICLPROPMA.CLIENT