Recently I am preparing an internal middleware training session and I need to provide more detail about the Consolidated Database in architecture picture below.
Here below is copied from standard training course: “The Consolidated Database is a logical part of the entire CRM database, which also contains application data.
CRM Middleware server owns the consolidated database where CRM data is stored centrally. The consolidated database comprises the contents of all mobile clients’ local databases.”
A frequently asked question is: Can you give some example of CDB? For example if I would like to look for a CDB for product / material in CRM system, how can I find it without google?
Here below is how I teach. Since we don’t have any hint where to start, I suggest to always start from package. As rule of thumb all middleware framework package starts with SM, so package SMO3 is identified.
Then tcode SE80, use Repository Information System, specify SMO3 as package and filter by Table description:
Here below are just what I am looking for.
We can do simple verification. Suppose I have one material in ERP system QI3/502 and after it is downloaded to CRM, a product with id 1367 is generated.
Then in CRM, I can find a corresponding entry for this product in CDB table SMOMARA I found in previous step.
With the same approach we can also find some CDB table which only stores CRM specific data, for example product hierarchy or category which makes sense only in CRM:
Take SMOCATREL for example, it stores the assignment information of product categories of a given product.
Just specify the product guid into field SFAMARA and we can get three records in DB, which represent the three assigned product categories for this product:
This information exactly matches the fact in transaction code COMMPR01: