I_InsurClmReserveApp

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_InsurClmReserveApp.
-- 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: IICLRESERVEAPP

CREATE VIEW I_InsurClmReserveApp AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmRsrvType,
  InsurClmReserveCurrency,
  _ReserveType.InsurClmLossExpnType AS InsurClmLossExpnType,
  _ReserveType.InsurClmExpectationReserve AS InsurClmExpectationReserve,
  InsurClmRsrvChangeTime,
  InsurClmChangeDate,
  GrossReserveAmount,
  PostingDate,
  InsurClmRsrvMethodName,
  InsurClmRsrvMethodText,
  InsurClmReserveChangeRsn,
  _ChangeReason._ChangeReasonText[ Language = $session.system_language].InsurClmReserveChangeRsnName AS InsurClmReserveChangeRsnName,
  InsurClmRsrvPendingAmount,
  InsurClmSubclaimAssignUUID,
  InsurClmAssignUUID
FROM I_InsurClmReserve
LEFT OUTER JOIN I_InsurClmRsrvChangeReason AS _ChangeReason ON InsurClmReserveChangeRsn = _ChangeReason.InsurClmReserveChangeRsn  -- association [1..1]
LEFT OUTER JOIN I_InsurClmSubclaimUnionVH AS _SubclaimName ON InsuranceClaim = _SubclaimName.InsuranceClaim AND InsurClmSubclm = _SubclaimName.InsurClmSubclm  -- association [1..1]
;