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 EPM: DDL View for Stock

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