CRM Tables

[Former Member]

Hi Experts,

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.

Thanks,

Abhishek

[Former Member · Accepted solution]

Hi,

These are the table used in CRM

Table Name Description

Business Partner

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

Account Number

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

code.

Regards

Gaurav

[Former Member · Accepted solution]

Hi,

Thanks for giving out all the table names in CRM. These will prove quite useful to me.

However I didnt find the table used for Trade Promotions. I need the table name in which the header data of trade promotion is saved after creation.

Thanks,

Abhishek

[Former Member · Accepted solution]

Hi,

Trade promotion is basically related to marketing.U can reffer marketing tables and find which is sutable for ur requirement.Bellow are some marketing tables.

CRMD_MKTTG_DL_AB -- CRM Marketing: Header Table - Business Rules

CRMD_MKTTG_DL_AH -- CRM Marketing: Header Table of Delivered Attributes.

U can search with CRMD_MKTTG * for marketing related tables.

Regards

Gaurav

[CarstenKasper]

Hi,

there exists TX SD11 with which you can have a look at the datamodel.

Search this forum to find additional information on it.

cheers Carsten