I_InsurClmFNOLTP

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_InsurClmFNOLTP.
-- 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: ICLFNOLRAPTP

CREATE VIEW I_InsurClmFNOLTP AS
SELECT
  InsuranceClaim,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClaimUUID,
  InsuranceClaimDraftIdentifier,
  InsuranceContract,
  ChangedOnDateTime,
  LastChangedByUser,
  CreationDateTime,
  CreatedByUser,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmLifeCycSts,
  _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName AS InsurClmLifeCycStsName,
  InsurClmAuthznGrp,
  I_InsuranceClaim.InsurClmIncdntType AS InsurClmIncdntType,
  _IncidentType._IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName AS InsurClmIncdntTypeName,
  InsurClmDateOfLoss,
  InsurClmCauseOfLoss,
  _LossCause._LossCauseText[ Language = $session.system_language].InsurClmCauseOfLossName AS InsurClmCauseOfLossName,
  InsurClmLossLocAddressID,
  I_InsuranceClaim.InsurClmPolicyProduct AS InsurClmPolicyProduct,
  I_InsuranceClaim.InsurClmPolicyProdGeneration AS InsurClmPolicyProdGeneration,
  I_InsuranceClaim.InsurClmPolicyProductVersion AS InsurClmPolicyProductVersion,
  I_InsuranceClaim.InsurClmPolicyProdGeneration AS InsurClmPlcyProdGnrtnSrchHelp,
  I_InsuranceClaim.InsurClmPolicyProductVersion AS InsurClmPolicyProdVersSrchHelp,
  _ProductName[Language = $session.system_language].InsurClmPlcyProdName AS InsurClmPlcyProdName,
  _PolicyHolder.BusinessPartnerName AS InsurClmPolicyHolderName,
  _PolicyHolder.BirthDate AS BirthDate,
  _ClaimHandler.FullName AS FullName,
  _ClaimHandler.ContactCardID AS ContactCardID,
  _PolicyHolder.BusinessPartner AS InsurancePolicyholder,
  _LossDescription.InsurClmDescriptionOfLoss AS InsurClmDescriptionOfLoss,
  _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,
  cast ( '/sap/bc/ui5_ui5/sap/INS_FNOL2S1/images/Fnol.jpg' as abap.char( 48 ) ) AS InsurClmImageURL
FROM I_InsuranceClaim
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_InsurClmLossDesc AS _LossDescription ON InsuranceClaim = _LossDescription.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_Address AS _LossLocationAddress ON InsurClmLossLocAddressID = _LossLocationAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_InsurClmHandler AS _ClaimHandler ON InsuranceClaim = _ClaimHandler.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClmStatus AS _ClaimStatus ON InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts  -- 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_InsurClmFNOLPaymentDetails AS _FnolPay ON InsurClmPolicyProduct = _FnolPay.InsurClmPolicyProduct AND InsurClmIncdntType = _FnolPay.InsurClmIncdntType  -- association [1..1]
LEFT OUTER JOIN I_InsurClmProdNameVH AS _ProductName ON InsurClmPolicyProduct = _ProductName.InsurClmPolicyProduct AND InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration  -- association [1..1]
LEFT OUTER JOIN I_InsurClmFNOLDamagedObjectTP AS _DamagedVehicle ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurClmFNOLNoteTP AS _Note ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurClmFNOLFactsOriginTP AS _Facts ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurClmFNOLWtnssTP AS _Witness ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_InsurClmFNOLFactsLossLocTP AS _SFCLoss ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_InsurClmFNOLPaytAppTP AS _Payment ON /* condition not available in parsed metadata */  -- association [1..*]
;