This discussion is locked
8 Replies Latest reply: Jun 30, 2014 12:33 PM by Devi b RSS

SAP-CRM Tables

Sridhar P
Currently Being Moderated

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

  • Re: SAP-CRM Tables
    Arjun Pawar
    Currently Being Moderated

    Sent to ur email Id.

     

    Please, allot points,

     

    Regards,

    Arjun

  • Re: SAP-CRM Tables
    roopesh misra
    Currently Being Moderated

    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

  • Re: SAP-CRM Tables
    Manuel Rodriguez
    Currently Being Moderated

    Hi Sridhar,

     

    Look at CRM knowledge for a technical person? maybe it helps you.

     

    Regards.

    Manuel

  • Re: SAP-CRM Tables
    Pratik Patel
    Currently Being Moderated

    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>

  • Re: SAP-CRM Tables
    satish kumar
    Currently Being Moderated

    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

  • Re: SAP-CRM Tables
    Javesh Gaju
    Currently Being Moderated

    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

Actions