SAP Opportunities Tables

Are you looking for the right table related to SAP Opportunities 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 Opportunities (CRM-BTX-OPP) module.

Top 10 tables in Opportunities

TableDescription
CRMC_CYCLE_TSales Cycle Texts
CRMC_ITPR_CPY_MACopy item to sub opportunity - General Control Data
CRMC_CYCPHASESales Cycle Phase
CRMC_IT_AUART_COCross-system item category determination
CRMC_SOURCEOpportunity Origin Kind / Lead Origin Kind
CRMD_OPP_LINKInterlinkages between Opportunities (Master/Sub)
CRMC_AUART_COPYCross-System Copying of Transaction Types - General Control
CRMC_SOURCE_TLead Origin Type / Opportunity Origin Type: Texts
CRMC_OPPT_TYPEOpportunity Type
CRMC_CON_PHASEBusiness Warehouse - Analysis Phase

List of tables in Opportunities

TableDescription
CRMC_CYCLE_TSales Cycle Texts
CRMC_ITPR_CPY_MACopy item to sub opportunity - General Control Data
CRMC_CYCPHASESales Cycle Phase
CRMC_IT_AUART_COCross-system item category determination
CRMC_SOURCEOpportunity Origin Kind / Lead Origin Kind
CRMD_OPP_LINKInterlinkages between Opportunities (Master/Sub)
CRMC_AUART_COPYCross-System Copying of Transaction Types - General Control
CRMC_SOURCE_TLead Origin Type / Opportunity Origin Type: Texts
CRMC_OPPT_TYPEOpportunity Type
CRMC_CON_PHASEBusiness Warehouse - Analysis Phase
CRMC_PHASE_TPhase Texts
CRMD_OPPORT_IOpportunity Item Table
CRMC_CON_PHASE_TControlling phase texts
CRMC_OPPIMPOROpportunity Priority / Lead Priority
CRMC_CYCLESales cycle
CRMC_OPPT_TYPE_TOpportunity Types: Texts
CRMC_OPPIMPOR_TOpportunity Priority / Lead Priority: Texts
CRMC_PHASEOpportunity Phase
CRMC_IF_AUARTCross-system item category determination
CRMC_OPPT_ODCustomizing table for Transaction type in Opportunity OData
CRMD_OPPORT_HOpportunity