crm

[Former Member]

what are the important tables in SAP CRM?

Thanks,

Prasu

[Former Member]

Hi

Can someone mail me CRM data tables and their relationship info.

My email : s_batish@hotmail.com

Thx

Seema

[Former Member]

Hi this is navin

can someone plz send me the tables u have encountered in CRM till now

can u post the tables n their relationship info to

nkdisdon@gmail.com

thanku in advance

bye

[Former Member]

Hi Rani,

Please allot points.

Thanks & Regards,

Satish.

[Former Member]

Hi,

Just mailed all CRM tables which I have experienced in last 4years.

Regards,

Paul Kondaveeti

[Former Member]

Hi Rani,

These are some imp tables.alloting points will be appriciated.

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

Warm Regards,

Satish.

[Former Member]

can anyone email me the important tables in SAP CRM to

prasanna_ny@hotmail.com.

Thanks,

Prasu

[Former Member]

Hello Prasanna,

I have send you document for important tables in SAP CRM .

assign points if found helpful.

Thanks & Regards

Aashish Garg

[Former Member]

Hi Ashish,

Can u send me the info on crm tables to egoutham@yahoo.com

thanks

GE

[Former Member]

Hi Ashish,

Could u please send me the tables please.

If any documents on CRM Middleware on CRM5.0