3 Replies Latest reply: Jun 18, 2008 5:05 AM by upendra patro RSS

how to find crm tables and objects in service market place?

sap crm
Currently Being Moderated



there is a place or link in www.service.sap.com where we get the information about the objects/tables related to  business partners,products,sales,service and marketing.


can anyone please provide me that link,information.




  • Re: CRM tables and objects in service market place
    Currently Being Moderated

    Hello Hun,


    Check out this link,

    Links to CRM Documentation

    May be that was the thread u were searching for...


    Also some of the tables in my knowledge are as follows,

    1. COMM_PRODUCT: Product header and administration data.

    2. CRMC_T077D: customer account groups

    3. CRMD_ORDERADM_I (Item data)

    CRMD_ORDERADM_H: Business Transactions header CRM

    4.CRMD_ACTIVITY_H: Activity

    5.CRMD_OPPORT_H :Opportunity

    6.BUTOO : Customer details

    7.BUT001:BP General data II

    8.BUT100: BP Roles

    9.BUT150: BP relationship: Attribute table (test different

    10.BUT_HIER_TREE Business Partner Group Hierarchy

    11.CDBC_T_PRODUCTID Mapping: Product Id

    12.CDBD_ORGMAN Business transaction - organizational unit - set

    13.COMC_PRODUCT General Product Settings

    14.COMC_R3_FIELDS Assignment of R/3 material master fields to CFOP

    15.COMM_CATEGORY Category

    16.COMM_CFGMAT Basic Data for Materials

    17.COMM_HIERARCHY Category Hierarchy

    18.COMP_TYPES Hierarchy Tool: Comparison Type Check Table

    19.CRMC_CPRICPROC Customer Pricing Procedures

    20.SMOKVBEZ15 Assignment employees to positions


    R/3 Tables re CRM:


    1. CRMRFCPAR: CRM Destination.

    2. CRMPRLS: Name of the Logical System for Download(GUID).

    3. CRMCONSUM: Consumer entry (must match consumer of object in R3AC*).

    4. KNA1: Business Partner Master Data.

    5. CRMPARNR: Partner Functions \ Contacts

    6. CRMKUNNR: Business Partner GUIDS

    7. KNVV: Sales Area Data

    8. KNVP: Sales Area Data

    9. KNVK: Contact Person

    10. TBE31 & 34: Events/Enhancement

    11.MARA: Products

    12. CRMFILTAB: Filters

    13. CRMBP_MAP_BUGRP: Mapping of Business Partner Grouping

    14. CRMCLASSIF: Account Groups in Replication into R/3

    15. CRMCONSUM Possible Users R/3 Adapter Functionality

    16.CRMFILFLD Permitted Table Fields for Filtering

    17.CRMFILTAB Filter Criteria for Download

    18.CRMINTBAP Assignment of Internal& External Table FLD

    19.CRMKTOKD Assign Classification and Grouping R/3 Account Groups

    20.CRMKUNNR Mapping Table Business Partner - Customer

    21.CRMMAPTAB: Relationship Between Table Names in CRMOBJTAB (Tables Belonging to One Object) and BAPIMTCS is Middleware Transaction Container Structure

    22.CRMPARNR Mapping Table Business Partner Relationship - Contact Person

    23.CRMPAROLTP CRM OLTP Parameter

    24.CRMQNAMES Queue Name Management for CRM-QRFC Supply

    25.CRMSUBTAB Subscription Table for Up and Download Objects

    26.COM_BUPA_CALL_FU Determining FMs for Data Exchange BP

    27.COM_BUPA_BCSET Central Settings Data Exchange Business Partner

    28.TCRMBP_REFCUST Default Reference Customer



    CRM Tables:


    1.CRMMLSGUID: GUID entry (should match GUID in CRMPRLS) also its LOGSYS-change-LOG.

    2. CRMM_BUT_CUSTNO: Also GUID table (GUID here should match GUID in R/3 table CRMKUNNR)

    3.SMOFSUBTAB: Mapping & Parameters

    4.SMOFDSTAT: Download Monitor (R4AM1)

    5.SMOFFILTAB: Filters (Should match filters in R3AC1 & R/3 Table CRMFILTAB)


    6.SMOFOBJECT Definition of Objects for Download

    7.SMOFOBJPAR Parent Objects of an Object in Table

    8.SMOFPARSFA Middleware Parameter

    9.SMOFQFIND Queue Finder Table for MW-Queue finder

    10.SMOFTABLES Definition of Tables for Download.

    11. CRM_JEST: Individual Object Status

    12. CRMD_SHIPPING: Business Transaction - Shipping Set

    13. COMM_PRODUCT: Product

    14. CRMD_ORDERADM_H: Business Transaction

    15. COM_TA_R3_ID: R3 Identification

    16. SCAPPTSEG: Folder for Individual Appointments

    17. CRMD_PARTNER: Partners

    18. CRMD_CUSTOMER_H: Transaction - Customer Extension



    KindlyReward Graciously if found useful...:)




  • Order header to CRM product ralated tables-
    upendra patro
    Currently Being Moderated

    Order header to CRM product ralated tables-

    CRMD_ORDERADM_H - Take the object GUID

    CRMD_orderadm_i -put in object id next to (prod short text)

    CRMD_orderadm_i -Get 1st guid in the table

    crmd_product_i - Put the object guid and get some related data for product