Registration

Dear SCN Member,
In order to fully benefit from what SCN has to offer, please register at:
http://scn.sap.com/login.jspa
Thank you,
The SCN team
We are improving!
The SCN wiki will not be available for new content submission starting September 11th 6PM CET until September 14th 6PM CET. Please plan your SCN wiki tasks accordingly.
Skip to end of metadata
Go to start of metadata

CRM Tables
These are some important tables in CRM :

- BUT000 : BP: General data - Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.
- BUT020 BP: Addresses
- BUT050 BP relationships/role definitions: General data - Contains Relationship, Partner Number (PARTNER1), Relationship Category
- 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_OPPORT_H OPPORTUNITY HEADER DATA
- 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
CRMD_ORDER_INDEX.
2. This table can be used for search based on the Object Id(Business Transaction No).
- CRMD_OPPORT_H OPPORTUNITY HEADER DATA
- 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

Along with these the other tables such as

ID Numbers                                                              But0ID
Industries                                                                But0IS
Contact Person Relationship                                   But051
Assignment BP - Address                                      But020
Assignment BP Relation Address                          But052
Address                                                                 ADRC
Address                                                                 ADRP
Sales Classification                                               CRMM_BUT_FRG0041
Sales Area - Partner Function                               CRMM_BUT_FRG0081
Map Business Partner Customer                           CRMM_BUT_CUSTNO
Mapping Table Business Partner
Relationship - Contact Person                                 CRMM_BUT_CONTNO
Segment Builder Profile Set                                     CRMD_MKTTG_SET_H
Profile                                                                       CRMD_MKTTG_PF_H
Filter                                                                         CRMD_MKTTG_PF_S

Filter Conditions                                                       CRMD_MKTTG_PF_SR
Target Group                                                           CRMD_MKTTG_TG_H

                                                                                CRMD_MKTTG_TG_I

Attribute List                                                            CRMD_MKTTG_SAL
Attribute                                                                   CRMD_MKTTG_SA
Attribute Filter                                                          CRMD_MKTTG_SAF
Data Source                                                             CRMD_MKTTG_SDS
Assignment AL / DS                                                 CRMD_MKTTG_SALDS

Status tables in CRM (Very useful)

 CRM_JEST, CRM_JCDS, CRM_JSTO, CRM_JCDO   table for the status of a business transaction.

  • No labels
  1. Guest

    The table should be CRMD_ORDER_INDEX not CRM_ORDER_INDEX.

    Please fix this ASAP as not to confuse other CRM developers.

  2. More SAP CRM Table

    Linked Tables:

    BUT000- Has general data (Person number)

    TSAD3T- Title

    BUT020 - BP: Addresses (Address number)

    BUT021- BP: Address usages (Address type)

    BUT021_FS- Time-Dependent Address Usage (Detailed Address Type)

    ADRC- Addresses (Business Address Services) Other details

    ADRP- Persons (Business Address Services)

    ADR2- Telephone Numbers (Business Address Services)

    ADR3- Fax Numbers (Business Address Services)

    ADR4- Teletex Numbers (Business Address Services)

    ADR5- Telex Numbers (Business Address Services)

    ADR6- E-Mail Addresses (Business Address Services)

    ADR10- Printer (Business Address Services)

    ADR12- FTP and URL (Business Address Services)