MMPUR_CAT_PRCONV

Transparent Table Application Table
6 Fields 3 CDS Views

Price Conversion Table

MMPUR_CAT_PRCONV is an SAP database table in S/4HANA. Price Conversion Table. It contains 6 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_OpnCtlgPriceConversion view from BASIC Catalog Item Price Convertion
I_Priceconversion view left_outer BASIC Basic view for Price Conversion
P_Priceconversion view from BASIC Basic view for Price Conversion

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY price_key mmpur_cat_d_prc_key Price Key
itm_price mmpur_cat_itm_price_curr Catalog Item Price
itm_currency mmpur_cat_itm_currency Currency
price_comm_curr mmpur_cat_com_price_curr Itm Prc in Com Crcy
common_currency mmpur_cat_itm_currency Currency

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 Conversion Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_CAT_PRCONV (
    MANDT,            -- Client [mandt]
    PRICE_KEY,        -- Price Key [mmpur_cat_d_prc_key]
    ITM_PRICE,        -- Catalog Item Price [mmpur_cat_itm_price_curr]
    ITM_CURRENCY,     -- Currency [mmpur_cat_itm_currency]
    PRICE_COMM_CURR,  -- Itm Prc in Com Crcy [mmpur_cat_com_price_curr]
    COMMON_CURRENCY,  -- Currency [mmpur_cat_itm_currency]
    PRIMARY KEY (MANDT, PRICE_KEY)
);

Learn More