I_InsurClmClaimValueHelp

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_InsurClmClaimValueHelp.
-- 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: IICLCLAIMVH

CREATE VIEW I_InsurClmClaimValueHelp AS
SELECT
  InsuranceClaim,
  InsuranceClaim AS InsuranceClaimForEdit,
  _PolicySnapshot.InsurancePolicy AS InsurancePolicy,
  InsuranceContract,
  InsurClmPolicyProduct,
  InsurClmPolicyProdGeneration,
  _ProductName[Language = $session.system_language].InsurClmPlcyProdName AS InsurClmPlcyProdName,
  InsurClmType,
  CreatedByUser,
  cast( _PolicySnapshot.InsurClmContractStartDateTime as icl_achangetime_fiori preserving type ) AS InsurClmContractStartDateTime,
  cast( _PolicySnapshot.InsurClmContractEndDateTime as icl_achangetime_fiori preserving type ) AS InsurClmContractEndDateTime,
  InsurClmLifeCycSts,
  _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName AS InsurClmLifeCycStsName,
  InsurClmIncdntType,
  _IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName AS InsurClmIncdntTypeName,
  InsurClmDateOfLoss,
  InsurClmAuthznGrp,
  InsurClmCauseOfLoss,
  _PolicyHolder.InsurClmPolicyHolderName AS InsurClmPolicyHolderName,
  _InsuredVehicle.InsurClmVehiclePlateNumber AS InsurClmVehiclePlateNumber,
  concat_with_space(_InsuredVehicle.InsurClmVehicleMfrTxt,_InsuredVehicle.InsurClmVehicleModelTxt,1) AS InsurClmInsrdVehMakeModelText
FROM I_InsuranceClaim
LEFT OUTER JOIN I_InsurClmPolicyHolderInquiry AS _PolicyHolder ON InsuranceClaim = _PolicyHolder.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClmStatus AS _ClaimStatus ON InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts  -- association [0..1]
LEFT OUTER JOIN I_InsurClmIncdntTypeText AS _IncidentTypeText ON InsurClmIncdntType = _IncidentTypeText.InsurClmIncdntType  -- association [0..*]
LEFT OUTER JOIN I_InsurClmInsuredVehInquiry AS _InsuredVehicle ON InsuranceClaim = _InsuredVehicle.InsuranceContract  -- association [1..1]
LEFT OUTER JOIN I_InsurClmProdNameVH AS _ProductName ON InsurClmPolicyProduct = _ProductName.InsurClmPolicyProduct AND InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration  -- association [1..1]
;