I need to know the SAP table where I can find the TPM details of WEB UI.
It would be great if someone can give me a document which contains the CRM 2007 tables.
Gaurave Mehta replied
These are the table used in CRM
Table Name Description
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
Personu2019s Address data
BUT0BK -- Business Partner: Bank Data & Details BP Number, Bank Key, Bank Country Key, Bank
BNKA -- Bank Master Data
BUT100 -- BP: Roles
ADR2 -- Telephone Numbers (Business Address Services)
ADR6 -- SMTP Numbers (Business Address Services) Contains Email u2013 Id of the BP.
ADRC -- Addresses (Business Address Services) BPu2019s 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 Contract
account table FKKVKP.
CRMM_BABR_H -- Rule data for business agreements u2013 data in this table correspond to ISU Contract
account table FKKVK Business Transaction(Service Contracts in Particular)
CNCCRMPRCUSZZBUR -- Condition Records for Service Contracts. We get Basic Unit Rate, Standing
Charge Rate etc. (This is a Z table used in a leading ISU SAP-CRM
mplementation. You can give the table SAP0090 u2013 this is a standard table. u2013 in
general all condition tables have the naming convention CNCC*)
CRMD_ORDERADM_H -- Contains the Header Information for a Business Transaction.
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
Transaction Data Tables
CRMD_LINK -- Transaction GUID set for all the Business Transactions
CRMD_ORDER_INDEX -- Contains Header as well as Item details for a Business Transaction.
CRMD_CUSTOMER_I -- Additional Site Details at the Item Level of a Service Contract
SCAPPTSEG -- Table for individual Appointment Types for a transaction.
CRM_JEST -- Individual Object Status for any business transaction.
CRM_JCDS -- Current Status for a business transaction along with set date, set time and status