
There may be situations where you need to export and import SAP tables from OS level, this can be achieved using R3trans utility in SAP.
Setp 1 :- Collect all the list of tables to be exported.
Step 2 :- Check enough disk space available in the directory where you are going to perform export.
Step 3 :- Create two control files for R3trans which will be used for export & import.
For example :- create control file named as export.ctl and the control file should contain entries like below
The below are the calling options for R3trans, you can use the below options based on your requirement
You can specify the following options for calling R3trans:
Example:- R3trans export.ctl -w export_log.log
Step 4:- Once export is completed export_data.dat file will get generated.
Step 5:- Use the same .dat file to perform the import, create the import control file (import.ctl) as below
Step 6:- Call R3trans command with the import control file to start import, the table entries will get imported automatically.
Example:- R3trans import.ctl -w import_log.log
Note:- You can even use R3trans to delete a client from OS level, which will remove all the contents of the table with respect to a single client. For that you need to create a control file as below
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
19 | |
16 | |
9 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 |