SAP Customer Relationship Management Tables
Are you looking for the right table related to SAP Customer Relationship Management 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 Customer Relationship Management (CRM) module.
Top 10 tables in Customer Relationship Management
| Table | Description |
|---|---|
| CRM_ACE2_OO_GRP | OO (one-order) ACE groups |
| RSCRMIDCAT | External IDs for Business Partners (Settings) |
| CRM_ACE_UCC | ACE user context cache for use in shared buffer |
| CRM_ACE_BP_GRP | BP (business-partner) ACE groups |
| CRM_ACE_OBJ_WL | ACE work list for object calculation |
| CRM_ACE2_VP_ACL | VP (Visit Plan) ACE access control list |
| CRM_ACE_FAV_OBJS | ACE favorite objects |
| CRM_ACE_UGP_RT | Runtime ACE user-group/workpackage combinations |
| CRM_ACE_USER_OTS | ACE users with their active objecttypes |
| CRM_ACE_WP_LOG | ACE work-package activation/deactivation log |
List of tables in Customer Relationship Management
| Table | Description |
|---|---|
| CRM_ACE2_OO_GRP | OO (one-order) ACE groups |
| RSCRMIDCAT | External IDs for Business Partners (Settings) |
| CRM_ACE_UCC | ACE user context cache for use in shared buffer |
| CRM_ACE_BP_GRP | BP (business-partner) ACE groups |
| CRM_ACE_OBJ_WL | ACE work list for object calculation |
| CRM_ACE2_VP_ACL | VP (Visit Plan) ACE access control list |
| CRM_ACE_FAV_OBJS | ACE favorite objects |
| CRM_ACE_UGP_RT | Runtime ACE user-group/workpackage combinations |
| CRM_ACE_USER_OTS | ACE users with their active objecttypes |
| CRM_ACE_WP_LOG | ACE work-package activation/deactivation log |
| CRM_ACE2_REL_GRP | REL ICM (Investigative Case Management) ACE Groups |
| CRM_ACE2_MPR_UCT | Marketing Segment: ACE user-contexts |
| CRM_ACE2_MP_ACL | Runtime access control list of marketing planner objects |
| CRM_ACE_AFO_CL | Repository of all ACE relevant AFO-classes |
| CRM_ACE_ACTTYP | Repository of all ACE relevant actor-types |
| CRM_ACE2_OBJ_WL | ACE work list for object calculation |
| CRM_ACE_U_GRP_T | Descriptions for ACE relevant user-groups |
| CRM_ACE_ACTS | Repository of all ACE relevant actions |
| CRM_ACE2_OO_UCT | OO (one-order) ACE user-contexts |
| CRM_ACE_MPL_GRP | Runtime ACE groups of marketing planner objects |
| CRM_ACE_RULES | Repository of all ACE relevant rules |
| CRM_ACE_BP_ACL | BP (business partner) ACE access control list |
| CRM_ACE_ACTS_OTS | CRM object-types of ACE actions |
| CRM_ACE_ST_ACC | Repository of all ACE relevant CRM super-types |
| CRM_ACE2_PR_UCT | PR (product) ACE user-contexts |
| CRM_ACE_U_GRP | Repository of all ACE relevant user-groups |
| CRM_ACE_OTYPES | Repository of all ACE relevant CRM object-types |
| CRM_ACE2_REL_ACL | REL ICM (Investigative Case Management) ACE acl |
| CRM_ACE_PRC_AC_T | Texttable for ACE calculation process sources |
| CRM_ACE_MPL_ACL | Runtime access control list of marketing planner objects |
| CRM_ACE_AFU_CL_T | Descriptions for ACE relevant AFU-classes |
| RSCRMAT_TRAN_T | Support Package Validation table |
| RSDRCRM_SEG_EXNV | Execution Plan: Rec. Add. Data for Generic Operations |
| CRM_ACE2_MTG_GRP | Marketing Target Groups ACE groups |
| RSDRCRM_SEG_EXEC | Execution Plan: Recording Table |
| CRM_ACE2_RO_GRP | RO (Resale order) ACE groups |
| CRM_ACE_WP_RT | Runtime ACE work-packages |
| RSCRMSYSTEM | RFC Connection to CRM Systems |
| CRM_ACE_USERS | Repository of all ACE relevant users |
| RSCRMPACK_AXIS2 | . |
| CRM_ACE_BP_UCT | BP (business-partner) ACE user-contexts |
| CRM_ACE2_MPS_GRP | Marketing Segment Model: ACE groups |
| CRM_ACE2_OB_GRP | BP (business-partner) ACE groups |
| RSCRMI_EVENTS | System table containing the events possible for planning |
| CRM_ACE_AFO_CL_T | Descriptions for ACE relevant AFO-classes |
| CRM_ACE2_MS_ACL | Marketing Segment: ACE access control list |
| CRM_ACE_INF_CL_T | Descriptions for ACE relevant info-classes |
| RSCRMTGEXTIDS | External IDs in Target Groups |
| RSCRMPARAMS | RSCRM: Parameters for Report Interface |
| CRM_ACE2_AD_GRP | OO (one-order) ACE groups |
| RSCRMPACK_H | . |
| CRM_ACE2_AP_GRP | AP (account plan) ACE groups |
| CRM_ACE2_VP_UCT | VP (Visit Plan) ACE user-contexts |
| CRM_ACE_ACTS_RT | Runtime table for actions of active rights |
| CRM_ACE2_CND_GRP | Condition ACE Groups |
| CRM_ACE2_MIO_UCT | Marketing Interaction Objectsl: ACE user-contexts |
| CRMC_CATEGO_GM | Mulitlevel Categorization GenIL Model |
| CRM_ACE2_AP_ACL | AP (account plan) ACE access control list |
| CRM_ACE2_AD_UCT | OO (one-order) ACE user-contexts |
| CRM_ACE2_FU_UCT | FU Header ACE user-contexts |
| RSDRCRM_SEG_EXST | Execution Plan: Recording Additional Data for Step Calls |
| CRM_ACE2_FUI_GRP | FU Items ACE groups |
| CRM_ACE_PRC_ACT | ACE calculation process actions |
| CRM_ACE_RIG_WL | ACE work list for right-activation |
| CRM_ACE2_MPR_GRP | Marketing Segment: ACE groups |
| CRM_ACE2_ICM_GRP | ICM (Investigative Case Management) ACE Groups |
| CRM_ACE2_FI_GRP | FU Item ACE groups |
| CRM_ACE2_MF_UCT | Marketing Mail Form: ACE user-contexts |
| RSCRMAT_EMAIL_T | EMAIL Table |
| RSCRMPACK_LOG | Packaging log |
| RSCRMAT_COUNT_T | Query Counter Table |
| CRM_ACE2_MIO_GRP | Marketing Interaction Objectsl: ACE groups |
| CRM_ACE_OO_UCT | OO (one-order) ACE user-contexts |
| RSCRMAT_VAR_T | Query Variable Table |
| RSCRMI_EVENTS_T | Text table for event types |
| CRM_ACE2_FI_ACL | FU Item ACE access control list |
| RSCRMBATVAR | RSCRM: Variable for batch processing |
| CRM_ACE2_MF_ACL | Marketing: Mail Form: ACE access control list |
| CRM_ACE_RIG_LOG | ACE right activation log |
| CRM_ACE2_BPPACL | OO (one-order) ACE access control list |
| CRM_ACE2_BPPGRP | OO (one-order) ACE groups |
| CRM_ACE_RULES_T | Descriptions for ACE relevant rules |
| RSSFMSSVAR | Variants for MSS users |
| CRM_ACE_WP_OTS | CRM Object-types of ACE work-packages |
| CRM_ACE2_CG_UCT | Case Management ACE user-contexts |
| CRM_ACE_PR_GRP | PR (product) ACE groups |
| CRM_ACE_CUSTOM | Customizing for ACE |
| CRM_ACE2_CG_GRP | Case Management ACE groups |
| CRM_ACE_OBF_CL | Repository of all ACE relevant OBF-classes |
| CRM_ACE2_FI_UCT | FU Item ACE user-contexts |
| CRM_ACE_U_GRPS | Users/roles/user-groups of ACE user-groups |
| CRM_ACE2_IC_ACL | ICM (Investigative Case Management) ACE access control list |
| CRMC_CATEXTATTR | Multilevel Categorization - Extended Attributes Objects |
| CRM_ACE2_CG_ACL | Case Management ACE access control list |
| CRM_ACE2_CND_ACL | Condition ACE Access Control List |
| CRM_ACE2_RO_UCT | RO (Resale order) ACE user-contexts |
| RSDRCRM_SEG_PARA | Parameters for testing RSDRCRM_SEG |
| CRM_ACE2_MP_GRP | Runtime ACE groups of marketing planner objects |
| CRM_ACE_OO_ACL | OO (one-order) ACE access control list |
| CRM_ACE_ANGRPS | Actions of ACE action-groups |
| RSCRMC_TIME_TGT | Customizing target time characteristics by infoprovider |
| RSCRM_IMP_TRACE | Trace results table |
| CRMC_RTD_PROFSIZ | RTOM table to define the amout of data to retreive for BP |
| RSCRMEXTERN | External IDs for Business Partners (Settings) |
| CRM_ACE2_AD_ACL | OO (one-order) ACE access control list |
| RSCRMISQREGISTER | Customizing for Infoset Display |
| CRM_ACE2_MPS_ACL | Marketing Segment Modell: ACE access control list |
| CRM_ACE_TASK_LOG | ACE Dispatcher Background-Task Log |
| CRM_ACE2_ICM_AC | ICM (Investigative Case Management) ACE access control list |
| CRM_ACE_MPL_UCT | Runtime user context of marketing planner objects |
| RSCRMC_TIME_IPRO | Customizing table to enable multi time for infoprovider |
| CRM_ACE2_IO_ACL | IOBJECT ACE access control list |
| CRM_ACE2_TM_UCT | Territory Management ACE user-contexts |
| CRM_ACE_ANGRP_T | Descriptions for ACE relevant action-groups |
| CRM_ACE2_ICM_UCT | ICM (Investigative Case Management) ACE User Context |
| CRM_ACE_UGR_RT | Runtime ACE user-groups |
| RSDRCRM_SEG_QSI | RSDRCRM Segmentation - Job - QSI Administration |
| CRM_ACE2_FUI_ACL | FU Items ACE access control list |
| CRM_ACE2_ICM_GR | ICM (Investigative Case Management) ACE Groups |
| CRM_ACE2_MTG_UCT | Marketing Target Groups ACE user-contexts |
| RSCRMC_EVENT_QRY | Customizing table for defining the queries that have events |
| CRM_ACE2_LC_GRP | BP (business-partner) ACE groups |
| CRM_ACE2_OB_UCT | BP (business-partner) ACE user-contexts |
| CRM_ACE2_BP_ACL | BP (business partner) ACE access control list |
| RSCRMPACK_CELL2 | . |
| CRM_ACE2_RIG_WL | ACE work list for right-activation |
| CRM_ACE_ANGRP | Repository of all ACE relevant action-groups |
| RSCRMEXCP | RSCRM: Extract Fields (Cross Product) |
| CRMC_CATEGO_GO | Multilevel Categorization - GenIL Objects |
| CRM_ACE_RIG_RT | Runtime ACE rights |
| CRM_ACE2_MF_GRP | Marketing Mail Form: ACE groups |
| RSCRMC_INFO_CONV | Customizing table for conversion of characteristics format |
| CRM_ACE_TRACE | ACE object trace |
| RSDRCRM_SEG_EXAO | Execution Plan: Recording Additional Data for MRI Operations |
| CRM_ACE2_ICM_UC | ICM (Investigative Case Management) ACE User Context |
| CRM_ACE2_PR_GRP | PR (product) ACE groups |
| CRM_ACE2_TM_GRP | Territory Management ACE groups |
| CRM_ACE2_IC_UCT | ICM (Investigative Case Management) ACE User Context |
| CRM_ACE2_IC_GRP | ICM (Investigative Case Management) ACE Groups |
| RSCRMMONERR | RSCRM: Batch Error Messages |
| CRM_ACE2_MPR_ACL | Marketing Segment: ACE access control list |
| RSCRMEXFLDS | RSCRM: Extract field |
| CRM_ACE2_PR_ACL | PR (product) ACE access control list |
| CRM_ACE_PRC_SR_T | Texttable for ACE calculation process sources |
| CRM_ACE2_AP_UCT | AP (account plan) ACE user-contexts |
| CRM_ACE2_LC_UCT | BP (business-partner) ACE user-contexts |
| CRM_ACE2_FUI_UCT | FU Items ACE user-contexts |
| RSSFMSSREP | MSS-relevant reports |
| RSSFMSSGRP | MSS-relevant channel |
| CRM_ACE2_TASKS | ACE Dispatcher Background-Task Log |
| CRM_ACE_WP | Repository of all ACE relevant work-packages |
| CRM_ACE_PR_ACL | PR (product) ACE access control list |
| CRM_ACE_RIGHTS | Repository of all ACE relevant rights |
| REC_FILE_SESSION | Activate - Deactivate XML Recording |
| CRM_ACE2_FU_ACL | FU Header ACE access control list |
| CRM_ACE_PRC_ST_T | Texttable for ACE object process status |
| RSCRMTGTODO | External IDs Still to be Attached to Target Group |
| CRM_ACE_AFU_CL | Repository of all ACE relevant AFU-classes |
| CRM_ACE2_RO_ACL | RO (Resale order) ACE access control list |
| CRM_ACE2_BP_UCT | BP (business-partner) ACE user-contexts |
| CRM_ACE_FAVS | ACE user favorites |
| CRM_ACE_WP_T | Descriptions for ACE work-packages |
| CRM_ACE2_MS_GRP | Marketing Segment ACE groups |
| RSCRMTREECUSMON | User-Specific Tree Display Monitor |
| CRM_ACE2_MIO_ACL | Marketing Interaction Object: ACE access control list |
| CRM_ACE2_OB_ACL | BP (business partner) ACE access control list |
| CRM_ACE2_OO_ACL | OO (one-order) ACE access control list |
| CRM_ACE_INF_CL | Repository of all ACE relevant info-classes |
| RSCRMTGLIST | External IDs Still to be Attached to Target Group |
| RSCRMSCENTXT | CRM Scenarios |
| RSCRMVIEWSTORE | Repository for ISQ Views |
| CRM_ACE2_BPPUCT | OO (one-order) ACE user-contexts |
| CRM_ACE2_BP_GRP | BP (business-partner) ACE groups |
| CRM_ACE_PR_UCT | PR (product) ACE user-contexts |
| CRM_ACE2_MPS_UCT | Marketing Segment Model: ACE user-contexts |
| CRM_ACE2_CND_UCT | Condition ACE User-Contexts |
| CRM_ACE2_VP_GRP | VP (Visit Plan) ACE groups |
| RSCRMMON | RSCRM: Monitoring for Batch |
| CRM_ACE_PRC_SRC | ACE calculation process sources |
| CRM_ACE_TASKS | ACE Dispatcher Background-Task Log |
| CRM_ACE_OBF_CL_T | Descriptions for ACE relevant OBF-classes |
| CRM_ACE_ACTTYP_T | Descriptions for ACE relevant actor-types |
| CRM_ACE_PRC_TY_T | Process-types of ACE-calculations |
| RSCRMPACK_MEMV2 | . |
| CRM_ACE2_LC_ACL | BP (business partner) ACE access control list |
| RSCRMIS2INTERNAL | Mapping Fields c70 in InfoSet to Internal IOBLNM c30/GUID |
| CRM_ACE2_REL_UCT | REL ICM (Investigative Case Management) ACE User Context |
| RSCRMC_TIME_AGGR | Customizing table to enable multi time for aggregation level |
| RSCRMSCENE | CRM Scenarios |
| CRM_ACE_PRC_STAT | ACE object process status |
| CRM_ACE2_FU_GRP | FU header ACE groups |
| CRM_ACE2_TM_ACL | Territory Management ACE access control list |
| CRM_ACE_RIGHTS_T | Descriptions for ACE relevant rights |
| CRM_ACE2_MS_UCT | Marketing Segment ACE user-contexts |
| RSCRMC_QUERY_T | Text table for query descriptions |
| CRM_ACE_OO_GRP | OO (one-order) ACE groups |
| RSSFMSSUSR | MSS User |
| CRM_ACE2_MP_UCT | Runtime user context of marketing planner objects |
| CRM_ACE2_MTG_ACL | Marketing Target Groups: ACE access control list |
| CRM_ACE2_ICM_ACL | ICM (Investigative Case Management) ACE access control list |
| CRM_ACE_PRC_TYPS | Process-types of ACE-calculations |
| RSCRMREPTAB | RSCRM: Report Table Catalog |
| RSCRMEXTRTXT | RSCRM: Report table catalog |
| RSCRMC_IMP_EVENT | Customizing table for defining event handlers in planning |
| CRM_ACE_ACTS_T | Descriptions for ACE relevant actions |