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