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

SAP ECC Vendor Master data copy by SAP TDMS 4.0

Introduction:

We can use TDMS Business process Library to copy vendor 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 copy 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 vendor 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 vendor 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 – Vendor
    • 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 the Business Process library modeler, we can create a copy of BPL Objets and can be performed the below task and create customized BPL solution based on the requirement.

    • 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 Vendor 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 vendor 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 vendor master and it comes under BPL. Select BPL and choose BC – Vendor master

Add requirement to project template

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 multiple times.

Project creation

Create a project for vendor master data copy and assign a project template to it.

Goto projects and click on new, Provide relevant project name and description.

Goto next and assign project template to project

Click on finish and it will add BC- vendor into an execution phase

 

Project creation completed, Same projects can be used multiple times for the same solution.

System landscape creation

We will define the data transfer system landscape in this step and during the process, itself all communication automatically will be created between the control system, source, and target system.

Go to SYSTEM LANDSCAPES and create a new system landscape.

Once you click on create, It will open below the wizard.

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 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 the row and start execution for mandatory steps.

View vendor master related table

Table Name Description Tab. Cat. Table Role Pool/Cluster No. of Records Table Size (in KB) Software Component Software Comp. Desc.
ADCP 0 0
ADR10 0 0
ADR2 0 0
ADR3 0 0
ADR4 0 0
ADR5 0 0
ADR6 0 0
ADR7 0 0
ADR8 0 0
ADR9 0 0
ADRC 0 0
ADRCT 0 0
ADRG 0 0
ADRT 0 0
ADRV 0 0
BNKA 0 0
BNKAIN 0 0
CDHDR 0 0
CDPOS 0 0
CRVM_B 0 0
EBEW 0 0
EBEWH 0 0
GLT0 0 0
KEKO 0 0
KNA1 0 0
KNAS 0 0
KNB1 0 0
KNB4 0 0
KNB5 0 0
KNBK 0 0
KNBW 0 0
KNC1 0 0
KNC3 0 0
KNEX 0 0
KNKA 0 0
KNKK 0 0
KNMT 0 0
KNMTK 0 0
KNVA 0 0
KNVD 0 0
KNVI 0 0
KNVK 0 0
KNVL 0 0
KNVP 0 0
KNVV 0 0
KNZA 0 0
LFA1 StarterTable 0 0
LFAT 0 0
LFB1 0 0
LFB5 0 0
LFBK 0 0
LFBW 0 0
LFEI 0 0
LFLR 0 0
LFM1 0 0
LFM2 0 0
LFMH 0 0
LFZA 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 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
SKA1 0 0
SKAS 0 0
SKAT 0 0
SKB1 0 0
STXB 0 0
STXH 0 0
STXL 0 0
TIBAN 0 0
WYT1 0 0
WYT1T 0 0
WYT3 0 0

 

Assign all logical system names based on the receiver system.

Need to update “Name in the Receiver System” based on sender system details.

 

                                               Configuration and Selection

Execute all below mandatory steps

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

Provide vendor master range based on LFA1 table LIFNR column.

Or provide individual vendor master numbers based on the requirement.

It’s very important to provided vendor master range or individual value in this step, If you leave 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 and 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 LFA1 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 a 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

 

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

 

Cheers!

Anikesh Jyotishi

Assigned tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.