I_InsurClmClaimOverview

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_InsurClmClaimOverview.
-- 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: IICLCLAIMOVW

CREATE VIEW I_InsurClmClaimOverview AS
SELECT
  InsuranceClaim,
  InsuranceContract,
  InsurClmPolicyProduct,
  InsurClmLifeCycSts,
  _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName AS InsurClmLifeCycStsName,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmAuthznGrp,
  InsurClmPolicyProdGeneration,
  InsurClmPolicyProductVersion,
  InsurClmIncdntType,
  _IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName AS InsurClmIncdntTypeName,
  _PolicySnapshot.InsurLineOfBus AS InsurLineOfBus,
  InsurClmDateOfLoss,
  InsurClmCauseOfLoss,
  InsurClmLossLocAddressID,
  _LossLocDesc.InsurClmDescriptionOfLossLoc AS InsurClmDescriptionOfLossLoc,
  _LossDesc.InsurClmIncidentDetailsText AS InsurClmIncidentDetailsText,
  _ObjectAssign.InsuranceClaimObject AS InsurClaimBundle,
  InsurClmTimeOfLoss,
  InsurClmComplexity,
  _ComplexityText[ Language = $session.system_language ].InsurClmComplexityName AS InsurClmComplexityName,
  InsurClmCovered,
  _PolicySnapshot.InsurancePolicy AS InsurancePolicy,
  cast( _PolicySnapshot.InsurClmContractStartDateTime as icl_achangetime_fiori preserving type ) AS InsurClmContractStartDateTime,
  cast( _PolicySnapshot.InsurClmContractEndDateTime as icl_achangetime_fiori preserving type ) AS InsurClmContractEndDateTime,
  concat_with_space( _address.HouseNumber, concat_with_space(_address.StreetName, concat_with_space(_address.CityName, concat_with_space(_address.Region, concat_with_space(_address.PostalCode,_address.Country, 1), 1), 1), 1), 1 ) as InsurClmLocationText AS Country11111asInsurClmLocationText,
  _LossDescription.InsurClmDescriptionOfLoss AS InsurClmDescriptionOfLoss,
  _LossCause._LossCauseText[ Language = $session.system_language ].InsurClmCauseOfLossName AS InsurClmCauseOfLossName,
  _ClaimHandler.FullName AS FullName,
  _PolicyHolder.InsurClmPolicyHolderName AS InsurClmPolicyHolderName,
  _PolicyHolder.BusinessPartner AS InsurancePolicyholder,
  _LossExpRecovery.InsurClmExpnExpenditureAmount AS InsurClmExpnExpenditureAmount,
  _LossExpRecovery.InsurClmLossExpenditureAmount AS InsurClmLossExpenditureAmount,
  _LossExpRecovery.InsurClmTotalRecoveryPaytAmt AS InsurClmTotalRecoveryPaytAmt,
  _LossExpRecovery.InsurClmLossPaytAmt AS InsurClmLossPaytAmt,
  _LossExpRecovery.InsurClmExpensePaytAmt AS InsurClmExpensePaytAmt,
  _LossExpRecovery.InsurClmLossReserveAmt AS InsurClmLossReserveAmt,
  _LossExpRecovery.InsurClmExpnExpenditureAmount - _LossExpRecovery.InsurClmExpensePaytAmt AS InsurClmExpenseReserveAmount,
  _LossExpRecovery.InsurClmSalvagePaytAmt AS InsurClmSalvagePaytAmt,
  _LossExpRecovery.InsurClmSubrogtnRcvryPaytAmt AS InsurClmSubrogtnRcvryPaytAmt,
  _LossExpRecovery.InsurClmRecoveryPaytAmt AS InsurClmRecoveryPaytAmt,
  cast(_LossExpRecovery.InsurClmPaymentCurrency as char0008) AS InsurClmPaymentCurrency,
  InsurClmStatReason,
  InsurClmAgentReportedDate
FROM I_InsuranceClaim
LEFT OUTER JOIN I_InsurClmInsuredVehInquiry AS _InsuredVehicle ON InsuranceClaim = _InsuredVehicle.InsuranceContract  -- 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 [1..1]
LEFT OUTER JOIN I_Address AS _address ON InsurClmLossLocAddressID = _address.AddressID AND InsurClmLossLocAddressID is not initial  -- association [1..1]
LEFT OUTER JOIN I_InsurClmLossDesc AS _LossDescription ON InsuranceClaim = _LossDescription.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClmHandler AS _ClaimHandler ON InsuranceClaim = _ClaimHandler.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClmIncdntTypeText AS _IncidentTypeText ON InsurClmIncdntType = _IncidentTypeText.InsurClmIncdntType  -- association [0..*]
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_InsurClmLossExpnRcvryInqry AS _LossExpRecovery ON InsuranceClaim = _LossExpRecovery.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmObjectAssignment 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_InsurClmLossLocDesc AS _LossLocDesc ON InsuranceClaim = _LossLocDesc.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClmIncidentDetails AS _LossDesc ON InsuranceClaim = _LossDesc.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN E_InsuranceClaim AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim  -- association [0..1]
LEFT OUTER JOIN I_InsurClmStatsReasonText AS _StatusReasonText ON InsurClmStatReason = _StatusReasonText.InsurClmStatReason AND _StatusReasonText.Language = $session.system_language  -- association [1..1]
;