MMPUR_CAT_PRCSCL

Transparent Table Application Table
7 Fields 1 CDS Views

Price scale for catalog items

MMPUR_CAT_PRCSCL is an SAP database table in S/4HANA. Price scale for catalog items. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_Pricescale view from BASIC

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY pricscl_key mmpur_cat_d_prcscl_key Price scale Key
ctlg_itm_key mmpur_cat_d_itm_key Catalog Item Key
scaletype char2 Component of the Version Number
low wsi_oci_quantity Quantity
high wsi_oci_quantity Quantity
price wsi_oci_price Price

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.

-- Price scale for catalog items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_PRCSCL (
    MANDT,         -- Client [mandt]
    PRICSCL_KEY,   -- Price scale Key [mmpur_cat_d_prcscl_key]
    CTLG_ITM_KEY,  -- Catalog Item Key [mmpur_cat_d_itm_key]
    SCALETYPE,     -- Component of the Version Number [char2]
    LOW,           -- Quantity [wsi_oci_quantity]
    HIGH,          -- Quantity [wsi_oci_quantity]
    PRICE,         -- Price [wsi_oci_price]
    PRIMARY KEY (MANDT, PRICSCL_KEY)
);

Learn More