SNWD_SO_TEST

Transparent Table Temporary Data
22 Fields 1 CDS Views

EPM: Sales Order Header Table

SNWD_SO_TEST is an SAP database table in S/4HANA. EPM: Sales Order Header Table. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
SADL_R_SO_UNION view from Sales Order Union Test

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
so_id snwd_so_id Sales Order ID
created_by_bp snwd_bool Value
changed_by_bp snwd_bool Value
note_guid snwd_node_key Node Key
buyer_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_so_lc_status_code Lifecycle Status
billing_status snwd_so_cf_status_code Confirmation Status
delivery_status snwd_so_or_status_code Ordering Status
op_id snwd_op_id Opportunity ID
_dataaging data_temperature Data Aging
overall_status snwd_so_oa_status_code Overall Status
buy_contact_guid snwd_node_key Node Key
ship_to_adr_guid snwd_node_key Node Key
bill_to_adr_guid snwd_node_key Node Key
payment_method snwd_so_payment_method Payment Method
payment_terms snwd_so_payment_term Payment Terms

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: Sales Order Header Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_SO_TEST (
    CLIENT,            -- Client [mandt]
    NODE_KEY,          -- Node Key [snwd_node_key]
    SO_ID,             -- Sales Order ID [snwd_so_id]
    CREATED_BY_BP,     -- Value [snwd_bool]
    CHANGED_BY_BP,     -- Value [snwd_bool]
    NOTE_GUID,         -- Node Key [snwd_node_key]
    BUYER_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_so_lc_status_code]
    BILLING_STATUS,    -- Confirmation Status [snwd_so_cf_status_code]
    DELIVERY_STATUS,   -- Ordering Status [snwd_so_or_status_code]
    OP_ID,             -- Opportunity ID [snwd_op_id]
    _DATAAGING,        -- Data Aging [data_temperature]
    OVERALL_STATUS,    -- Overall Status [snwd_so_oa_status_code]
    BUY_CONTACT_GUID,  -- Node Key [snwd_node_key]
    SHIP_TO_ADR_GUID,  -- Node Key [snwd_node_key]
    BILL_TO_ADR_GUID,  -- Node Key [snwd_node_key]
    PAYMENT_METHOD,    -- Payment Method [snwd_so_payment_method]
    PAYMENT_TERMS,     -- Payment Terms [snwd_so_payment_term]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More