I_PaytReqTemplatePaymentData

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_PaytReqTemplatePaymentData.
-- 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_PaytReqTemplatePaymentData AS
SELECT
  cast(tfiblmpvar.origin as farp_payrq_type preserving type) AS PaymentRequestType,
  tfiblmpvar.var_id AS PaymentRequestTemplate,
  cast(tfiblmpvar.pay_comp_code as farp_bnk_com_dzbukr preserving type) AS PayingCompanyCode,
  cast(tfiblmpvar.housebankid as farp_hbkid preserving type) AS HouseBank,
  tfiblmpvar.housebankacctid AS HouseBankAccount,
  cast(tfiblmpvar.paym_curr as farp_prq_pacur preserving type) AS PaymentRequestCurrency,
  cast(tfiblmpvar.paym_amount as farp_prq_amtfc preserving type) AS PaymentRequestAmountInPaytCrcy,
  tfiblmpvar.loc_currcy AS CompanyCodeCurrency,
  tfiblmpvar.loc_amount AS PaymentRequestAmountInCCCrcy,
  tfiblmpvar.paym_method AS PaymentMethod,
  cast(tfiblmpvar.item_text as farp_reftxt preserving type) AS ReferenceTypeText,
  cast(tfiblmpvar.indiv_payment as farp_prq_xpore preserving type) AS IsSinglePayment,
  cast(tfiblmpvar.instr_key as farp_bnk_com_dtaws preserving type) AS DataExchangeInstructionKey,
  cast(tfiblmpvar.instr1 as farp_dtat16 preserving type) AS DataExchangeInstruction1,
  cast(tfiblmpvar.instr2 as farp_dtat17 preserving type) AS DataExchangeInstruction2,
  cast(tfiblmpvar.instr3 as farp_dtat18 preserving type) AS DataExchangeInstruction3,
  cast(tfiblmpvar.instr4 as farp_dtat19 preserving type) AS DataExchangeInstruction4,
  cast(tfiblmpvar.scbank_ind as farp_prq_lzbkz preserving type) AS StateCentralBankPaymentReason,
  tfiblmpvar.supcountry AS SupplyingCountry,
  tfiblmpvar.chainid AS BankChain,
  tfiblmpvar.pmtmthsupl AS PaymentMethodSupplement,
  tfiblmpvar.paymt_ref AS PaymentReference,
  tfiblmpvar.tax_no_1 AS TaxID1
FROM tfiblmpvar
;