Skip to Content

Delta Replication of Material Master - SAP SRM One Client

Hello All

We are on SAP SRM One Client set up with SRM 7 EHP 3.

We are facing the below issue whenever we try to replicate new material groups into SRM:

When we run MDS_LOAD_COCKPIT for "MATGROUP" to "Product Category" replication, system seem to think that it is the initial load and tries to download all the material groups. It then hits the short dump DBSQL_DUPLICATE_KEY_ERROR in function module COM_CATEGORY_SAVE_DU because on line 21 it tries to insert already existing product categories.

In SRM other scenarios (other than one client), there is an option to replicate only the delta after the initial replication. However, in this case, we could not find any such option.

Also, a few SCN links we could find mention that the delta replication happens through "delta reports". But nowhere we could find those "delta reports".

It does not seem to happen synchronously as and when there is a new material group or changes to existing material groups.

Could you please let us know how can we set up "delta replication" of "material groups" from ECC to SRM in SRM One Client scenario?

Thank you


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 26, 2016 at 04:59 AM


    In the path below, activating synchronization will automatically replicate the changes from ECC to SRM side after initial download:

    Cross-Application Components
    Master Data Synchronization
    Synchronization Control
    Synchronization Control
    Activate Synchronization Options

    1.png (36.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      For the specific entries to be maintained, you may adjust this according to your system scenario. This is not mandatory to maintain each of them.

      As I know, initial download must be manually executed via MDS_LOAD_COCKPIT. Then later for any changes in ECC side, it should be updated automatically once the synchronization is activated. Once it is activated, you may notice it in MDS_LOAD_COCKPIT. All the related queue name and monitor functionality are also available in MDS_LOAD_COCKPIT.


      22.png (81.7 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.