Perform Synchronized TDMS Data Reductions for SAP ECC, SAP CRM, and SAP NetWeaver BW

  • by Saad Y Hassan, President, Hassan Associates, Inc.
  • October 6, 2011
SAP Test Data Migration Server (TDMS) now has the capability to consistently transfer data to a connected SAP ERP Central Component, SAP Customer Relationship Management, and SAP NetWeaver Business Warehouse application landscape. A non-production landscape built with TDMS maintains the consistency and integration of its source systems and thus delivers significant value for its users. Learn key tips for performing such a synchronized TDMS transfer, as well as lessons learned from an actual transfer.
Key Concept
SAP Test Data Migration Server (TDMS) is used to bring a subset of production data to a development or test environment. TDMS can reduce the data volume by several criteria, including the company code, the From date, and the application area. Recent developments by SAP allow TDMS to reduce data for SAP NetWeaver Business Warehouse and SAP CRM systems in addition to SAP ERP Central Component (SAP ECC). TDMS ensures consistency of data in each system. All core TDMS functionality for SAP ECC (such as SAP ERP Human Capital Management data scrambling and the Business Process Library) is still available.

SAP Test Data Migration Server (TDMS) allows you to consistently populate a client with subsets of data from a source (e.g., production or recently refreshed quality assurance) to a target (e.g., development or quality assurance) client. The initial releases of TDMS were focused on SAP R/3 and SAP ERP Central Component (SAP ECC) only, which limited usage by companies looking to incorporate other applications.

In this setting, there was no elegant solution for SAP NetWeaver Business Warehouse (SAP NetWeaver BW) and SAP Customer Relationship Management (SAP CRM) systems connected to an SAP ECC system that had been built from a TDMS reduction. To maintain consistency among such connected SAP applications in the past, you could either perform a database copy from the connected source systems to the appropriate targets or perform an initial data download from the TDMS-based target SAP ECC system to the corresponding SAP CRM and SAP NetWeaver BW systems. Both of these options had their drawbacks — wasted storage space in the former and time-consuming manual work in the latter.

With the introduction of TDMS solutions for SAP CRM and SAP NetWeaver BW, you can now perform synchronized data reductions in a consistent manner. In other words, TDMS can carry the level of data and transactional harmony in the source environment to the target. This consistency can ensure, for example, that if an existing sales order is modified in the TDMS-based SAP ECC instance (e.g., creation of a delivery), the corresponding updates are reflected in the connected SAP CRM instance (e.g., through Internet sales). Furthermore, this TDMS-based creation of the SAP CRM and SAP NetWeaver BW clients is optimal — only the data that’s needed to interact with the TDMS-based SAP ECC client is brought to the target.

Saad Y Hassan

Saad Y. Hassan is an experienced SAP consulting manager and an entrepreneur. His area of expertise is the architecture, implementation, and management of SAP application components.

If you have any comments about this article or SAP Professional Journal, or want to submit and idea for an article, contact the SAP Professional Journal editor.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.