FTR_PAYMENT_REASON_SOURCE

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 FTR_PAYMENT_REASON_SOURCE.
-- 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 FTR_PAYMENT_REASON_SOURCE AS
SELECT
  cast ('BusinessPa' as bu_partner preserving type ) AS BusinessPartner,
  cast ('Z123' as bu_istype preserving type ) AS IndustrySystem,
  cast ('Z123456789' as bu_indsect preserving type ) AS Industry,
  cast ('XYZ' as bp_cntr_hd preserving type ) AS BusinessPartnerOfficeCountry,
  cast ( 'A' as bp_ccom_re preserving type ) AS BPCoCodeCompanyRelationship,
  cast ( 'Z999' as fis_bukrs preserving type ) AS CompanyCode,
  cast ( 'ZZZ' as land1 preserving type ) AS CompanyCodeCountry,
  cast ('PayerPayee' as tb_rpzahl_new preserving type ) AS PayerPayee,
  cast ( '9999' as tpm_com_val_class preserving type ) AS FinTransGeneralValuationClass,
  cast ( '000' as ftr_gen_fin_instr_prod_categ preserving type ) AS FinancialInstrProductCategory,
  cast ( 'ZZZ' as vvsart preserving type ) AS FinancialInstrumentProductType,
  cast ( 'ZSEACCOUNT' as ftr_gen_security_account preserving type ) AS SecurityAccount,
  cast ( 'ZPORT12345' as rportb preserving type ) AS Portfolio,
  cast ( 'Z99999999999999999' as dzuonr preserving type ) AS TreasuryFinanceProject,
  cast ( 'Z99999999999999999' as ftr_gen_fin_instr_assignment preserving type ) AS FinancialInstrumentAssignment,
  cast ( 'Z999999999999999' as ftr_gen_fin_instr_internal_ref preserving type) AS FinancialInstrumentReference,
  cast ( 'Z999999999999999999999999' as ftr_gen_fin_instr_char preserving type ) AS FinancialInstrCharacteristic,
  cast ( 'Z123456789012' as ftr_gen_security_class preserving type ) AS SecurityClass,
  cast ( 'ZYX' as ftr_gen_transaction_type preserving type ) AS FinancialInstrTransactionType,
  cast ( 'ZZZZ' as tb_sfhazba preserving type ) AS FinTransFlowType,
  cast ( 000000000000000000000.00 as ftr_payment_amount ) AS AmountInPaymentCurrency,
  cast ( Currency as ftr_flow_payment_amount_crcy preserving type ) AS PaymentCurrency,
  cast ( 000000000000000000000.00 as ftr_payt_amt_in_local_currency ) AS AmountInLocalCurrency,
  cast ( Currency as ftr_flow_payment_amount_crcy preserving type ) AS LocalCurrency,
  cast ( '0' as ftr_payment_reason_changed preserving type ) AS PaymentReasonChanged,
  cast ( 'ZZZZ' as farp_payt_rsn preserving type ) AS PaymentReason
FROM I_Currency
;