C_InsurClmDamagedVehicleInqry

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 C_InsurClmDamagedVehicleInqry.
-- 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: CICLDAMVEHINQ

CREATE VIEW C_InsurClmDamagedVehicleInqry AS
SELECT
  I_InsurClmDamageVehicleDetails.InsuranceClaim AS InsuranceClaim,
  I_InsurClmDamageVehicleDetails.InsurClmDmgdSubObject AS InsurClmDmgdSubObject,
  InsurClmDamagedObject,
  InsurClmDamagedObjectLocation,
  InsurClmVehiclePlateNumber,
  concat_with_space(InsurClmVehicleMfrTxt, InsurClmInsuredObjectModel,1) AS InsurClmInsrdVehMakeModelText,
  cast(InsurClmVehicleMfrLogo as abap.sstring(260)) AS InsurClmVehicleMfrLogo,
  InsurClmConstructionYear,
  InsurClmVehicleIdentification,
  InsurClmVehicleMileage,
  InsurClmVehicleMileageUnit,
  InsurClmVehicleValueAmount,
  InsurClmVehObjectValCurrency,
  InsurClmInspectionDate,
  InsurClmDamageSeverity,
  _DmgdSvrtyTxt.InsurClmDamageSeverityName AS InsurClmDamageSeverityName,
  InsurClmProbableLossAmount,
  InsurClmProbableLossAmountCrcy,
  _SubclaimData.InsurClmSubclaimLbltyText AS InsurClmSubclaimLbltyText,
  _SubclaimData._SubclaimType.InsurClmSubclmLiability AS InsurClmSubclmLiability
FROM I_InsurClmDamageVehicleDetails
LEFT OUTER JOIN C_InsurClmFactCapture AS _FactsCapture ON InsuranceClaim = _FactsCapture.InsuranceClaim AND _FactsCapture.InsurClmFactCaptureCategory = 'DO' AND InsurClmDamagedObject = _FactsCapture.InsurClmSubobject  -- association [1..*]
LEFT OUTER JOIN C_InsurClmServiceProvider AS _ServiceProvider ON InsuranceClaim = _ServiceProvider.InsuranceClaim AND InsurClmDamagedObject = _ServiceProvider.InsurClmSubobject  -- association [1..*]
;