I_RepetitiveCode

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_RepetitiveCode.
-- 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: IRPTVCODE

CREATE VIEW I_RepetitiveCode AS
SELECT
  bukrs AS PayingCompanyCode,
  hbkid AS HouseBank,
  rpcode AS RepetitiveCode,
  hktid AS HouseBankAccount,
  pbukr AS PayeeCompanyCode,
  partn AS PayeeHouseBank,
  parta AS PayeeHouseBankAccount,
  zlsch AS PaymentMethod,
  waers AS Currency,
  banks AS BankCountry,
  companycode.Country AS CompanyCodeCountry,
  _PaytMeth.PaymentMethodName AS PaymentMethodName,
  _Reference.rp_text AS RepetitiveCodeReferenceText,
  _Reference.paymt_ref AS PaymentReference,
  _Reference.instr_key AS DataExchangeInstructionKey,
  _Reference.instr1 AS DataExchangeInstruction1,
  _Reference.instr2 AS DataExchangeInstruction2,
  _Reference.instr3 AS DataExchangeInstruction3,
  _Reference.instr4 AS DataExchangeInstruction4,
  _Reference.xpore AS IsSinglePayment,
  _Reference.scbank_ind AS StateCentralBankPaymentReason,
  _Reference.supcountry AS SupplierCountry,
  _Reference.pmtmthsupl AS PaymentMethodSupplement
FROM fibl_rpcode AS rpcode
INNER JOIN I_CompanyCode AS companycode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PaymentMethod AS _PaytMeth ON PaymentMethod = _PaytMeth.PaymentMethod AND CompanyCodeCountry = _PaytMeth.Country  -- association [1..1]
LEFT OUTER JOIN fibl_rpcode_tdef AS _Reference ON rpcode.bukrs = _Reference.bukrs AND rpcode.hbkid = _Reference.hbkid AND rpcode.rpcode = _Reference.rpcode  -- association [1..1]
;