I_PaymentOrder

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_PaymentOrder.
-- 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: IPAYTORDHDR

CREATE VIEW I_PaymentOrder AS
SELECT
  pyordh.pyord AS PaymentOrder,
  pyordh.laufd AS PaymentRunDate,
  pyordh.laufi AS PaymentRunID,
  pyordh.rzawe AS PaymentMethod,
  pyordh.waers AS PaymentCurrency,
  pyordh.zbukr AS PayingCompanyCode,
  pyordh.hbkid AS HouseBank,
  pyordh.hktid AS HouseBankAccount,
  cast(pyordh.rwbtr as farp_rwbtr) AS PaidAmountInPaytCurrency,
  pyordh.lifnr AS Supplier,
  pyordh.kunnr AS Customer,
  pyordh.valut AS ValueDate,
  pyordh.fdlev AS PlanningLevel,
  pyordh.bnkko AS GLAccount,
  pyordh.curra AS PlanningCurrency,
  cast(pyordh.rbetr as farp_rbetr) AS AmountInCompanyCodeCurrency,
  pyordh.srtgb AS BusinessArea,
  pyordh.x_dd_prenotif AS DirectDebitPreNotification,
  _CompanyCode.Currency AS CompanyCodeCurrency
FROM pyordh
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON PayingCompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PaymentCurrency ON PaymentCurrency = _PaymentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [0..1]
;