Skip to Content

I have summarized some useful tables which is used often for SAP CRM middleware, including middleware general parameter related tables, adapter object related tables, filter related tables, queue name related tables, Bdoc flow and Bdoc message related tables, load status tables and RFC related tables etc.

 

Useful tables for CRM Middleware

 

Middleware general parameter related tables:

 

Table name System Description
SMOFPARSFA CRM General middleware parameters
SMOF_ERPSH CRM ERP-Site Header table
CRMPAROLTP ERP CRM OLTP Parameters
CRMCONSUM ERP CRM consumer
CRMRFCPAR ERP Definitions for RFC Connections

 

Adapter Object related tables:

 

Table name System Description
SMOFTABLES CRM Finding the Adapter Object Involved
SMOFOBJECT CRM Download Objects
SMOFINICON CRM Flow Contexts in Initial Download depending on Site Types
CRMOBJECT ERP Download Objects
CRMSUBTAB ERP Generic Extractor for Objects
CRMATAB ERP Tables Permitted for Customizing Download
CRMOBJTAB ERP Tables Belonging to One Object
CRMMAPTAB ERP Relationship Between Table Names in CRMOBJTAB and BAPIMTCS
CRMINTBAP ERP Assignment of Internal and External Table Fields

 

 

Filter related tables:

 

Table name System Description
SMOFFILFLD CRM The predefined fields for filter
SMOFFILTAB CRM Filter settings
CRMFILTAB ERP Filter settings

 

 

Queue Name tables:

 

Table name System Description
SMOFQFIND CRM Queue Name setting
CRMQNAMES ERP Queue Name setting

 

 

Bdoc Type Flow related tables:

 

Table name System Description
SMW3BDOCIF CRM BDoc Type Specific Flow Attributes (Validation service)
SMW3FDSTD CRM Flow: Standard Configuration
SMW3FDBDOC CRM BDoc Type Specific Flow
SMW3FDCUST CRM Customer-Specific Flow

 

 

Bdoc message related tables:

 

Table name System Description
SMW3_BDOC CRM BDoc Message Store: Header
SMW3_BDOC1 CRM BDoc Message Store: Message Body (classic  part)
SMW3_BDOC2 CRM BDoc Message Store: Message Body (extension part)
SMW3_BDOC4 CRM BDoc: Validation Errors
SMW3_BDOC5 CRM BDoc: Receivers with state
SMW3_BDOC6 CRM BDoc: Receiver specific error segments
SMW3_BDOC7 CRM BDoc: Receiver Root IDs
SMW3_BDOCQ CRM qRFC Queues in use by BDoc Message
TSMW3_STAT CRM Attributes of Bdoc Processing States

 

Load status related tables:

 

Table name System Description
SMOFDSTAT CRM Initial load monitoring – Current Download Status of Objects
SMOFRSTAT CRM Request load monitoring – Current Download Status of Objects
SDIMASTAT CRM Dima load monitoring – Current Download Status of Objects

 

 

RFC related tables:

 

Table name System Description
ARFCSSTATE CRM,ERP Description of ARFC Call Status (Send)
ARFCSDATA CRM,ERP ARFC Call Data (Callers)
TRFCQSTATE CRM,ERP Description of qRFC Call Conditions (Inbound Queue)
TRFCQDATA CRM,ERP qRFC Call Data (Inbound Queue)
TRFCQOUT CRM,ERP tRFC Queue Description (Outbound Queue)
TRFCQIN CRM,ERP tRFC Queue Description (Inbound Queue)

DIMA related tables:

 

Table name System Description
SDIMABASIC CRM Basic Information for DIMA
SDIMAHEAD CRM Header Data of Dima
SDIMASTAT CRM Dima load monitoring – Current Download Status of Objects
SDIMAMESS CRM Messages for DIMA
SDIMADET CRM DIMA Filter conditions
SDIMAFILT CRM Allowed Filters for DIMA

 

Logical system during exchange:

 

 

Table name System Description
CRMPRLS ERP ERP Logical System for Download
CRMMLSGUID CRM ERP Logical System (should has same value as ERP CRMPRLS)
TBDLS(T) ERP, CRM Logical system defination

 

I will try to add more in the future.

Hope this helps.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply