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 |