SNWD_PO

Transparent Table Temporary Data
19 Fields 2 CDS Views

EPM: Purchase Order Header Table

SNWD_PO is an SAP database table in S/4HANA. EPM: Purchase Order Header Table. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SEPM_I_PurchaseOrder view from EPM Demo: Purchase Order
sepm_sddl_purchaseorder_header view from

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_key SNWD_NODE_KEY Node Key
po_id SNWD_PO_ID Purchase Order ID
created_by SNWD_NODE_KEY Node Key
created_at SNWD_CREATED_AT Created At
changed_by SNWD_NODE_KEY Node Key
changed_at SNWD_CHANGED_AT Changed At
note_guid SNWD_NODE_KEY Node Key
partner_guid SNWD_NODE_KEY Node Key
currency_code SNWD_CURR_CODE Currency Code
gross_amount SNWD_TTL_GROSS_AMOUNT Gross Amount
net_amount SNWD_TTL_NET_AMOUNT Net Amount
tax_amount SNWD_TTL_TAX_AMOUNT Tax Amount
lifecycle_status SNWD_PO_LC_STATUS_CODE Lifecycle Status
approval_status SNWD_PO_AP_STATUS_CODE Approval Status
confirm_status SNWD_PO_CF_STATUS_CODE Confirmation Status
ordering_status SNWD_PO_OR_STATUS_CODE Ordering Status
invoicing_status SNWD_PO_IN_STATUS_CODE Invoicing Status
overall_status SNWD_PO_OA_STATUS_CODE Overall Status

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: Purchase Order Header Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_PO (
    CLIENT,            -- Client [MANDT]
    NODE_KEY,          -- Node Key [SNWD_NODE_KEY]
    PO_ID,             -- Purchase Order ID [SNWD_PO_ID]
    CREATED_BY,        -- Node Key [SNWD_NODE_KEY]
    CREATED_AT,        -- Created At [SNWD_CREATED_AT]
    CHANGED_BY,        -- Node Key [SNWD_NODE_KEY]
    CHANGED_AT,        -- Changed At [SNWD_CHANGED_AT]
    NOTE_GUID,         -- Node Key [SNWD_NODE_KEY]
    PARTNER_GUID,      -- Node Key [SNWD_NODE_KEY]
    CURRENCY_CODE,     -- Currency Code [SNWD_CURR_CODE]
    GROSS_AMOUNT,      -- Gross Amount [SNWD_TTL_GROSS_AMOUNT]
    NET_AMOUNT,        -- Net Amount [SNWD_TTL_NET_AMOUNT]
    TAX_AMOUNT,        -- Tax Amount [SNWD_TTL_TAX_AMOUNT]
    LIFECYCLE_STATUS,  -- Lifecycle Status [SNWD_PO_LC_STATUS_CODE]
    APPROVAL_STATUS,   -- Approval Status [SNWD_PO_AP_STATUS_CODE]
    CONFIRM_STATUS,    -- Confirmation Status [SNWD_PO_CF_STATUS_CODE]
    ORDERING_STATUS,   -- Ordering Status [SNWD_PO_OR_STATUS_CODE]
    INVOICING_STATUS,  -- Invoicing Status [SNWD_PO_IN_STATUS_CODE]
    OVERALL_STATUS,    -- Overall Status [SNWD_PO_OA_STATUS_CODE]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More