I_BankFee

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_BankFee.
-- 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.

CREATE VIEW I_BankFee AS
SELECT
  bsb_uuid AS BkSrvcBillgStmntUUID,
  report_id AS ReportIdentifier,
  to_date AS EndDateYearMonth,
  sender_id AS Sender,
  receiver_id AS ReceiverIdentifier,
  account_level AS AccountLevel,
  account_id AS BankAccountNumber,
  case when from_date is not null and from_date != ' ' then from_date else cast( '00000000' as abap.dats(8)) end as StartDateYearMonth AS dats8endasStartDateYearMonth,
  statement_id AS BankFeeStatement,
  bank_key AS Bank,
  bank_country AS BankCountry,
  company_code AS CompanyCode,
  _Company.Country AS CompanyCodeCountry,
  account_bam_id AS BankAccountInternalID,
  sender_name AS SenderName,
  sender_country AS SenderCountry,
  receiver_name AS BankFeeReceiverName,
  receiver_country AS ReceiverCountry,
  compensation_type AS CompensationType,
  compensation_currency AS CompensationCurrency,
  compensation_amount AS CompensationAmount,
  compensation_method AS CompensationMethod,
  tax_calculation_method AS TaxCalculationMethod,
  tax_designation_region AS GrossIncomeTaxRegion,
  host_currency AS BankFeeHostCurrency,
  service_id AS BankFeeService,
  service_description AS BankFeeServiceDescription,
  sub_service_id AS BankFeeSubService,
  sub_service_issuer AS BankFeeSubServiceIssuer,
  service_common_code_issuer AS BankFeeSrvcComCodeIssuer,
  service_common_code AS BankFeeSrvcComCode,
  service_type AS BankFeeSrvcType,
  billing_charge_method AS BankFeeSrvcChrgMeth,
  service_volume AS TotalSettlmtVolume,
  service_unit_price AS BankFeeSrvcUnitPriceAmount,
  service_unit_price_currency AS PriceCurrency,
  payment_method AS PaymentMethod,
  original_charge_price AS OriginalChargePrice,
  original_change_price_currency AS OriginalChargePriceCurrency,
  tax_designation_code AS TaxDesignation,
  tax_region_number AS BankFeeTaxRegion,
  tax_region_name AS TaxRegionNumberTxt,
  tax_id_total_tax_amount AS TotalTaxAmount,
  tax_id_total_tax_currency AS TotalTaxAmountCurrency,
  tax_service_tax_host_amount AS TaxServiceTaxHostAmount,
  tax_service_tax_host_currency AS TaxServiceTaxHostCurrency,
  tax_service_tax_pricing_amt AS TaxServiceTaxPricingAmount,
  tax_service_tax_pricing_ccy AS TaxServiceTaxPricingCurrency,
  cond AS BankFeeConditionID,
  ValidFrom,
  condarea AS ConditionArea,
  validation_status AS BankFeeSrvcPricingStatus
FROM fclm_brm_bsb
LEFT OUTER JOIN I_CompanyCode AS _Company ON CompanyCode = _Company.CompanyCode  -- association [0..1]
;