CMM_MTM_SO - MtM per Sales Order
MtM per Sales Order information is stored in SAP table CMM_MTM_SO.
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_SO
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| .INCLUDE | X | CMM_MTM_SO_K | 0 | |||
| VBELN | Sales Document | X | VBELN_VA | CHAR | 20 | VBAK |
| POSNR | Item number of the SD document | X | POSNR | NUMC | 12 | VBAP |
| KAPPL | Application | X | KAPPL | CHAR | 4 | T681A |
| KSCHL | Condition Type | X | KSCHL | CHAR | 8 | T685 |
| COMMODITY | Commodity | X | TBA_STOEFFCHEN | CHAR | 36 | TBAC_PHYSCOMM |
| VBTYP_N | Document Category of Subsequent Document | X | VBTYPL_N | CHAR | 8 | |
| VBELNN | Subsequent Sales and Distribution Document | X | VBELN_NACH | CHAR | 20 | |
| POSNN | Subsequent Item of an SD Document | X | POSNR_NACH | NUMC | 12 | * |
| 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_SO_A | 0 | ||||
| BUKRS | Company Code | BUKRS | CHAR | 8 | T001 | |
| KUNNR | Customer Number | KUNNR | CHAR | 20 | KNA1 | |
| MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| 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 |