Skip to Content
Technical Articles
Author's profile photo Sai Kumar Dudala

Mass Transports Import in SAP


In this blog I’m going to explain how to import multiple transports at a time in SAP system and how to add huge number of transports into buffer using scripts on OS – Windows and DB – MSSQL environment.

System details

SID         –              <SID>

DB          –              MSSQL 2012

OS          –              Windows Server 2012



  • We have nearly 475 transports which needs to be imported into a development system in our landscape with OS – Windows and on DB – MSSQL.
  • Manually adding each TR into buffer kills time. Instead of adding tr’s manually we can use scripts to add any number of transports into buffer.
  • Place all the TR related Cofiles and Data files into trans directoryi.e.,  in “<drive>:\usr\sap\trans\cofiles” 

    &  in “<drive>:\usr\sap\trans\data” as shown below

  • After copying both cofile and data files to the trans directory open a new .txt file and enter the script as shown below.


SYNTAX – tp addtobuffer REQUEST SID client=XXX pf= Transport domain profile.

SYNTAX – tp addtobuffer <SID>K9XXXXX <target SID> client=XXX pf=TP_DOMAIN_SID.PFL

Where as Request = Transport number = <source SID>K9XXXXX,

<SID> = <Target SID> in which system you are going to import these Tr’s

Client = Target Client where your transport must be imported.

pf = <drive>:\usr\sap\trans\bin\TP_DOMAIN_<target SID>.PFL

Now for example script syntax will look like

tp addtobuffer EC1K900010 EC2 client=100 pf=D:\usr\sap\trans\bin\TP_DOMAIN_EC2.PFL

  • Copy the final script and load it into a new excel sheet to do the same for all other Tr’s as shown below.

  • After writing the script for all the transports in excel copy the syntax into a .txt file and save it as transports.bat or transports.cmd

  • And save the file as “transports.bat”

  • Copy this file to usr\sap\trans\bin directory


  • Now run the file from command prompt using command “transports.bat>>error.txt”, you can view the error log in error.txt file if any.


  • You can trace the error logs if any from error.txt file


  • Now goto the target system and enter STMS_IMPORT here you can see now all the 475 Tr’s added to buffer.

Click on Import All Requests button to import all the Tr’s into the target system. Give the target client and choose appropriate import options.



This procedure makes life easy when there are many number of transports to be imported. Please add comments for any changes

Assigned Tags

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

      Or you can maintain a text file with list of transports, then write a powershell script to read from this text file, line by line and pass it as a variable to substitute TR in the TP ADDTOBUFFER command in a loop,  rest of the parameters  remain constant. you can achieve this whole thing in just few lines, skipping the cumbersome process of copy / paste  in excel then notepad etc.

      Author's profile photo Former Member
      Former Member

      There is a script to do mass import under Linux systems. -->

      Author's profile photo Archana Vijay
      Archana Vijay


      nice blog.

      How to ensure the sequence is right when doing import_all as we are asked to move TR's in the right sequence as there are depedencies.

      Secondly the TR's are already present in the import queue/buffer with the status "waiting to be imported".

      Please advise.