MMPUR_CAT_MY_FAV

Transparent Table Application Table
30 Fields 1 CDS Views

Personal Markers

MMPUR_CAT_MY_FAV is an SAP database table in S/4HANA. Personal Markers. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Mmpur_Cat_Favourites view from BASIC CDS View for User Favourites

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY user_id mmpur_cat_user_name User Name
KEY ctlg_itm_key mmpur_cat_d_itm_key Catalog Item Key
ext_product_id wsi_oci_bbp_catalogitem External Bid
ws_service_id bbp_ws_service_id Web Service ID
description mmpur_cat_desc_text Product Description
price wsi_oci_price Price
currency waers Currency
averagerating mmpur_cat_rating Rating
unit wsi_oci_unit Unit of Meas.
minorderquantity wsi_oci_quantity Quantity
main_image_url mmpur_cat_url Catalog Main Img URL
thumbnail_url mmpur_cat_url Catalog Main Img URL
vendor_name mmpur_cat_vendor_name Vendor Name
leadtime wsi_oci_leadtime Delivery Time
manufactname mmpur_cat_manfct_name Manufacturer Name
ismanagedbycatlg boolean Boolean Variable (X = True, - = False, Space = Unknown)
favorite boolean Boolean Variable (X = True, - = False, Space = Unknown)
bookmark boolean Boolean Variable (X = True, - = False, Space = Unknown)
marker_type mmpur_cat_marker_type Marker Type
vendcatalogname abap.char
matnr wsi_oci_product Product
matgroup wsi_oci_product_group Product Group
vendormat wsi_oci_vendor_product Vendor Product
intcatalogname mmpur_cat_int_ctlg_name Int Catalog name
manufactmat mmpur_cat_manfct_mat Manufacturer Mat
price_quantity wsi_oci_quantity Quantity
is_del_frm_ctlg boolean Boolean Variable (X = True, - = False, Space = Unknown)
del_frm_ctlg_on bcos_tstmp Time Stamp
unit_decimal andec Rounding

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.

-- Personal Markers
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_MY_FAV (
    MANDT,             -- Client [mandt]
    USER_ID,           -- User Name [mmpur_cat_user_name]
    CTLG_ITM_KEY,      -- Catalog Item Key [mmpur_cat_d_itm_key]
    EXT_PRODUCT_ID,    -- External Bid [wsi_oci_bbp_catalogitem]
    WS_SERVICE_ID,     -- Web Service ID [bbp_ws_service_id]
    DESCRIPTION,       -- Product Description [mmpur_cat_desc_text]
    PRICE,             -- Price [wsi_oci_price]
    CURRENCY,          -- Currency [waers]
    AVERAGERATING,     -- Rating [mmpur_cat_rating]
    UNIT,              -- Unit of Meas. [wsi_oci_unit]
    MINORDERQUANTITY,  -- Quantity [wsi_oci_quantity]
    MAIN_IMAGE_URL,    -- Catalog Main Img URL [mmpur_cat_url]
    THUMBNAIL_URL,     -- Catalog Main Img URL [mmpur_cat_url]
    VENDOR_NAME,       -- Vendor Name [mmpur_cat_vendor_name]
    LEADTIME,          -- Delivery Time [wsi_oci_leadtime]
    MANUFACTNAME,      -- Manufacturer Name [mmpur_cat_manfct_name]
    ISMANAGEDBYCATLG,  -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    FAVORITE,          -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    BOOKMARK,          -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    MARKER_TYPE,       -- Marker Type [mmpur_cat_marker_type]
    VENDCATALOGNAME,   -- abap.char
    MATNR,             -- Product [wsi_oci_product]
    MATGROUP,          -- Product Group [wsi_oci_product_group]
    VENDORMAT,         -- Vendor Product [wsi_oci_vendor_product]
    INTCATALOGNAME,    -- Int Catalog name [mmpur_cat_int_ctlg_name]
    MANUFACTMAT,       -- Manufacturer Mat [mmpur_cat_manfct_mat]
    PRICE_QUANTITY,    -- Quantity [wsi_oci_quantity]
    IS_DEL_FRM_CTLG,   -- Boolean Variable (X = True, - = False, Space = Unknown) [boolean]
    DEL_FRM_CTLG_ON,   -- Time Stamp [bcos_tstmp]
    UNIT_DECIMAL,      -- Rounding [andec]
    PRIMARY KEY (MANDT, USER_ID, CTLG_ITM_KEY)
);

Learn More