The complete list of SAP Tables in Customer Relationship Management -> Business Transactions module. The most commonly used Tables are at the top of the list. Click on a sub-module to see the Tables specific to that module.

CRM-BTX General Tables

There are 15631 Tables in Business Transactions module. View the full list here: SAP CRM-BTX General Tables

Rank Table Description Table Type
1 ORDERADM_H Reporting Structure for Ext. ORDERADM_H Structure
2 CRMD_ORDER_INDEX Index table for one-order document Transparent Table
3 CRMD_CUSTOMER_H Transaction - Customer Extension Transparent Table
4 CRMD_ACTIVITY_H Activity Transparent Table
5 E101CRMXIF_BUSTRANS Interface: Business Transaction Structure
6 ACTIVITY_H Auxiliary Structure: Do NOT Use!!! Structure
7 CRMD_SALES Business Transaction - Sales Set Transparent Table
8 BAPIBUS20001_INPUT_FIELDS BO BusProcessND: Fields Entered Structure
9 CRMD_OPPORT_H Opportunity Transparent Table
10 SERVICEPLAN Service Plan Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX General Tables
Go to top

Operative Reporting and BW Analyses Tables (CRM-BTX-ANA)

There are 695 Tables in Operative Reporting and BW Analyses module. View the full list here: SAP CRM-BTX Operative Reporting and BW Analyses Tables (CRM-BTX-ANA)

Rank Table Description Table Type
1 ORDERADM_H Reporting Structure for Ext. ORDERADM_H Structure
2 ACTIVITY_H Auxiliary Structure: Do NOT Use!!! Structure
3 CRMC_REPDY Control Table for Dyn. Access (CL_CRM_REPORT_ACC_DYNAMIC) Transparent Table
4 CRMV_LINKPARTNER Generated Table for View CRMV_LINKPARTNER General View Structure
5 CRMV_LINKORGMAN Generierte Tabelle zu einem View General View Structure
6 CRMT_BW_DS_ACTIVITY DataSource for Activities Structure
7 CRMT_BW_LEAD_I BW: Datasource for CRM Leads, Item Data Structure
8 CRMT_BW_COMPLAINTS_I BW: Datasource for CRM Complaints - Item Data Structure
9 CRMV_INDEX_JEST Generierte Tabelle zu einem View General View Structure
10 CRMC_REPDY_DB DB Access Description for Dynamic Access Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Operative Reporting and BW Analyses Tables (CRM-BTX-ANA)
Go to top

Basic Functions for Business Transactions Tables (CRM-BTX-BF)

There are 4175 Tables in Basic Functions for Business Transactions module. View the full list here: SAP CRM-BTX Basic Functions for Business Transactions Tables (CRM-BTX-BF)

Rank Table Description Table Type
1 CRMD_CUSTOMER_H Transaction - Customer Extension Transparent Table
2 E101CRMXIF_BUSTRANS Interface: Business Transaction Structure
3 BAPIBUS20001_INPUT_FIELDS BO BusProcessND: Fields Entered Structure
4 BAPIBUS20001_HEADER_INS BO BusProcessND: Administration Data Trans. Header Create() Structure
5 CRMC_PROC_TYPE Business Transaction Type Transparent Table
6 BAPIBUS20001_PARTNER_INS BO BusProcessND: Process Partner for a Transaction Create() Structure
7 CRMD_SRV_SUBJECT Subject Transparent Table
8 CRMD_CUSTOMER_I Transaction Item - Customer Extension Transparent Table
9 CRMC_OBJECTS Business Transaction - Component Type Transparent Table
10 BAPIBUS20001_GUID_DIS BO BusProcessND: GUID in BAPI Format Display () Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Basic Functions for Business Transactions Tables (CRM-BTX-BF)
Go to top

Activity Management Tables (CRM-BTX-ACT)

There are 1236 Tables in Activity Management module. View the full list here: SAP CRM-BTX Activity Management Tables (CRM-BTX-ACT)

Rank Table Description Table Type
1 CRMD_ACTIVITY_H Activity Transparent Table
2 CRMC_ACT_OBJ_T Goal of an Activity: Text Transparent Table
3 BAPIBUS2000110_HEADER_INS BO CRM Activity: CRM Activity Header Data in Create Mode Structure
4 BAPIBUS2000110_HEADER_INSX BO CRM Activity: Header Data in Creation Mode Flag Bar Structure
5 CRMT_APPOINTMENT_WRK External Transfer Structure for Date Management Structure
6 CRMD_ACTIVITY_I Activity Reporting : Activity Line Item Extension Transparent Table
7 CRMC_ACTIVITY_H Transaction Type - Activity Control Parameter Transparent Table
8 CRMC_ACT_CATEGOR Activity Category Transparent Table
9 BAPIBUS2000110_MATERIAL BO CRM Activity: Material Structure
10 BAPIBUS2000110_JOURNALX BO CRM Activity: Journal Change Flags Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Activity Management Tables (CRM-BTX-ACT)
Go to top

Opportunities Tables (CRM-BTX-OPP)

There are 387 Tables in Opportunities module. View the full list here: SAP CRM-BTX Opportunities Tables (CRM-BTX-OPP)

Rank Table Description Table Type
1 CRMD_OPPORT_H Opportunity Transparent Table
2 CRMC_OPPIMPOR_T Opportunity Priority / Lead Priority: Texts Transparent Table
3 CRMC_OPPT_TYPE_T Opportunity Types: Texts Transparent Table
4 CRMC_OPPT_TYPE Opportunity Type Transparent Table
5 CRMD_OPP_LINK Interlinkages between Opportunities (Master/Sub) Transparent Table
6 CRMC_PHASE_T Phase Texts Transparent Table
7 CRMT_OPPORT_H_WRK Opportunity Header Data - Structure of Work Area and Buffer Structure
8 CRMC_OPPIMPOR Opportunity Priority / Lead Priority Transparent Table
9 CRMC_CYCLE_T Sales Cycle Texts Transparent Table
10 CRMT_OPPORT_H_COM Opportunity Header Data - Structure containing comm. fields Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Opportunities Tables (CRM-BTX-OPP)
Go to top

Service Plan Tables (CRM-BTX-SPL)

There are 54 Tables in Service Plan module. View the full list here: SAP CRM-BTX Service Plan Tables (CRM-BTX-SPL)

Rank Table Description Table Type
1 SERVICEPLAN Service Plan Transparent Table
2 CRMD_SRVPLAN_I Service Plan Item - Service Cycle Interval Transparent Table
3 SERVICEPLANH Service Plan Transparent Table
4 CRMD_SRVPLAN_IE Service Plan Item - Service Cycle Transparent Table
5 CRMC_MAINT_PLAN Customizing Service Plan Transparent Table
6 CRMC_SRV_CYCLE_D Service Cycle Interval Transparent Table
7 CRMC_SRV_CYCLE_P Service Cycle Template Transparent Table
8 CRMC_SRV_CYCLE_T Service Cycle Template - Text Transparent Table
9 CRMT_0200IE_SERVICEPLAN_UI Interface Service Plan 1:1 Extension Structure
10 CRMT_0200_SERVICEPLAN_I_UI Service Plan Data Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Service Plan Tables (CRM-BTX-SPL)
Go to top

Contracts Tables (CRM-BTX-CTR)

There are 1157 Tables in Contracts module. View the full list here: SAP CRM-BTX Contracts Tables (CRM-BTX-CTR)

Rank Table Description Table Type
1 CRMM_LOCMAP Mapping Table: Business Partner -> Location Transparent Table
2 VCRMD_ESCAL_RECN Generated Table for View VCRMD_ESCAL_RECN General View Structure
3 CRMD_ESCAL_RECNO Response Time Profile - Service Agreement Transparent Table
4 CRMD_SERWI Service Availability Profile Transparent Table
5 CRMD_SERWI_T Availability Time Texts Transparent Table
6 CRM_PR_UBB_SLS_DYNP_SV Usage-Based Billing-Specific Attributes Structure
7 CRM_PR_UBB_SLS Usage-Based Billing-Specific Attributes Transparent Table
8 CRMD_ESCAL_REC Response Time Profile - Service Agreement Transparent Table
9 CRMST_UBB_CP_ALL UBB Change process attributes Structure
10 CRMD_ESCAL Service Response Time Schema Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Contracts Tables (CRM-BTX-CTR)
Go to top

Sales Transaction Tables (CRM-BTX-SLO)

There are 1928 Tables in Sales Transaction module. View the full list here: SAP CRM-BTX Sales Transaction Tables (CRM-BTX-SLO)

Rank Table Description Table Type
1 CRMD_SCHEDLIN Business Transaction Item - Schedule Line Transparent Table
2 CRMD_PRODUCT_I Transaction Item - Product Transparent Table
3 CRMT_SCHEDLIN_I_COM CRM Schedule Line: Commun. Structure for an Item - complex Structure
4 CRMD_SHIPPING Business Transaction - Shipping Set Transparent Table
5 CRMT_SCHEDLIN_EXTD CRM: Schedule Line: Structure External Data DB and Dynamic Structure
6 CRMT_PRODUCT_I_WRK Item Data Product - Structure: Work Structure Structure
7 CRMT_PRODUCT_I_COM Product Data: Communication Fields Structure
8 CRMT_SHIPPING_COM Shipping Set: Communikation Structure Structure
9 CRMT_SCHEDLIN_WRK CRM Schedule Line: Work Structure Structure
10 CRMT_SALESORD_MASSCHNG_HEAD2 Changeable fields on header level Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Sales Transaction Tables (CRM-BTX-SLO)
Go to top

Service Order Tables (CRM-BTX-SVO)

There are 226 Tables in Service Order module. View the full list here: SAP CRM-BTX Service Order Tables (CRM-BTX-SVO)

Rank Table Description Table Type
1 DAY_COUNT Structure to store the count values based on the day Structure
2 CRMT_DNO_SERVICE_MONITOR Transaction Monitor - Service, Complete Field List Structure
3 CRMD_SERVICE_H Service Process Transparent Table
4 CRMD_SERVICE_I Transaction Item - Service Transparent Table
5 CRMT_SERVICE_H_COM CRM Service Header: Communication Fields Structure
6 CRMT_SERVICE_I_COM CRM Service Item: Communication Fields Structure
7 CRMC_VAL_TYPE_T Valuation Type: Texts Transparent Table
8 CRMT_DNO_ISSUE_DATA Issue Data: Integration of Solution Manager Structure
9 CRMD_BREL_RSHP Interlinkages Between CRM Application Objects Transparent Table
10 CRMD_SRV_DEMAND Transaction Item - Service - Resource Requirement Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Service Order Tables (CRM-BTX-SVO)
Go to top

Lead Management Tables (CRM-BTX-LEA)

There are 587 Tables in Lead Management module. View the full list here: SAP CRM-BTX Lead Management Tables (CRM-BTX-LEA)

Rank Table Description Table Type
1 CRMD_LEAD_H Lead Transparent Table
2 BAPIBUS2000108_HEADER_INS BO BusProcessND: Header Data LEAD in Entry Mode Structure
3 BAPIBUS2000108_HEADER_INSX BO BusProcessND: Lead Change Toolbar Structure
4 CRMT_BSP_LEA_OVERVIEW CRM Lead Management: Overview Structure
5 CRMT_BSP_LEA_DISPLAY CRM Lead Management: Common Display Fields for OIC Structure
6 CRMC_LEAD_SV_QL Percentage Rate for Lead Questionnaire Level Transparent Table
7 CRMT_LEAD_H_COM Lead Header Data: Structure with Communication Fields Structure
8 CRMC_LEAD_TYPE_T Lead Grouping: Texts Transparent Table
9 CRMC_LEAD_TYPE Lead Grouping Transparent Table
10 CRMC_LEAD_QL_T Lead Qualification Level: Texts Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Lead Management Tables (CRM-BTX-LEA)
Go to top

Service Request Tables (CRM-BTX-SRQ)

There are 827 Tables in Service Request module. View the full list here: SAP CRM-BTX Service Request Tables (CRM-BTX-SRQ)

Rank Table Description Table Type
1 ADD_INFO Proxy Structure (generated) Structure
2 CRMV_SRQM_DATSTA Generated Table for View CRMV_SRQM_DATSTA General View Structure
3 REQUEST_GUID Proxy Structure (generated) Structure
4 CRMST_QUERY_SRV_REQ_BTIL Attribute structure for Dynamic Search Object BTQSrvReq Structure
5 CRMD_IC_CCODE Company Code Transparent Table
6 CRMD_SRQM_SOLCF Solution manager system configuration settings Transparent Table
7 CRMST_QUERY_R_SRV_REQ_BTIL Attribute structure for BTQRSrvReq search result object Structure
8 CRMC_ITSM_SWITCH Check if function activated for a particular bus. type Transparent Table
9 CRM_CHKLST_I CRM Checklist Item Extension Transparent Table
10 CRMC_CHKLST_OP Checklist Option Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Service Request Tables (CRM-BTX-SRQ)
Go to top

BSP for ERP Sales Order Tables (CRM-BTX-ERP)

There are 261 Tables in BSP for ERP Sales Order module. View the full list here: SAP CRM-BTX BSP for ERP Sales Order Tables (CRM-BTX-ERP)

Rank Table Description Table Type
1 CRMST_QORDER_ERPIL Search attributes for ERP Order Structure
2 CRMC_ORALL_ERPIL Customer-defined Object Relations in genIL component ERP Transparent Table
3 CRMST_ADMINI_ERPIL ERP: Administration Data Item Structure
4 CRMST_L2_ITEM_COMV Lean Order - RFC - Item Data (Values) Structure
5 CRMST_L2_ITEM_COMC Lean Order - Item Data (CHAR) Structure
6 CRMC_ERP_CFG_PRC Fields supported by IPC Transparent Table
7 CRMST_ADMINH_ERPIL Administration Data Header Structure
8 CRMST_QRORDER_ERPIL Search Result attributes for ERP Order Structure
9 CRMC_OBJ_ERPIL Objectmodel in genIL component ERP Transparent Table
10 CRMC_ORLST_ERPIL SAP Standard Object Relations in genIL Component ERP Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX BSP for ERP Sales Order Tables (CRM-BTX-ERP)
Go to top

Provider Transactions Tables (CRM-BTX-PRV)

There are 252 Tables in Provider Transactions module. View the full list here: SAP CRM-BTX Provider Transactions Tables (CRM-BTX-PRV)

Rank Table Description Table Type
1 CRMD_IST_ITA3 EEW: Generated Object (Do Not Process Manually) Transparent Table
2 CRMC_PROV_ORDER Provider Order settings Transparent Table
3 CRMC_IST_DLPRF Profile for the Dealer Portal Application Transparent Table
4 CRMC_IST_DLPRF_T Profile Text for the Dealer Portal Application Transparent Table
5 CRMC_IST_ITMTYPE IS-T-Specific Customizing of Item Categories Transparent Table
6 BAD_IST_ITA3 EEW: Generated Object (Do Not Process Manually) Structure
7 BAD_IST_ITA3_EXT EEW: Generated Object (Do Not Process Manually) Append Structure
8 BAPI_TE_CRMD_IST_ITA3 EEW: Generated Object (Do Not Process Manually) Structure
9 BAPI_TE_CRMD_IST_ITA4 EEW: Generated Object (Do Not Process Manually) Structure
10 CRMA_IST_ITA3 EEW: Generated Object (Do Not Process Manually) Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Provider Transactions Tables (CRM-BTX-PRV)
Go to top

Controlling Integration Tables (CRM-BTX-COI)

There are 94 Tables in Controlling Integration module. View the full list here: SAP CRM-BTX Controlling Integration Tables (CRM-BTX-COI)

Rank Table Description Table Type
1 CRMD_AC_ASSF4_EX Search Help Values - External Account Assignment AC_ASSIGN Transparent Table
2 CRMD_AC_ASSF4_02 Search Help Values - Sales Order Item AC_ASSIGN Transparent Table
3 CRMD_AC_ASSF4_05 Search Help Values for Cost Center AC_ASSIGN Transparent Table
4 CRMD_AC_ASSF4_01 Search Help Values - Internal Order AC_ASSIGN Transparent Table
5 CRMD_AC_ASSF4_03 Search Help Values - WBS Element AC_ASSIGN Transparent Table
6 CRMC_CODEX_GRP Check Group Transparent Table
7 CRMC_CDX_SCN_GRP Scenario / Group Transparent Table
8 CRMC_CODEX_SCN Check Scenario Transparent Table
9 CRMC_CODEX_CHK_T Check Number Text Transparent Table
10 CRMC_CDX_GRP_CHK Check Number / Group Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Controlling Integration Tables (CRM-BTX-COI)
Go to top

Billing Request Tables (CRM-BTX-BRQ)

There are 5 Tables in Billing Request module.

Rank Table Description Table Type
1 CRMC_BILLREQ_P Amount Allocation Profile Transparent Table
2 CRMC_BILLR_BT_IT Amount Allocation Profile Determination - Item Transparent Table
3 CRMC_BILLREQ_P_T Amount Allocation Profile: Texts Transparent Table
4 CRMV_BILLREQ_P Generated Table for View CRMV_BILLREQ_P General View Structure
5 CRMV_BILLR_BT_IT Generierte Tabelle zu einem View General View Structure
View the full list of SAP CRM-BTX Billing Request Tables (CRM-BTX-BRQ)
Go to top

Knowledge Article Tables (CRM-BTX-KA)

There are 19 Tables in Knowledge Article module. View the full list here: SAP CRM-BTX Knowledge Article Tables (CRM-BTX-KA)

Rank Table Description Table Type
1 CRMS_QUERY_KNOART_BTIL Knowledge Article: dynamic query structure Structure
2 CRMS_ITSM_KA_EXT Extension structure for Knowledge Article Structure
3 CRMS_KNOW_ART_EXT Extension structure for Knowledge Article Structure
4 CRMS_QUERY_R_KNOART_BTIL Knowledge Article: query result structure Structure
5 CRMC_KA_BRF_CARD Table for Briefing-Card in Knowledge Articles Result List Transparent Table
6 CRMC_KA_NOTETEXT Bearbeitungstabelle f_r Wissensartikeltext Transparent Table
7 CRMC_KA_STATUS Bearbeitungstabelle f_r Wissensartikelstatus Transparent Table
8 CRMC_KA_TEXT_UI Wissensartikeltext zu UI-Attributnamen zuordnen Transparent Table
9 CRMC_RATEDISCRIP description of rating text Transparent Table
10 CRMC_RATEDISCRPT Text for ratings Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Knowledge Article Tables (CRM-BTX-KA)
Go to top

Service Confirmation Tables (CRM-BTX-SCO)

There are 18 Tables in Service Confirmation module. View the full list here: SAP CRM-BTX Service Confirmation Tables (CRM-BTX-SCO)

Rank Table Description Table Type
1 CRMT_5510_SERVICE_UI Service Confirmation - Service Product Items Structure
2 CRMT_5501_ALV_SERVICE_UI Structure for overview Confirmation item list Structure
3 CRMT_5501_SERVICE_UI Service Confirmation Items Structure
4 CRMT_5520_ALV_SERVICE_UI Service Confirmation Service Material Data - Grid Control Structure
5 CRMT_5520_SERVICE_UI Service Confirmation - Service Material Items Structure
6 CRMT_5570_ALV_SERVICE_UI Service Confirmation Service Tool Data - ALV Grid Control Structure
7 CRMT_5570_SERVICE_UI Service Confirmation - UI Structure for Tool Return Items Structure
8 CRMT_CONFIRM_H_API CRM: API Structure of Service Confirmation (Header) Structure
9 CRMT_CONFIRM_I_API CRM: API Structure of Service Confirmation (Item) Structure
10 CRMT_CONFIRM_MESSAGES_API CRM: API Structure for Service Confirmation (Messages) Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Service Confirmation Tables (CRM-BTX-SCO)
Go to top

Complaints / Returns / In-House Repair Tables (CRM-BTX-COM)

There are 108 Tables in Complaints / Returns / In-House Repair module. View the full list here: SAP CRM-BTX Complaints / Returns / In-House Repair Tables (CRM-BTX-COM)

Rank Table Description Table Type
1 CRMC_PERI_COMPL Customizing: Customer Interval for Returns Transparent Table
2 CRMD_RMA_INDEX Index Table for RMA Transparent Table
3 CRMC_CHK_MSH Define Complaint Types for loyalty Transparent Table
4 CRMC_COMPL_ITM Read Item categories for Complaint Transparent Table
5 CRMC_EXTBTIL_MOD External Document for Business Transaction Object Model Transparent Table
6 CRMC_EXTBTIL_OBJ Objects Transparent Table
7 CRMST_PRIDOC_EXT External Fields for Price Determination Result Structure
8 CRMST_RFND_MESS messages occurred during refund value determination Structure
9 CRMT_COMPL_BEA_HEADER Billing Doc. Header Data (BE): Wrapper /1BEA/S_CRMB_BDH_WRK Structure
10 CRMT_COMPL_BEA_ITEM Billing Doc. Item Data (BE): Wrapper /1BEA/S_CRMB_BDI_WRK Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Complaints / Returns / In-House Repair Tables (CRM-BTX-COM)
Go to top

Groupware Integration (Client) Tables (CRM-BTX-GWI)

There are 30 Tables in Groupware Integration (Client) module. View the full list here: SAP CRM-BTX Groupware Integration (Client) Tables (CRM-BTX-GWI)

Rank Table Description Table Type
1 GWI_PROPERTIES Settings for client-based groupware integration Transparent Table
2 CRMD_ACT_SYHST CRM - Groupware Client Synchronization History Transparent Table
3 CRMD_ACT_SYEXC CRM - Groupware Client Synchronization Exceptions Transparent Table
4 CRMD_ATT_SYHST Attachment's Sync History Transparent Table
5 CRMD_ATT_SYNCHST_STRUCT Structure for Attachment history Structure
6 CRMS_GWI_TREENODE GWI: Treenode Structure
7 CRMT_ACT_PARTNER_ADDR CRM-Groupware Client Sync.: Address data of activity partner Structure
8 CRMT_ACT_RETURN Return parameter Structure
9 CRMT_GWSYNC_CONTACT_ACCOUNT Contact and assigned account table Structure
10 CRMT_GWSYNC_CONTACT_ADDRESS Detailed address information Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-BTX Groupware Integration (Client) Tables (CRM-BTX-GWI)
Go to top