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