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