SAP Commodity Derivative Order and Trade Execution Tables

Are you looking for the right table related to SAP Commodity Derivative Order and Trade Execution Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Commodity Derivative Order and Trade Execution (FIN-FSCM-CMM-DOT) module.

Top 10 tables in Commodity Derivative Order and Trade Execution

TableDescription
CMMFDOR_D_LEG_DI_COMMODITYORDERREQUESTTP I_CMMDTYORDERREQLEGTP
CMMFDCO_C_RCNTRecent Change Time for UI Applicaitons
CMMFDCO_C_NOTTYPNotification Grouping
CMMFDOR_C_ORDTYTCommodity Derivative Order Type Text Table
CMMFDOR_C_DOCTYTCommodity Drvtv Order Document Type Text for Application ID
CMMFDOR_C_BRKTTOrder Request Bracket Type Text
CMMFDOF_D_FLPKTCommodity Derivative Order Fill Packet
CMMFDOR_D_EICNDNCommodity Derivative Order Expiry Instruction Conditions
CMMFSA_D_BROFIXBroker Communication Settings
CMMFDOR_C_EICONFCommodity Derivative Order Expiry Instruction Customization

List of tables in Commodity Derivative Order and Trade Execution

TableDescription
CMMFDOR_D_LEG_DI_COMMODITYORDERREQUESTTP I_CMMDTYORDERREQLEGTP
CMMFDCO_C_RCNTRecent Change Time for UI Applicaitons
CMMFDCO_C_NOTTYPNotification Grouping
CMMFDOR_C_ORDTYTCommodity Derivative Order Type Text Table
CMMFDOR_C_DOCTYTCommodity Drvtv Order Document Type Text for Application ID
CMMFDOR_C_BRKTTOrder Request Bracket Type Text
CMMFDOF_D_FLPKTCommodity Derivative Order Fill Packet
CMMFDOR_D_EICNDNCommodity Derivative Order Expiry Instruction Conditions
CMMFSA_D_BROFIXBroker Communication Settings
CMMFDOR_C_EICONFCommodity Derivative Order Expiry Instruction Customization
CMMFDAI_D_AIFLOGCommodity Derivative Order Outbound FIX Message Log
CMMFDOR_D_BKTICommodity Derivative Order Request Bracket Item
CMMFDOF_C_FILLTTCommodity Order Fill Type Text
CMMFDOR_D_EXINTRCommodity Derivative Order Expiry Instruction
CMMFDCO_C_SEMOBJList of Semantic Object for UI Applicaitons
CMMFDOR_D_PRCEXCCommodity Drvtv Order Pricing Execution and Instructions
CMMFDOR_D_QTYTHROrder Quantity Threshold Header
CMMFDOF_C_FILLTYCommodity Derivative Fill Packet Type and Category
CMMFDAI_D_STGFIXStaging of fix messages
CMMFDOR_D_REASONCommodity Drvtv Order Request Reason
CMMFDOR_C_APPIDCommodity Derivative Order Application ID
CMMFDOR_C_APPIDTCommodity Derivative Order Application ID Text
CMMFSA_D_SA_MAPCommodity Subaccount Mapping
CMMFDOR_D_SMPCommodity Order Request Self Match Prevention
CMMFDOF_D_FILLCommodity Derivative Order Fills
CMMFDOR_C_PECONFCmmdty Drvtv Ord Pricing Execution Instruction Configuration
CMMFDOR_C_PREXETCmmdty Drvtv Order Pricing Execution Instruction Description
CMMFDCO_C_NOTTYTNotification Grouping
CMMFDOR_D_ORDCTGCommodity Derivative Order Category
CMMFDOR_D_EXINTTCommodity Derivative Order Expiry Instruction Description
CMMFDOR_C_DOCTYPCommodity Drvtv Order Document Type for Application ID
CMMFDOR_C_EINSTRCommodity Derivative Order Expiry Instruction
CMMFDOR_D_QTYVALOrder Quantity Threshold Values
CMMFDAI_AIF_IDXStandard index table
CMMFDOF_D_FLDEVCommodity Order Fill Packet price deviation
CMMFDOR_D_MKTPRCCommodity Derivative Order Last Market Price
CMMFSA_D_APICFGTable for Commodity Subaccount API Configuration
CMMFDOR_D_DOC_DI_COMMODITYORDERREQUESTTP I_CMMDTYORDREQDOCUMENTTP
CMMFSA_D_CNTRSUBCDOTE Subaccounts of Interlat Counterparty
CMMFSA_D_FIXVFLDBroker FIX Message Field Values
CMMFDOR_D_BKT_DI_CMMDTYORDREQBRACKETTP I_CMMDTYORDREQBRACKETTP
CMMFDOR_C_TASFWDTrade At Settlement Settings for Commodity Forwards
CMMFDCO_C_NOTUSRDefine Users to be notfied for special CDOTE actions
CMMFDOR_D_PRCGEXCmmdty Derivative Order Pricing Execution and Instructions
CMMFDOR_C_PREXECCmmdty Derivative Order Pricing Execution and Instructions
CMMFDCO_D_DCSPRCDerivative Contract Specification: Market Price Quotations
CMMFDOR_D_ORD_DI_COMMODITYORDERREQUESTTP I_COMMODITYORDERREQUESTTP
CMMFDOR_C_TAS_FICommodity Derivative Order Request Trade At Settlement Fin.
CMMFDOR_C_ORDTYPCommodity Derivative Order Type
CMMFDOF_D_FWDCommodity Derivative Order Fill Forwards
CMMFDOR_D_BKTCommodity Derivative Order Request Bracket
CMMFSA_C_BROGRPBroker Groups for Commodity Derivatve Orders
CMMFDAI_D_STGLOGApplication Log for Fix data staged
CMMFDOF_D_FLMSGCommodity Derivative Order Fill Packet Message Table
CMMFDOR_C_LOTRULCommodity Drvtv Order Rounding rule for lots
CMMFSA_D_OFFFOOTSubaccount Footprint Options
CMMFDOF_C_FLCATTCommodity Order Fill Category Text
CMMFDOR_D_ORDCTTCommodity Derivative Order Category Text Table
CMMFSA_C_BROGRPTBroker Groups for Commodity Derivatve Orders
CMMFDOR_D_EXPINSCommodity Derivative Order Expiration Instructions
CMMFDOR_C_NON_TRNon-Tradable Commodity Order Request Type
CMMFDOF_C_TRMDRVCommodity Derivative Order Fill Packet Type TRM
CMMFDOR_D_DOCCommodity Derivative Order Request Document
CMMFDOR_D_LEGCommodity Derivative Order Leg Information
CMMFSA_D_SUBACCTCommodity Subaccount
CMMFDOR_C_BKTTYPOrder Request Bracket Type
CMMFDOR_C_EINSTTCommodity Derivative Order Expiry Instruction Description
CMMFSA_D_BRORACCCounterparty Broker Reference Accounts
CMMFDOR_D_PECNDNCommodity Order Pricing and Execution Instruction Conditions
CMMFSA_D_CLACCNTBroker Clearing Accounts
CMMFDOF_C_FLCTGCommodity Order Fill Category
CMMFDOR_D_ORDERCommodity Derivative Order Request
CMMFDOR_D_PRCGETCmmdty Drvtv Order Pricing Execution Instruction Description
CMMFSA_D_CHRCMPGCommodity Sub Account Mapping Table for Free Characteristics
CMMFDOR_D_BKTI_DI_CMMDTYORDREQBRACKETTP I_CMMDTYORDREQBRACKETITMTP
CMMFDOR_D_TASCommodity Derivative Order Request Trade At Settlement