I_FinTransInterest

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_FinTransInterest.
-- 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: IFINTRANSINTRST
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_FinTransInterest AS
SELECT
  Flow.CompanyCode AS CompanyCode,
  Flow.FinancialTransaction AS FinancialTransaction,
  Flow.FinancialTransactionDirection AS FinancialTransactionDirection,
  Condition.FinConditionInterestCategory AS FinConditionInterestCategory,
  Flow.FinTransFlowPaytAmt AS FinTransFlowPaytAmt,
  Flow.FinTransFlowPaytAmtCrcy AS FinTransFlowPaytAmtCrcy,
  Flow.FinTransFlowPaymentDate AS FinTransFlowPaymentDate,
  Flow.FinTransFlowPaymentDueDate AS FinTransFlowPaymentDueDate,
  Flow.FinTransFlowIntrstRateFixDate AS FinTransFlowIntrstRateFixDate,
  Flow.ConditionPercentageRate AS ConditionPercentageRate,
  Flow.FinInterestRateAdjmtStatus AS FinInterestRateAdjmtStatus,
  _FinTrans._CurrentActivity.FinTransIntrstHndlgAtRollover AS FinTransIntrstHndlgAtRollover,
  _FinTrans._CurrentActivity.RolloverDfrrdIntrstPyoutDte AS RolloverDfrrdIntrstPyoutDte
FROM R_FinTransCashFlowActivity AS Activity
INNER JOIN R_FinTransFlow AS Flow ON /* join condition not captured in parsed metadata */
INNER JOIN R_FinTransCondition AS Condition ON /* join condition not captured in parsed metadata */
INNER JOIN R_FinTransUnfixedFlow AS UnfixedFlow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinTrans ON CompanyCode = _FinTrans.CompanyCode AND FinancialTransaction = _FinTrans.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_FinTransactionDirection AS _Direction ON FinancialTransactionDirection = _Direction.FinancialTransactionDirection  -- association [0..1]
LEFT OUTER JOIN I_FinCndnInterestCategory AS _IntCat ON FinConditionInterestCategory = _IntCat.FinConditionInterestCategory  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON FinTransFlowPaytAmtCrcy = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FinIntrstRateAdjmtStatus AS _AdjmtStatus ON FinInterestRateAdjmtStatus = _AdjmtStatus.FinInterestRateAdjmtStatus  -- association [0..1]
-- UNION with additional select branch(es): R_FinTransCashFlowActivity
;