Downtime Announcement: Please note the SAP Community Wiki will be unavailable due to a system upgrade on Thursday, September 24th between 6 and 7 AM CEST
Skip to end of metadata
Go to start of metadata

 Many new SAP CRM Tables

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)

CRMV_LINKORGMAN: Link with Organizational Management at Header Level

T-code:

SD11: data modeler

Business partner relationship:

A business partner relationship forms a business-relevant connection between two business partners.

SAP Implementation Guide Cross-Application Components ___ SAP Business{_}

Partner _ Business Partner _ Basic Settings _ Properties of business partner relationship

To show that two business partners have a particular relationship to one another, we assign them a relationship category. Eg is contact person of etc.

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

 

Few more tables:

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

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

CRMD_PRICING_I: Transaction Item Price

CRM_JEST(combined with CRM_JSTO): status value table for all business objects which are using status management

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

CRMD_LINK: Transaction - Set - Link. Relationship between GUID of a CRM Order Object and object type

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

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

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

TOJTB: BOR header table

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 views

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

 

  • No labels

1 Comment

  1. CRMV_PROD_SALESA- CRM Product ID & Sales area info