SEPM_I_PurchaseOrder_E

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 SEPM_I_PurchaseOrder_E.
-- 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: SEPM_IPOE

CREATE VIEW SEPM_I_PurchaseOrder_E AS
SELECT
  PO.PurchaseOrder AS PurchaseOrder,
  cast ( BP.BusinessPartner as snwd_supplier_id preserving type ) AS Supplier,
  PO.TransactionCurrency AS TransactionCurrency,
  PO.GrossAmountInTransacCurrency AS GrossAmountInTransacCurrency,
  PO.NetAmountInTransactionCurrency AS NetAmountInTransactionCurrency,
  PO.TaxAmountInTransactionCurrency AS TaxAmountInTransactionCurrency,
  PO.PurchaseOrderLifeCycleStatus AS PurchaseOrderLifeCycleStatus,
  PO.PurchaseOrderApprovalStatus AS PurchaseOrderApprovalStatus,
  PO.PurchaseOrderConfStatus AS PurchaseOrderConfStatus,
  PO.PurchaseOrderOrderingStatus AS PurchaseOrderOrderingStatus,
  PO.PurchaseOrderInvoicingStatus AS PurchaseOrderInvoicingStatus,
  PO.PurchaseOrderOverallStatus AS PurchaseOrderOverallStatus,
  PO._CreatedByUser.SystemUser AS CreatedBySystemUser,
  PO._LastChangedByUser.SystemUser AS LastChangedBySystemUser,
  PO.CreationDateTime AS CreationDateTime,
  PO.LastChangedDateTime AS LastChangedDateTime,
  PO._TransactionCurrency AS _TransactionCurrency,
  PO._ApprovalStatus AS _ApprovalStatus,
  PO._InvoicingStatus AS _InvoicingStatus,
  PO._OrderingStatus AS _OrderingStatus,
  PO._ConfirmationStatus AS _ConfirmationStatus,
  PO._LifeCycleStatus AS _LifeCycleStatus,
  PO._OverallStatus AS _OverallStatus
FROM SEPM_I_PurchaseOrder AS PO
LEFT OUTER JOIN SEPM_I_BusinessPartner AS BP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN SEPM_I_PurchaseOrderItem_E AS _Item ON PurchaseOrder = _Item.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN SEPM_I_PurchaseOrderText_E AS _Text ON PurchaseOrder = _Text.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN SEPM_I_BusinessPartner_E AS _Supplier ON Supplier = _Supplier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SUPPLIER_E AS _SupplierV2 ON Supplier = _SupplierV2.Supplier  -- association [0..1]
;