The complete list of SAP Tables in Customer Relationship Management 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.

SAP Customer Relationship Management Tables by Sub-Module

CRM General Tables

Go to top of the page
S.No Table Description Table Type
1 SMOKNA1 General Data in Customer Master Transparent Table
2 PMNTTRMS CDB Customers: Terms of Payment Transparent Table
3 ORDERADM_H Reporting Structure for Ext. ORDERADM_H Structure
4 CRMD_ORDER_INDEX Index table for one-order document Transparent Table
5 OUTPUT_DATA Output Data Structure
6 SMOHQUEUE Managing queues of mobile clients Transparent Table
7 PARTNER_FUNCTION PartnerFunction Structure
8 SMOUSERS Users Transparent Table
9 SERVICEORDER Proxy Structure (Generated) Structure
10 CRMD_CUSTOMER_H Transaction - Customer Extension Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM General Tables
Go to top

Mobile Sales Tables (CRM-MSA)

Go to top of the page
S.No Table Description Table Type
1 SMOKNA1 General Data in Customer Master Transparent Table
2 PMNTTRMS CDB Customers: Terms of Payment Transparent Table
3 SMOUSERS Users Transparent Table
4 SMOMITABT Employee Master Transparent Table
5 SMOKVBEZ11 Interlinkage Activity - Employee Transparent Table
6 SMOKNA1SHT Business Partner Short-File Transparent Table
7 SMOMITAREA Employee: Default Sales Area and Field Defaults Transparent Table
8 SMOVBAK Sales Document: Header Data Transparent Table
9 SMOADRC Addresses (central address admin.) Transparent Table
10 SMOREPMA Report: Header File Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Mobile Sales Tables (CRM-MSA)
Go to top

Business Transactions Tables (CRM-BTX)

Go to top of the page
S.No 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 Business Transactions Tables (CRM-BTX)
Go to top

Interaction Center WebClient Tables (CRM-IC)

Go to top of the page
S.No Table Description Table Type
1 OUTPUT_DATA Output Data Structure
2 EVENT_DATA Event Data Structure
3 CRMC_ERMS_CAT_OK Coherent Cat - External Object Keys Transparent Table
4 CRMC_ERMS_CAT_LN Coherent Cat - Links between Categories and External Object Transparent Table
5 CRMC_ERMS_CAT_CA Coherent Cat - Categories Transparent Table
6 CRMC_ERMS_CAT_HI Coherent Cat - Object Hierarchy Transparent Table
7 CRMC_ERMS_CAT_CT Coherent Cat - Category Descriptions Transparent Table
8 CRMC_ERMS_CAT_AS Coherent Cat - Aspects for Categorization Transparent Table
9 CRMC_IC_AUICOMM AUI: Task Communication Methods Transparent Table
10 CRMD_ERMS_HEADER Statistical data header Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Interaction Center WebClient Tables (CRM-IC)
Go to top

Middleware Tables (CRM-MW)

Go to top of the page
S.No Table Description Table Type
1 SMOHQUEUE Managing queues of mobile clients Transparent Table
2 SMOFPARSFA Middleware Parameter Transparent Table
3 CRMMLSGUID LOGSYS-change-LOG Transparent Table
4 SMOFSUBTAB Subscribtion table for function mod. to receive OLTP data Transparent Table
5 TABLENAMES TableName/Segment Name Structure
6 SMW3FDCUST Customer-Specific Flow Transparent Table
7 SMOFOBJECT Definition of Objects for Download Transparent Table
8 ISPCFG ISP Configuration Transparent Table
9 SMOFTABLES Definition of Tables for Download Transparent Table
10 SMOF_ERPSH ERP-Site Header table Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Middleware Tables (CRM-MW)
Go to top

Master Data Tables (CRM-MD)

Go to top of the page
S.No Table Description Table Type
1 PARTNER_FUNCTION PartnerFunction Structure
2 CRMM_BUT_CUSTNO Mapping Table Business Partner - Customer Transparent Table
3 CRMD_ORGMAN Organizational Unit Set Transparent Table
4 CRMM_PR_SALESG Product - Sales Pricing Set Transparent Table
5 CRMT_BUPA_IL_HEADER_SEARCH Search Structure of Search Object BuilHeaderSearch Structure
6 COMM_PCAT_ITM Product Catalog Item Transparent Table
7 CRMM_BUT_FRG0041 Business Partner Sales Classification Transparent Table
8 COMM_PCAT_CTY Product Catalog Area Transparent Table
9 CRMC_T077D Customer account groups Transparent Table
10 CRMM_BUT_FRG0050 Business Partner - Status Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Master Data Tables (CRM-MD)
Go to top

Basic Functions Tables (CRM-BF)

Go to top of the page
S.No Table Description Table Type
1 SERVICEORDER Proxy Structure (Generated) Structure
2 CONTENT_TEXT Proxy Structure (Generated) Structure
3 CRMXIF_IBASE Interface IBase Structure
4 MATERIAL_ID Proxy Data Element (Generated) Structure
5 LONG_DESCRIPTION Proxy Data Element (Generated) Structure
6 MEDIUM_NAME Proxy Structure (Generated) Structure
7 CRMC_PARTNER_FCT Definition of Partner Functions Transparent Table
8 COMM_IPC_URL IPC - URL Definition for UI Transparent Table
9 COMM_IPC_PROP IPC Settings (User Interface, Scenario-Spec., User-Spec.) Transparent Table
10 CRMT_PARTNER_EXTERNAL_WRK Transfer Structure for Partners Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Basic Functions Tables (CRM-BF)
Go to top

Tables (CRM-IM)

Go to top of the page
S.No Table Description Table Type
1 E101XIF_PR_PRODUCT_SET_CUST IF Material-Extension Set Type: Data Fields Structure
2 E101COMXIF_PR_S_PRODUCT_SET IF Material-Extension Set Type Structure
3 COMM_IL_IPMAT IP-Related Material Transparent Table
4 COMM_IL_IPPAC IP Package Element Transparent Table
5 COMM_IL_IPACC IP Part Transparent Table
6 COMM_IL_IPTTL IP Title Transparent Table
7 CRMT_IPM_BEA_DPLI_EXTRACT IPM: Extraction Structure for Settlement Data Collector Structure
8 COMM_IL_IPUCO IP Underlying Component Transparent Table
9 CRMT_IPM_BW_SALES_RIGHTS_I IPM: BW DataSource for IPM Sales Contracts Rights Items Structure
10 CRMT_IPM_BW_SALES_CONTRACT IPM: BW DataSource for IPM Sales Contracts Item Data Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Tables (CRM-IM)
Go to top

Pharmaceuticals Tables (CRM-IPH)

Go to top of the page
S.No Table Description Table Type
1 ATTACHMENT2 Proxy Structure (Generated) Structure
2 CRMPHAM_BP_BRK01 CRM Pharma. BP : Market Segments Master Data Transparent Table
3 CRMPHAM_BP_BRK00 CRM Pharma. BP: Market Segments Master Transparent Table
4 CRMPHAC_BP_GRP Business Partner Groups Transparent Table
5 CRMPHAC_BP_SGR Business Partner Subgroup Transparent Table
6 CRMPHAC_BP_GRP_T Business Partner Group Description Transparent Table
7 CRMPHAC_BP_SGR_T Business Partner Subgroup Description Transparent Table
8 CRMPHAM_BP_FRG21 CRM Pharma. BP: Specification Transparent Table
9 CRMPHAM_BP_FRG50 CRM Pharma BP: assigned DEA schedules Transparent Table
10 CRMPHAM_BP_FRG20 CRM Pharma. BP : Specification Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Pharmaceuticals Tables (CRM-IPH)
Go to top

Marketing Tables (CRM-MKT)

Go to top of the page
S.No Table Description Table Type
1 LTYPE_ATTR_STRUCT Attr structure for LAUNCHERINFO Structure
2 CRMD_MKTLIST_MAP CRM Marketing :ELM Mapping table Transparent Table
3 CRMT_MKTTG_GENIL_TG_I_ENHANCE Seg GenIL: Target Group Items (Enhancements) Structure
4 CRMC_MKTPL_CTYPT CRM Customizing Marketing Planning: Campaign Types Texts Transparent Table
5 CRM_MKTPL_ATTR CRM Marketing Planner: Marketing plan/campaign attributes Transparent Table
6 CRMD_MKTPL_TGGRP Assignment of Target Group in Marketing Planner Transparent Table
7 CRMT_MKTLIST_BCI_EXT CRM Marketing: Converted Cache - BP/Campaign Identification Structure
8 CRM_MKTGS_OBJMTD MKTGS OL: Generic Object Metadata Table Transparent Table
9 CRMS_DAM_ASSETVERS_ATTR_BW DAM Asset Version Attributes (PHIO Attributes) Structure
10 CRMT_MKTLIST_PER_EXT CRM Marketing : External List Converted Cache-Person details Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Marketing Tables (CRM-MKT)
Go to top

CRM Leasing Tables (CRM-LAM)

Go to top of the page
S.No Table Description Table Type
1 TREENODES Tree Control: Structure TREEV_NODE + TEXT Field of Length 30 Structure
2 IBASE Table of IBase Numbers Structure
3 CRMD_FS_FRA FRA: Index table for FRA relevant transactions Transparent Table
4 CRM_PR_RESIDVL Financing-Dependent Attributes Transparent Table
5 CRM_PR_FINOP02 Exercise Dates Transparent Table
6 COMM_IL_FINANC Financing-Product Relationships Transparent Table
7 COMM_IL_FINCAT Financing-Product Category Relationships Transparent Table
8 CRM_PR_FINOP01 Financing Options: Type Transparent Table
9 CRM_PR_FINOP03 Fin. Options: Additional Features Transparent Table
10 CRM_LEAS_ORDPPR Assignment: Product Family and Layout to Product Category Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM CRM Leasing Tables (CRM-LAM)
Go to top

CRM Analytics Tables (CRM-ANA)

Go to top of the page
S.No Table Description Table Type
1 SMOXHEAD_S Shadow Table for Table smoxhead Transparent Table
2 SMOXHEAD Control Table: BW Adapter 002 Transparent Table
3 SMOXRELP BWA: Use of Segments and Fields in DataSources Transparent Table
4 SMOXAFLD Field List: Key Attributes for BWA Master Data Delta Queue Transparent Table
5 SMOXRELP_S Shadow Table for Table smoxrelp Transparent Table
6 CRMBWTARGETS Data Targets for BW Upload Transparent Table
7 CRMD_TSS_DTRACK TSS Tracking of Documents: DB Table for Tracking Records Transparent Table
8 CRMT_IL_REMAN_ATTR_BW BW-Extraktion: Generierte Struktur f_r Tabelle COMM_IL_REMAN Structure
9 SMOXGSEL Control parameter per DataSource Transparent Table
10 CRMBW_MEASURET Texts for BW InfoObject 0MEASURE "Key Figure" Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM CRM Analytics Tables (CRM-ANA)
Go to top

Utilities Industry Tables (CRM-IU)

Go to top of the page
S.No Table Description Table Type
1 INDUSTRYSECTOR Utilities: Industry Transparent Table
2 CONSUMPT Utilities: Consumption Single-Rate Meter Transparent Table
3 CRMD_IUDSM_PMEAS DSM Program Measure Attributes Table Transparent Table
4 PAYMENTPLAN Utilities: Payment Plan Transparent Table
5 CRMD_IUDSM_PINCT DSM Program Incentive Attributes Table Transparent Table
6 ISU_POD ISU Point of Delivery Transparent Table
7 CRMD_IUDSM_PPASG DSM Program Process Assignments Table Transparent Table
8 V_POSTCODE Generated Table for View V_POSTCODE General View Structure
9 CRMD_IUDSM_PGOCO DSM Program Goal Contribution Table Transparent Table
10 CRMD_IUDSM_PHEAD DSM Program Header Table Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Utilities Industry Tables (CRM-IU)
Go to top

Tables (CRM-MT)

Go to top of the page
S.No Table Description Table Type
1 SMO_AUTH_SYS Mobile authorization system settings Transparent Table
2 WBTRCL WB Change List for transport Transparent Table
3 WBTRBSEG WB Transport Blob segments Transparent Table
4 WBTRREP WB Repositories connected to the server Transparent Table
5 WBTRCLQ WB Change list queue Transparent Table
6 WBTRBLOB WB Transport Blob header entries Transparent Table
7 SMO_AUTH_ROLE Authorization: Role Transparent Table
8 WBTRTLCL WB Change list for transport (Runtime object transfer) Transparent Table
9 WBTRTLBSEG WB Transport Blob segments (Runtime object transfer) Transparent Table
10 SMOSERVICE Service message handling (TL) Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Tables (CRM-MT)
Go to top

Mobile Smartphone Tables (CRM-MSP)

Go to top of the page
S.No Table Description Table Type
1 CRMS_MOBILE_CUST_ENHANCE Crm Mobile Customer Enhancement: Copy user specific fields Structure
2 CRMS_BUPA_MOB_BPHEADER BP Header Details Mobile Sales Structure
3 CRMC_SO_STATUS Customization Table for Sales Order Status Transparent Table
4 CRMT_BP_INITIAL xMobile Sales : Rltyp Category code for Contact & Employee Transparent Table
5 CRMS_MOBILE_CUST_ENHANCE_1O Crm Mobile Customer Enhancement: Copy user specific fields Structure
6 CRMS_BUPA_MOB_NOTE MSOO : Mobile Sales BP note - Text Structure
7 CRMS_BUPA_MOB_SALESAREA Business Partner Sales Area Data Mobile Sales for Smartphone Structure
View the full list of SAP CRM Mobile Smartphone Tables (CRM-MSP)
Go to top

Interaction Center WinClient Tables (CRM-CIC)

Go to top of the page
S.No Table Description Table Type
1 CCMSEARCH_STRUCT Search and Display Component - All Fields Structure
2 CRMS_CLM_CALL Call Structure
3 CRMD_TM_ACTIVITY Activity reference Transparent Table
4 CRMD_TM_IACT Calls Transparent Table
5 CCMSEARCH_CNTRL Search Component (both Search&display and Employee Search) Transparent Table
6 CCMSEARCH_RULES Search Priorities for the Business Partner Search in CIC Transparent Table
7 CRMD_TM_CL Call lists Transparent Table
8 CRMC_CLM_CMPGPM Campaign priority to call list priority mapping Transparent Table
9 CRMD_TM_IACT_BP Business context information: one order and business partner Transparent Table
10 CRMD_CIC_CTI_H CRM CIC: buffered CTI data: Header Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Interaction Center WinClient Tables (CRM-CIC)
Go to top

Mobile Service Tables (CRM-MSE)

Go to top of the page
S.No Table Description Table Type
1 CRMT_EQUI_DMBDOC Extended Data for CS Equipment Distribution MBDOC Structure
2 CDBD_IL_IBCWTY Installed Base Components - Warranty Relationship Transparent Table
3 CRMT_EQUI_MESS CRM Customer Service Equipment Master Data Structure
4 CDBD_IL_PRDIB Individual Object-Installed Base Interlinkage Transparent Table
5 CDBD_IBIB Installed Base Header Table. Transparent Table
6 CDBD_IBIBT Installed Base Header Text Transparent Table
7 CDBD_IBADDR Installed Base Address table. Transparent Table
8 CDBD_IBIN Installed Base Components table. Transparent Table
9 CRMT_ILOA_MESS CRM Customer Service Equipment - Location and Acc Assigmnent Structure
10 CDBD_IL_MD_MP Master Data (IOB , IBC ) : Counter Relationship Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Mobile Service Tables (CRM-MSE)
Go to top

Internet Service Tables (CRM-ISE)

Go to top of the page
S.No Table Description Table Type
1 CRMT_ICSS_FILE_INFO File information Structure
2 CRMT_ICSS_ATT_INFO Attachment Information Structure
3 CRMT_ICSS_OBJECT_GUID Guid of object whith a handle Structure
4 CRMVTQ80 Notification Types from R/3 for Mapping Transparent Table
5 CRMWBPHHR KW Request Data: Outbound Hyperlinks from Physical Objects Transparent Table
6 CRMWBPHNM KW Request Data: Use of Target Anchors in Physical Objects Transparent Table
7 CRMWBPHRE KW Request Data: Outbound Relatshps of Physical InfoObjects Transparent Table
8 CRMWBLORE KW Request Data: Outbound Relatshps of Logical InfoObjects Transparent Table
9 CRMWBLORI KW Request Data: Inbound Relatshps of Logical InfoObjects Transparent Table
10 CRMD_WR_BRF_EXP Database Table for Created Web Request Expressions Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Internet Service Tables (CRM-ISE)
Go to top

Channel Management Tables (CRM-CHM)

Go to top of the page
S.No Table Description Table Type
1 CMSD_RTCM Index table for RTCM Transparent Table
2 CMSV_DEA_MST Generierte Tabelle zu einem View General View Structure
3 CRMD_CHM_CLASS Dependency Partner Type/Status etc. Transparent Table
4 CMSD_CI_HEADER Channel Inventory Header Table Transparent Table
5 CMSM_BP_FRG10 CMS: BP additional attributes Transparent Table
6 CRMS_CHM_PROCESS Channel Management: System Table for CRM Processes Transparent Table
7 CRMS_CHM_PROC_T Channel Management: Texts for CRM Processes Transparent Table
8 CMSD_LO_HEADER Document header Transparent Table
9 CMSD_HIN_MST Health Industry Number (HIN) Transparent Table
10 CMSD_LO_STATUS Status data Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Channel Management Tables (CRM-CHM)
Go to top

Internet Sales Tables (CRM-ISA)

Go to top of the page
S.No Table Description Table Type
1 CRMT_ISALES_EXTENSION Structure for Including Enhancements of Objects Structure
2 CRMM_ISA_SHOP_H Header Data for a Shop Transparent Table
3 CRMC_ISA_SDOCTYP Generic Document Search: Document Type Transparent Table
4 CRMT_ISALES_BASKETHEAD_UI Internet Sales Shopping Basket Data WebAPI Structure
5 CRM_ISA_PTG_T Description of Group of Transaction Types Transparent Table
6 CRMT_ISALES_RETURN Internet Sales: Return Structure Structure
7 CRMT_ISA_BUPA Internet Sales: Business Partner Structure
8 CRMT_ISA_CUSTEXT Internet Sales: Ext. Visible/Maintainable Customer Data Structure
9 CRMD_ISA_SPL_I Shopping Basket and Purchasing List Item Data Transparent Table
10 CRMD_CHM_PPR The table to maintain the relationship partner and product Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Internet Sales Tables (CRM-ISA)
Go to top

Public Sector Tables (CRM-IPS)

Go to top of the page
S.No Table Description Table Type
1 CRMC_EEW_INFO_P EEW Information: Parameters Transparent Table
2 PSIC_NAMES Other Names Transparent Table
3 EMAIL_VIEW Generated Table for View General View Structure
4 CRM_SECURITY Security Settings Transparent Table
5 CRMM_ICM_BP_AID ICM BP Alternative Identity Master Data Transparent Table
6 COMM_IL_PSCIP Master Data on Relationship Cat. PSOB Incoming Payment Transparent Table
7 COMM_IL_PSCOP Master Data of Relationship Cat. PSOB Outgoing Payment Transparent Table
8 CRMD_GPM_PCT Grantor Program Process Control Transparent Table
9 COMM_IL_PSCBA_H Historical Data of Relationship Category Contract Objt Basis Transparent Table
10 COMM_IL_PRDREQ Product: Request Type Relationship Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Public Sector Tables (CRM-IPS)
Go to top

Access Control Engine Tables (CRM-ACE)

Go to top of the page
S.No Table Description Table Type
1 CRMS_ACE_OBJECT_GUID Structure for object GUIDs in ACE Structure
2 CRM_ACE2_BP_GRP BP (business-partner) ACE groups Transparent Table
3 CRM_ACE2_BP_ACL BP (business partner) ACE access control list Transparent Table
4 CRM_ACE2_BP_UCT BP (business-partner) ACE user-contexts Transparent Table
5 CRM_ACE_BP_GRP BP (business-partner) ACE groups Transparent Table
6 CRMS_ACE_ACTOR_ID Structure for ACE Actor ID Structure
7 CRM_ACE_CUSTOM Customizing for ACE Transparent Table
8 CRM_ACE_ANGRPS Actions of ACE action-groups Transparent Table
9 CRM_ACE_AFO_CL Repository of all ACE relevant AFO-classes Transparent Table
10 CRM_ACE_ACTS_OTS CRM object-types of ACE actions Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Access Control Engine Tables (CRM-ACE)
Go to top

CRM Integration for ERP Billing in Current Account Tables (CRM-FCA)

Go to top of the page
S.No Table Description Table Type
1 CRMT_ISX_ERP_PRODUCT_SALESG Product replication to FI-CA - Sales Area Data Structure
2 CRMT_FICA_ONEOFF_GEN_ATTR Transfer structure for one-offs - generic attributes Structure
View the full list of SAP CRM CRM Integration for ERP Billing in Current Account Tables (CRM-FCA)
Go to top

Tables (CRM-RPL)

Go to top of the page
S.No Table Description Table Type
1 CRM_LRP_RFC_CON RFC Connection to External Scheduling Engine Transparent Table
2 CRM_LRP_RES_TIMEINT List of Service Rep. Attendence/Absence Structure
3 COMM_IL_BPQFR_H Product-Warranty Relationships History Transparent Table
4 COMM_IL_IBHQFR Qualification Requirements IBase Components (As for BPQFR) Transparent Table
5 COMM_IL_BPQFR Qualification Requirements Business Partner Transparent Table
6 COMM_IL_IOBQFR Qualif. Requirements IBase Components (As for BPQFR) History Transparent Table
7 CRM_LRP_PF_RPL Partner Function Category of Business Partner Transparent Table
8 CRM_LRP_APP_ACT Active Functions Transparent Table
9 CRM_LRP_COL_GRA Allocation of Color to Assignment for Graphic Element Transparent Table
10 CRM_LRP_ACT_SHED Selection of Active Scheduling Engine Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Tables (CRM-RPL)
Go to top

Billing Tables (CRM-BE)

Go to top of the page
S.No Table Description Table Type
1 E101CRMXIF_TLINE External Interfaces: Text Lines Structure
2 TXCRM_BEAD_CRMB_BDH Billing Document Header Structure
3 E102CRMXIF_ADDRESS UI Business Transaction:Address Structure
4 TXCRM_BEAD_CRMB_BDI Billing Document Item Structure
5 BILL_ACC_ACGL09 G/L Account Item Structure
6 BILL_ACC_ACHE09 Header Structure
7 BEAD_PPF Table Showing Persistence for CL_BEA_PPF incl. BEA Name Transparent Table
8 TBILL001 Document Type Determination for Billing Transparent Table
9 CRM_ACE2_REX_GRP Rebate Extract ACE groups Transparent Table
10 CRM_ACE2_BE_GRP BEA ACE groups Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Billing Tables (CRM-BE)
Go to top

Telecommunications Tables (CRM-IT)

Go to top of the page
S.No Table Description Table Type
1 CRMD_ISX_MSG ISX - Message distribution Transparent Table
2 CRMC_ISX_CNTNSP Z_hlernamensraum f_r katalog_bergreifendes Mapping Transparent Table
3 CRM_ISX_PAYMNT Payment settings Transparent Table
4 COMM_IL_SLSBDL Master Data for the Sales Bundle Relationship Type Transparent Table
5 COMM_IL_PROPRD Master Data for the Process Products Relationship Type Transparent Table
6 COMM_IL_PRDFMT Allocation of Telco Product to Indemnity Payment Product Transparent Table
7 CRMD_EDR CRM Invoice Line Item - EDR Table Transparent Table
8 CRM_IST_BW_PFT IS-T: Partner Function Categories for BW Transparent Table
9 CALL_FWD_TD Call Forwarding Transparent Table
10 CRM_ISX_TECRES Technical Resources Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Telecommunications Tables (CRM-IT)
Go to top

Waste Management Tables (CRM-WA)

Go to top of the page
S.No Table Description Table Type
1 TCRM_EWA_EL_GEO EEWA auxiliary data for GenIL object Transparent Table
2 CRM_EWA_SOBJECTADDRESS_INFO EEWA: List info structure for Object Address Structure
3 CRM_EWA_SSERVICEADDRESS_SHLP Search structure for Service Address Structure
4 CRM_EWA_SBP_SHLP Search structure for Object Address Structure
5 CRM_EWA_SOBJECTADDRESS_SHLP Search structure for Object Address Structure
6 CRM_EWA_SSERVICEADDRESS_INFO EEWA: Info structure for service address Structure
7 CRM_EWA_SBP_INFO Search structure for Object Address Structure
8 CRM_EWA_SSERVICEADDRESS_ATTR Attribute structure for service address Structure
9 TCRM_EWA_EL_GEOR EEWA auxiliary data for GenIL object relation Transparent Table
View the full list of SAP CRM Waste Management Tables (CRM-WA)
Go to top

Case Management Tables (CRM-CM)

Go to top of the page
S.No Table Description Table Type
1 CRMD_CMG_CASE_AT CRM-Specific Case Attributes Transparent Table
2 CRMD_CMG_CAT_LIS Extended Attributes for Case Categories Transparent Table
3 CRMD_CASE_INDEX Index Table for CRM Cases Transparent Table
4 CRMC_METHOD_CMG Case Management: Executable Methods for an Object Transparent Table
5 CRMT_CMGPROFSTAT Case: Profil_ID and User Status Transparent Table
6 CRMD_CMG_N_ATR_T Table for PU Attributes for Case Note Enhancement Transparent Table
7 CRMD_CMG_CASE_INCLUDE Include for CRM-Specific Case Attributes(SAP, IBU and Cust.) Structure
8 CRMD_CMG_XI_MAP Mapping for case XI Transparent Table
9 CRMC_MODEL_CMG Case Management: Interaction Layer Model Transparent Table
10 CRMT_CMG_ADVANCED_SEARCH CRM Case: Selection Parameters Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Case Management Tables (CRM-CM)
Go to top

Loyalty Tables (CRM-LOY)

Go to top of the page
S.No Table Description Table Type
1 LOYD_MSH_MEMS Loyalty Membership Table Transparent Table
2 LOYD_MEM_MEMBER Loyalty Menagement : Database Table for Member Transparent Table
3 REWARD_PRO_LOY Set Type for Reward Products Transparent Table
4 LOYD_MSH_MSDYN Table for Maintaining Points for diff point types of Tiers Transparent Table
5 LOYD_CRD_CARD Cards table Transparent Table
6 LOYD_PLOGS_CLST Processing logs for Loyalty Transparent Table
7 LOY_BENEFIT Loyalty Benefits Product Set type Transparent Table
8 LOYD_MSH_MS_MEMB Link Table for Membership and Member Transparent Table
9 LOYD_MA_SPECATTR Table for member activity specific attributes Transparent Table
10 LOYD_MA_GENATTR Table to store member activity generic attributes Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Loyalty Tables (CRM-LOY)
Go to top

Financial Services Tables (CRM-IFS)

Go to top of the page
S.No Table Description Table Type
1 CRM_PROD_FS002 Term Transparent Table
2 CRM_PROD_FS007 Payment Structure Transparent Table
3 CRM_FS_OPTION Information About Financing Option Transparent Table
4 CRM_PR_FSCA01 Agreement Type Transparent Table
5 CRM_PROD_FS003 Interest and Payments Transparent Table
6 CRM_PROD_FS018 Bank Details Transparent Table
7 CRM_PR_FSC_02 Object Details Transparent Table
8 CRM_PROD_FS019 Results Transparent Table
9 CRM_PR_FSC_03 Object Location Transparent Table
10 CRM_PROD_FS017 Payment Schedule Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Financial Services Tables (CRM-IFS)
Go to top

Tables (CRM-FM)

Go to top of the page
S.No Table Description Table Type
1 CRMD_FM_AGR_FUI FM Fund Item Postings Aggregates by Fund / Fund Period Transparent Table
2 CRMD_FM_ACL_SV Storage Area for Sales Volumes of ERP accruals Transparent Table
3 CRMD_FM_LR_ELM Live Rate Planning Element Transparent Table
4 CRMS_APPLOG_MOD Model Table for Gen. Interaction Layer APPLOG Component Transparent Table
5 CRMI_FM_FND_ATTR Fund Attributes Metadata table for Inteface Implementation Transparent Table
6 CRMS_APPLOG_IMPL Object Impl Table for Gen. IL APPLOG Component Transparent Table
7 CRMS_APPLOG_OBJ Object Table for Generic Interaction Layer APPLOG COMP Transparent Table
8 CRMD_FM_LR_PLN Live Rate Plan Transparent Table
9 CRMD_FM_FU_ITEM TFM-Fund Usage: Fund usage item Transparent Table
10 CRMD_FM_LR_FUND Fund associated to Live Rates Planning Elements Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Tables (CRM-FM)
Go to top

People-Centric CRM (CRM Portal Content) Tables (CRM-PCC)

Go to top of the page
S.No Table Description Table Type
1 CRMT_PORTAL_SEARCH_BUSINESSACT Contains Search Parameters for Bus. Activities in Portal Structure
2 CRMT_PORTAL_LIST_BUSINESSACT Hit List with Bus. Activities Structure
3 CHAR_ARRAY Structure to store the flag value. Structure
4 CRM_PRT_PAGEDISP Assignment of Portal Page for Object Type and Role Transparent Table
5 CRMT_PORTAL_RESULTLIST Result list for the portal Structure
6 CRMT_PORTAL_SERVICE_SEARCH Structure for the import parameter of the search FM Structure
7 CRMT_PORTAL_LIST_OPPORTUNITIES Hit List with Bus. Activities Structure
8 CRMC_PRT_KM_HIER Definition of WebDAV Hierarchies for CRM Documents Transparent Table
9 CRMC_QC_OLNK Object Link Targets in the Quick Create iView Transparent Table
10 CRMC_FS_EL_GRP Element Group Table Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM People-Centric CRM (CRM Portal Content) Tables (CRM-PCC)
Go to top

CRM integration with IS-H Tables (CRM-ISH)

Go to top of the page
S.No Table Description Table Type
1 CRMM_ISH_PAT Patient Data for Business Partner Transparent Table
2 CRM_ISH_SER Patient Service Information Transparent Table
3 CRM_ISH_SER_GR Patient Service Group Transparent Table
4 CRMS_ISH_NTPK IS-H: Filter Description for Healthcare Service Adapter Structure
View the full list of SAP CRM CRM integration with IS-H Tables (CRM-ISH)
Go to top

Localization Tables (CRM-LOC)

Go to top of the page
S.No Table Description Table Type
1 CRMM_BUT_KOR0041 Business Partner Korea History Transparent Table
2 CRMM_BUT_KOR0040 Business Partner Korea Transparent Table
3 CRMC_BUPA_INDTYP Business Partner: Industry Type (Korea) Transparent Table
4 CRMC_BUPA_BUSTYP Business Partner: Business Type (Korea) Transparent Table
5 CRMD_TAXEXMT_AR Business Partner: Tax Exemption Transparent Table
6 CDBD_TAXEXMT_AR MSA: Tax Exemptions for Business Partners Transparent Table
7 CRMT_TAXEXMT_00 Business Partner: Tax Exemption Transparent Table
8 ITLC_NFTYPE Nota Fiscal Type Transparent Table
9 ITLC_DCLS_TRNF Transfer Official Document Number to R/3 Fields Transparent Table
10 COMC_TTE_TAXMAP Assignment TTE Tax Type to Pricing Condition Types Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Localization Tables (CRM-LOC)
Go to top

Multi-System Exchange Projects Tables (CRM-MEP)

Go to top of the page
S.No Table Description Table Type
1 CRMMEP_PARAM MEP Parameters Transparent Table
2 CRMMEP_T684 Condition Exclusion Groups Transparent Table
3 CRMMEP_LOOK_TAB Lookup Tables Transparent Table
4 CRMMEP_TMC1 Generated DDIC Structures for LIS, Conditions, Output Transparent Table
5 CRMMEP_T681 Conditions: Structures Transparent Table
6 CRMMEP_PRE_LOOK PREFIX_LOOKUP Transparent Table
7 CRMMEP_CUSTOMIZE Customizing table for MEP Transparent Table
8 CRMMEP_T683 Pricing procedures Transparent Table
9 CRMMEP_SCENARIO MEP Scenario Transparent Table
10 CRMMEP_FLD_OPR Operational Field Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Multi-System Exchange Projects Tables (CRM-MEP)
Go to top

Tables (CRM-IHT)

Go to top of the page
S.No Table Description Table Type
1 CRMD_CSDR_INDEX Index for design registration Transparent Table
2 CRM_CSDR_THRSL Opportunity Thresholds Transparent Table
3 CRM_CSDR_WINMS Win Metrics Transparent Table
4 CRM_CSDR_ACTS Activity Status t Transparent Table
5 CRM_CSDR_REGS Registration Status Transparent Table
6 CRMD_CSDR_ATTR Value table for Design Registration attrtbutes. Transparent Table
7 CRM_CSDR_THRSLH Opportunity Thresholds Transparent Table
8 CRM_CSDR_WINMSH Win Metrics Transparent Table
9 CRMC_CSDR_PCTYPE Customizing table for Design Reg.relevant prod Catalog type. Transparent Table
10 CRMC_CSDR_ATTR Value table for Design Registration attrtbutes. Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Tables (CRM-IHT)
Go to top

Tables (CRM-ACP)

Go to top of the page
S.No Table Description Table Type
1 CRMD_ACC_PL_PAR Assignment Partner Set in Account Planning Transparent Table
2 CRMD_ACC_PL_ATTR Account Planning account plan attributes Transparent Table
3 CRMD_ACCPL_BDINC Account Planner: Additional fields for the Basic Data Tab Transparent Table
4 CRMD_ACC_PL_PCAT Account Planning assignment of product category Transparent Table
5 CRMD_ACC_PL_COST Trade Spend Assignments table Transparent Table
6 CRM_ACCPL_BW_URL Zugriffsparameter f?r BW-Berichte Transparent Table
7 CRM_ACCPL_PLGBWQ Account Planner: Assignment BW Analyses to Plg ProfileGps Transparent Table
8 CRM_ACCPL_BW_URT Texte f?r BW Analysen Transparent Table
9 CRMD_ACCPL_PGRP DB table for ACCPL Product Group Assignments Transparent Table
10 CRMD_ACC_PL_OPER Operations in Account Planning Programs Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Tables (CRM-ACP)
Go to top

Tables (CRM-ITT)

Go to top of the page
S.No Table Description Table Type
1 TCTR_RESOURCES TC: Resource assignment settings Transparent Table
2 CRMV_TC_AUTH Generierte Tabelle zu einem View General View Structure
3 CRMD_TC_TECH_RES TC: Technical Resources Transparent Table
View the full list of SAP CRM Tables (CRM-ITT)
Go to top

Incentive and Commission Management Tables (CRM-ICM)

Go to top of the page
S.No Table Description Table Type
1 CRMM_ICM_BPMAP CRM Incentives: CRM BuPa to Commission contract partner Transparent Table
2 CRMC_ICM_RFCDEST RFC Destinations for Logical Systems Transparent Table
3 CRMC_ICM_APPL_T BW-ICM Transfer Application Text Table Transparent Table
4 CRMC_ICM_TRIST CRM Incentives: supported trigger status per trans.category Transparent Table
5 CRMC_ICM_SOCAT CRM Incentives: Subobject category dependent parameters Transparent Table
6 CRMC_ICM_QRY_T BW-ICM Transfer Application Text Table Transparent Table
7 CRMC_ICM_PFTRC CRM Incentives: PartFunct & TrIgCategory dependent params. Transparent Table
8 CRMC_ICM_BW_QRY Logical definintion of BW query Transparent Table
9 CRMC_ICM_TRACT CRM Incentives: CRM transaction activity type Transparent Table
10 CRMC_ICM_QRYFLD BW-ICM: BW Query Field Customizing Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Incentive and Commission Management Tables (CRM-ICM)
Go to top

Handheld Tables (CRM-HH)

Go to top of the page
S.No Table Description Table Type
1 CRM_HH_LUIDGUID LUID - GUID table Transparent Table
2 CRM_HH_TRANSACT Sync Transaction table Transparent Table
3 CRMD_PDA_PROF Profile parameters for PDA Transparent Table
4 CRMHH_PDA_PROF Profile parameters for PDA Transparent Table
5 CRMC_HH_QUO CRM Handheld: Quotation Attributes Transparent Table
6 CRMC_HH_SALE CRM Handheld: Sales Attributes Transparent Table
7 CRMC_HH_SRV_ASSI CRM Handheld: Service assignment attributes Transparent Table
8 CRMC_HH_ORG CRM Handheld: Organization and Distribution Channel Transparent Table
9 CRM_TIMSPEC_DBG Table for Time Spec. Using RFC for Debugging Transparent Table
10 CRMC_HH_SRV_ORDR CRM Handheld: service order attributes Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Handheld Tables (CRM-HH)
Go to top

Claims Management Tables (CRM-CLA)

Go to top of the page
S.No Table Description Table Type
1 CRMI_CLA_MSG_MAP Maps Messages from ERP to Messages in CRM Transparent Table
2 CRMD_CLACCR_LINK Temporary storage of payment item key and CCR Transparent Table
3 CRMD_CLA_VS_VS Table of validation sheets Transparent Table
4 CRMD_CLA_VS_RL Relations of validation sheets to other objects Transparent Table
5 CRMT_CLA_H_COM Claim Header - Structure containing comm. fields Structure
View the full list of SAP CRM Claims Management Tables (CRM-CLA)
Go to top

Insurance Tables (CRM-IIN)

Go to top of the page
S.No Table Description Table Type
1 CRMS_IIN_ICLS Maint.:Assignment of Interfaces to Classes (SAP) Transparent Table
2 CRMC_IIN_ICLS Maint.:Assignment of Interfaces to Classes (Customer) Transparent Table
View the full list of SAP CRM Insurance Tables (CRM-IIN)
Go to top

Rebate Processing Tables (CRM-RB)

Go to top of the page
S.No Table Description Table Type
1 BEAC_ETY_DET Extract Type Determination Transparent Table
2 REB_RQ_SETS Requirement Set Transparent Table
3 BEAC_DTY Customizing of Document Types Transparent Table
4 BEAC_CPF Customizing of Cumulation Profiles Transparent Table
5 BEAC_ETY_R1 Customizing of Extract Types Transparent Table
6 REB_EIDX_MAPP Assignment Table Field Name <-> Key Figure Transparent Table
7 BEAC_EPF_R1 Customizing of Calculation Profiles Transparent Table
8 REQ_SET Requirement Set Transparent Table
9 BEAC_RDLBFRM_T Text Table: Filter Calculation of Base Value Transparent Table
10 BEAC_ETY_AR_R1 Archiving Control: Extracts Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM Rebate Processing Tables (CRM-RB)
Go to top

Tables (CRM-IA)

Go to top of the page
S.No Table Description Table Type
1 CRMV_IOBJ_PROG Generated Table for View CRMV_IOBJ_PROG General View Structure
2 CRMC_CIC_SUBSC_T Customizing Table for Dynamic Subscreen Language Dependent Transparent Table
3 CRMC_IOBJ_CIC_M Customizing Table for Dynamic Tabstrip-Main Transparent Table
4 CRMC_IOBJ_CIC_D Customizing Table for Dynamic Tabstrip-Detail Transparent Table
View the full list of SAP CRM Tables (CRM-IA)
Go to top

CRM Entitlement Management Tables (CRM-EM)

Go to top of the page
S.No Table Description Table Type
1 CMSD_CEMI_I_EXTN Entitlements Inbound duelist item extension Transparent Table
2 CMSD_CEMO_I_EXTN Entitlements Inbound duelist item extension Transparent Table
3 CMSD_CEMO Index table for CEMO Transparent Table
View the full list of SAP CRM CRM Entitlement Management Tables (CRM-EM)
Go to top

Tables (CRM-ISR)

Go to top of the page
S.No Table Description Table Type
1 ISR_VARCR_CHAR Variant Creating Characteristic Values Transparent Table
View the full list of SAP CRM Tables (CRM-ISR)
Go to top

Most viewed SAP Customer Relationship Management Tables