A_INS_FinancialOverviewRange

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 A_INS_FinancialOverviewRange.
-- 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.
-- Parameters: P_InsurClmFinOvrRngeFrmDteTme : icl_createutc_fiori, P_InsurClmFinOvrRngeToDteTme : icl_createutc_fiori

CREATE VIEW A_INS_FinancialOverviewRange AS
SELECT
  InsurClmActive,
  InsuranceClaim,
  InsurClmPaymentSubclaim,
  max (CreationDateTime) AS CreationDateTime,
  cast( $parameters.P_InsurClmFinOvrRngeFrmDteTme as icl_createutc_fiori preserving type ) AS InsurClmFinOvrRngeFrmDteTme,
  cast( $parameters.P_InsurClmFinOvrRngeToDteTme as icl_createutc_fiori preserving type ) AS InsurClmFinOvrRngeToDteTme,
  InsurClmPaymentCurrency,
  InsurClmType,
  InsurClmAuthznGrp,
  sum(InsurClmPaymentsLossAmount) AS InsurClmPaytsLossDiffAmt,
  sum(InsurClmPaymentsExpenseAmount) AS InsurClmPaytsExpenseDiffAmount,
  sum(InsurClmRecoveryLossAmount) AS InsurClmRcvryLossDiffAmount,
  sum(InsurClmRecoveryExpenseAmount) AS InsurClmRcvryExpenseDiffAmount,
  sum(InsurClmSubrogtnLossAmount) AS InsurClmSubrogtnLossDiffAmt,
  sum(InsurClmSubrogtnExpenseAmount) AS InsurClmSubrogtnExpnDiffAmount,
  sum(InsurClmSalvageLossAmount) AS InsurClmSalvgLossDiffAmount,
  sum(InsurClmReservesPayLossAmount) AS InsurClmReservesPayLossDiffAmt,
  sum(InsurClmReservesPayExpenseAmt) AS InsurClmReservesPayExpnDiffAmt,
  sum(InsurClmRsrvSubrogtnLossAmt) AS InsurClmRsrvSubrogtnDiffAmt,
  sum(InsurClmRsrvSubrogtnExpnAmt) AS InsurClmRsrvSubrogtnExpDiffAmt,
  sum(InsurClmRsrvSalvageLossAmt) AS InsurClmRsrvSalvgLossDiffAmt
FROM R_INS_FinancialOverviewRange
;