Transferring Customizing Data to the
Consolidated Database (CDB)
Use
The CDB Customizing tables must be initially filled from the related CRM Enterprise tables.
To do so, call the program SMOF_DOWNLOAD from the SAP menu by choosing Architecture and Technology ® Middleware ® Data Exchange ® Initial Load ® Start.
Start with the following objects:
CRM Enterprise Table |
CDB Table |
Object |
SAP ECC Table |
/SAPCND/T681 |
CDBC_C_T681 |
CRM_CND_CNDTAB |
T681 |
/SAPCND/T68E |
CDBC_C_T681E |
CRM_CND_CNDTAB |
TMC1, TMC1K, TMC1D |
/SAPCND/T681T |
CDBC_C_T681T |
CRM_CND_CNDTAB |
T681T |
/SAPCND/T681A |
CDBC_C_T681A |
CRM_CND_APPLIC |
|
/SAPCND/T681AT |
CDBC_C_T681AT |
CRM_CND_APPLIC |
|
/SAPCND/T681V |
CDBC_C_T681V |
CRM_CND_USAGE |
|
/SAPCND/T681Z |
CDBC_C_T681Z |
CRM_CND_USAGE |
|
/SAPCND/T681M |
Not required |
|
MNTCNT |
/SAPCND/T682 |
CDBC_C_T682 |
CRM_CND_ACCSEQ |
T682 |
/SAPCND/T682I |
CDBC_C_T682I |
CRM_CND_ACCSEQ |
T682I |
/SAPCND/T682T |
CDBC_C_T682T |
CRM_CND_ACCSEQ |
T682T |
/SAPCND/T682Z |
CDBC_C_T682Z |
CRM_CND_ACCSEQ |
T682Z |
/SAPCND/T682V |
Not required |
|
T682V |
/SAPCND/T686E |
Not required |
|
T686E |
/SAPCND/T686F |
Not required |
|
T686F |
/SAPCND/T685 |
CDBC_C_T685 |
CRM_CND_CNDTYP |
T685 |
/SAPCND/T685T |
CDBC_C_T685T |
CRM_CND_CNDTYP |
T685T |
PRCC_COND_CT |
CDBC_P_CN_CT |
CRM_PRC_CNDTYP |
T685A |
PRCC_COND_PPD |
CDBC_P_CN_PPD |
CRM_PRC_PROC |
T683 |
PRCC_COND_PPDT |
CDBC_P_CN_PPDT |
CRM_PRC_PROC |
T683U |
PRCC_COND_PP |
CDBC_P_CN_PP |
CRM_PRC_PROC |
T683S |
PRCC_COND_PPT |
CDBC_P_CN_PPT |
CRM_PRC_PROC |
T683T |
FGDC_COND_PD |
CDBC_FG_CN_PD |
CRM_FGD_PROC |
T683 |
FGDC_COND_PDT |
CDBC_FG_CN_PDT |
CRM_FGD_PROC |
T683U |
FGDC_COND_P |
CDBC_FG_CN_P |
CRM_FGD_PROC |
T683S |
PRCC_EXCL_GROUPS |
CDBC_P_EX_GRP |
CRM_PRC_EXCGRP |
T684 |
PRCC_EXCL_COND |
CDBC_P_EX_COND |
CRM_PRC_EXCGRP |
T684G |
PRCC_EXCL_PROC |
CDBC_P_EX_PROC |
CRM_PRC_EXCGRP |
T684S |
PRCC_EXCL_GRP_T |
CDBC_P_EX_GRP_T |
CRM_PRC_EXCGRP |
T684T |
PRCC_COND_LIMITS |
CDBC_P_CN_LIMITS |
CRM_PRC_CNDLMT |
T685Z |
/SAPCND/T681F |
CDBC_C_T681F |
CRM_CND_FCAT |
|
/SAPCND/T681FA |
CDBC_C_T681FA |
CRM_CND_FCAT |
|
/SAPCND/T681FD |
CDBC_C_T681FD |
CRM_CND_FCAT |
|
/SAPCND/T681FF |
CDBC_C_T681FF |
CRM_CND_FCAT |
|
/SAPCND/T681FR |
CDBC_C_T681FR |
CRM_CND_FCAT |
|
/SAPCND/T681FV |
CDBC_C_T681FV |
CRM_CND_FCAT |
|
/SAPCND/CONFIG |
CDBC_C_CONFIG |
CRM_CND_CONFIG |
|
/SAPCND/CONFIGCC |
CDBC_C_CONFIGCC |
CRM_CND_CONFIGC |
|
/SAPCND/GROUP |
CDBC_C_GROUP |
CRM_CND_GROUP |
|
/SAPCND/GROUP_I |
CDBC_GROUP_I |
CRM_CND_GROUP |
|
/SAPCND/GROUPT |
CDBC_GROUPT |
CRM_CND_GROUP |
|
PRCC_COND_DEST |
CDBC_P_CN_DEST |
CRM_PRC_DEST |
|
PRCC_COPY_TYPE |
CDBC_COPY_TYPE |
PRC_CUST_CPYTYP |
|
PRCC_COPY_TYPE_T |
CDBC_P_COPYTYPET |
PRC_CUST_CPYTYP |
|
DD01L |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
DD01T |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
DD03L |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
DD04L |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
DD04T |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
DD07L |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
DD07T |
CDBC_C_DD01L |
CRM_CUST_CNDDIC |
|
Even in the case of cross-client data, replication to the CDB must be triggered in each active client, as the data stored on the CDB is generally saved client-specifically. The metadata is cross-client from the following: condition tables (/SAPCND/T681, /SAPCND/T681E, /SAPCND/T681T), access sequences (/SAPCND/T682, /SAPCND/T682I, /SAPCND/T682T, /SAPCND/T682Z), field catalogs (/SAPCND/T681F, /SAPCND/T681FA, /SAPCND/T681FD, /SAPCND/T681FR, /SAPCND/T681FV), applications (/SAPCND/T681A, /SAPCND/T681AT), usages (/SAPCND/T681V, /SAPCND/T681VT), and tasks (/SAPCND/T681Z).
There is no automatic delta download to the CDB from the CRM Enterprise database for Customizing.