SAP CRM Tables

Master Data Tables

Business Partner
BUT000	BP: General dataContains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.
BUT020	BP: Addresses
BUT050	BP relationships/role definitions: General dataContains Relationship, Partner Number (PARTNER1), Relationship Category
BUT051	BP Relationship: Contact Person RelationshipSimilar to BUT050 , additionally contains Contact Person’s Address data
BUT0BK	Business Partner: Bank Data & DetailsBP 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. Note: Pass the langu key with the language in which you want the text.
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 – 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 implementation. You can give the table SAP0090 – this is a standard table. – in general all condition tables have the naming convention CNCC*)
CRMD_ORDERADM_H	Contains the Header Information for a Business Transaction. Note: It doesn’t store the Business Partner responsible for the transaction. To get the Partner No, link it with CRM_ORDER_INDEX. 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. Note: Pass the langu key with the language in which you want the 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

Table Name	Description
CRMD_LINK	Transaction GUID set for all the Business Transactions
CRMD_ORDER_INDEX	Contains Header as well as Item details for a Business Transaction. Note: 1.It doesn’t store the Business Transaction No (Object ID). To get the Business Transaction No link the table with CRMD_ORDERADM_H 2.   This table can be used for search based on the Partner No
CRMD_ORDERADM_I	Stores the Item information for a Business Transaction. The scenarios where we have a Contract Header and within contract we have Line Items for the contract, this table can be useful.E.g. Service Contracts
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 code.

Table Enhancements

Table Name	Description
BUT000	Fields such as Registration No, SIC Code, Cost to Serve etc. that appear in the additional details tab in BP transaction
CRMM_BUAG_H	Fields such as Acc in Legacy, Invoice Output, Clearing Category, Bill Form, Lock Process Type etc. that appear in the Business Agreement tab in BP transaction
CRMD_CUSTOMER_H	This table is used as an extension of the service contract header i.e. if there is a requirement to add new fields to CRMD_ORDERADM_H then; this table has to be used to add the fields.
CRMD_CUSTOMER_I	This table is used as an extension of the service contract header i.e. if there is a requirement to add new fields to CRMD_ORDERADM_I then; this table has to be used to add the fields. For e.g. fields required for additional site details tab at item level of Service Contract are added to this table.

CRM Table Associations

Tags: SAP, SAP CRM 2007 Tables, SAP CRM 7.0 Tables, SAP Tables