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?

/wp-content/uploads/2016/05/clipboard1_952518.png

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.

/wp-content/uploads/2016/05/clipboard2_952519.png

Then tcode SE80, use Repository Information System, specify SMO3 as package and filter by Table description:

/wp-content/uploads/2016/05/clipboard3_952520.png

Here below are just what I am looking for.

/wp-content/uploads/2016/05/clipboard4_952521.png

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.



/wp-content/uploads/2016/05/clipboard5_952522.png

Then in CRM, I can find a corresponding entry for this product in CDB table SMOMARA I found in previous step.

/wp-content/uploads/2016/05/clipboard6_952523.png

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:

/wp-content/uploads/2016/05/clipboard7_952524.png

Take SMOCATREL for example, it stores the assignment information of product categories of a given product.

/wp-content/uploads/2016/05/clipboard8_952525.png

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:

/wp-content/uploads/2016/05/clipboard12_952507.png

This information exactly matches the fact in transaction code COMMPR01:

/wp-content/uploads/2016/05/clipboard13_952517.png

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply