I_REVIEWS

CDS View
7 Fields 1 CDS Views

Reviews of Catalog Item

I_REVIEWS is a CDS View in S/4HANA. Reviews of Catalog Item. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_Reviews view from CONSUMPTION Reviews of Catalog Items

Fields (7)

KeyField CDS FieldsUsed in Views
KEY OpnCtlgItemID OpnCtlgItemID 1
KEY UserID UserID 1
OpenCatalogItemReviewText ReviewedByUser 1
OpenCatalogUserRatingValue UsageRating 1
OpnCtlgChangedDateTimeValue ChangedDateTime 1
OpnCtlgExternalProductID OpnCtlgExternalProductID 1
OpnCtlgWebServiceID OpnCtlgWebServiceID 1

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.

-- Reviews of Catalog Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REVIEWS (
    OPNCTLGITEMID,
    USERID,
    OPENCATALOGITEMREVIEWTEXT,
    OPENCATALOGUSERRATINGVALUE,
    OPNCTLGCHANGEDDATETIMEVALUE,
    OPNCTLGEXTERNALPRODUCTID,
    OPNCTLGWEBSERVICEID,
    PRIMARY KEY (OPNCTLGITEMID, USERID)
);

Learn More