Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Database tables in CRM

Former Member
0 Kudos

Hi Experts,

Can you please provide me the database tables in CRM where I can find Enrollment data, Cancellation data, Campaign data, Affiliate data etc?

Thanks

Naveen Rana

2 REPLIES 2

Kanagaraja_L
Active Contributor
0 Kudos

Hi Naveen,

Some CRM tables and Desc....

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_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_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

COMM_PRODUCT : Products

CRMC_T077D : customer account groups

CRMD_ORDERADM_H (for header) CRMD_ORDERADM_I (Item data)

CRMD_ORDERADM_H Business Transactions CRM

CRMD_ACTIVITY_H Activity

CRMD_OPPORT_H Opportunity

BUTOO : Customer details

BUT001 BP: General data II

BUT100 BP: Roles

BUT150 BP relationship: Attribute table (test

different

BUT_HIER_TREE Business Partner Group Hierarchy

CDBC_T_PRODUCTID Mapping: Product Id

CDBD_ORGMAN Business transaction - organizational unit -

set

COMC_PRODUCT General Product Settings

COMC_R3_FIELDS Assignment of R/3 material master fields to

CFOP

COMM_CATEGORY Category

COMM_CFGMAT Basic Data for Materials

COMM_HIERARCHY Category Hierarchy

COMP_TYPES Hierarchy Tool: Comparison Type Check

Table

CRMC_CPRICPROC Customer Pricing Procedures

SMOKVBEZ15 Assignment employees to positions

CRMMLSGUID: GUID entry (should match GUID in CRMPRLS)

CRMM_BUT_CUSTNO : Also GUID table (GUID here should match GUID in R/3 table CRMKUNNR)

SMOFSUBTAB : Mapping & Parameters

SMOFDSTAT : Download Monitor (R4AM1)

SMOFFILTAB : Filters (Should match filters in R3AC1 & R/3 Table CRMFILTAB)

SMOFOBJECT Definition of Objects for Download

SMOFOBJPAR Parent Objects of an Object in Table

SMOFPARSFA Middleware Parameter

SMOFQFIND Queue Finder Table for MW-Queue finder

SMOFTABLES Definition of Tables for Download

Kanagaraja L

Former Member
0 Kudos

Dear Naveen,

T Code: se11

put crm*..then search..you will get the list of all the tables..

put t*..then search...the list of tables related to configuration...

you can search by description also..

Thanks,

Atin