MMPUR_ANA_CENCTR

Transparent Table Application Table
40 Fields 1 CDS Views

Central Contracts Price data for analytics

MMPUR_ANA_CENCTR is an SAP database table in S/4HANA. Central Contracts Price data for analytics. It contains 40 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CntrlPurContrWthPriceHist view from BASIC Central Contracts Price data

Fields (40)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY active_doc_number EBELN_AD Active Purchase Doc
KEY document_version REVNO Version
KEY item EBELP Item
KEY plant_unique_id MMPUR_BE_PLANT_UNIQUE_ID Plant Unique ID
KEY validity_uuid VALIDITY_UUID Validity ID
KEY is_current_version BOOLE_D TRUE
document_number EBELN Purchasing Doc.
document_sub_type BSAKZ Control
contract_type ESART Document Type
price_validity_start_date DATAB Valid From
price_validity_end_date DATBI Valid To
net_price_doc_curr NPRC NET PRICE
net_price_rep_currency1 NPRC NET PRICE
net_price_rep_currency2 NPRC NET PRICE
effective_price_doc_curr EFFWR Effective value
effective_price_rep_curr1 NPRC NET PRICE
effective_price_rep_curr2 NPRC NET PRICE
base_price_doc_curr NPRC NET PRICE
base_price_rep_currency1 NPRC NET PRICE
base_price_rep_currency2 NPRC NET PRICE
document_currency WAERS Currency
reporting_currency1 WAERS_REPCURR1 Reporting Currency 1
reporting_currency2 WAERS_REPCURR2 Reporting Currency 2
version_creation_date DATUM Date
supplier ELIFN Supplier
company_code BUKRS Company Code
purchasing_org EKORG Purchasing Org.
purchasing_group EKGRP Purch. Group
extmaterialforpurg MM_PUR_HUB_MATNR Material
item_description TXZ01 Short Text
material_group MATKL Material Group
change_reason_indicator BOOLE_D TRUE
unit_of_measure LAGME Base Unit
changed_by ERCNAM Changed By
incoterms1 INCO1 Incoterms
incoterms2 INCO2 Incoterms 2
payment_terms DZTERM Pyt Terms
shipping_instructions VSBED Shipping Conditions
company_code_group MMPUR_D_CC_GROUPING_ID Grouping ID

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 Contracts Price data for analytics
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_ANA_CENCTR (
    MANDT,                      -- Client [MANDT]
    ACTIVE_DOC_NUMBER,          -- Active Purchase Doc [EBELN_AD]
    DOCUMENT_VERSION,           -- Version [REVNO]
    ITEM,                       -- Item [EBELP]
    PLANT_UNIQUE_ID,            -- Plant Unique ID [MMPUR_BE_PLANT_UNIQUE_ID]
    VALIDITY_UUID,              -- Validity ID [VALIDITY_UUID]
    IS_CURRENT_VERSION,         -- TRUE [BOOLE_D]
    DOCUMENT_NUMBER,            -- Purchasing Doc. [EBELN]
    DOCUMENT_SUB_TYPE,          -- Control [BSAKZ]
    CONTRACT_TYPE,              -- Document Type [ESART]
    PRICE_VALIDITY_START_DATE,  -- Valid From [DATAB]
    PRICE_VALIDITY_END_DATE,    -- Valid To [DATBI]
    NET_PRICE_DOC_CURR,         -- NET PRICE [NPRC]
    NET_PRICE_REP_CURRENCY1,    -- NET PRICE [NPRC]
    NET_PRICE_REP_CURRENCY2,    -- NET PRICE [NPRC]
    EFFECTIVE_PRICE_DOC_CURR,   -- Effective value [EFFWR]
    EFFECTIVE_PRICE_REP_CURR1,  -- NET PRICE [NPRC]
    EFFECTIVE_PRICE_REP_CURR2,  -- NET PRICE [NPRC]
    BASE_PRICE_DOC_CURR,        -- NET PRICE [NPRC]
    BASE_PRICE_REP_CURRENCY1,   -- NET PRICE [NPRC]
    BASE_PRICE_REP_CURRENCY2,   -- NET PRICE [NPRC]
    DOCUMENT_CURRENCY,          -- Currency [WAERS]
    REPORTING_CURRENCY1,        -- Reporting Currency 1 [WAERS_REPCURR1]
    REPORTING_CURRENCY2,        -- Reporting Currency 2 [WAERS_REPCURR2]
    VERSION_CREATION_DATE,      -- Date [DATUM]
    SUPPLIER,                   -- Supplier [ELIFN]
    COMPANY_CODE,               -- Company Code [BUKRS]
    PURCHASING_ORG,             -- Purchasing Org. [EKORG]
    PURCHASING_GROUP,           -- Purch. Group [EKGRP]
    EXTMATERIALFORPURG,         -- Material [MM_PUR_HUB_MATNR]
    ITEM_DESCRIPTION,           -- Short Text [TXZ01]
    MATERIAL_GROUP,             -- Material Group [MATKL]
    CHANGE_REASON_INDICATOR,    -- TRUE [BOOLE_D]
    UNIT_OF_MEASURE,            -- Base Unit [LAGME]
    CHANGED_BY,                 -- Changed By [ERCNAM]
    INCOTERMS1,                 -- Incoterms [INCO1]
    INCOTERMS2,                 -- Incoterms 2 [INCO2]
    PAYMENT_TERMS,              -- Pyt Terms [DZTERM]
    SHIPPING_INSTRUCTIONS,      -- Shipping Conditions [VSBED]
    COMPANY_CODE_GROUP,         -- Grouping ID [MMPUR_D_CC_GROUPING_ID]
    PRIMARY KEY (MANDT, ACTIVE_DOC_NUMBER, DOCUMENT_VERSION, ITEM, PLANT_UNIQUE_ID, VALIDITY_UUID, IS_CURRENT_VERSION)
);

Learn More