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