Keys in CRM Table/OLTP R/3 Table and CDB/ Table Correspondance – CDB -> OLTP-> R3

OLTP R/3 Table and CDB

 

 R/3 tables in the CRM Middleware are prefixed with SMO.

  Some important development classes are:

  SMOF (R/3 Adapter service)

  SMOG (CRM Middleware Repository services)

  SMOH (Replication & Realignment service) 

Keys in CRM Table

 

GUIDS((Globally Unique Identifiers) serve as primary keys for all tables in the CDB. A GUID is generated by a special algorithm using as input data certain hardware information of the host computer, the current system time, and a randomly generated number. The GUID can be represented in various formats; for CRM a 32-byte character sequence is used. It is globally unique in the sense that two GUIDs produced on any two computers (or even on the same one) at any time can never be the same.

  Primary keys of all tables are called SFA<table name without the SMO prefix>, such as SFAKNA1, SFAMARA. 

Table Correspondance – CDB -> OLTP-> R3

 

 The main customer table on the OLTP R/3 system is the KNA1 table with the customer number (KUNNR) as the key field. The corresponding CDB table is the SMOKNA1 with the GUID (SFAKNA1) as the key. The field KUNNR is an ordinary table field. The main table for customers in CRM online is the BUTØØØ table with the key field PARTNER. The R/3 customer number is kept in the field CUSTOMER_NO in the table CRMM_BUT_CUSTNO. The link between this table BUTØØØ can be established via the field PARTNER_GUID.

  More information about the correspondence between the CRM online tables, the CDB tables and the OLTP R/3 tables can be found in the R/3 Adapter guide (via service.sap.com, alias instguides).