SNWD_STOCK

Transparent Table Temporary Data
9 Fields 2 CDS Views

EPM: Stock Table

SNWD_STOCK is an SAP database table in S/4HANA. EPM: Stock Table. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SEPM_I_Stock view from EPM Demo: Stock
sepm_sddl_stock view from

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_key SNWD_NODE_KEY Node Key
product_guid SNWD_NODE_KEY Node Key
org_unit_guid SNWD_NODE_KEY Node Key
bin_number SNWD_STOCK_BIN_NUMBER Bin Number
quantity_unit SNWD_QUANTITY_UNIT Unit of Measure
quantity SNWD_QUANTITY Quantity
lot_size SNWD_LOT_SIZE Lot Size
min_stock SNWD_MIN_STOCK Minimum Stock

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: Stock Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_STOCK (
    CLIENT,         -- Client [MANDT]
    NODE_KEY,       -- Node Key [SNWD_NODE_KEY]
    PRODUCT_GUID,   -- Node Key [SNWD_NODE_KEY]
    ORG_UNIT_GUID,  -- Node Key [SNWD_NODE_KEY]
    BIN_NUMBER,     -- Bin Number [SNWD_STOCK_BIN_NUMBER]
    QUANTITY_UNIT,  -- Unit of Measure [SNWD_QUANTITY_UNIT]
    QUANTITY,       -- Quantity [SNWD_QUANTITY]
    LOT_SIZE,       -- Lot Size [SNWD_LOT_SIZE]
    MIN_STOCK,      -- Minimum Stock [SNWD_MIN_STOCK]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More