Skip to Content
Technical Articles

Mass Transports Import in SAP

Introduction

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

 

Activity

  • 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.

 

Conclusion

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

1 Comment
You must be Logged on to comment or reply to a post.
  • 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.