SAP CRM Tables List
SAP CRM Tables List
SAP CRM is the CRM tool provided by SAP and is used for many a business process,SAP CRM is a part of SAP business suite. It can implement customized business processes, integrate to other SAP and non-SAP systems, help achieve CRM strategies.SAP CRM can help an organization to stay connected to customers. This way organization can achieve customer expectations with the types of services and products .
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)
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
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
BUT0BK Business Partner: Bank Data & Details BP Number, Bank Key, Bank Country Key, Bank Account Number
TSAD3T Table containing the Title text against a Title No.
COMM_PRODUCT Master Table for Product
CRMM_BUAG Master table for Business Agreement
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.
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:
It doesn't store the Business Partner responsible for the transaction. To get the Partner No, link it with
CRMD_ORDER_INDEX.
This table can be used for search based on the Object Id(Business Transaction No).
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
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.
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
Assignment BP - Address But020
Assignment BP Relation Address But052
Address ADRC
Address ADRP
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.
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)
CRMV_LINKORGMAN: Link with Organizational Management at Header Level
SD11: data modeler
BUT050- BP relationships/role definitions: General data
BUT050_CD- BP Rel./Role Determination:Index Table for Change Doc.Access
BUT051- BP Relationship: Contact Person Relationship
BUT052- BP Relationship: Addresses
BUT053- BP Relationship: Company Interest
BUT0BANK Business Partner: Bank Data
BUT0BK BP: Bank details
BUT0CC BP: Payment Cards
BUT0ID BP: ID Numbers
BUT0ID_BIP_NOHIT Business Information Provider: Logging of non identified BP
BUT0IS BP: Industries
BUT0VP BP: Business Partner Assignment and Links
BUT100 BP: Roles
BUT150 BP relationship: Attribute table (test different.type TBUKR)
CRMM_BUT_BUHI_1 R/3 Customer Sales Area CRM BP Hierarchy Group Mapping
CRMM_BUT_BUHI_2 R/3 Leaf Customer Sales Area CRM BP Hierarchy Group Mapping
CRMM_BUT_CONTNO Mapping Table Business Partner Relationship – Contact Person
CRMM_BUT_CRMOBJ Buffer: Which BPs are in Which Systems
CRMM_BUT_CUSTNO Mapping Table Business Partner – Customer
CRMM_BUT_FRG0040 Business Partner Sales Classification List
CRMM_BUT_FRG0041 Business Partner Sales Classification
CRMM_BUT_FRG0042 Business Partner Sales Classification List Order Blocks
CRMM_BUT_FRG0050 Business Partner – Status
CRMM_BUT_FRG0060 Business Partner – Business Hours
CRMM_BUT_FRG0061 Business Partner – Business Hours Interval
CRMM_BUT_FRG0070 Business Partner Excluded Partner Functions List
CRMM_BUT_FRG0071 Business Partner Excluded Partner Functions
CRMM_BUT_FRG0080 Business Partner – Sales Area – Partner Function List
CRMM_BUT_FRG0081 Business Partner – Sales Area – Partner Function
CRMM_BUT_FRG0100 CRM Business Partner: Status
CRMM_BUT_SET0010 Business Partner – Sales Rule Period
CRMM_BUT_SET0020 Business Partner – Shipping Rule Period
CRMM_BUT_SET0030 Business Partner – Billing Rule Period
CRMM_BUT_SET0140 Business Partner Organization Rule Period
CRMM_BUT_TDAR010 Business Partner – Time-Dependent Appointment Rules
CRMM_BUT_TDAR011 Business Partner – Time-Dependent Appointment Rule Intervals
CRMM_BUT_TDAR012 Business Partner – Time-Dependent Appt Rule Single Intervals
BUT_DNC BP: Telephone Numbers of the “Do Not Call” List
BUT_DNC_OLD BP: Telephone Numbers of the “Do Not Call” List
BUT_FRG0010 Business Partner: Tax Classification
BUT_FRG0011 Business Partner: Tax Classification
BUT_HIER_NODE Business Partner Hierarchy Group
BUT_HIER_NODE_BP Business Partner Hierarchy Group – Bus. Partner Assignment
BUT_HIER_NODE_D Business Partner Hierarchy Group – Description
BUT_HIER_STRUCT Business Partner Hierarchy Group – Hierarchy Relationship
BUT_HIER_TREE Business Partner Group Hierarchy
BUT_HIER_TREE_D Business Partner Group Hierarchy – Description
BUT_HIER_TYPE Business Partner Group Hierarchy Category (GUID)
CRMD_ACTIVITY_H Activity Header table
CRMD_ACTIVITY_I Activity Reporting: Activity Line Item Extension
CRMD_TM_ACTIVITY Activity reference
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
COMM_PR_FRG_ROD: Product Sales Set - Product – Assignment
CRMV_PR_SALESA: Product - Sales Order Set
CRMM_TERRITORY_V: Territory validity date
CRMD_ORGMAN: Organizational Unit Data Set
COMM_IL_SERVI: Master Data of Relationship Type Services
CRMD_SCHEDLIN: Business Transaction Item - Schedule Line
CRMD_PRODUCT_I: Transaction Item - Product
CRMD_TERR_LINK: Mapping between the Rule and Territory
CRMD_PARTNER: Partner Header table
CRMC_WST_DESIGN: Open Services Tool: Design
CRMC_WST_DOBJ: Open Services Tool: Design Object list
CRMD_PRICING_I: Transaction Item Price
CRM_JEST(combined with CRM_JSTO): status value table for all business objects which are using
CRMD_MKTTG_TG_H: CRM Marketing: Target Group Header Data
CRMD_ORDER_INDEX: Index table for one-order document
CRMD_ORDERADM_H = Document Header Table
CRMD_ORDERADM_I = Document Line item Table
CRMC_PROC_CATTYP: Defines process type to category type
CRMV_LINKPARTNER: For Easy Access to the Partner Set, maintain the relationship between one order instance and its partner set
TOJTB: BOR header table
CRMD_LEAD_H Lead Header table
COMM_IL_PRDCPN: Master Data of Relationship Type Customers
CRMD_OPPORT_H Opportunity Header table
CRMC_T077D : customer account groups
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
Common tables used by CRM applications
SOTR_HEAD: Header Table for OTR Texts
SOTR_TEXT: Text Table in the OTR
BSPWD_ADH_DSBL(BSPWD_ADH_DSBLC): Delta Handling disablement config for individual
Design layer and UI component repository related table
BSP_DLC_SDESIGNT: Design layer: Field labels for Design
BSP_DLC_SDOBJ: Design object header table
BSP_DLC_SDASSIGN: Design layer: Assignment of design object to UI
BSP_V_DLC_STXT: View to access standard configuration texts
BSPC_DL_XMLSTRX2: Storagetable for XML layout descriptions
BSP_DL_XMLST_PR: Processed Standdard Configuration (switch related handling)
BSP_DL_XMLSTRX2: Storagetable for delivered XML layout descriptions
BSPC_DL_STXTREP2: Repository for custom texts
BSP_V_DLC_STXT: View to access standard configuration texts
BSPC_DL_PERSSTOR: Storagetable for XML personalized layout descriptions
CRMD_LINK: Transaction - Set - Link. Relationship between GUID of a CRM Order Object and
CRMD_SALES: Business Transaction - Sales Set
CRM_MKTPL_ATTR: CRM Marketing Planner: Marketing plan/campaign attributes
CRMV_LINKORGMAN: Link with Organizational Management at Header Level
CRMC_SVH_ENTRIES: Smart Value Help - Last five entries
CRMC_WST_SRV_OBJ: Open Services Tool: Service Object
Enterprise Search related table
WCFD_ES_CPOINTER: Delta pointer handling: Map BOL root object to template
CRMV_ES_TMPLHDR: Enterprise search Template header view
Business object repository related table
CRMM_BUT_KOR0040 Business Partner Korea
CRMM_BUT_KOR0041 Business Partner Korea History
CRMM_BUT_LNK0010 Business Partner – Sales Rule List
CRMM_BUT_LNK0011 Business Partner – Sales Rule
CRMM_BUT_LNK0020 Business Partner – Shipping Rule List
CRMM_BUT_LNK0021 Business Partner – Shipping Rule
CRMM_BUT_LNK0030 Business Partner – Billing Rule List
CRMM_BUT_LNK0031 Business Partner – Billing Rule
CRMM_BUT_LNK0140 Business Partner Organization Rule List
CRMM_BUT_LNK0141 Business Partner Organization Rule
CRMM_BUT_MIGRATE Migration Table: Fields Changed In CDB
CRMM_BUT_SEMPL00 Sales Employee for Contact Person Relationship: Admin. Tech.
CRMM_BUT_SEMPL01 Sales Employee to Contact Person Rel.: Data Table
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
SAP CRM Tables,CRM Tables,CRM Module Tables,CRM Tables List,Tables,SAP CRM Table.
Great post. Thanks for sharing. If you’re in the business of selling anything, chances are you’ll need a customer relationship management (CRM) solution.
ReplyDelete