MMPUR_ANA_CENCTR - Central Contracts Price data for analytics
Central Contracts Price data for analytics information is stored in SAP table MMPUR_ANA_CENCTR.
It is part of development package ODATA_MM_ANALYTICS in software component MM-IS-PU-RPT. This development package consists of objects that can be grouped under "ODATA Services for MM Analytics".
It is part of development package ODATA_MM_ANALYTICS in software component MM-IS-PU-RPT. This development package consists of objects that can be grouped under "ODATA Services for MM Analytics".
Fields for table MMPUR_ANA_CENCTR
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
ACTIVE_DOC_NUMBER | Active Purchasing Document | X | EBELN_AD | CHAR | 20 | |
DOCUMENT_VERSION | Version number in Purchasing | X | REVNO | CHAR | 16 | |
ITEM | Item Number of Purchasing Document | X | EBELP | NUMC | 10 | |
PLANT_UNIQUE_ID | Plant Unique ID | X | MMPUR_BE_PLANT_UNIQUE_ID | CHAR | 60 | |
VALIDITY_UUID | Validity ID for the central purchase contract | X | VALIDITY_UUID | RAW | 16 | |
IS_CURRENT_VERSION | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | X | BOOLE_D | CHAR | 2 | |
DOCUMENT_NUMBER | Purchasing Document Number | EBELN | CHAR | 20 | ||
DOCUMENT_SUB_TYPE | Control indicator for purchasing document type | BSAKZ | CHAR | 2 | ||
CONTRACT_TYPE | Purchasing Document Type | ESART | CHAR | 8 | ||
PRICE_VALIDITY_START_DATE | Valid-From Date | DATAB | DATS | 16 | ||
PRICE_VALIDITY_END_DATE | Valid To Date | DATBI | DATS | 16 | ||
NET_PRICE_DOC_CURR | Price in reporting currency | NPRC | CURR | 6 | ||
NET_PRICE_REP_CURRENCY1 | Price in reporting currency | NPRC | CURR | 6 | ||
NET_PRICE_REP_CURRENCY2 | Price in reporting currency | NPRC | CURR | 6 | ||
EFFECTIVE_PRICE_DOC_CURR | Effective value of item | EFFWR | CURR | 7 | ||
EFFECTIVE_PRICE_REP_CURR1 | Price in reporting currency | NPRC | CURR | 6 | ||
EFFECTIVE_PRICE_REP_CURR2 | Price in reporting currency | NPRC | CURR | 6 | ||
BASE_PRICE_DOC_CURR | Price in reporting currency | NPRC | CURR | 6 | ||
BASE_PRICE_REP_CURRENCY1 | Price in reporting currency | NPRC | CURR | 6 | ||
BASE_PRICE_REP_CURRENCY2 | Price in reporting currency | NPRC | CURR | 6 | ||
DOCUMENT_CURRENCY | Currency Key | WAERS | CUKY | 10 | ||
REPORTING_CURRENCY1 | Reporting Currency 1 | WAERS_REPCURR1 | CUKY | 10 | ||
REPORTING_CURRENCY2 | Reporting Currency 2 | WAERS_REPCURR2 | CUKY | 10 | ||
VERSION_CREATION_DATE | Date | DATUM | DATS | 16 | ||
SUPPLIER | Vendor's account number | ELIFN | CHAR | 20 | ||
COMPANY_CODE | Company Code | BUKRS | CHAR | 8 | ||
PURCHASING_ORG | Purchasing organization | EKORG | CHAR | 8 | ||
PURCHASING_GROUP | Purchasing Group | EKGRP | CHAR | 6 | ||
EXTMATERIALFORPURG | Material of External System | MM_PUR_HUB_MATNR | CHAR | 80 | ||
ITEM_DESCRIPTION | Short Text | TXZ01 | CHAR | 80 | ||
MATERIAL_GROUP | Material Group | MATKL | CHAR | 18 | ||
CHANGE_REASON_INDICATOR | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
UNIT_OF_MEASURE | Base Unit of Measure | LAGME | UNIT | 6 | ||
CHANGED_BY | Name of Person Who Changed Object | ERCNAM | CHAR | 24 | ||
INCOTERMS1 | Incoterms (Part 1) | INCO1 | CHAR | 6 | ||
INCOTERMS2 | Incoterms (Part 2) | INCO2 | CHAR | 56 | ||
PAYMENT_TERMS | Terms of payment key | DZTERM | CHAR | 8 | ||
SHIPPING_INSTRUCTIONS | Shipping Conditions | VSBED | CHAR | 4 | ||
COMPANY_CODE_GROUP | Grouping ID for Company Codes | MMPUR_D_CC_GROUPING_ID | CHAR | 6 |