C_BankFeeStatement

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 C_BankFeeStatement.
-- 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, P_KeyDate : vdm_v_exchange_rate_date, P_ExchangeRateType : kurst_curr

CREATE VIEW C_BankFeeStatement AS
SELECT
  EndDateYearMonth,
  Sender,
  ReceiverIdentifier,
  AccountLevel,
  BankAccountNumber,
  StartDateYearMonth,
  IBAN,
  BankAccountInternalID,
  BankFeeStatement,
  SenderCountry,
  ReceiverCountry,
  ReportIdentifier,
  _BankVH.BankName AS BankName,
  BankCountry,
  _BankCountryVH.CountryName AS CountryName,
  BankHeadquarter,
  BankHeadquarterName,
  CompanyCode,
  _CompanyVH.CompanyCodeName AS CompanyCodeName,
  CompanyCodeCountry,
  _CompanyCountryVH.CountryName AS CountryLongName,
  _CompnMeth.BankFeeCompnMethTxt AS BankFeeCompnMethTxt,
  TaxCalculationMethod,
  _TxCalcMeth.BankFeeTxCalcMethTxt AS BankFeeTxCalcMethTxt,
  BankFeeTotalServiceCurrency,
  BankFeeTotalServiceAmount,
  BankFeeTotalTaxCurrency,
  BankFeeTotalTaxAmount,
  BankFeeTotalAmountCurrency,
  BankFeeTotalAmount,
  BankFeeFeesPaidCurrency,
  BankFeeFeesPaidAmount,
  cast($parameters.P_ExchangeRateType as abap.cuky( 5 ) ) AS ExchangeRateType,
  cast($parameters.P_DisplayCurrency as vdm_v_display_currency ) AS DisplayCurrency,
  cast( left( cast(EndDateYearMonth as abap.char(23)), 8 ) as abap.dats(8) ) AS CalendarDate,
  cast( left( cast(EndDateYearMonth as abap.char(23)), 4 ) as abap.numc(4) ) AS CalendarYear,
  cast( left( cast(EndDateYearMonth as abap.char(23)), 6 ) as abap.numc(6) ) AS CalendarYearMonth,
  cast( substring( cast(EndDateYearMonth as abap.char(23)), 5, 2) as abap.numc(2) ) AS CalendarMonth
FROM I_BankFeeStmntCalct
LEFT OUTER JOIN I_BankFeeServiceCalct AS _ServiceCalct ON BankFeeStatement = _ServiceCalct.BankFeeStatement AND EndDateYearMonth = _ServiceCalct.EndDateYearMonth  -- association [0..1]
LEFT OUTER JOIN C_BankFeeAccountVH AS _AccountVH ON _BankFee.BankAccountInternalID = _AccountVH.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN C_BankFeeBankVH AS _BankVH ON Bank = _BankVH.Bank AND _BankFee.BankCountry = _BankVH.BankCountry  -- association [0..1]
LEFT OUTER JOIN C_BankFeeBankCountryVH AS _BankCountryVH ON _BankFee.BankCountry = _BankCountryVH.BankCountry  -- association [0..1]
LEFT OUTER JOIN C_BankFeeCompanyVH AS _CompanyVH ON CompanyCode = _CompanyVH.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_BankFeeCompanyCountryVH AS _CompanyCountryVH ON CompanyCodeCountry = _CompanyCountryVH.CompanyCodeCountry  -- association [0..1]
LEFT OUTER JOIN C_BankFeeDspCrcyVH AS _CurrencyVH ON DisplayCurrency = _CurrencyVH.DisplayCurrency  -- association [0..1]
LEFT OUTER JOIN I_BankFeeExchRateTypeVH AS _ExchRateTypeVH ON ExchangeRateType = _ExchRateTypeVH.ExchangeRateType  -- association [0..1]
LEFT OUTER JOIN C_BankFeeBkGrpVH AS _BankGroup ON BankHeadquarter = _BankGroup.BankHeadquarter  -- association [0..1]
LEFT OUTER JOIN C_BankFeeCompnMethVH AS _CompnMeth ON _BankFee.CompensationMethod = _CompnMeth.CompensationMethod  -- association [0..1]
LEFT OUTER JOIN C_BankFeeAcctLvlVH AS _AccountLevel ON _BankFee.AccountLevel = _AccountLevel.AccountLevel  -- association [0..1]
LEFT OUTER JOIN C_BankFeeTxCalcMethVH AS _TxCalcMeth ON _BankFee.TaxCalculationMethod = _TxCalcMeth.TaxCalculationMethod  -- association [0..1]
;