I_PaytReqChgAndPostingData

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_PaytReqChgAndPostingData.
-- 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_PaytReqChgAndPostingData AS
SELECT
  cast(payrqc.keyno as farp_prq_keyno preserving type) AS PaymentRequest,
  cast(payrqc.chusr as farp_changed_by preserving type) AS LastChangedByUser,
  payrqc.chtime AS LastChangeTime,
  cast(payrqc.chdate as ttet_dt_chg_date preserving type) AS LastChangeDate,
  cast(payrqc.koart as farp_koart preserving type) AS FinancialAccountType,
  cast(payrqc.konto as farp_account_apar) AS CustomerSupplierAccount,
  payrqc.sgtxt AS DocumentItemText,
  cast(payrqc.payrq_type as farp_payrq_type preserving type) AS PaymentRequestType,
  payrqc.chainid AS BankChain
FROM payrqc
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON CustomerSupplierAccount = _Customer.Customer  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON CustomerSupplierAccount = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN E_PaymentRequest AS _Extension ON PaymentRequest = _Extension.PaymentRequest  -- association [1..1]
;