I_InsurClm1stNotifTP

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_InsurClm1stNotifTP.
-- 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: ICL1STNFTP

CREATE VIEW I_InsurClm1stNotifTP AS
SELECT
  InsuranceClaim,
  InsuranceContract,
  ChangedOnDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmAuthznGrp,
  InsurClmIncdntType,
  InsurClmDateOfLoss,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  InsurClmPolicyProduct,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  _LossLocationAddress.StreetName AS InsurClmLossLocStreet,
  _LossLocationAddress.HouseNumber AS InsurClmLossLocHouseNumber,
  _LossLocationAddress.CityName AS InsurClmLossLocCity,
  _LossLocationAddress.Region AS InsurClmLossLocRegion,
  _LossLocationAddress.PostalCode AS InsurClmLossLocPostalCode,
  _LossLocationAddress.Country AS InsurClmLossLocCountry,
  cast(0 as geolon) AS InsurClmLossLocLongitude,
  cast(0 as geolat) AS InsurClmLossLocLatitude,
  _LossDescription.InsurClmDescriptionOfLoss AS InsurClmDescriptionOfLoss,
  InsurancePolicyholder
FROM I_InsurClm1stNotif
LEFT OUTER JOIN I_InsurClm1stNotifDmgdVehTP AS _DamagedVehicle ON _DamagedVehicle.InsuranceClaim = InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_InsurClm1stNotifNoteTP AS _Note ON InsuranceClaim = _Note.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_InsurClm1stNotifWtnssTP AS _Witness ON I_InsurClm1stNotif.InsuranceClaim = _Witness.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_Address AS _LossLocationAddress ON InsurClmLossLocAddressID = _LossLocationAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_InsurClmLossDesc AS _LossDescription ON I_InsurClm1stNotif.InsuranceClaim = _LossDescription.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClm1stNotifFactTP AS _Facts ON I_InsurClm1stNotif.InsuranceClaim = _Facts.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN I_InsurClm1stNotifFactDeltdTP AS _FactsDeleted ON I_InsurClm1stNotif.InsuranceClaim = _FactsDeleted.InsuranceClaim  -- association [0..*]
LEFT OUTER JOIN E_InsuranceClaim AS _Extension ON I_InsurClm1stNotif.InsuranceClaim = _Extension.InsuranceClaim  -- association [1..1]
;