SEPM_I_PURCHASEORDER_E

CDS View
14 Fields 4 CDS Views

EPM Demo: Purchase Order with Ext IDs

SEPM_I_PURCHASEORDER_E is a CDS View in S/4HANA. EPM Demo: Purchase Order with Ext IDs. It contains 14 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
REPM_ClosePurOrderC view from Close Purchase Order Cube View
REPM_OpenPurOrderC1 view from Open Days Dimension View
REPM_PurchaseOrderC view from Purchase Order Cube View
S_Epm_Wf_Po view from CDS view for Purchase Order in annotation based task UI

Fields (14)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 4
CreationDateTime CreationDateTime 1
GrossAmountInTransacCurrency GrossAmnt,GrossAmountInTransacCurrency 4
LastChangedDateTime LastChangedDateTime 1
NetAmountInTransactionCurrency DataPoint01 1
PurchaseOrderApprovalStatus PurchaseOrderApprovalStatus 1
PurchaseOrderConfStatus PurchaseOrderConfStatus 1
PurchaseOrderInvoicingStatus PurchaseOrderInvoicingStatus 1
PurchaseOrderLifeCycleStatus PurchaseOrderLifeCycleStatus 1
PurchaseOrderOrderingStatus PurchaseOrderOrderingStatus 1
PurchaseOrderOverallStatus OverallStatus,PurchaseOrderOverallStatus 2
Supplier Supplier 1
TaxAmountInTransactionCurrency TaxAmountInTransactionCurrency 1
TransactionCurrency TransactionCurrency 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- EPM Demo: Purchase Order with Ext IDs
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SEPM_I_PURCHASEORDER_E (
    PURCHASEORDER,
    CREATIONDATETIME,
    GROSSAMOUNTINTRANSACCURRENCY,
    LASTCHANGEDDATETIME,
    NETAMOUNTINTRANSACTIONCURRENCY,
    PURCHASEORDERAPPROVALSTATUS,
    PURCHASEORDERCONFSTATUS,
    PURCHASEORDERINVOICINGSTATUS,
    PURCHASEORDERLIFECYCLESTATUS,
    PURCHASEORDERORDERINGSTATUS,
    PURCHASEORDEROVERALLSTATUS,
    SUPPLIER,
    TAXAMOUNTINTRANSACTIONCURRENCY,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (PURCHASEORDER)
);

Learn More