I_ProcmtHubRpldPOOutputParam

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_ProcmtHubRpldPOOutputParam.
-- 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: IPRMTHBRPLDPOOM

CREATE VIEW I_ProcmtHubRpldPOOutputParam AS
SELECT
  PurchaseOrder,
  ExtSourceSystem,
  PurchasingDocumentCategory,
  cast(PurchaseOrderType as abap.char( 4 )) AS PurchaseOrderType,
  cast(CompanyCode as abap.char( 4 )) AS CompanyCode,
  Supplier,
  cast(PurchasingGroup as abap.char( 3 )) AS PurchasingGroup,
  cast(PurchasingOrganization as abap.char( 4 )) AS PurchasingOrganization,
  SupplyingSupplier,
  InvoicingParty,
  PaymentTerms,
  cast(IncotermsClassification as abap.char( 3 )) AS IncotermsClassification,
  IncotermsTransferLocation,
  cast(IncotermsVersion as abap.char( 4 )) AS IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  DocumentCurrency,
  cast (ExchangeRate as abap.dec(9,5)) AS ExchangeRate,
  VATRegistrationCountry,
  CorrespncExternalReference,
  CorrespncInternalReference
FROM I_ProcmtHubRpldPurchaseOrder
LEFT OUTER JOIN I_ProcmtHubRpldPurchaseOrder AS _RpldPurchaseOrder ON _RpldPurchaseOrder.PurchaseOrder = PurchaseOrder AND _RpldPurchaseOrder.ExtSourceSystem = ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN E_PrmtHbRpldPurchaseOrder AS _Extension ON _Extension.PurchaseOrder = PurchaseOrder AND _Extension.ExtSourceSystem = ExtSourceSystem  -- association [0..1]
;