Skip to Content
Author's profile photo Former Member

Overview of Data Transfer Through Files Using SAP TDMS 4.0

Data Transfer Through Files


One of the new feature of SAP TDMS 4.0 is data transfer through files.It is considered to be one of major enhancement in TDMS 4.0.

File transfer method is different from standard TDMS packages as it does not require the RFC destinations to all the involved system.

File-Based Transfer separate Data Selection and Data Transfer process by introducing

1. An Export Package – Standard TDMS Package without receiver related actions

2. An Import Package –  Allows a data transfer to selected receiver system

The figure below shows the main steps to be followed in both contexts (export and import package)


The export package requires Sender system,control system,Central system and a file system where data will be extracted.

The import package requires a dummy sender system, where SAP TDMS can create the cluster DMC_INDXCL and import files to the cluster.

The dummy sender system can be the receiver system, the control system, or a different system not used during export.

Why File-Based Transfer :

File -based transfer can be used in following contexts(which cannot be achieved through RFC based transfer):

1.There is no direct connection between the sender system and the receiver system.


  • Sender (Production/production snapshot) is ready to send data but the test system is not yet ready to receive it since it is down for maintenance or is being installed using TDMS shell creation method. Everything is on hold until test system is online. I wondered at such times if there was a way I can export data (similar to SAP Sapinst export/import method used in system copy) and store it in the file system which I can then import when receiver system is available.
  • Due to security reasons, the sender system is not allowed to connect to non production systems via RFC. It is not therefore possible to use RFC means to extract data.

Both of these problems can be addressed via this new TDMS functionality.

2. If one want to carry out multiple imports of test data using a single export file.- With the single export file,one can carry out multiple imports into various non production systems.This reduces the effort and time of running data export every time. Remember that data import take relatively less time than data extraction.

3. Sender and receiver systems are in different data centers located in different geographical areas.In such cases, RFC based transfer takes lot to time due to slow network bandwidth between data center.One can overcome this limitation by running export package involving systems residing in same data center,move the data extract file to other data center and run import package there.

Things to do before using file-transfer method:

1. Definition of Data Extract Export and Import Directory :

Specify the export and import directory for the data extract files by defining the logical path DMIS_DEX_ROOT in the SAP transaction-‘File’.

By default, the logical path DMIS_DEX_ROOT points to the transport directory DIR_TRANS that is defined in the system profile of the respective Data Transfer Control system

While choosing the export and import directory,keep in mind that it should have space available for data files which are going to be placed at that location.

The space required depends on the sender database size and type of reduction scenarios used.One such example, data files amounting 100 GB of space is extracted from 4 TB database using 1 year data reduction scenario(Time base reduction).

Export or import path can be assigned using any one of the following methods:

-Change the definition of the logical path DMIS_DEX_ROOT in the control system by using transaction FILE.

-Create own logical path definitions and assign them as the new logical export or import path by using transaction CNV_MBT_DEXDEFAULTS in the control system.

2.Definition of Maximum File Size for Data Extract Data Files:

One can change the maximum size for each data extract file by defining a corresponding maximum file size in bytes using transaction CNV_MBT_DEXDEFAULTS for the control system.Please don’t keep maximum size more than 500 MB as it can cause runtime errors(TSV_TNEW_PAGE_ALLOC_FAILED,SYSTEM_NO_ROLL) during data extraction phase.

Steps involved in File transfer method :

1. Creating export package:

  • Create appropriate TDMS migration package for the required application.
  • Specify –‘file based transfer ‘as Method of Transfer in the first execution step of the package.


By default, SAP TDMS chooses RFC-based data transfer. Change the mode of transfer to data transfer through files by choosing Mode 2.


  • Define a data extract id for file transfer: In data transfer phase, execute the activity -Defining a Data Extract ID for File Transfer.


Other steps in process tree are quite similar to the RFC based transfer method.

Once export package is complete,transfer the files to receiver system

2. Creating an Import Package :

  • Create a new import package to import data through files by choosing appropriate solutions from TDMS portfolio.

The migration process tree for data import contains the following new activities:

– Identification of Data for File Import :

Assign a data extract to the import package by executing the Select Data Extract for Import activity. Enter the data extract ID,press Enter then click Assign button.


– Start of File Import:

Execute the Start Data Extract Import activity to import the data to the data cluster DMC_INDXCL in the defined sender system.

Other steps in process tree are quite similar to the RFC based transfer method.

This (file based transfer) is what I consider to be major enhanced feature of SAP TDMS 4.0. There are several other improvements which I have not included in this blog.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Chandrakanth Angannagari
      Chandrakanth Angannagari

      Thanks Kartik . The blog is indeed help ful especially considering the fact that the documentation from SAP on TDMS currently is not very illustrative.

      Would look forward for more showing in more detail general problems during TDMS copies and how to tackle them.

      Author's profile photo Former Member
      Former Member

      Quite a helpful doc Kartik...Keep it up!

      Author's profile photo Former Member
      Former Member

      Thanks Karthik, useful info. I have a quick question on TDMS, Is this tool can be used for Payroll results compare?. I know Accenture has a DCM, wondering can this TDMS tool can be used for that?  We have a requirement to compare payroll results within SAP( Production/Quality system ) and compare payroll results from SAP to payroll result from Legacy system.

      Thanks a lot for the help. you can reply to

      Author's profile photo Former Member
      Former Member

      Hello Andi,

      TDMS provides you the feature to compare the payroll and Time results between systems and also provides you the feature to perform mass compare between system or the same system.


      Rishav Surana

      Author's profile photo Former Member
      Former Member

      Thanks Rishav. Will it compare between SAP system and Legacy payroll system?. 

      Regards, Andi

      Author's profile photo Former Member
      Former Member

      Hello Andi,

      TDMs does not compare payroll results between SAP and Legacy system.


      Rishav Surana

      Author's profile photo Former Member
      Former Member

      Hi Kartik,

      Do you have any documentation on how to define the virtual Sender system for Export? We are trying to configure tthe control system as the virtual sender.


      Author's profile photo Uday Bhaskar Raghupatula
      Uday Bhaskar Raghupatula

      Thanks Karthik for detailed explanation.


      I have one basic doubt.


      While doing export using File Based Transfer, can we select last 6 months or 1 year data like we do in TBR?

      If not, what is the difference between regular DB export/import and File based Transfer?