The CMMFDOR_D_LEG_D table in SAP ERP or S/4HANA stores I_COMMODITYORDERREQUESTTP I_CMMDTYORDERREQLEGTP data. There are total 32 fields in CMMFDOR_D_LEG_D table. The I_COMMODITYORDERREQUESTTP I_CMMDTYORDERREQLEGTP 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 CMMFDOR_D_LEG_D table. It is in Commodity Derivative Order Request (FS_CMM_CDOTE_ORDER_REQUEST) ABAP package and is part of the Commodity Derivative Order and Trade Execution (FIN-FSCM-CMM-DOT) module.
SAP CMMFDOR_D_LEG_D Table Fields
Following is the list of fields that are available in SAP CMMFDOR_D_LEG_D table. The primary key fields of the table are MANDT (Client), CMMDTYORDERREQLEGUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| CMMDTYORDERREQLEGUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| COMMODITYORDERREQUESTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| COMMODITYORDERREQUEST | Commodity Derivative Order Request ID | CMMFDOR_ORDERREQUESTID | NUMC (10) | |
| CMMDTYORDERREQLEGCATEGORY | Commodity Derivative Order Leg Category | CMMFDOR_ORDREQLEGCATEGORY | CHAR (3) | |
| CMMDTYORDERREQUESTFLOWTYPE | Commodity Derivative Order Request Flow Type | CMMFDOR_ORDERREQUESTFLOWTYPE | CHAR (2) | |
| CMMDTYDERIVATIVEFLOWTYPETEXT | Short Text for Fixed Values | VAL_TEXT | CHAR (60) | |
| CMMDTYORDREQUESTQUANTITYINLOT | Commodity Derivative Order Request Quantity in Lots | CMMFDOR_ORDREQNUMBEROFLOTS | INT2 (5) | |
| CMMDTYDERIVATIVEQUANTITYPERLOT | Derivative Contract Specification Quantity | TBA_DCS_QNT | QUAN (13) | |
| CMMDTYDRVTVQUANTITYUNITPERLOT | Derivative Contract Specification Unit of Measure | CMMFDOR_ORDREQDCSUOM | UNIT (3) | |
| CMMDTYDERIVATIVECURRENCYPERLOT | Quotation Currency | TBA_CURRENCY | CUKY (5) | |
| COMMODITYDERIVATIVEFUTURE | Commodity Order Request Future ID | CMMFDOR_CMMDTYORDFILLFUTUREID | CHAR (13) | |
| COMMODITYDERIVATIVEFUTURENAME | Short Name | XALKZ | CHAR (15) | |
| DERIVATIVECONTRSPECIFICATION | Derivative Contract Specification (DCS) | CMMFDOR_DERIVATIVECONTRACTSPEC | CHAR (20) | |
| DERIVATIVECONTRSPECNAME | Derivative Contract Specification Description | TBA_DCSID_TXT | CHAR (40) | |
| MARKETIDENTIFIERCODE | Market Identifier Code | TBA_MIC | CHAR (4) | |
| MARKETIDENTIFIERCODENAME | Market Identifier Code Description | CMMFSA_MICTXT | CHAR (40) | |
| COMMODITY | Commodity Derivative Order Request Exchange Commodity | CMMFDOR_EXCHANGECOMMODITY | CHAR (18) | |
| COMMODITYNAME | Commodity Description | CMMFSA_COMMODITYDESCRIPTION | CHAR (40) | |
| MATURITYKEYDATE | Maturity Key Date | TBA_KEYDATE | DATS (8) | |
| CONTRDRVTVCONTRMATURITYCODE | Contract Maturity Code | TBA_CONTRACT_CODE | CHAR (13) | |
| CREATEDBYUSER | Created By User | CMMFDOR_CREATEDBY | CHAR (12) | |
| CREATIONDATETIME | Timestamp of record creation | CMMFDOR_CREATIONDATETIME | DEC (15) | |
| LASTCHANGEDBYUSER | Last changed by user ID | CMMFDOR_LASTCHANGEDBYUSER | CHAR (12) | |
| LASTCHANGEDATETIME | Timestamp of last change | CMMFDOR_LASTCHANGEDATETIME | DEC (15) | |
| ACTIVEUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
