The CMM_GMDA table in SAP ERP or S/4HANA stores Generic Market Data Storage data. There are total 25 fields in CMM_GMDA table. The Generic Market Data Storage 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_GMDA 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_GMDA Table Fields
Following is the list of fields that are available in SAP CMM_GMDA table. The primary key fields of the table are CLIENT (Client), SCENARIO (Scenario), DCSID (Derivative Contract Specification ID), MIC (Market Identifier Code), PRICETYPE (Type of Price Quotation), INSTRUMENT (A key required to access market data), PRICEDATE_FROM (Date of Price Quotation).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| SCENARIO | Scenario | TV_SZENARI | CHAR (10) | |
| DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR (20) | |
| MIC | Market Identifier Code | TBA_MIC | CHAR (4) | |
| PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR (2) | |
| INSTRUMENT | A key required to access market data | CMM_VLOGP_INSTR | CHAR (40) | |
| PRICEDATE_FROM | Date of Price Quotation | TBA_PRICEDATE | DATS (8) | |
| PRICEDATE_TO | Date of Price Quotation | TBA_PRICEDATE | DATS (8) | |
| PRICE | Quotation Price in DEC 20.8 format | CMM_GMDA_PRICE | DEC (20) | |
| PRICE_DEC34 | Quotation Price in floating decimal | CMM_GMDA_PRICE_DF34 | D34D (31) | |
| UOM | Quotation Unit of Measure | TBA_UOM | T006 | UNIT (3) |
| CPE_UOM | Commodity Pricing Engine Unit of Measure | TBA_CPEUOM | T006 | UNIT (3) |
| CURRENCY | Quotation Currency | TBA_CURRENCY | TCURC | CUKY (5) |
| PRICETIME | Time of Price Quotation | TBA_PRICETIME | TIMS (6) | |
| INSTRUMENT_XML | Instrument in readable XML Format | CMM_GMDA_INSTRUMENT_XML | STRG () | |
| ADJ_REF_KEYDATE | Basis Market reference maturity keydate | CMM_BAS_MKT_REF_KEYDATE | DATS (8) | |
| ADJ_REF_CONTRACT_CD | Basis Market Reference Contract Maturity Code | CMM_BAS_MKT_REF_CONTRACT_CODE | CHAR (13) | |
| ADJ_REF_RATE | Original Basis Market reference rate | CMM_BAS_MKT_REF_RATE | DEC (20) | |
| ADJ_SPREAD | Adjustment Value | CMM_BAS_MKT_REF_ADJ_SPREAD | DEC (20) | |
| ADJ_CURR | Adjustment Value Currency | CMM_BAS_MKT_REF_ADJ_CURR | * | CUKY (5) |
| TIMING | Timing/Periodicity of Commodity Forward Indexes | TBA_TIMING | NUMC (2) | |
| KEYDATE | Maturity Key Date | TBA_KEYDATE | DATS (8) | |
| CONTRACT_CODE | Contract Maturity Code | TBA_CONTRACT_CODE | CHAR (13) | |
| BASIS_TYPE | Basis Type | TBAC_BASIS_TYPE | CHAR (3) | |
| BASIS_ID | Basis ID | TBAC_BASIS_ID | CHAR (18) |
