Find The Table Names For a CRM Transaction

These are some important tables in CRM :

- 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                              *-- Pankaj

Generic SAP

Interview Question on CRM
SAP-CRM Interview Questions

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

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.