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
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.
There is a script to do mass import under Linux systems.
sidimport.sh --> https://github.com/trockenasche/scripts/blob/main/SAP%20Transport%20Import
Hi
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.