SAP Tables

SAP CRM Tables within the data dictionary and their relationships

There is so much SAP CRM information stored in hundreds of thousands of database tables! But how do you know what is stored in where? Well, the simple answer is that experience plays a big part but can provide you with a helping hand to speed the process, providing easy to find information of all these CRM database tables.

This allows you to be able to perform a simple keyword search (i.e. table name/title) and view the details of each table on one page including details such as Table name, Title, Delivery class, Text table if appropriate, Field list, Key field indicator, Data element, Data type, Length, Check table, Field description, Includes, full details about each field/data element/domain

CRMD_ORDERADM_H - Business Transaction header (tcode CRMD_ORDER)
CRMD_ORDERADM_I - Business Transaction Item (tcode CRMD_ORDER)
CRMD_LINK - Transaction Set Link
CRMD_CUSTOMER_H - Transaction - Customer Extension
CRMD_CUSTOMER_I - Transaction Item - Customer Extension
CRMD_PRICING - Business Transaction Pricing Parameter Set
CRM_JEST - Individual Object Status
CRMRFCPAR - Definitions for RFC Connections
CRMCONSUM - Possible Users of R/3 Adapter Functionality
CRMC_BLUEPRINT - SAP Application Scenario - Screen Area Table
CRMPAROLTP - CRM table to store OLTP Parameters
CRMPRLS - Name of the Logical System for Download

Read data for all main SAP CRM tables

You can select data from the CRM tables just like any other table but generally, the easiest way to read this data I via the standard CRM function modules such as CRM_ORDER_READ. One trick worth remembering is that there is also a standard SAP report also called CRM_ORDER_READ which you can execute via SE38/SE80/SA38 etc and pass a transaction/customer id. It will then select all the data from the CRM tables for that customer/transaction and display it as an output.

Generally if you replace the ET_ with CRMD_ you should find the actually SAP database table i.e. ET_ACTIVITY_H becomes CRMD_ACTIVITY_H etc...

Add data to SAP CRM tables

Again when updating SAP CRM data you can use the standard methods such as adding data manually via SM30 to a database table or using ABAP code to add data inserted within an SAP program or report.

But within SAP CRM you should use the CRM_ORDER_MAINTAIN function module to update the data rather than doing it manually. There are also may function modules that update individual subsets of CRM data that can be used instead of CRM_OTDER_MAINTAIN.

SAP Tables related to other Module area

Purchase Order Tables
Project Systems Tables
SAP MM Tables - Material Management
SAP BC Tables - Basis Components
ALL SAP Tables - SAP Tables