I_MakeBkTransfWthTmplItm

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_MakeBkTransfWthTmplItm.
-- 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.
-- SQL view name: IMBTTMPLITM

CREATE VIEW I_MakeBkTransfWthTmplItm AS
SELECT
  flow_id AS MakeBankTransferRunID,
  detail_id AS MakeBankTransferItemID,
  cast(_payrq.rfttrn as rpcode) AS RepetitiveCode,
  _payrq.zbukr AS PayingCompanyCode,
  _payrq.hbkid AS HouseBank,
  cast( transfer_amt as farp_prq_amtfc ) AS PaymentRequestAmountInPaytCrcy,
  reference_key AS PaymentRequest,
  Currency,
  _payrq.sgtxt AS Note,
  _payrq.valut AS ValueDate,
  cast(_payrq.dtaws as farp_bnk_com_dtaws) AS DataExchangeInstructionKey,
  cast(_payrq.dtws1 as farp_dtat16) AS DataExchangeInstruction1,
  cast(_payrq.dtws2 as farp_dtat17) AS DataExchangeInstruction2,
  cast(_payrq.dtws3 as farp_dtat18) AS DataExchangeInstruction3,
  cast(_payrq.dtws4 as farp_dtat19) AS DataExchangeInstruction4,
  cast(_payrq.xpore as farp_prq_xpore) AS IsSinglePayment,
  cast( '' as fin_gl_boole ) AS BankTransferReleaseAndPay,
  cast('0000' as fclm_revision preserving type ) AS BankAccountRevision,
  cast(_payrq.lzbkz as farp_prq_lzbkz) AS StateCentralBankPaymentReason,
  _payrq.land1 AS SupplierCountry,
  cast(_payrq.uzawe as farp_uzawe) AS PaymentMethodSupplement,
  _payrq.kidno AS PaymentReference
FROM fclm_cpl_flow_it
LEFT OUTER JOIN payrq AS _payrq ON PaymentRequest = _payrq.keyno  -- association [1..1]
;