SAP, SAP ERP

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 “:\usr\sap\trans\cofiles”

& in “:\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 K9XXXXX client=XXX pf=TP_DOMAIN_SID.PFL

Where as Request = Transport number = K9XXXXX,

= in which system you are going to import these Tr’s

Client = Target Client where your transport must be imported.

pf = :\usr\sap\trans\bin\TP_DOMAIN_.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.

Leave a Reply

Your email address will not be published. Required fields are marked *