Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Important CRM Tables:
Below is the list of CRM tables which are widely used in CRM Development. 

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
CRM_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

Activities:
CRMD_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item Extension
CRMD_TM_ACTIVITY Activity reference

Lead:
CRMD_LEAD_H Lead Header table

Opportunity:
CRMD_OPPORT_H Opportunity Header table

please find the Marketing planner tables
CRM_MKTPL_ATTR
CRM_MKTPL_LOGTAB
CRM_MKTPL_OGRPT
CRM_MKTPL_OGRPT
CRM_MKTPL_PLGBWQ
CRM_MKTPL_R3MAP
CRMC_IM_ADRESS
CRMC_IM_ADRESS_T
CRMC_IM_ATTR_SET
CRMC_IM_FIELDS
CRMC_IM_PRINT_T
CRMC_IM_PRINTER
CRMC_IM_SCEN
Regards,Sujeet

  • No labels