SNWD_SO_TEST

Transparent Table Temporary Data
27 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 27 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 (27)

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 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
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
dummy abap.char
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,        -- 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]
    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]
    DUMMY,             -- abap.char
    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