I_InsurClmFNOLInsrdVeh

Composite View Insured Vehicle Fnol | view: ICLFNOLINSRDVEH | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPARTOCC, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL321, ICLPOLOAU, TICL007T, TB008S, TB008U
Column Name Description
InsuranceContract FK Contract Number
InsurClmVehicle FK Insured Vehicle
Column Name Description
Column Name Description
📏 Unit for Cubic Capacity (InsurClmVehicleEngineCapUnit):
InsurClmVehicleEngineCapacity Engine Capacity of Insured Vehicle
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
Master Data Relations Join Conditions
Authorization Group
  • ?
  • Client
  • Authorization Group
  • I_INSURCLMFNOLINSRDVEH.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_INSURCLMFNOLINSRDVEH.MANDT == TB037.CLIENT
  • I_INSURCLMFNOLINSRDVEH.AUTHORIZATIONGROUP == TB037.AUGRP
Unit for Cubic Capacity
  • Client
  • Unit for Cubic Capacity
  • I_INSURCLMFNOLINSRDVEH.MANDT == T006.MANDT
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEENGINECAPUNIT == T006.MSEHI
Insured Object Model
  • ?
  • Client
  • Insured Object Model
  • Make of Insured Object
  • I_INSURCLMFNOLINSRDVEH.[column in domain "ICL_IOBCAT"] == ICLPROPMO.PROPCAT
  • I_INSURCLMFNOLINSRDVEH.MANDT == ICLPROPMO.CLIENT
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEMODEL == ICLPROPMO.PROPMODEL
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEMFR == ICLPROPMO.PROPMAKE
Country/Region Key
  • Client
  • Country/Region Key
  • I_INSURCLMFNOLINSRDVEH.MANDT == T005.MANDT
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEPLATECOUNTRY == T005.LAND1
Region (State, Province, County)
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEPLATEREGION == T005S.BLAND
  • I_INSURCLMFNOLINSRDVEH.MANDT == T005S.MANDT
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEPLATECOUNTRY == T005S.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Make of Insured Object
  • ?
  • Client
  • Make of Insured Object
  • I_INSURCLMFNOLINSRDVEH.[column in domain "ICL_IOBCAT"] == ICLPROPMA.PROPCAT
  • I_INSURCLMFNOLINSRDVEH.MANDT == ICLPROPMA.CLIENT
  • I_INSURCLMFNOLINSRDVEH.INSURCLMVEHICLEMFR == ICLPROPMA.PROPMAKE