I_InsurClmDamageVehicleDetails

Damaged Vehicle for Claims Inquiry | view: IINSURCLMDAMGAU | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLITEMDD, ICLDAMOBJ, ICLITEMAU, ADCP, ADRC, ICLPROPMA
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmDamagedObject FK Damaged vehicle
InsurClmDamagedObjectLocation FK Location where damaged object can be seen
InsurClmDmgdSubObject Damaged Objects Occurrence Subobject
Column Name Description
💲 Currency of Value at Conclusion of Policy (InsurClmVehObjectValCurrency):
InsurClmVehicleValueAmount Value of Object at Contract Conclusion
InsurClmProbableLossAmount Probable Amount of Loss
Column Name Description
📏 Unit for mileage (InsurClmVehicleMileageUnit):
InsurClmVehicleMileage Mileage
Column Name Description
InsurClmInspectionDate Inspection Date
Column Name Description
Column Name Description Domain name
InsurClmVehicleMfrTxt Name of Object Make TEXT25
InsurClmVehicleMfrLogo URL of Logo of Object Make ICL_IOBMALOGOURL
InsurClmVehiclePlateNumber License Plate Number CHAR12
InsurClmConstructionYear Construction Year of Insured Vehicle BU_YEAR
InsurClmVehicleIdentification Vehicle Identification Number CHAR17
AddressID Address Number AD_ADDRNUM
CityName City TEXT40
HouseNumber House Number TEXT10
StreetName Street TEXT60
Master Data Relations | to Other Relations ↓ Join Conditions
Country key
  • Client
  • Country/Region Key
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == T005.MANDT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.COUNTRY == T005.LAND1
Damage Category
  • Client
  • Damage Category
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == TICL006.CLIENT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMDAMAGECATEGORY == TICL006.DAMAGECAT
Location where damaged object can be seen
  • Client
  • Location where damaged object can be seen
  • ?
  • ?
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == ADRC.CLIENT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMDAMAGEDOBJECTLOCATION == ADRC.ADDRNUMBER
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Insured Object Model
  • Client
  • ?
  • Insured Object Model
  • Make of Insured Object
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == ICLPROPMO.CLIENT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "ICL_IOBCAT"] == ICLPROPMO.PROPCAT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMINSUREDOBJECTMODEL == ICLPROPMO.PROPMODEL
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMINSUREDOBJECTMAKE == ICLPROPMO.PROPMAKE
Currency of Probable Amount of Loss
  • Client
  • Currency of Probable Amount of Loss
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == TCURC.MANDT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMPROBABLELOSSAMOUNTCRCY == TCURC.WAERS
Unit for mileage
  • Client
  • Unit for mileage
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == T006.MANDT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMVEHICLEMILEAGEUNIT == T006.MSEHI
Currency of Value at Conclusion of Policy
  • Client
  • Currency of Value at Conclusion of Policy
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == TCURC.MANDT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMVEHOBJECTVALCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Damage Severity
  • Client
  • Damage Severity
  • ?
  • ?
  • ?
  • Damage Category
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == TICL051.CLIENT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMDAMAGESEVERITY == TICL051.SEVERITY
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "ICL_CLTYPEV"] == TICL051.VERSION
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "ICL_CLTYPE"] == TICL051.CLTYPE
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "ICL_CLTYPEG"] == TICL051.GENERAT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMDAMAGECATEGORY == TICL051.DAMAGECAT
Make of Insured Object
  • Client
  • ?
  • Make of Insured Object
  • I_INSURCLMDAMAGEVEHICLEDETAILS.MANDT == ICLPROPMA.CLIENT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.[column in domain "ICL_IOBCAT"] == ICLPROPMA.PROPCAT
  • I_INSURCLMDAMAGEVEHICLEDETAILS.INSURCLMINSUREDOBJECTMAKE == ICLPROPMA.PROPMAKE