Ads

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.



Comments

  1. 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

Post a Comment

Popular posts from this blog

BADI Interview Questions in SAP ABAP

Sample SAP ABAP Programming Examples for Practice

Module Pool Programming Interview Questions and Answers in SAP ABAP

Step by Step tutorial on BDC Session Method Program in SAP ABAP

SAP ABAP Interview Questions and Answers for 10 Years Experienced