List Of Frequently Used CRM Tables List

The list of table is as under: You have to figure out the table according to your requirement.

None the less CRMD_ORDERADM_H, CRMD_ORDERADM_I will give you info about all the transactions.

BUT000 : BP: General data - Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc. 
BUT020 : BP: Addresses 
BUT050 : BP relationships/role definitions: General data - Contains Relationship, Partner Number (PARTNER1), Relationship Category 
BUT051 : BP Relationship: Contact Person Relationship Similar to 
BUT050 : Additionally contains Contact Person's Address data 
BUT0BK : Business Partner: Bank Data & Details BP Number, Bank Key, Bank Country Key, Bank Account Number 
BNKA : Bank Master Data 
BUT100 : BP: Roles 
ADR2 : Telephone Numbers (Business Address Services) 
ADR6 : SMTP Numbers (Business Address Services) - Contains Email – Id of the BP. 
ADRC : Addresses (Business Address Services) - BP's Complete Address Details- City, Country, Post Code, District, Street, Title No Etc 
TSAD3T : Table containing the Title text against a Title No. 
COMM_PRODUCT : Master Table for Product 
CRMM_BUAG : Master table for Business Agreement 
CRMM_BUAG_H : Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU 
CRMD_OPPORT_H : OPPORTUNITY HEADER DATA 
CRMD_ORDERADM_H : Contains the Header Information for a Business Transaction. 

Note: 
1. It doesn't store the Business Partner responsible for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX. 
2. This table can be used for search based on the Object Id(Business Transaction No). 
• CRMD_OPPORT_H OPPORTUNITY HEADER DATA 
• CRMD_CUSTOMER_H Additional Site Details at the Header Level of a Business Transaction 
• CRMC_PROC_TYPE Master table Business Transaction Type 
• CRMC_PARTNER_FCT Definition of Partner Functions 
• SCPRIOT Priorities for Activities with priority text. 
• CRMC_PROC_TYPE_T Text for a transaction type 
• CRMC_ACT_OBJ_T Objective Number and Text for Activities 
• TJ30T All the status code and text 
• CRMC_PR_ASSIGN : Transaction Type and its Transaction Type Object. 
• IBIB : Installed Base/Ibase 
• IBIN : Installed Base Components 

Activities:
CRMD_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item Extension
CRMD_TM_ACTIVITY Activity reference

Lead:
CRMD_LEAD_H Lead Header table

Opportunity:
CRMD_OPPORT_H Opportunity Header table

BUT000 : BP: General data
Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

BUT020 : BP: Addresses
BUT050 : BP relationships/role definitions: General data Contains Relationship, Partner Number (PARTNER1), Relationship Category
BUT051 : BP Relationship: Contact Person Relationship Similar to BUT050, additionally contains Contact Persons Address data
BUT0BK : Business Partner: Bank Data & Details BP Number, Bank Key, Bank Country Key, Bank Account Number
BNKA : Bank Master Data
BUT100 : BP: Roles
ADR2 : Telephone Numbers (Business Address Services)
ADR6 : SMTP Numbers (Business Address Services) Contains Email Id of the BP.
ADRC : Addresses (Business Address Services) : BPs Complete Address Details- City, Country, Post Code, District, Street, Title No Etc
TSAD3T : Table containing the Title text against a Title No.
COMM_PRODUCT : Master Table for Product
CRMM_BUAG : Master table for Business Agreement 
CRMM_BUAG_H : Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU CRMD_ORDERADM_H 

Contains the Header Information for a Business Transaction.
Note:
1. It doesn’t store the Business Partner responsible for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX.
2. This table can be used for search based on the Object Id(Business Transaction No). 
CRMD_CUSTOMER_H : Additional Site Details at the Header Level of a Business Transaction
CRMC_PROC_TYPE : Master table Business Transaction Type
CRMC_PARTNER_FCT : Definition of Partner Functions
SCPRIOT : Priorities for Activities with priority text.
CRMC_PROC_TYPE_T : Text for a transaction type
CRMC_ACT_OBJ_T : Objective Number and Text for Activities 
TJ30T : All the status code and text
CRMC_PR_ASSIGN : Transaction Type and its Transaction Type Object.
IBIB : Installed Base/Ibase
IBIN : Installed Base Components

SAP CRM Tips

CRM Tables
Find The Table Names For a CRM Transaction

SAP CRM Books
SAP Customer Relationship Management Certification, Interview Questions and Configuration Reference Books

SAP CRM Hints
SAP CRM - Customer Relationship Management Tips

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.