P_MakeBankTransferTemplate

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 P_MakeBankTransferTemplate.
-- 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: PMBKWITHTMPL

CREATE VIEW P_MakeBankTransferTemplate AS
SELECT
  concat(concat(a.rpcode,a.bukrs),a.hbkid) AS RepetitiveCodeFlowID,
  a.rpcode AS RepetitiveCode,
  a.bukrs AS PayingCompanyCode,
  a.hbkid AS PayingHouseBank,
  a.hktid AS PayingHouseBankAccount,
  a.pbukr AS PayeeCompanyCode,
  cast(a.partn as fclm_bam_aclink_hbkid ) AS HouseBank,
  a.partn AS PayeeHouseBank,
  cast(a.parta as fclm_bam_aclink_hktid ) AS HouseBankAccount,
  a.parta AS PayeeHouseBankAccount,
  cast(a.zlsch as char1) AS PaymentMethod,
  a.waers AS Currency,
  _rpcodetext.rp_text AS RepetitiveCodeReferenceText,
  a.banks AS BankCountry,
  a.bankl AS PayingBankKey,
  a.bankn AS PayeeBankAccount,
  a.ptype AS RepetitiveCodeCategory,
  a.dcrea AS CreationDate,
  a.ucrea AS CreationUserName,
  a.drele AS LastChangeDate,
  a.urele AS LastChangeByUserName
FROM fibl_rpcode AS a
LEFT OUTER JOIN fibl_rpcode_tdef AS _rpcodetext ON /* join condition not captured in parsed metadata */
;