I_InsurClmInsuredVehInquiry

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InsurClmInsuredVehInquiry.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IICLINSVEHINQ

CREATE VIEW I_InsurClmInsuredVehInquiry AS
SELECT
  InsuranceContract,
  InsurClmVehicle,
  InsurClmVehicleMfr,
  InsurClmVehicleModel,
  InsurClmVIN,
  InsurClmVehiclePlateCountry,
  InsurClmVehiclePlateRegion,
  InsurClmVehiclePlateNumber,
  InsurClmVehicleModelYear,
  _ManufacturerTxt.InsurClmVehicleMfrTxt AS InsurClmVehicleMfrTxt,
  _ModelTxt.InsurClmVehicleModelTxt AS InsurClmVehicleModelTxt,
  concat_with_space( _ManufacturerTxt.InsurClmVehicleMfrTxt, _ModelTxt.InsurClmVehicleModelTxt, 1 ) AS InsurClmInsrdVehMakeModelText,
  _InsurClm.InsurClmType AS InsurClmType,
  _InsurClm.InsurClmAuthznGrp AS InsurClmAuthznGrp
FROM I_InsurClmInsuredVehicle
LEFT OUTER JOIN I_InsurClmVehicleMfrTxt AS _ManufacturerTxt ON _ManufacturerTxt.InsurClmVehicleMfr = InsurClmVehicleMfr AND _ManufacturerTxt.InsurClmVehicleCat = 'AU'  -- association [0..1]
LEFT OUTER JOIN I_InsurClmVehicleModelTxt AS _ModelTxt ON _ModelTxt.InsurClmVehicleMfr = InsurClmVehicleMfr AND _ModelTxt.InsurClmVehicleModel = InsurClmVehicleModel AND _ModelTxt.InsurClmVehicleCat = 'AU'  -- association [0..1]
LEFT OUTER JOIN I_InsuranceClaim AS _InsurClm ON InsuranceContract = _InsurClm.InsuranceClaim  -- association [1..1]
;