I_InsurClm1stNotif

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_InsurClm1stNotif.
-- 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: ICL1STNF

CREATE VIEW I_InsurClm1stNotif AS
SELECT
  InsuranceClaim,
  InsuranceContract,
  ChangedOnDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmAuthznGrp,
  I_InsuranceClaim.InsurClmIncdntType AS InsurClmIncdntType,
  InsurClmDateOfLoss,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  I_InsuranceClaim.InsurClmPolicyProduct AS InsurClmPolicyProduct,
  I_InsuranceClaim.InsurClmPolicyProdGeneration AS InsurClmPolicyProdGeneration,
  I_InsuranceClaim.InsurClmPolicyProductVersion AS InsurClmPolicyProductVersion,
  _PolicyHolder.BusinessPartner AS InsurancePolicyholder
FROM I_InsuranceClaim
LEFT OUTER JOIN I_InsurClm1stNotifContract AS _Contract ON InsuranceContract = _Contract.InsuranceContract  -- association [1..1]
LEFT OUTER JOIN I_InsurClmIncdntType AS _IncidentType ON InsurClmPolicyProduct = _IncidentType.InsurClmPolicyProduct AND InsurClmPolicyProdGeneration = _IncidentType.InsurClmPolicyProdGeneration AND InsurClmPolicyProductVersion = _IncidentType.InsurClmPolicyProductVersion AND InsurClmIncdntType = _IncidentType.InsurClmIncdntType  -- association [1..1]
LEFT OUTER JOIN I_InsurClmLossCause AS _LossCause ON InsurClmType = _LossCause.InsurClmType AND InsurClmTypeGeneration = _LossCause.InsurClmTypeGeneration AND InsurClmTypeVers = _LossCause.InsurClmTypeVers AND InsurClmCauseOfLoss = _LossCause.InsurClmCauseOfLoss  -- association [0..1]
LEFT OUTER JOIN I_InsurClm1stNotifDmgdVeh AS _DamagedVehicle ON InsuranceClaim = _DamagedVehicle.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_InsurClm1stNotifNote AS _Note ON InsuranceClaim = _Note.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_InsurClmHandler AS _ClaimHandler ON InsuranceClaim = _ClaimHandler.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPrtcpntOccrnc AS _PolicyHolder ON InsuranceClaim = _PolicyHolder.InsuranceClaim AND _PolicyHolder.InsurClmSubobjectCategory = 'PO' AND _PolicyHolder.InsurClmSubobject = '' AND _PolicyHolder.InsurClmParticipantRole = 'POLH'  -- association [1..*]
LEFT OUTER JOIN I_InsurClm1stNotifFactCapture AS _Facts ON InsuranceClaim = _Facts.InsuranceClaim  -- association [1..*]
;