I_InsurClmSubclaimInquiry

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_InsurClmSubclaimInquiry.
-- 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: IICLSUBCLMINQ

CREATE VIEW I_InsurClmSubclaimInquiry AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  _Claimant.InsurClmClaimantName AS InsurClmClaimantName,
  _Claimant.BusinessPartner AS InsurClmClaimantID,
  _CoveragePolicySnapshot._CoverageType._CoverageTypeText[ Language = $session.system_language].InsurClmCoverageTypeName AS InsurClmCoverageText,
  InsurClmLifeCycSts,
  _SubStatus._ClaimStatusText[ Language = $session.system_language].InsurClmLifeCycStsName AS InsurClmSubclmStatusText,
  _SubclaimType._SubclaimTypeText[ Language = $session.system_language].InsurClmSubclmTypeName AS InsurClmSubclmTypeName,
  _Subrogation.InsurClmSubrogationStatusText AS InsurClmSubrogationStatusText,
  InsurClmSubclmStsChgdOnDteTime,
  InsurClmSubclmType,
  InsurClmSubrogtnRecoveryStatus,
  InsurClmSubclaimDescription,
  InsurClmCoverage,
  InsurClmSubclmStsRsn,
  IsInProcess,
  IsClosed,
  InsurClmSubrogtnPotential,
  _SubrogtnPotentialTxt.InsurClmSubrogtnPotentialText AS InsurClmSubrogtnPotentialText,
  concat_with_space(cast (_PayTotal.InsurClmSubclmPaytTotAmount as abap.char( 18 )), _PayTotal.InsurClmPaymentCurrency, 1) AS InsurClmSubclmPaytTotText,
  concat_with_space(cast (_ResTotal.InsurClmSubclmTotRsrvAmount as abap.char( 18 )), _ResTotal.InsurClmReserveCurrency, 1) AS InsurClmSubclmTotRsrvText,
  _SubclmStsReasonTxt.InsurClmStatReasonText AS InsurClmStatReasonText
FROM I_InsurClmSubclaim
LEFT OUTER JOIN I_InsurClmClaimant AS _Claimant ON InsuranceClaim = _Claimant.InsuranceClaim AND InsurClmSubclm = _Claimant.InsurClmSubobject  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubclaimType AS _SubclaimType ON InsurClmSubclmType = _SubclaimType.InsurClmSubclmType  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubrogationItem AS _Subrogation ON InsuranceClaim = _Subrogation.InsuranceClaim AND InsurClmSubclm = _Subrogation.InsurClmSubclm  -- association [0..1]
LEFT OUTER JOIN I_InsurClmStatus AS _SubStatus ON InsurClmLifeCycSts = _SubStatus.InsurClmLifeCycSts  -- association [0..1]
LEFT OUTER JOIN I_InsurClmSubclmPaytTotal AS _PayTotal ON InsuranceClaim = _PayTotal.InsuranceClaim AND InsurClmSubclm = _PayTotal.InsurClmSubclm  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubclmReserveTotal AS _ResTotal ON InsuranceClaim = _ResTotal.InsuranceClaim AND InsurClmSubclm = _ResTotal.InsurClmSubclm  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubrogtnPotentialTxt AS _SubrogtnPotentialTxt ON InsurClmSubrogtnPotential = _SubrogtnPotentialTxt.InsurClmSubrogtnPotential AND _SubrogtnPotentialTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InsurClmStatsReasonText AS _SubclmStsReasonTxt ON InsurClmSubclmStsRsn = _SubclmStsReasonTxt.InsurClmStatReason AND _SubclmStsReasonTxt.Language = $session.system_language  -- association [1..1]
;