SNWD_PD

Transparent Table Temporary Data
24 Fields 28 CDS Views

EPM: Product Data Table

SNWD_PD is an SAP database table in S/4HANA. EPM: Product Data Table. It contains 24 fields. 28 CDS views read from this table.

CDS Views using this table (28)

ViewTypeJoinVDMDescription
DEMO_CDS_EPM_PRODUCT view_entity from EPM Demo: Product
I_Sadl_Voc_Salesorder_Item view left_outer BASIC Vocan Core View: Sales Order Item
SADL_GwVAunitV2Parameter_Syst view from View with hidden system parameters
SADL_GwVAunitV2Prod view from Product for local unit tests
SADL_V_2Parameters view from
SADL_V_AnalyticsAnnotations view from
SADL_V_AnalyticsDetails view from
SADL_V_Annotations_RT view from
SADL_V_AUnit_Prod view from Product for local unit tests
SADL_V_CDS_Parameter view from
SADL_V_EXP_CustomerProd_VH view from End user customer products
SADL_V_EXP_CustomerProduct view from End user customer products
SADL_V_EXP_ProductCategory view from CDS view to test view parameters
Sadl_V_Param_Visible_Client view from View which must not be exposed
SADL_V_Parameter view from
SADL_V_Parameter_Analytics view from
Sadl_V_Parameter_Syst view from View with hidden system parameters
Sadl_V_Parameter_Syst_Anly view from Analytical view with implicit system parameters
SADL_V_Parameter_Type view from
SADL_V_SearchAnno view from
SADL_V_SearchAnnotations view from
sepm_cds_product view from
SEPM_E_Product view from EPM Demo: Product Extension
SEPM_I_Product view from EPM Demo: Product
sepm_sddl_product view from
SEPMRA_I_Product_E view from Product
SEPMRA_I_ProductAttachment view inner Product Attachment
SEPMRA_I_ProductText view from Product Text

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY node_key SNWD_NODE_KEY Node Key
product_id SNWD_PRODUCT_ID Product ID
type_code SNWD_PRODUCT_TYPE_CODE Type Code
category SNWD_PRODUCT_CATEGORY Category
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
name_guid SNWD_NODE_KEY Node Key
desc_guid SNWD_NODE_KEY Node Key
supplier_guid SNWD_NODE_KEY Node Key
tax_tarif_code SNWD_PRODUCT_TAX_TARIF_CODE Tax Tariff Code
measure_unit SNWD_QUANTITY_UNIT Unit of Measure
weight_measure SNWD_WEIGHT_MEASURE Weight
weight_unit SNWD_WEIGHT_UNIT Unit of Measure
currency_code SNWD_CURR_CODE Currency Code
price SNWD_UNIT_PRICE Price
product_pic_url SNWD_PRODUCT_PIC_URL Image
width SNWD_WIDTH Width
depth SNWD_DEPTH Depth
height SNWD_HEIGHT Height
dim_unit SNWD_DIM_UNIT Dimension Unit
dummy_field_pd abap.char

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: Product Data Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_PD (
    CLIENT,           -- Client [MANDT]
    NODE_KEY,         -- Node Key [SNWD_NODE_KEY]
    PRODUCT_ID,       -- Product ID [SNWD_PRODUCT_ID]
    TYPE_CODE,        -- Type Code [SNWD_PRODUCT_TYPE_CODE]
    CATEGORY,         -- Category [SNWD_PRODUCT_CATEGORY]
    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]
    NAME_GUID,        -- Node Key [SNWD_NODE_KEY]
    DESC_GUID,        -- Node Key [SNWD_NODE_KEY]
    SUPPLIER_GUID,    -- Node Key [SNWD_NODE_KEY]
    TAX_TARIF_CODE,   -- Tax Tariff Code [SNWD_PRODUCT_TAX_TARIF_CODE]
    MEASURE_UNIT,     -- Unit of Measure [SNWD_QUANTITY_UNIT]
    WEIGHT_MEASURE,   -- Weight [SNWD_WEIGHT_MEASURE]
    WEIGHT_UNIT,      -- Unit of Measure [SNWD_WEIGHT_UNIT]
    CURRENCY_CODE,    -- Currency Code [SNWD_CURR_CODE]
    PRICE,            -- Price [SNWD_UNIT_PRICE]
    PRODUCT_PIC_URL,  -- Image [SNWD_PRODUCT_PIC_URL]
    WIDTH,            -- Width [SNWD_WIDTH]
    DEPTH,            -- Depth [SNWD_DEPTH]
    HEIGHT,           -- Height [SNWD_HEIGHT]
    DIM_UNIT,         -- Dimension Unit [SNWD_DIM_UNIT]
    DUMMY_FIELD_PD,   -- abap.char
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More