MMPUR_CAT_RTGRVW

Transparent Table Application Table
8 Fields 2 CDS Views

Rating and review table

MMPUR_CAT_RTGRVW is an SAP database table in S/4HANA. Rating and review table. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OpnCtlgReview view from BASIC Catalog Item Review
I_Reviews view from BASIC Reviews of Catalog Item

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ctlg_itm_key mmpur_cat_d_itm_key Catalog Item Key
KEY user_id mmpur_cat_user_name User Name
ext_product_id mmpur_cat_ext_prd_id External Product ID
ws_service_id mmpur_cat_ws_serv_id Catalog Web Serv ID
rating mmpur_cat_rating Rating
review mmpur_cat_review Customer Review
date_time mmpur_cat_date_time Date Time

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.

-- Rating and review table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_RTGRVW (
    MANDT,           -- Client [mandt]
    CTLG_ITM_KEY,    -- Catalog Item Key [mmpur_cat_d_itm_key]
    USER_ID,         -- User Name [mmpur_cat_user_name]
    EXT_PRODUCT_ID,  -- External Product ID [mmpur_cat_ext_prd_id]
    WS_SERVICE_ID,   -- Catalog Web Serv ID [mmpur_cat_ws_serv_id]
    RATING,          -- Rating [mmpur_cat_rating]
    REVIEW,          -- Customer Review [mmpur_cat_review]
    DATE_TIME,       -- Date Time [mmpur_cat_date_time]
    PRIMARY KEY (MANDT, CTLG_ITM_KEY, USER_ID)
);

Learn More