MMPUR_ANA_CENCTR

Central Contracts Price data for analytics | #transactional | Component: Reporting
Column Name Description
MANDT Client
ACTIVE_DOC_NUMBER Active Purchasing Document
DOCUMENT_VERSION Version number in Purchasing
ITEM Item Number of Purchasing Document
PLANT_UNIQUE_ID Plant Unique ID
VALIDITY_UUID Validity ID for the central purchase contract
IS_CURRENT_VERSION Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description
💲 Currency Key (EKKO.WAERS):
NET_PRICE_DOC_CURR Price in reporting currency
NET_PRICE_REP_CURRENCY1 Price in reporting currency
NET_PRICE_REP_CURRENCY2 Price in reporting currency
EFFECTIVE_PRICE_DOC_CURR Effective value of item
EFFECTIVE_PRICE_REP_CURR1 Price in reporting currency
EFFECTIVE_PRICE_REP_CURR2 Price in reporting currency
BASE_PRICE_DOC_CURR Price in reporting currency
BASE_PRICE_REP_CURRENCY1 Price in reporting currency
BASE_PRICE_REP_CURRENCY2 Price in reporting currency
Column Name Description
Column Name Description
PRICE_VALIDITY_START_DATE Valid-From Date
PRICE_VALIDITY_END_DATE Valid To Date
VERSION_CREATION_DATE Date
Column Name Description
IS_CURRENT_VERSION Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
DOCUMENT_SUB_TYPE Control indicator for purchasing document type Show values
CHANGE_REASON_INDICATOR Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
Column Name Description Domain name
DOCUMENT_NUMBER Purchasing Document Number EBELN
CONTRACT_TYPE Purchasing Document Type BSART
SUPPLIER Vendor's account number LIFNR
COMPANY_CODE Company Code BUKRS
PURCHASING_ORG Purchasing organization EKORG
PURCHASING_GROUP Purchasing Group EKGRP
EXTMATERIALFORPURG Material of External System MATNR
ITEM_DESCRIPTION Short Text TEXT40
MATERIAL_GROUP Material Group MATKL
CHANGED_BY Name of Person Who Changed Object USNAM
INCOTERMS1 Incoterms (Part 1) INCO1
INCOTERMS2 Incoterms (Part 2) INCO2
PAYMENT_TERMS Terms of payment key ZTERM
SHIPPING_INSTRUCTIONS Shipping Conditions VSBED
COMPANY_CODE_GROUP Grouping ID for Company Codes MMPUR_D_CC_GROUPING_ID