The CMM_FIX_SPREAD table in SAP ERP or S/4HANA stores Master Data for Fix Spreads between Future Market References data. There are total 19 fields in CMM_FIX_SPREAD table. The Master Data for Fix Spreads between Future Market References table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMM_FIX_SPREAD table. It is in Runtime Valuation of logistics documents (LOG_CMM_RUNTIME_VALUATION) ABAP package and is part of the Basic Functions (LO-CMM-BF) module.
SAP CMM_FIX_SPREAD Table Fields
Following is the list of fields that are available in SAP CMM_FIX_SPREAD table. The primary key fields of the table are MANDT (Client), DCSID (Derivative Contract Specification ID), MIC (Market Identifier Code), KEYDATE1 (Maturity Key Date).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR (20) | |
| MIC | Market Identifier Code | TBA_MIC | CHAR (4) | |
| KEYDATE1 | Maturity Key Date | TBA_KEYDATE | DATS (8) | |
| KEYDATE2 | Second Maturity Key Date in a Spread Pair | CMM_DEND_SPREAD_KEYDATE2 | DATS (8) | |
| SPREAD_FIX_DATE | Spread Fixation Date | CMM_DEND_SPREAD_DT | DATS (8) | |
| FIX_DATE_ONLY | Use Value from Spread Fixation Date | CMM_DEND_SPREAD_DATE_ONLY | CHAR (1) | |
| SPREAD_RATE | Fixed Spread Rate | CMM_DEND_SPREAD | CURR (17) | |
| CURRENCY | Currency of the Fixed Spread Rate | CMM_DEND_SPREAD_CUR | CUKY (5) | |
| UOM | Unit of Measure of the Fixed Spread Rate | CMM_DEND_SPREAD_UOM | UNIT (3) | |
| VALID_FROM_TST | Valid-From Timestamp | CMM_MTM_VALID_FROM_TST | DEC (15) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| PHID | Portfolio Hierarchy | JBRPHID | NUMC (3) | |
| PKNOTEN | Node in Portfolio Hierarchy | JBRPKNOTEN | NUMC (6) | |
| SICHTID | View of an Analysis Structure | JBRSICHTID | CHAR (3) |
