DevOps and System Administration Blogs
Explore DevOps and system administration blog posts. Stay current with best practices, tools, and insights into efficient IT management strategies.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Export and Import tables in SAP from the OS Level with real use case

gorbenkoteh
Active Participant
‎2022 Feb 20 9:10 AM
17,083

Intro:


R3trans is the SAP transport tool is used to transport data between SAP Systems and in the migration use case. R3trans is usually called from other programs (for example tp) and in turn, tp is also usually called from Application Layer (transactions STMS_IMPORT, SPAM, etc)

But sometimes SAP BASIS Administrator must interact with these utilities in specific tasks directly

Real use-case:


For example - your development system contains a lot of "dead" development objects (abandoned internal projects, developers who left the company and did not leave proper documentation, and so on)

The more such objects, the greater the chance that new developments will not work correctly in the QAS and Production systems.

For continuous normal development process, you must refresh the Dev system from the Qas/Prod system (for example via backup/restore homogenous system copy)

This is a very complex task with many pitfalls!

One of them -  Version management

Version management contains only in the Development system so after system copy you may lose this information.

To keep this from happening you must export version management and import them after system copy.

For such a specific task, you can use Export and Import tables in SAP from the OS Level procedure.


Resolution:


In your development system before system copy

Log in via <sid>adm OS-user and execute the following commands


For Linux OS:


R3trans -w /usr/sap/trans/log.txt /usr/sap/trans/export_control


For Windows OS:


R3trans -w <drive>:\usr\sap\trans\log.txt E:\usr\sap\trans\export_control


* export_control file you can download from github, adjust only a file path (String nr.2)



Result:

Transport request created on the OS level






In your development system after system copy:

For Linux OS:


R3trans -w /usr/sap/trans/log.txt -i /usr/sap/trans/data/R00000.EWD


For Windows OS:


R3trans -w <drive>:\usr\sap\trans\log.txt -i <drive>:\usr\sap\trans\R00000.EWD


* transport request file name and path you specify in the export_control file from the previous step.


Result:

Transport requests contained table content of vrsd, vrsx, etc tables imported in a system from the OS level







Conclusion.


SAP BASIS routine task explained.

3 Comments
Popular Blog Posts