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