SNWD_REV_ITEM

Transparent Table Temporary Data

EPM: Review Item Table

SNWD_REV_ITEM is an SAP database table in S/4HANA. EPM: Review Item Table. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
SEPM_I_CollaborativeReviewPost view from EPM Demo: Collaborative Review Post
sepm_sddl_review_item view from EPM DDL Entity View for Review Item

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY node_key snwd_node_key Node Key
parent_key snwd_node_key Node Key
rated_by snwd_node_key Node Key
rated_at snwd_rated_at Date
rating snwd_average_rating Average Rating
rating_title snwd_rating_title Rating Title
rating_text snwd_rating_text Rating Text
number_helpful snwd_num_helpful Positive Responses
number_total snwd_num_responses Number of Responses

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: Review Item Table
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SNWD_REV_ITEM (
    CLIENT,          -- Client [mandt]
    NODE_KEY,        -- Node Key [snwd_node_key]
    PARENT_KEY,      -- Node Key [snwd_node_key]
    RATED_BY,        -- Node Key [snwd_node_key]
    RATED_AT,        -- Date [snwd_rated_at]
    RATING,          -- Average Rating [snwd_average_rating]
    RATING_TITLE,    -- Rating Title [snwd_rating_title]
    RATING_TEXT,     -- Rating Text [snwd_rating_text]
    NUMBER_HELPFUL,  -- Positive Responses [snwd_num_helpful]
    NUMBER_TOTAL,    -- Number of Responses [snwd_num_responses]
    PRIMARY KEY (CLIENT, NODE_KEY)
);