CRM

[Former Member]

Please anyone give me all the tables related to CRM & MySAP CRM.

I also need all the FMs related to CRM.

Please urgent

[Former Member]

Hi,

<b>Some important tables in CRM :</b>

<b>BUT000</b> : BP: General data

Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

<b>BUT020</b> BP: Addresses

<b>BUT050</b> BP relationships/role definitions: General data

Contains Relationship, Partner Number (PARTNER1), Relationship Category

<b>BUT051</b> BP Relationship: Contact Person Relationship Similar to BUT050 , additionally contains Contact Person’s Address data

<b>BUT0BK</b> Business Partner: Bank Data & Details

BP Number, Bank Key, Bank Country Key, Bank Account Number

<b>BNKA</b> Bank Master Data

<b>BUT100</b> BP: Roles

<b>ADR2</b> Telephone Numbers (Business Address Services)

<b>ADR6</b> SMTP Numbers (Business Address Services)

Contains Email – Id of the BP.

<b>ADRC</b> Addresses (Business Address Services)

BP’s Complete Address Details- City, Country, Post Code, District, Street, Title No Etc

<b>TSAD3T</b> Table containing the Title text against a Title No.

<b>COMM_PRODUCT</b> Master Table for Product

<b>CRMM_BUAG</b> Master table for Business Agreement

<b>CRMM_BUAG_H</b> 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).

<b>CRMD_CUSTOMER_H</b> Additional Site Details at the Header Level of a Business Transaction

<b>CRMC_PROC_TYPE</b> Master table Business Transaction Type

<b>CRMC_PARTNER_FCT</b> Definition of Partner Functions

SCPRIOT Priorities for Activities with priority text.

<b>CRMC_PROC_TYPE_T</b> Text for a transaction type

<b>CRMC_ACT_OBJ_T</b> Objective Number and Text for Activities

<b>TJ30T</b> All the status code and text

<b>CRMC_PR_ASSIGN</b> : Transaction Type and its Transaction Type Object.

<b>IBIB</b> : Installed Base/Ibase

<b>IBIN</b> : Installed Base Components

<b>Also refer to below link:</b>

help.sap.com

<b>For CRM Function modules refer to below links:</b>

Check these Links out which lists all the FM's

http://www.geocities.com/victorav15/sapr3/abapfun.html

http://www.sapgenie.com/abap/functions.htm

http://members.tripod.com/abap4/SAP_Functions.html

http://abap4.tripod.com/SAP_Functions.html

http://www.sapdevelopment.co.uk/fmodules/fmssap.htm

http://planetsap.com/Useful_function_modules.htm

http://www.sapgenie.com/abap/functions.htm

<b>Reward the points if your Q has been answered and close the thread</b>

Regards,

Shakuntala