I_InsurClmChange

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_InsurClmChange.
-- 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: ICLCLAIMCHANGE

CREATE VIEW I_InsurClmChange AS
SELECT
  InsuranceClaim,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClaimUUID,
  InsurClmCauseOfLoss,
  InsuranceContract,
  InsurClmPolicyProduct,
  InsurClmDateOfLoss,
  ChangedOnDateTime,
  InsurClmLossLocAddressID,
  InsurClmAuthznGrp,
  InsurClmIncdntType,
  InsurClmComplexity,
  InsurClmLifeCycSts,
  InsurClmStatReason,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmTimeOfLoss,
  InsurClmReportedDate,
  InsurClmAgentReportedDate,
  InsurClmSensitiveClaim,
  InsurClmPolicyProdGeneration,
  _policy.InsurLineOfBus AS InsurLineOfBus,
  _PolicySnapshot.InsurClmContractStartDateTime AS InsurClmContractStartDateTime,
  _PolicySnapshot.InsurClmContractEndDateTime AS InsurClmContractEndDateTime,
  _IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName AS InsurClmIncdntTypeName,
  _ObjectAssign.InsuranceClaimObject AS InsurClaimBundle,
  _ComplexityText[ Language = $session.system_language ].InsurClmComplexityName AS InsurClmComplexityName,
  _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName AS InsurClmLifeCycStsName,
  _PolicyHolder.InsurClmPolicyHolderName AS InsurClmPolicyHolderName,
  _PolicyHolder.BusinessPartner AS InsurancePolicyholder,
  _LossLocationAddress.StreetName AS StreetName,
  _LossLocationAddress.CityName AS CityName,
  _LossLocationAddress.Region AS Region,
  _LossLocationAddress.PostalCode AS PostalCode,
  _LossLocationAddress.Country AS Country,
  _LossLocationAddress.HouseNumber AS HouseNumber,
  _LossType[ Language = $session.system_language ].InsurClmCauseOfLossName AS InsurClmCauseOfLossName
LEFT OUTER JOIN I_InsurClmLossCauseText AS _LossType ON InsurClmCauseOfLoss = _LossType.InsurClmCauseOfLoss  -- association [1..1]
LEFT OUTER JOIN I_Address AS _LossLocationAddress ON InsurClmLossLocAddressID = _LossLocationAddress.AddressID  -- association [0..1]
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_InsurClmComplexityText AS _ComplexityText ON InsurClmComplexity = _ComplexityText.InsurClmComplexity  -- association [0..*]
LEFT OUTER JOIN I_InsurClmObjectAssignmentBndl AS _ObjectAssign ON InsuranceClaim = _ObjectAssign.InsuranceClaim AND _ObjectAssign.InsurClmSubobjectCategory = 'C' AND _ObjectAssign.InsurClmObjectCategory = 'E' AND _ObjectAssign.IsDeleted = 'O'  -- association [1..1]
LEFT OUTER JOIN I_InsurClmIncdntTypeText AS _IncidentTypeText ON InsurClmIncdntType = _IncidentTypeText.InsurClmIncdntType  -- association [0..*]
LEFT OUTER JOIN I_InsurClmPolicySnapshot AS _policy ON InsuranceClaim = _policy.InsuranceClaim  -- association [1..1]
;