- 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 withCRM_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
Along with these the other tables such as
ID Numbers But0IDIndustries But0ISContact Person Relationship But051Assignment BP - Address But020Assignment BP Relation Address But052Address ADRCAddress ADRPSales Classification CRMM_BUT_FRG0041Sales Area - Partner Function CRMM_BUT_FRG0081Map Business Partner Customer CRMM_BUT_CUSTNOMapping Table Business PartnerRelationship - Contact Person CRMM_BUT_CONTNOSegment Builder Profile Set CRMD_MKTTG_SET_HProfile CRMD_MKTTG_PF_HFilter CRMD_MKTTG_PF_S
Filter Conditions CRMD_MKTTG_PF_SRTarget Group CRMD_MKTTG_TG_H
CRMD_MKTTG_TG_I
Attribute List CRMD_MKTTG_SALAttribute CRMD_MKTTG_SAAttribute Filter CRMD_MKTTG_SAFData Source CRMD_MKTTG_SDSAssignment AL / DS CRMD_MKTTG_SALDS
Status tables in CRM (Very useful)
CRM_JEST, CRM_JCDS, CRM_JSTO, CRM_JCDO table for the status of a business transaction.
from : http://wiki.sdn.sap.com/wiki/display/CRM/CRM+Tables
