Skip to Content
Technical Articles
Author's profile photo Anikesh Jyotishi

SAP ECC Material Master data copy by SAP TDMS 4.0

Introduction:

We can use TDMS Business process Library to copy Material master data from production to non-production systems based on business requirements,

Business Process Library in SAP TDMS is a collection of specific SAP business processes. That we can use the BPL-Based Transfer migration solution to transfer data relevant to the business processes from the sender system to the receiver system.

For most of the projects UAT and SIT business required live Material master data for production to the non-production environment, Through TDMS we can copy consistent data into the non-production system.

Please check the below blog for basic functionality and control system setup.

https://blogs.sap.com/2021/06/09/tdms-basic-functionality-and-control-system-setup/

 

DISCLAIMER

The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors, and out-of-date information. This document may be updated or changed without notice at any time. Use of the information is therefore at your own risk. In no event shall SAP be liable for special, indirect, incidental, or consequential damages resulting from or related to the use of this document.

 

Overview

Now we can copy Material master data from source to target as per business requirements for SIT & UATs.

SAP TDMS BPL Basic Features

  • SAP TDMS transfers the required data of the BPL objects based on the selection criteria.
  • Following Objects are a part of the BPL package in our case package will be BC – Material
    • Root Table
    • Tables
    • Subobjects
  • Transferring BPL objects is necessary to ensure a high level of data consistency in the receiver system.

We can modify default BPL objects based on business requirements, Through Business Process Library Modeler we can perform the below tasks.

    • Add tables
    • Add subobjects
    • Modify foreign key or link mappings
    • Delete tables
    • Deactivate or activate subobject links
    • Set a table as a root table or remove the selection

 

SAP TDMS Material Master Copy Technical Steps:-

·       Project Template creation

·       Project creation

·       System landscape creation

·       Package creation

                           o   Technical Settings

                           o   Configuration and Selection

                           o   Data Transfer

Project Template creation

Created project template based on the requirement, in our scenario we have to copy Material master.

Goto TDMS tcode will redirect you to the web URL.

Go to the project template and create a new project template.

Add a required portfolio to the template, In our case, we need to copy Material master and it comes under BPL. Select BPL and choose BC – Material master

Green status means all ok and proceed with the next setup project creation

Once you assign a portfolio solution to a project template you can’t add more solutions on the same project template, but you can use the same template for many projects and multiple times.

Project creation

Need to create a project for Material master data copy and assign project template to it.

 

Assign project template to project

Just finish and it will add BC- Material to an execution phase

Project creation completed

The same projects can be used many times for the same solution.

System landscape creation

In this setup, it will create all RFC automatically between the control system, source, and target system.

Go to SYSTEM LANDSCAPES and create a new system landscape.

Provide central system, control system, Receiver and sender system SID, and client numbers.

Your central and control system can be the same.

 

In the next step provide instance number, language, server name, RFC user id, and password.

Click on Distribute RFC destinations, It will automatically create all RFCs.

 

Package creation

Once again go to projects and double click on your project and open.

Click on edit and assign your system landscape to the project.

Create a package by clicking on create a package.

Click on enter package and it will open the data transfer dashboard same as below.

                                                 Technical Settings

 

Some of the settings are optional and we can ignore them.

We can select row and start execution for mandatory steps.

View Material master related table

Table Name Description Tab. Cat. Table Role Pool/Cluster No. of Records Table Size (in KB) Software Component Software Comp. Desc.
CDHDR 0 0
CDPOS 0 0
CKMLCR 0 0
CKMLHD 0 0
CKMLPP 0 0
CKMLPR 0 0
CRVM_B 0 0
EBEW 0 0
EBEWH 0 0
KEKO 0 0
MAEX 0 0
MAFU 0 0
MAKG 0 0
MAKT 0 0
MAKV 0 0
MAKZ 0 0
MAPE 0 0
MAPR 0 0
MARA StarterTable 0 0
MARC 0 0
MARCH 0 0
MARD 0 0
MARDH 0 0
MARM 0 0
MASE 0 0
MBEW 0 0
MBEWH 0 0
MBPR 0 0
MCHB 0 0
MCHBH 0 0
MEAN 0 0
MGEF 0 0
MKAL 0 0
MKOL 0 0
MKOLH 0 0
MKOP 0 0
MLAN 0 0
MLEA 0 0
MLGN 0 0
MLGT 0 0
MSCA 0 0
MSCAH 0 0
MSKA 0 0
MSKAH 0 0
MSKU 0 0
MSKUH 0 0
MSLB 0 0
MSLBH 0 0
MSPR 0 0
MSPRH 0 0
MSSA 0 0
MSSAH 0 0
MSSL 0 0
MSSQ 0 0
MSSQH 0 0
MVER 0 0
MVKE 0 0
NDBSMATG16 0 0
ONR00 0 0
QBEW 0 0
QBEWH 0 0
QMAT 0 0
STXB 0 0
STXH 0 0
STXL 0 0

 

Assign all logical system names based on the receiver system.

                                                  Configuration and Selection

Execute all below mandatory steps

This is one of the most important steps where we have to provide either individual Material master numbers or a range of Material masters based on the MARA table.

Provide Material master range based on MARA table MATNR column

Or provide individual Material master numbers based on the requirement

It’s very important to the provided Material master range or individual value in this setup, If you level this step blank then nothing will be copied from source to target.

Run the below step to create filters on source and target for data transfer or deletion.

the scrambling rule is very important if you are coping with business-critical data from production to non-production.

Before executing the activity, you have created the required scrambling rules in the TDMS Scrambling Workbench.

                                                        Data Transfer

Execute below setup to perform final checks

Lock users on the receiver system are optional, Based on Receiver usages.

This is an optional setup, Execute the below step if you want to clear all data from the receiver system or if you want to merge data with the current receiver system-level below step.

In this step, you start the data selection for all migration objects with reading type Cluster Technique. The data of these migration objects are stored in partitioned and compressed form in a storage table in the sender system (cluster).

If you assigned another cluster technique-related reading type to any objects in the optional step for manual selection of reading types, this step covers those objects as well. (This from tool description)

Start the data transfer from source to target

We can check logs by clicking on the number of executions.

Unlock users in the receiver system if you locked in the above step.

Check number range.

Verify Data:-

Login into receiver system, Goto Se16 give MARA table name.

The next screen provides the same range which we have provided in the “specify migration parameters for data Selection “step.  

Then check the number of entries it should be the same as the source after providing the same inputs.

See Also :-

http://support.sap.com/tdms

 

Reference Document:-

TDMS tools inside details

https://help.sap.com/saphelp_tdm40/helpdata/en/d6/aaffd14c0f4e728f2d5c8bb433c803/frameset.htm

https://blogs.sap.com/2021/08/16/vendor-master-data-copy-by-sap-tdms-4.0/

 

I hope this document will help you with the Material master copy.

 

Cheers!

Anikesh Jyotishi

 

 

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jaskaran Singh
      Jaskaran Singh

      Thanks  Anikesh for creating a detailed blog on Material Master data copy in TDMS.

      Author's profile photo Jay Park
      Jay Park

      What is BPL object can copy Variant Configuration(VC) data to target system(Non-Prod) from Source System(PROD) in TDMS?

       

      List of VC tables

      Table Discription
      AUSP Characteristic Values
      BCST User-specific settings in configurator
      CABN Characteristic
      CABN_EXCL Characteristics That Are Excluded for Type Matching
      CABNNEW Characteristic
      CABNT Characteristic Descriptions
      CABNZ Assignment of Table Fields to Characteristics
      CABS Result of the Statistical Analysis of Table
      CAWN Characteristic values
      CAWNT Value Texts
      CDCND Configuration: Direct Conditions Data Type:CHAR
      CECUFM Configuration editor: design: format
      CECUSD Configuration editor: design: basic data
      CECUSDT Configuration editor: design: descriptions
      CECUSF Configuration editor: design: borders
      CECUSFT Configuration editor: design: Border descriptions
      CLAENNR Change number-to-class alloc.: classificati
      CLBUF Cluster Table for Classes and Variants
      CLINDEX Indices of Classification System
      CLINDEXATINN Characteristic – Index Assignment
      CLINDEXOBTAB Restriction of Index to Object Types
      CLINDEXPROT Log Table for Document Search Index in Web
      CLNAMESPACE Namespace for Characteristics / Classes
      CLPROF Classification: Parameters for Settings
      CLRK Recursiveness Info on Objects in Classes for BOM
      CLSELSTATISTICS Statistics for Optimizing Object Search
      CLSELSTATISTICS2 Statistical AUSP Information for Characteri
      CUCO Additional Data for Configurable Objects
      CUFM Customizing: Class/Config: Screendesigner Form
      CUOB Assignment of Object to Dependency
      CUPE Extension to BOM Item for Variants
      CUSD Customizing: Class/Config: Screendesigner
      CUSDT Customizing: Class/Config: Screendesigner Descri
      CUSEPRES Material Variant Matching Preselection + Settings
      CUSF Customizing: Class/Config: Screendesigner Frame
      CUSFT Customizing: Class/Config: Screendesigner Frame
      IBVALUEC  CBASE: Redundant Object Doc. on Value Changes for Inst
      INOB Link between Internal Number and Object
      KLAH Class Header Data
      KLAT Classes: Long Texts
      KRIF Richie Riffle
      KSML Characteristics of a Class
      KSSK Allocation Table: Object to Class
      MACOND Configuration: Manually Assigned Conditions
      SWOR Classification System: Keywords
      TCL_MENU_BUTTON Menu Options and Buttons in the Classificat
      TCLAO Several Objects in one Class Type
      TCLAT Class Type Texts
      TCLAU Subscreen for Additional Data of Class
      TCLAUT Tab Text for Additional Class Maintenance S
      TCLAX CLASSIFICATION:
      TCLCAT Catalogs for Finding Objects in Classes
      TCLD Characteristic Data from Standard
      TCLFM Control Table Include Screen Module Pool fo
      TCLG Class Groups
      TCLGT Class Groups (Texts)
      TCLO Key Fields of Objects
      TCLOKCODE OK Code Control for Classification System
      TCLR Object-Specific Reports and Transactions
      TCLS Classes: Organizational areas
      TCLST Classes: Org. Areas (Texts)
      TCLT Classifiable Objects
      TCLTT Classifiable Objects: Texts
      TCLU Class Status
      TCLUT Class Status (Texts)
      TCLX Class Text IDs
      TCLXT Class Text IDs, Language-Dependent
      TCME Validity for Global Characteristics
      TCMG Characteristics Groups
      TCMGT Characteristics Group Descriptions
      TCMS Characteristic Status
      TCMST Characteristic Status Descriptions
      TCMV Default Values for Characteristics Management
      TCOB Configuration: Configurable Objects
      TCOBJ Help table for optimization reports (INTERN
      TCOBT Configuration: Configurable Objects -Texts-
      TCPA Templates for Characteristics Management
      TCPAT Templates for Characteristics
      TCPS Define Characters in Templates
      TCTRW Reserved Characteristic Names
      TCUA Configuration: Find Layout for Configuration Result
      TCUL Configuration: Configuration Result Layout
      TCUQ Configuration: Configurable Objects
      TCUQT Text Table for TCUQ
      TCUZ Configuration: Configuration Result Layout -Line-