CRM TABLES

[Former Member]

Hi All,

I am in Sap Tech side and i want to know some information regarding the CRM.

Can anyone tell from where i can find the list of tables use in CRM ?

and how these tables are linked with SAP R/3

Thanks

Namrata

[Former Member]

Hi,

thanks for proving CRM tables.Actually i want CRM guide,which is usefull for beggner.and i found some document in sdn,but didnt get any good materials in word format or pdf format.if u have any good materials in CRM then plz send me to my mail id pankaj.sinhas@gmail.com.

Thanks and Regards

Pankaj Sinha.

Satyam Development Center,bangalore.

[Former Member]

Some other very usefull tables:

R/3 Tables re CRM:

CRMRFCPAR : CRM Destination

CRMPRLS: GUID entry

CRMCONSUM: COnsumer entry (must match consumer of object in R3AC*)

KNA1 : Business Partner Master Data.

CRMPARNR : Partner Functions \ Contacts

CRMKUNNR : Business Partner GUIDS

KNVV: Sales Area Data

KNVP: Sales Area Data

KNVK: Contact Person

TBE31 & 34 : Events

MARA : Products

CRMFILTAB : Filters

CRMBP_MAP_BUGRP Mapping of Business Partner Grouping

CRMCLASSIF Account Groups in Replication into R/3

CRMCONSUM Possible Users R/3 Adapter Functionality

CRMFILFLD Permitted Table Fields for Filtering

CRMFILTAB Filter Criteria for Download

CRMINTBAP Assignment of Internal& External Table FLD

CRMKTOKD Assign Classification and Grouping R/3 Account Groups

CRMKUNNR Mapping Table Business Partner - Customer

CRMMAPTAB Relationship Between Table Names in CRMOBJTAB and BAPIMTCS

CRMPARNR Mapping Table Business Partner Relationship - Contact Person

CRMPAROLTP CRM OLTP Parameter

CRMQNAMES Queue Name Management for CRM-QRFC Supply

CRMSUBTAB Subscription Table for Up and Download Objects

COM_BUPA_CALL_FU Determining FMs for Data Exchange BP

COM_BUPA_BCSET Central Settings Data Exchange Business Partner

TCRMBP_REFCUST Default Reference Customer

CRM Tables:

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

Hope this info helps....

[Former Member]

Dear community,

if someone has this list of CRM Table - this holy grail of information - would you be so kind to send it to me as well: a.bohlmann@erco.com

Thank you in advance to deliver us from ignorance.

Best regards

Andreas

[Former Member]

hi

wel some of the common tables in crm are

crmd_orderadm_h for storing orders

but000 for storing business partner

adr6 for storing emails

check sapgenie.com

u may find something useful

[Former Member]

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

[Former Member]

Hi

Thanks a lot .It is really very helpful

Namrata