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

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