SAP Business Transactions Tables

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

Top 10 tables in Business Transactions

TableDescription
CDBD_SRV_SUBJECTCRM Service: CDB Subject Table
CDBD_DATESEGTime segment for class CL_APPOINTMENT_SEG
CDBD_BINRELInterlinkages Between CRM Application Objects
CDBD_PDLIMBusiness transaction - value limit
CDBD_ADR3Fax numbers (central address admin.)
CDBD_PAYPLAN_DCBT - payment plan - Dat e - Payment Card
CDBD_ADRPPersons (central address administration.)
CDBD_PRCD_CONDPricing condition item - condition
CDBD_PARTNERBT - Partner
CDBD_LINK_IItem Link Table

List of tables in Business Transactions

TableDescription
CDBD_SRV_SUBJECTCRM Service: CDB Subject Table
CDBD_DATESEGTime segment for class CL_APPOINTMENT_SEG
CDBD_BINRELInterlinkages Between CRM Application Objects
CDBD_PDLIMBusiness transaction - value limit
CDBD_ADR3Fax numbers (central address admin.)
CDBD_PAYPLAN_DCBT - payment plan - Dat e - Payment Card
CDBD_ADRPPersons (central address administration.)
CDBD_PRCD_CONDPricing condition item - condition
CDBD_PARTNERBT - Partner
CDBD_LINK_IItem Link Table
CDBD_ORDERADM_IBusiness transaction item
CDBD_PDACC_SBusiness transaction - account assignment - set
CDBD_PDHGPBusiness transaction - purchasing information
CDBD_CUSTOMER_HBusiness transaction - customer extension
CRMC_CANCPROCCancellation Procedure
CRMD_CANCEL_IRIndividual cancellation rule
CRMD_PERMISSIONSAdministration Table for Change Authorization
CDBD_PDTAXBusiness transaction - tax
CDBD_ACTIVITY_HBusiness Transaktion - Activity segment
CDBD_JESTBT Single status
CDBD_ADRTCommunication data text (central address administration)
CDBD_PDATT_SBusiness transaction - Document attachment - set
CDBD_SALESBusiness transaction - sales - set
CRMC_PARTYCancelling party
CRMC_METHOD_BTILBusiness Transaction - Object Method Definition
CRMD_CUMULAT_HBusiness Transaction - Cumulat_H extension
CRMC_ORLTXT_BTILObject Relation Texts
CRMC_DPRICPROCBusiness Transaction - Pricing Procedure Grouping
CRMC_CANCREASONTDescription for Canc. Reason
CDBD_PDFRTBusiness transaction - Shipment costs
CRMC_SCENARIOScenario Settings
CDBD_LINK_HHeader Link Table
CRMC_MSGIDWork areas relevant for CRM_MESSAGES
CRMD_ORDER_INDEXIndex table for one-order document
CDBD_SHIPPINGBusiness transaction - shipping - set
CDBD_ADCPPerson/Address assignment (central address administration)
CDBD_DATECLASS_SCDB Table DateClass Set header
COMD_SCORINGCreditworthiness Check Results of a Partner
CDBD_SRV_REFOBJCRM Service: CDB Reference Object Table
CDBD_BILLPLAN_SBusiness transaction - billing plan - set
CDBD_PRCD_HEADPricing condition - set
CDBD_ORGMANBusiness transaction - organizational unit - set
CRMC_BO_RANGESGroups of object types
CRMM_ES_ORG_TXTEnterprise Search: Org Unit - Text
CRMC_LOG_PROFCustomising table to maintain log profile
CRMM_ES_ORGEnterprise Search: OrgUnits
CRMC_MESSAGES_TTrace for CRM_MESSAGE_COLLECT
CDBD_PDFRT_SBusiness transaction - Shipment costs - set
CRMC_MESSAGES_SSystem Table: Attribute for Messages in CRM
CDBD_ADRAddress header
CRMC_ORLALL_BTILCustomer-defined Object Relations
CDBD_SERORGMSE Service Organization table.
CDBD_SCHEDLINBusiness transaction item - schedule line data
CRMC_PERF_SWITCHControl Table for Performance-Relevant Functions
CDBD_PDATTBusiness transaction - Document attachment
CDBD_ORDERADM_HBusiness Transaction
CDBD_PDHSBBid invitation
CDBD_ADR2Telephone numbers (central address admin.)
CRMC_OBJ_BTIL_CCustomer specific implementations for objects
CRMD_PRICING_ITransaction Item Price
CRMC_CANCPROC_TDescription for cancellation procedure
CDBD_ADRCAddresses (central address admin)
CDBD_ADRVPPerson where-used list (central address administration)
CDBD_ASSIGNMENTService Assignment
CRMC_DBA_RELRelations for DB Analyzer
CDBD_STRUCT_IBusiness transaction item - configuration
CDBD_PARTNER_SBusiness transaction - Partner - set
CDBD_BILLPLAN_DBT - Billing plan - Date
CRMD_BILLINGBusiness Transaction - Billing Set
CRMC_CANCREASONCancellation Reason
CDBD_DATEFULLTime segment class CL_APPOINTMENT_FULL
CDBD_PRICINGBusiness transaction - pricing parameter - set
CDBD_OPPORT_HBT - Opportunity
CRMC_CANCRULES_TDescription for cancellation rules
CDBD_PAYPLANBusiness transaction - payment plan - set
SMOKVBEZ25MSE Assignment -- Activity Linkage table.
CDBD_PDTAX_SBusiness transaction - tax - set
CRMD_SALESBusiness Transaction - Sales Set
CDBD_PDORG_SBusiness transaction - purchasing organization - set
CDBD_CANCELBusiness transaction - cancellation - set
CDBD_PRICING_IBusiness transaction item - pricing result
CRMD_CANCELBusiness Transaction - Cancellation Set
CDBD_SRV_DEMANDBT - Service Demand
CRMR_PRICINGData for Pricing
CDBD_SRV_OSSETCRM Service: Reference object - Subject Set
CDBD_PDIGPBusiness transaction item - purchasing information
CRMC_CUSTOBJ_ACCustomer-Specific Archiving Objects
CDBD_BILLINGBusiness transaction - billing - set
CRMC_MESSAGESControl for Error Processing
CDBD_SERORG_TMSE Service Organization Text table.
CRMC_CANCRULESCancellation Rules
CRMC_PARTY_TDescription for cancelling party
CRMD_PRICINGBusiness Transaction Pricing Parameter Set
CDBD_SET_HSet Header Table
CRMC_FIELDCHECKLeaving Field Checks for Field Selection
CDBD_PDLIM_SBusiness transaction - value limit - set
CDBD_JSTOBT - Status
CDBD_PDORGBT - purchasing organization
CDBD_BILLPLANBT - Billing plan
CDBD_BRELVONAICDB Table: Item Interlinkages - Object Interlinkage VONA
CDBD_PRODUCT_IBusiness transaction item - product
CDBD_SERVICE_IBusiness transaction item - service
CDBD_CUSTOMER_IBusiness transaction item - customer extension
CDBD_LINKBusiness transaction - set - link
CDBD_ADRVAddress where used list (central address administration)
CRMC_OBJ_LOGCustomising Table for linking log profile to Business obj
CDBD_DATECLASSDate classes (unit for time segments)
CDBD_PAYPLAN_DCDB TAbBusiness transaction - payment plan - Date
CRMC_OBJ_BTILObjects
CRMC_ORLSTA_BTILSAP Standard Object Relations
CRMC_RULES2PROCCancellation procedure rule
CDBD_PDACCBusiness transaction - account assignment
SCCONFIG_CUSTCustomizing for Solution Configurator for Packages
CRMC_DPRICPROC_TPricing Procedures: Document: Texts
CDBD_BRELVONAECDB Table - Additional Attributes: Object Interlinkage VONA