SAP WB2B_CMM_MTM_TC MtM per Trading Contract Table
Overview
WB2B_CMM_MTM_TC is a standard SAP S/4HANA table that stores MtM per Trading Contract data. There are total 60 fields in the WB2B_CMM_MTM_TC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WB2B_CMM_MTM_TC belongs to Basic Functions (LO-CMM-BF) module and is located in the package Commodity Management Analytics Integration Layer (WB2B_CMM_ANALYTICS).
In addition, following links provide an overview of foreign key relationships, if any, that link WB2B_CMM_MTM_TC to other SAP tables and standard CDS views available based on WB2B_CMM_MTM_TC table in S/4HANA 2020.
Techincal Settings of WB2B_CMM_MTM_TC
Below are technical details of the table WB2B_CMM_MTM_TC
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WB2B_CMM_MTM_TC Fields
The following table gives you an overview of the fields available in WB2B_CMM_MTM_TC
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | |
| TKONN | Trading Contract | TKONN | WBHK | CHAR | 10 |
| TPOSN | Item Number of Trading Contract | TPOSN | WBHI | NUMC | 6 |
| KAPPL | Application | KAPPL | T681A | CHAR | 2 |
| KSCHL | Condition type | KSCHL | T685 | CHAR | 4 |
| COMMODITY | Commodity | TBA_STOEFFCHEN | TBAC_PHYSCOMM | CHAR | 18 |
| VGABE | Transaction/event type purchase order history | VGABE | CHAR | 1 | |
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| GJAHR | Material Document Year | MJAHR | NUMC | 4 | |
| BUZEI | Item in Material Document | MBLPO | NUMC | 4 | |
| VBTYP_N | Document Category of Subsequent Document | VBTYPL_N | CHAR | 4 | |
| VBELNN | Subsequent Sales and Distribution Document | VBELN_NACH | CHAR | 10 | |
| POSNN | Subsequent Item of an SD Document | POSNR_NACH | NUMC | 6 | |
| VERSION | Version of an MtM Valuation Record | CMM_MTM_VERSION | NUMC | 10 | |
| EVAL_DATE | Evaluation Key Date | CMM_EVAL_KEYDATE | DATS | 8 | |
| VALID_FROM_TST | Valid-From Timestamp | CMM_MTM_VALID_FROM_TST | DEC | 15 | |
| VALID_TO_TST | Valid-To Timestamp | CMM_MTM_VALID_TO_TST | DEC | 15 | |
| VALID_FROM_DATE | Valid-From Date | CMM_MTM_VALID_FROM_DATE | DATS | 8 | |
| VALID_FROM_TIME | Valid-From Time | CMM_MTM_VALID_FROM_TIME | TIMS | 6 | |
| VALID_TO_DATE | Valid-To Date | CMM_MTM_VALID_TO_DATE | DATS | 8 | |
| VALID_TO_TIME | Valid-To Time | CMM_MTM_VALID_TO_TIME | TIMS | 6 | |
| VERSION_MAX | Highest Version Number | CMM_MTM_VERSION_MAX | NUMC | 10 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| DATE_DISCOUNTING | Date on which a value relevant for MtM becomes effective | CMM_MTM_DATE_DISC | DATS | 8 | |
| DATE_PYMNT | Payment Date | CMM_MTM_DATE_PYMNT | DATS | 8 | |
| CGROUP | MtM Condition Group | CMM_MTM_CGROUP | CMM_MTM_CGROUPT | CHAR | 1 |
| CGROUP_CAT | Categorization of Condition Group | CMM_MTM_CGROUP_CAT | CHAR | 1 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| TKONN_ROOT | Trading Contract | TKONN | WBHK | CHAR | 10 |
| TPOSN_ROOT | Item Number of Trading Contract | TPOSN | WBHI | NUMC | 6 |
| TKONN_EX | External Identifier in Trading Contract | TKONN_EX | CHAR | 30 | |
| TKONN_EX_ROOT | External Identifier in Trading Contract | TKONN_EX | CHAR | 30 | |
| KWERT | Condition Value | CMM_MTM_KWERT | CURR | 17 | |
| KWERT_DISC | Condition Value - Discounted | CMM_MTM_KWERT_D | CURR | 17 | |
| KWERT_DOC | Condition Value | CMM_MTM_KWERT | CURR | 17 | |
| STWAE | Statistics Currency | STWAE | * | CUKY | 5 |
| WAERK | SD document currency | WAERK | * | CUKY | 5 |
| MGAME | Quantity | CMM_MTM_MENGE_D | QUAN | 17 | |
| VRKME | Sales unit | VRKME | * | UNIT | 3 |
| MGLME | Quantity in Base Unit | CMM_MTM_MENGE_D_BASE | QUAN | 17 | |
| LAGME | Base Unit of Measure | LAGME | * | UNIT | 3 |
| MGAME_ADJ | Open Quantity | CMM_MTM_MENGE_D_ADJ | QUAN | 17 | |
| MGLME_ADJ | Open Quantity in Base Unit | CMM_MTM_MENGE_D_ADJ_BASE | QUAN | 17 | |
| COMMODITY_QUAN | Commodity Quantity | CMM_MTM_QUAN_COMM | QUAN | 17 | |
| COMMODITY_ADJ | Open Commodity Quantity | CMM_MTM_QUAN_COMM_ADJ | QUAN | 17 | |
| COMMODITY_UOM | Unit of Measure for Commodity | CMM_MTM_QUAN_COMMUOM | * | UNIT | 3 |
| COMMODITY_RF_UOM | Reference unit of measure for proportion unit/product unit | REFME_WS | * | UNIT | 3 |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 20 | |
| MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | |
| TENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | |
| KEYDATE | Maturity Key Date | TBA_KEYDATE | DATS | 8 | |
| DCS_REPORTING_DATE | Reporting Date | TBA_REPORTING_DATE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WB2B_CMM_MTM_TC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WB2B_CMM_MTM_TC | BUKRS | : | T001 |
| WB2B_CMM_MTM_TC | CGROUP | : | CMM_MTM_CGROUPT |
| WB2B_CMM_MTM_TC | COMMODITY | : | TBAC_PHYSCOMM |
| WB2B_CMM_MTM_TC | EKORG | : | T024E |
| WB2B_CMM_MTM_TC | KAPPL | : | T681A |
| WB2B_CMM_MTM_TC | KSCHL | : | T685 |
| WB2B_CMM_MTM_TC | KUNNR | : | KNA1 |
| WB2B_CMM_MTM_TC | LIFNR | : | LFA1 |
| WB2B_CMM_MTM_TC | MATNR | : | MARA |
| WB2B_CMM_MTM_TC | SPART | : | TSPA |
| WB2B_CMM_MTM_TC | TKONN | : | WBHK |
| WB2B_CMM_MTM_TC | TKONN_ROOT | : | WBHK |
| WB2B_CMM_MTM_TC | TPOSN | : | WBHI |
| WB2B_CMM_MTM_TC | TPOSN_ROOT | : | WBHI |
| WB2B_CMM_MTM_TC | VKORG | : | TVKO |
| WB2B_CMM_MTM_TC | VTWEG | : | TVTW |
| WB2B_CMM_MTM_TC | WERKS | : | T001W |