P_PaytTransRepetitiveCode

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_PaytTransRepetitiveCode.
-- 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: PRPTVCODE

CREATE VIEW P_PaytTransRepetitiveCode AS
SELECT
  bukrs AS PayingCompanyCode,
  hbkid AS HouseBank,
  rpcode AS PaymentRepetitiveCode,
  hktid AS HouseBankAccount,
  chain AS BankChain,
  banks AS BankCountryKey,
  bankl AS BankKey,
  bankn AS BankAccount,
  bkont AS BankControlKey,
  bkref AS BankDetailReference,
  koinh AS BankAccountHolderName,
  ptype AS RcvgPaytBusPartnerCategory,
  partn AS RcvgPaytBusPartnerReference,
  parta AS PartnerBankDetailKey,
  pbukr AS CompanyCode,
  zlsch AS PaymentMethod,
  waers AS Currency,
  urele AS RepetitiveCodeReleasedBy,
  zpayment_system AS PayeePaymentSystem,
  zalias_type AS PayeeAliasType,
  zbank_alias AS PayeeAliasName
FROM fibl_rpcode
LEFT OUTER JOIN I_PaymentSystem AS _PaymentSystem ON PayeePaymentSystem = _PaymentSystem.PaymentSystem  -- association [0..1]
LEFT OUTER JOIN I_AliasType AS _AliasType ON PayeeAliasType = _AliasType.AliasType  -- association [0..1]
;