FTR_PAYMENT_REASON_SA_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_SA_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_SA_SOURCE AS
SELECT
  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 ( 'ZSEACCOUNT' as ftr_gen_security_account preserving type ) AS SecurityAccount,
  cast ( 'Z123456789012' as ftr_gen_security_class preserving type ) AS SecurityClass,
  cast ( '000' as ftr_gen_fin_instr_prod_categ preserving type) AS FinancialInstrProductCategory,
  cast ( 'ZZZ' as vvsart preserving type ) AS FinancialInstrumentProductType,
  cast ( 'IssuerSecA' as repke_new preserving type) AS Issuer,
  cast ('Z123' as bu_istype preserving type ) AS IssuerIndustrySystem,
  cast ('Z123456789' as bu_indsect preserving type ) AS IssuerIndustry,
  cast ( 'A' as bp_ccom_re preserving type ) AS BPCoCodeCompanyRelationship,
  cast ( Currency as rewhr preserving type ) AS IssueCurrency,
  cast ( 'X' as wpfan preserving type ) AS SecurityClassIsPledgeable,
  cast ( 'ZZZ' as alwpkl preserving type ) AS ScrtyClassGenClassification,
  cast ( '999' as swpklass preserving type ) AS BondClassification,
  cast ( '9' as sakar preserving type ) AS SecurityClassStockCategory,
  cast ( '9' as sfoty preserving type ) AS SecurityClassFundType,
  cast ( 00000000000.00 as ftr_flow_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
;