SNWD_PD

Transparent Table Temporary Data
19 Fields 29 CDS Views

EPM: Product Data Table

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

CDS Views using this table (29)

ViewTypeJoinVDMDescription
CDS_VIEW_ENTITY_SIMPLE view_entity from SIMPLE CDS VIEW ENTITY
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 Exposure with parameters
SADL_V_AnalyticsAnnotations view from SADL_V_AnalyticsAnnotations
SADL_V_AnalyticsDetails view from SADL_V_AnalyticsAnnotations
SADL_V_Annotations_RT view from SADL_V_Annotations_RT
SADL_V_AUnit_Prod view from Product for local unit tests
SADL_V_CDS_Parameter view from test
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 Exposure with parameters
SADL_V_Parameter_Analytics view from Analytical view with parameters
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 Test
SADL_V_SearchAnno view from View with Search Annotations
SADL_V_SearchAnnotations view from SADL_V_SearchAnnotations
sepm_cds_product view from EPM CDS: Product Information
SEPM_E_Product view from EPM Demo: Product Extension
SEPM_I_Product view from EPM Demo: Product
sepm_sddl_product view from EPM: SDDL for Product
SEPMRA_I_Product_E view from Product
SEPMRA_I_ProductAttachment view inner Product Attachment
SEPMRA_I_ProductText view from Product Text

Fields (19)

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
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

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]
    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]
    PRIMARY KEY (CLIENT, NODE_KEY)
);

Learn More