I_BankFeeStatementCube

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_BankFeeStatementCube.
-- 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_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_BankFeeStatementCube AS
SELECT
  EndDateYearMonth,
  Sender,
  ReceiverIdentifier,
  AccountLevel,
  BankAccountNumber,
  StartDateYearMonth,
  BankFeeStatement,
  BankAccountInternalID,
  _BankAccount.IBAN AS IBAN,
  SenderName,
  SenderCountry,
  BankFeeReceiverName,
  ReceiverCountry,
  CompanyCode,
  CompanyCodeCountry,
  Bank,
  BankCountry,
  CompensationMethod,
  TaxCalculationMethod,
  BankFeeHostCurrency,
  BankFeeSettlmtCrcy,
  ReportIdentifier,
  case when _BankGroup.BankHeadquarterName is not null then _BankGroup.BankHeadquarterName else cast ('(Undefined)' as abap.char( 12 ) ) end as BankHeadquarterName AS char12endasBankHeadquarterName,
  case when _StatementTotalService1.CompensationAmount is not null then cast(_StatementTotalService1.CompensationAmount as farp_amount_display_crcy) when _StatementTotalService1.CompensationAmount is null and _StatementTotalService2.CompensationAmount is not null then cast(_StatementTotalService2.CompensationAmount as farp_amount_display_crcy) else cast( 0 as abap.curr( 23, 4 ) ) end as BankFeeTotalServiceAmount AS curr234endasBankFeeTotalServiceAmount,
  case when _StatementTotalTax.CompensationAmount is not null then cast(_StatementTotalTax.CompensationAmount as farp_amount_display_crcy) else cast( 0 as abap.curr( 23, 4 ) ) end as BankFeeTotalTaxAmount AS curr234endasBankFeeTotalTaxAmount,
  case when _StatementTotalAmount1.CompensationAmount is not null then cast(_StatementTotalAmount1.CompensationAmount as farp_amount_display_crcy) when _StatementTotalAmount1.CompensationAmount is null and _StatementTotalAmount2.CompensationAmount is not null then cast(_StatementTotalAmount2.CompensationAmount as farp_amount_display_crcy) else cast( 0 as abap.curr( 23, 4 ) ) end as BankFeeTotalAmount AS curr234endasBankFeeTotalAmount,
  cast(cast(_StatementFeesPaid.CompensationAmount as abap.curr( 23, 4 ) ) as farp_amount_display_crcy) AS BankFeeFeesPaidAmount,
  cast($parameters.P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency
FROM I_BankFeeStatement AS Statement
LEFT OUTER JOIN I_BankAccount AS _BankAccount ON BankAccountInternalID = _BankAccount.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountWithBGN AS _BankGroup ON BankAccountInternalID = _BankGroup.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankFee AS _StatementTotalService1 ON Sender = _StatementTotalService1.Sender AND ReceiverIdentifier = _StatementTotalService1.ReceiverIdentifier AND StartDateYearMonth = _StatementTotalService1.StartDateYearMonth AND EndDateYearMonth = _StatementTotalService1.EndDateYearMonth AND ( BankFeeSettlmtCrcy = ' ' OR BankFeeSettlmtCrcy = _StatementTotalService1.CompensationCurrency ) AND AccountLevel = _StatementTotalService1.AccountLevel AND BankAccountInternalID = _StatementTotalService1.BankAccountInternalID with default filter _StatementTotalService1.CompensationType = 'SCBT'  -- association [0..1]
LEFT OUTER JOIN I_BankFee AS _StatementTotalService2 ON Sender = _StatementTotalService2.Sender AND ReceiverIdentifier = _StatementTotalService2.ReceiverIdentifier AND StartDateYearMonth = _StatementTotalService2.StartDateYearMonth AND EndDateYearMonth = _StatementTotalService2.EndDateYearMonth AND ( BankFeeSettlmtCrcy = ' ' OR BankFeeSettlmtCrcy = _StatementTotalService2.CompensationCurrency ) AND AccountLevel = _StatementTotalService2.AccountLevel AND BankAccountInternalID = _StatementTotalService2.BankAccountInternalID with default filter _StatementTotalService2.CompensationType = 'SCCP'  -- association [0..1]
LEFT OUTER JOIN I_BankFee AS _StatementTotalTax ON Sender = _StatementTotalTax.Sender AND ReceiverIdentifier = _StatementTotalTax.ReceiverIdentifier AND StartDateYearMonth = _StatementTotalTax.StartDateYearMonth AND EndDateYearMonth = _StatementTotalTax.EndDateYearMonth AND ( BankFeeSettlmtCrcy = ' ' OR BankFeeSettlmtCrcy = _StatementTotalTax.CompensationCurrency ) AND AccountLevel = _StatementTotalTax.AccountLevel AND BankAccountInternalID = _StatementTotalTax.BankAccountInternalID with default filter _StatementTotalTax.CompensationType = 'TXTS'  -- association [0..1]
LEFT OUTER JOIN I_BankFee AS _StatementTotalAmount1 ON Sender = _StatementTotalAmount1.Sender AND ReceiverIdentifier = _StatementTotalAmount1.ReceiverIdentifier AND StartDateYearMonth = _StatementTotalAmount1.StartDateYearMonth AND EndDateYearMonth = _StatementTotalAmount1.EndDateYearMonth AND ( BankFeeSettlmtCrcy = ' ' OR BankFeeSettlmtCrcy = _StatementTotalAmount1.CompensationCurrency ) AND AccountLevel = _StatementTotalAmount1.AccountLevel AND BankAccountInternalID = _StatementTotalAmount1.BankAccountInternalID with default filter _StatementTotalAmount1.CompensationType = 'CTND'  -- association [0..1]
LEFT OUTER JOIN I_BankFee AS _StatementTotalAmount2 ON Sender = _StatementTotalAmount2.Sender AND ReceiverIdentifier = _StatementTotalAmount2.ReceiverIdentifier AND StartDateYearMonth = _StatementTotalAmount2.StartDateYearMonth AND EndDateYearMonth = _StatementTotalAmount2.EndDateYearMonth AND ( BankFeeSettlmtCrcy = ' ' OR BankFeeSettlmtCrcy = _StatementTotalAmount2.CompensationCurrency ) AND AccountLevel = _StatementTotalAmount2.AccountLevel AND BankAccountInternalID = _StatementTotalAmount2.BankAccountInternalID with default filter _StatementTotalAmount2.CompensationType = 'SCDB'  -- association [0..1]
LEFT OUTER JOIN I_BankFee AS _StatementFeesPaid ON Sender = _StatementFeesPaid.Sender AND ReceiverIdentifier = _StatementFeesPaid.ReceiverIdentifier AND StartDateYearMonth = _StatementFeesPaid.StartDateYearMonth AND EndDateYearMonth = _StatementFeesPaid.EndDateYearMonth AND ( BankFeeSettlmtCrcy = ' ' OR BankFeeSettlmtCrcy = _StatementFeesPaid.CompensationCurrency ) AND AccountLevel = _StatementFeesPaid.AccountLevel AND BankAccountInternalID = _StatementFeesPaid.BankAccountInternalID with default filter _StatementFeesPaid.CompensationType = 'FESS'  -- association [0..1]
;