CMM_MTM_PO - MtM per Purchase Order
MtM per Purchase Order information is stored in SAP table CMM_MTM_PO.
It is part of development package LOG_CMM_ANALYTICS in software component LO-CMM-BF. This development package consists of objects that can be grouped under "".
It is part of development package LOG_CMM_ANALYTICS in software component LO-CMM-BF. This development package consists of objects that can be grouped under "".
Fields for table CMM_MTM_PO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | X | CMM_MTM_PO_K | 0 | |||
| EBELN | Purchasing Document Number | X | EBELN | CHAR | 20 | EKKO |
| EBELP | Item Number of Purchasing Document | X | EBELP | NUMC | 10 | EKPO |
| KAPPL | Application | X | KAPPL | CHAR | 4 | T681A |
| KSCHL | Condition Type | X | KSCHL | CHAR | 8 | T685 |
| COMMODITY | Commodity | X | TBA_STOEFFCHEN | CHAR | 36 | TBAC_PHYSCOMM |
| VGABE | Transaction/event type, purchase order history | X | VGABE | CHAR | 2 | |
| MBLNR | Number of Material Document | X | MBLNR | CHAR | 20 | |
| GJAHR | Material Document Year | X | MJAHR | NUMC | 8 | |
| BUZEI | Item in Material Document | X | MBLPO | NUMC | 8 | |
| VERSION | Version of an MtM Valuation Record | X | CMM_MTM_VERSION | NUMC | 20 | |
| EVAL_DATE | Evaluation Key Date | X | CMM_EVAL_KEYDATE | DATS | 16 | |
| .INCLUDE | CMM_MTM_ADMIN | 0 | ||||
| VALID_FROM_TST | Valid-From Timestamp | CMM_MTM_VALID_FROM_TST | DEC | 8 | ||
| VALID_TO_TST | Valid-To Timestamp | CMM_MTM_VALID_TO_TST | DEC | 8 | ||
| VALID_FROM_DATE | Valid-From Date | CMM_MTM_VALID_FROM_DATE | DATS | 16 | ||
| VALID_FROM_TIME | Valid-From Time | CMM_MTM_VALID_FROM_TIME | TIMS | 12 | ||
| VALID_TO_DATE | Valid-To Date | CMM_MTM_VALID_TO_DATE | DATS | 16 | ||
| VALID_TO_TIME | Valid-To Time | CMM_MTM_VALID_TO_TIME | TIMS | 12 | ||
| VERSION_MAX | Highest Version Number | CMM_MTM_VERSION_MAX | NUMC | 20 | ||
| .INCLUDE | CMM_MTM_PO_A | 0 | ||||
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| KUNNR | Customer Number | KUNNR | CHAR | 20 | KNA1 | |
| LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | LFA1 | |
| MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| EKORG | Purchasing organization | EKORG | CHAR | 8 | T024E | |
| VKORG | Sales Organization | VKORG | CHAR | 8 | TVKO | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 4 | TVTW | |
| SPART | Division | SPART | CHAR | 4 | TSPA | |
| DATE_DISCOUNTING | Date on which a value relevant for MtM becomes effective | CMM_MTM_DATE_DISC | DATS | 16 | ||
| DATE_PYMNT | Payment Date | CMM_MTM_DATE_PYMNT | DATS | 16 | ||
| CGROUP | MtM Condition Group | CMM_MTM_CGROUP | CHAR | 2 | CMM_MTM_CGROUPT | |
| CGROUP_CAT | Categorization of Condition Group | CMM_MTM_CGROUP_CAT | CHAR | 2 | ||
| ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
| .INCLUDE | CMM_MTM_KF | 0 | ||||
| KWERT | Condition Value | CMM_MTM_KWERT | CURR | 9 | ||
| KWERT_DISC | Condition Value - Discounted | CMM_MTM_KWERT_D | CURR | 9 | ||
| KWERT_DOC | Condition Value | CMM_MTM_KWERT | CURR | 9 | ||
| STWAE | Statistics Currency | STWAE | CUKY | 10 | * | |
| WAERK | SD Document Currency | WAERK | CUKY | 10 | * | |
| MGAME | Quantity | CMM_MTM_MENGE_D | QUAN | 9 | ||
| VRKME | Sales unit | VRKME | UNIT | 6 | * | |
| MGLME | Quantity in Base Unit | CMM_MTM_MENGE_D_BASE | QUAN | 9 | ||
| LAGME | Base Unit of Measure | LAGME | UNIT | 6 | * | |
| MGAME_ADJ | Open Quantity | CMM_MTM_MENGE_D_ADJ | QUAN | 9 | ||
| MGLME_ADJ | Open Quantity in Base Unit | CMM_MTM_MENGE_D_ADJ_BASE | QUAN | 9 | ||
| COMMODITY_QUAN | Commodity Quantity | CMM_MTM_QUAN_COMM | QUAN | 9 | ||
| COMMODITY_ADJ | Open Commodity Quantity | CMM_MTM_QUAN_COMM_ADJ | QUAN | 9 | ||
| COMMODITY_UOM | Unit of Measure for Commodity | CMM_MTM_QUAN_COMMUOM | UNIT | 6 | * | |
| COMMODITY_RF_UOM | Reference unit of measure for proportion unit/product unit | REFME_WS | UNIT | 6 | * | |
| .INCLUDE | CMM_MTM_TERM | 0 | ||||
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 40 | ||
| MIC | Market Identifier Code | TBA_MIC | CHAR | 8 | ||
| TENOR | Time to Maturity | TBA_TENOR | CHAR | 20 | ||
| KEYDATE | Maturity Key Date | TBA_KEYDATE | DATS | 16 | ||
| DCS_REPORTING_DATE | Reporting Date | TBA_REPORTING_DATE | DATS | 16 |