SAP Basic Functions Tables

Are you looking for the right table related to SAP Basic Functions 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 Basic Functions (LO-CMM-BF) module.

Top 10 tables in Basic Functions

TableDescription
CMM_VAR_REP_CURRCommodity VAR Reporting currency
CPEC_FA_FLDCATCPE FA Fieldattributes
TEXT_CTY_CONV_LOConversion Commodity ID - Assignment for Listed Options
TEXC_COEX_RPACommodity Risk Profile Assignment
CMM_VFINDCMM Versioned Financial Transactions Data
CPEC_PSM_OTYPEDefinition of Order Request Types
TEXC_COEX_RPCommodity Risk Profile
CMM_VLOGP_CONV_UVersioned uom conversion factors
TEXT_CTY_DERActivate Commodity ID in Derivation Tools
CPEC_DIFF_BILLDifferential Invoicing Billing Types for Billing Due List

List of tables in Basic Functions

TableDescription
CMM_VAR_REP_CURRCommodity VAR Reporting currency
CPEC_FA_FLDCATCPE FA Fieldattributes
TEXT_CTY_CONV_LOConversion Commodity ID - Assignment for Listed Options
TEXC_COEX_RPACommodity Risk Profile Assignment
CMM_VFINDCMM Versioned Financial Transactions Data
CPEC_PSM_OTYPEDefinition of Order Request Types
TEXC_COEX_RPCommodity Risk Profile
CMM_VLOGP_CONV_UVersioned uom conversion factors
TEXT_CTY_DERActivate Commodity ID in Derivation Tools
CPEC_DIFF_BILLDifferential Invoicing Billing Types for Billing Due List
CMM_VLOGP_KONVDVlogP store for Delta quantities (Stock GMs)
CPED_TIERCPE Tiered Pricing
TEXT_CTY_TMDefault Timing for Conversion
TBACC_BAS_IDBasis IDs
TBACC_BAS_TYPE_DBasis Type - Period Definition Attributes
MTM_ACC_V_CCODEMtM Accounting: Default Purchasing Organizations and Groups
CMM_VAR_FX_CONFData Selection for Exchange Rate Type and Yield Curve Type
TBACC_BAS_CAT_TBasis Category Texts
CMM_TPL_EVNT_CATProfit and Loss Event Categories
CMM_EXT_BASISCMM Basis Handling CPE Extension
CPEC_PSMSTATUS_TStatus Description of a Price Setting Method
CMMC_PRC_GRPPrice Fixation group and its pricing approach
CMM_VLOGP_C_GRPMTM Calculation Group
CPED_FA_RSLTCPE FA Resultfields
CCTRCPEFORMULA_DI_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYFORMULATP
CMM_MTM_CLIENTMtM Settings at Client Level
CMM_MTM_BUKRSMtM Settings on company code level
CMM_MTM_CALCAssign Condition Types to Groups
CMM_TPL_EFFECTProfit and Loss Effects
CMM_MTM_POMtM per Purchase Order
CMM_TPL_EV_CAT_TProfit and Loss Event Categories Texts
CPEC_CONV_01Conversion Support: Assignment of QS/QT/QN to DCS/MIC...
CMM_CMDTY_PURHUBAdditional Commodity Settings for Central Procurement
CPEC_FA_APPLAssignment of BRF+ Application to Pricing Procedure
CMM_UOM_CONVCMM Unit Conversion
CMM_CMDTYCODEMAPCommodity Code Map
TBACC_BAS_TYPE_TBasis Type Texts
CMM_MD_CHARAssign Commodity Material to Characteristic
TEXT_CTY_CONVConversion Commodity ID - Assignment
CMM_FINSYNCCMM. Financial Synchronized Results
CPEC_PSM_ACTIVEActivation of Price Setting Methods
CMM_VLOGP_TSERTime Series for relevant quotations
CMM_TPL_EVENTS_TProfit and Loss Event Type Texts
CMM_GMDAFXFX Curve Pre-calculated Values
CMM_ALLOC_HEADERAllocation Header
CMMC_PRC_GRP_TText Table for Pricing Group
CMM_WB2B_FILTERTable for filter BADI CMM_MTM_VLOGP_MOD_PRICING_COMM
CMM_MTM_DATE_DTTDetermination Methods for MtM Date - Text Table
CMM_MTM_CGROUPTTMtM Condition Group
CPEC_FA_FLDMAPCPE FA Fieldmapping
CMM_ROBJ_HEADERRisk Object Header
CMM_ROBJ_ITEMRisk Object Item
CMM_GMDAGeneric Market Data Storage
CMM_QUOTGRPITEMQuotation Group Items
CMM_GMDACCCommodity Curve Values
WB2B_CMM_MTM_TCMtM per Trading Contract
CMM_MKTNORM_HISTMarket Norm History
CPED_CONV_S_02Conversion Support: Save Table for CPED_TERMINPUT
CMM_TPL_EVENTSProfit and Loss Event Types
CMM_MTM_CGROUPTMtM Condition Group
CMM_FBFIX_STFuture/Basis Price Fixation Status
CMM_MTM_SOMtM per Sales Order
CMM_MTM_DATE_DETDetermination Methods for MtM Date
CMM_VLOGP_CONV_CVersioned excahnge rates
CPEC_PSMSTATUSStatus of a Price Setting Method
CPEC_CONV_S_03Conversion Support: Save Table for CPEC_QUOTRULE
TEXC_COEX_RP_TXTCommodity Risk Profile Texts
CPEC_FA_FUNCAssignment of BRF+ Functions to Pricing Procedure/Appl.
CMM_DEND_CUTEnd-of-Day - Cutoff Time Definition
CMM_TPL_REP_ATTRProfit and Loss Reporting Attribute Fields
CMM_FIX_SPREADMaster Data for Fix Spreads between Future Market References
CMM_LOGSYNCCMM Logistics Synchronized Results
CMM_INTRACMP_STOConfiguration of Intra company STOs
CMM_VLOGPVersion Table
CMM_MATSTOCK_IDXMaterial Stock Versioning Index
CMM_CMDTY_CNDCommodity Condition Map
TEXT_CTY_EXPOSCommodity Price Exposure (obsolete)
CMM_ALLOC_ITEMAllocation Item
CMMC_PRCFIX_GRPAssign Price Fixation Condition types to group
TBACT_BAS_QUOTBasis Market Data
CPEC_PSMETHOD_TPrice Setting Method Description
CPEC_PSMETHODPrice Setting Method
CMM_C_CON_MIRMarket Condition Assignment to Stock Transport Orders
CMM_FCHAR_MAPMapping of Attribute in Classification to Structure Field
CMM_DEND_RUNDay-end Administration - Daily cutoff timestamps
CMM_D_IDXCommodity Management: Index Table
MTM_ACC_V_VENDMtM Accounting: Default Vendors
CMM_CMN_CONSTCommon Configurable Constants Table
TEXC_COEX_ACTIVEActivation of Commodity Price Exposures
TEXT_CTY_TTMDefault Time to Maturity for Conversion
CMM_RORisk Object Type Registry
CMM_FCHAR_OBTABObject Tables for Free Characteristics in Commodity Mgmnt
CCTRCPETERM_DI_CENTRALPURCHASECONTRACTTP I_CNTRLPURCONTRCMMDTYTERMTP
CMM_LREV_CCODERevaluation of Logistics Documents: Active Company Codes
CMM_GMDA_RGeneric Market Data Storage for reporting with Flat PriceDt
TBACC_BAS_TYPEBasis Types
CPEC_CONV_S_04Conversion Support: Save Table for CPEC_QUOTGRPPOS
CMM_VAR_PRICETYPValue at Risk: Customizing table for Price Type
TBACC_BAS_CATBasis Categories
CMM_NB_KEYDATEMaturity Key Dates
CMM_FBFIX_STTXTFuture/Basis Price Fixation Status Texts
TBACC_BAS_ID_TBasis ID Texts
CMM_MARKET_ROLLMarket Norm Roll-Overs
CMM_ORTH_MATUREOrthodox Maturity Selection for Pricing
CPEC_CONV_S_01Conversion Support: Save Table for CPEC_TERM