cancel
Showing results for 
Search instead for 
Did you mean: 

SAP-CRM Tables

Former Member
0 Kudos

Hi Friends,

I am a functional consultant these days i am in need of CRM Tables Information.

If anybody has got the list of impartant tables in CRM please mail me.

Thanks in advance,

Sridhar.P

e-Mail:

Moderation: email removed.

Message was edited by: Andrei Vishnevsky

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sridhar,

<b>

Following are the CRM Tables:</b>

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

Best Regards,

Pratik Patel

<b>Reward with Points!</b>

Answers (6)

Answers (6)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi friends,

I am techno functional anlyst and i have just joined the SAP capability. I am currently working on a CRM/IS-U project. I would really appreciate if someone coule give me more information about the main CRM tables and how they are ralted (Schema).

Thanks,

Javesh

Moderation: email removed.

Message was edited by: Andrei Vishnevsky

Former Member
0 Kudos

Hi Sridhar,

You can use these tables..

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

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

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

CRMD_ORDERADM_H - PROCESS_TYPE field will give the transaction type.

CRMC_PROC_TYPE – List of transaction types.

CRMV_LINKORGMAN – Find out the Sales orgn.

Please Award points if it is Useful to you.

Regards,

Satish

P000636
Active Contributor
0 Kudos

Hi Sridhar,

Look at maybe it helps you.

Regards.

Manuel

Former Member
0 Kudos

hi

there is some of the tables used for CRM

Sales order / Quote / Sched Agreement / Contract

VA02 Sales order change

VA05 List of sales orders

VA22 Quotation change

VA32 Scheduling agreement change

VA42 Contract change

Billing

VF02 Change billing document

VF11 Cancel Billing document

VF04 Billing due list

FBL5N Display Customer invoices by line

FBL1N Display Vendor invoices by line

Delivery

VL02N Change delivery document

VL04 Delivery due list

VKM5 List of deliveries

VL06G List of outbound deliveries for goods issue

VL06P List of outbound deliveries for picking

VL09 Cancel goods issue

VT02N Change shipment

VT70 Output for shipments

General

VKM3, VKM4 List of sales documents

VKM1 List of blocked SD documents

VD52 Material Determination

thanks

Roopesh

former_member182350
Active Contributor
0 Kudos

Sent to ur email Id.

Please, allot points,

Regards,

Arjun

Former Member
0 Kudos

hi,

can i get APO tables please?

regards

suneel.

Former Member
0 Kudos

Hi,

If you don't mind can you send me the CRM Tables list to this mail id

Thanks in advance

Moderation: email removed.

Message was edited by: Andrei Vishnevsky