List Of Frequently Used CRM Tables List

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

BUT000 : BP: General data - Contains Business Partner Number, PartnerCategory, Partner Type, First Name, Last Name etc. 
BUT020 : BP: Addresses 
BUT050 : BP relationships/role definitions: General data - ContainsRelationship, Partner Number (PARTNER1), Relationship Category 
BUT051 : BP Relationship: Contact Person Relationship Similar to 
BUT052 : Additionally contains Contact Person's Address data 
BUT0BK : Business Partner: Bank Data & Details BP Number, BankKey, 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 AddressDetails- 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 tablecorrespond 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(BusinessTransaction No). 
• CRMD_OPPORT_H OPPORTUNITY HEADER DATA 
• CRMD_CUSTOMER_H Additional Site Details at the Header Level of aBusiness 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