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 (BW-BCT-CRM) module.
Top 10 tables in Customer Relationship Management
| Table | Description |
|---|---|
| RSCXP_USERIOBJ | CRM Authorization Settings for Specific Users |
| RSBCT_NAVKEYDET | Customizing for Navigation from BW Webtemplates into PCUI |
| RSMRM_MKTCAL_P | Profiles |
| RSANT_STREAM_ASS | Assignment of Data Stream Fields to Query Elements |
| RSMRM_MKTCAL_F | HTML Color Codes |
| RSCXP_TXTPROG | ABAP Programs used as Textpools in Webtemplates |
| RSMRMT_C_MODEL | Coupon Redemption Model |
| RSCXP_TXT_MAP | Mapping for Textpools in Webtemplates |
| ELMC_STEPS | Ext. List Management: Attributes for Steps |
| RSANT_RFM_SEGM | RFM Segmentation Models |
List of tables in Customer Relationship Management
| Table | Description |
|---|---|
| RSCXP_USERIOBJ | CRM Authorization Settings for Specific Users |
| RSBCT_NAVKEYDET | Customizing for Navigation from BW Webtemplates into PCUI |
| RSMRM_MKTCAL_P | Profiles |
| RSANT_STREAM_ASS | Assignment of Data Stream Fields to Query Elements |
| RSMRM_MKTCAL_F | HTML Color Codes |
| RSCXP_TXTPROG | ABAP Programs used as Textpools in Webtemplates |
| RSMRMT_C_MODEL | Coupon Redemption Model |
| RSCXP_TXT_MAP | Mapping for Textpools in Webtemplates |
| ELMC_STEPS | Ext. List Management: Attributes for Steps |
| RSANT_RFM_SEGM | RFM Segmentation Models |
| RSCXP_AUTHIOBJ | BI Metadata for CRM User Authorization |
| RSBCT_0WS_DEFA | Text table for Default Answer Flag InfoObject |
| RSMRMT_A_DEF_MAP | Default Mapping between Profile Group & Calculation Method |
| RSANT_CLTV_FC | CLTV Prediction |
| ELMC_ORIGIN_T | Ext. List Management: Text for Origin |
| ELMC_TYPE_T | Ext. List Management: Text Category |
| RSANT_RFM_FCVRS | RFM Response Rate Models |
| RSANT_JOB_LOGS | CRM Analytics: Job Logs |
| RSMRMT_C_CLS_ATR | Coupon Redemption Model - Class Characteristic List |
| RSMRMT_A_CALCM_T | Available Accrual Methods - Language specific Text |
| RSANT_RFM_PORTSS | RFM: Assigned Data Streams |
| RSMRM_MKTCAL_C | Customizing - query specific |
| RSMRMT_A_M_CLIST | Accrual Methods Mapped to Planning Profile Group |
| RSANT_LOG_IDS | Application Logs |
| RSANT_CLTV_RUN | Executed CLTV Model Calculations and CLTV Forecasts |
| ELMC_ORIGIN | Ext. List Management: Origin |
| RSMRMT_C_RP_HEAD | Coupon Model Results -> Redemption Period Curves - Header |
| ELMC_TYPE | Ext. List Management: Category |
| RSANT_CLTV_FCT | CLTV Prediction |
| RSMRMT_C_CUSTOMI | Customizing Table |
| RSANT_RFM_RUN | Performed RFM Segmentations |
| RSANT_CLTV_MODET | Text Table for CLTV Models |
| RSMRMT_C_CLS_REL | CoRM Model Results -> Class to Characteristic Value Relation |
| RSMRMT_A_CALC_M | Table for Available Accrual Methods |
| RSMRMT_A_MODEL | Model Details |
| RSCRMALERTSTAT | Release status of alert settings |
| ELMD_LIST_FILE | Ext. List Management: File Relationship |
| CRM_BW_TCRM_FSTY | Characteristic of CRM Document Type for Fact Sheet |
| RSANT_STREAM_VRS | Data Stream Version |
| RSBCT_0WS_CMP | Attribute table for Campaign Related Flag InfoObject |
| RSBCT_NAVKEY_T | Texttable for Navigation from BW Webtemplates into PCUI |
| ELMD_ERROR | Ext. List Management: Error Table |
| RSMRMT_C_RP_DTL | CoRM Result Tables - RP Curve Details |
| RSANT_RFM_PORTS | RFM: Assigned Ports |
| RSMRMT_C_MODEL_T | Texts for CoRM Models |
| RSMRMT_C_CUS_DEF | Customizing Table - Defaults shipped by SAP |
| RSBCT_0WS_QTYP | Text table for Technical Type of Question InfoObject |
| CRMRESPONTXT1 | Table containing texts for 0CRM_RESPON Info Object |
| ELMD_LIST_STEP | Ext. List Management: Steps (Status, and so on) |
| RSMRMT_A_MOD_DSC | Accrual Models - Model Description |
| RSANT_PERS | Personalization |
| RSANT_RFM_FCVRST | RFM Response Rate Model Texts |
| RSANT_RESP | Response Model |
| RSMRMT_A_CUSTOMI | Customizing Table |
| RSANT_CLTV_P | Personalized Values CLTV |
| RSANT_STREAM | Assignment Data Stream <-> Structure |
| CRMPROMOTXT1 | Table containing texts for 0CRM_PROMO1 Info Object |
| RSCRMALERTDEF | Mapping of BW Exceptions to Basis Alerts |
| RSANT_JOB_RESULT | CRM Analytics: Job Results |
| COMC_PR_FORMAT_B | Data for Converting the Product ID |
| RSANT_RFM_PORTSM | Data Stream Mapping (XML) |
| RSCRMRTUPDDS | Datasources supporting realtime update |
| RSANT_RESPT | Response Model Texts |
| RSMRMT_A_CUS_DEF | Customizing Table - Defaults shipped by SAP |
| RSANT_CLTV_MODEL | CLTV Model: Customizing |
| RSANT_RFM_SEGMT | RFM Segment Version Texts |
| RSANT_RESP_DES | Response Model Descriptions |