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