MMPUR_ANA_VALPRC

Transparent Table Application Table
14 Fields 1 CDS Views

Central Contract Price Components

MMPUR_ANA_VALPRC is an SAP database table in S/4HANA. Central Contract Price Components. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlContrPriceComponents view from BASIC Central Contract Price Components

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY validity_uuid validity_uuid Validity ID
KEY condition_uuid condition_counter Condition ID
price_category prc_category Type of pricing
condition_type kschl Condition Type
condition_text kschl_txt Name
change_reason cndn_chgreason Cndn Change Reason
condition_amt_doc_curr nprc NET PRICE
condition_amt_rep_curr1 nprc NET PRICE
condition_amt_rep_curr2 nprc NET PRICE
document_currency waers Currency
reporting_currency1 waers_repcurr1 Reporting Currency 1
reporting_currency2 waers_repcurr2 Reporting Currency 2
sort_order numc4 Counter

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.

-- Central Contract Price Components
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_ANA_VALPRC (
    MANDT,                    -- Client [mandt]
    VALIDITY_UUID,            -- Validity ID [validity_uuid]
    CONDITION_UUID,           -- Condition ID [condition_counter]
    PRICE_CATEGORY,           -- Type of pricing [prc_category]
    CONDITION_TYPE,           -- Condition Type [kschl]
    CONDITION_TEXT,           -- Name [kschl_txt]
    CHANGE_REASON,            -- Cndn Change Reason [cndn_chgreason]
    CONDITION_AMT_DOC_CURR,   -- NET PRICE [nprc]
    CONDITION_AMT_REP_CURR1,  -- NET PRICE [nprc]
    CONDITION_AMT_REP_CURR2,  -- NET PRICE [nprc]
    DOCUMENT_CURRENCY,        -- Currency [waers]
    REPORTING_CURRENCY1,      -- Reporting Currency 1 [waers_repcurr1]
    REPORTING_CURRENCY2,      -- Reporting Currency 2 [waers_repcurr2]
    SORT_ORDER,               -- Counter [numc4]
    PRIMARY KEY (MANDT, VALIDITY_UUID, CONDITION_UUID)
);

Learn More