SEPM_I_PurchaseOrder

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.
-- 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_IPO

CREATE VIEW SEPM_I_PurchaseOrder AS
SELECT
  node_key AS PurchaseOrderUUID,
  po_id AS PurchaseOrder,
  note_guid AS ShortTextGroupUUID,
  partner_guid AS SupplierUUID,
  currency_code AS TransactionCurrency,
  gross_amount AS GrossAmountInTransacCurrency,
  net_amount AS NetAmountInTransactionCurrency,
  tax_amount AS TaxAmountInTransactionCurrency,
  lifecycle_status AS PurchaseOrderLifeCycleStatus,
  approval_status AS PurchaseOrderApprovalStatus,
  confirm_status AS PurchaseOrderConfStatus,
  ordering_status AS PurchaseOrderOrderingStatus,
  invoicing_status AS PurchaseOrderInvoicingStatus,
  overall_status AS PurchaseOrderOverallStatus,
  created_by AS CreatedByUser,
  created_at AS CreationDateTime,
  changed_by AS LastChangedByUser,
  changed_at AS LastChangedDateTime
FROM snwd_po
LEFT OUTER JOIN SEPM_I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN SEPM_I_ShortTextGroup AS _ShortTextGroup ON ShortTextGroupUUID = _ShortTextGroup.ShortTextGroupUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_BusinessPartner AS _Supplier ON SupplierUUID = _Supplier.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_SUPPLIER AS _SupplierV2 ON SupplierUUID = _SupplierV2.SupplierUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PurchaseOrderItem AS _Item ON PurchaseOrderUUID = _Item.PurchaseOrderUUID  -- association [0..*]
LEFT OUTER JOIN SEPM_I_PurOrdLifeCycleStatus AS _LifeCycleStatus ON PurchaseOrderLifeCycleStatus = _LifeCycleStatus.PurchaseOrderLifeCycleStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PurOrdApprovalStatus AS _ApprovalStatus ON PurchaseOrderApprovalStatus = _ApprovalStatus.PurchaseOrderApprovalStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PurOrdInvoicingStatus AS _InvoicingStatus ON PurchaseOrderInvoicingStatus = _InvoicingStatus.PurchaseOrderInvoicingStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PurOrdOrderingStatus AS _OrderingStatus ON PurchaseOrderOrderingStatus = _OrderingStatus.PurchaseOrderOrderingStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PurOrdConfStatus AS _ConfirmationStatus ON PurchaseOrderConfStatus = _ConfirmationStatus.PurchaseOrderConfStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_PurOrdOverallStatus AS _OverallStatus ON PurchaseOrderOverallStatus = _OverallStatus.PurchaseOrderOverallStatus  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Employee AS _CreatedByUser ON CreatedByUser = _CreatedByUser.EmployeeUUID  -- association [0..1]
LEFT OUTER JOIN SEPM_I_Employee AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.EmployeeUUID  -- association [0..1]
;