on 01-07-2008 1:37 AM
Hi,
Can anyone knows how can we export or keep a copy of WE20, WE21 and SM59 Entries for later use. As We are going to refresh the development server with quality and wish to restore the orignal DEV servers parameter (Enteries) settings.
How can we do Export and Import. Pl. suggest me some solution.
Thanks,
Raj
Hi Raj
As mentioned by Manu above , there are specific tables where the information related to ALE / RFC are stored. You can create .dmp files using R3trans utility to take a backup of these settings.
generally during System Refresh - the procedure is followed to backup tables in the target system for restoring after the PROD copy .
Thanks
Rishi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For WE20 the tables are not TBDLS and TBDLST stupid answer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think this will help for WE20/WE21 profiles export and import
export
client = 100
file = "\usr\sap\trans\data\SID_WE20_21_partnerprofexp.ctl"
Select * from EDIPHONE
Select * from EDMA
Select * from EDMAT
Select * from EDMMS
Select * from EDP12
Select * from EDP13
Select * from EDP21
Select * from EDPAR
Select * from EDPI1
Select * from EDPO1
Select * from EDPo3
Select * from EDPP1
Select * from EDPPV
Select * from EDPVW
Select * from EDIPOD
Select * from EDIPOA
Select * from EDIPORT
Select * from EDBAST
Select * from EDIPOF
Select * from EDIPOI
Select * from EDIPOX
Select * from EDIPO
Select * from EDIPo2
**************************************
import
file = "\usr\sap\trans\data\SID_WE20_21_partnerprofexp.ctl"
Thanks
Hi Raj,
You cannot transport RFC Destinations,WE20 and WE21 entries directly. But there is a trick,
Create a new Transport Request. After you have created the transport click on the request and in menu choose Request/Task and then Display. Goto change mode.
In PGMID give the value R3TR
In Obj give value TABU
In Object Name give RFCDES(for SM59 entries);give EDIPORT(for WE21); give TBDLS andTBDLST(for WE20).
After that double click on table name entry. You will come to the screen: Transport organizer:Change Key List.
Here choose insert line. A new line with table name and key as the column headers will come up.
Double click on the Bobject Field. In the next screen you will get options to fill in the key.
You can insert key as per your choice.
For example take the case of RFCs.
If you want to transport all the RFC Destinations give '*'. If you want to transport a RFC Des called say 'ABC' give the key as 'ABC'.
Similarly for WE20 and WE21.
Release the transport and import it in the target system.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That means I am going to create the transport request and will keep the backup of transport files with me for later import on that system only. I am not going to import that transport request to any other system.
So, I just want to know the sequence of files to be imported if we do that process with tp command from OS level.
Regards,
Raj
Try this Script . Go to /usr/sap/trans/bin create a file ( <filename>.ctl > with the following entries
export
file '/usr/sap/trans/data/filename1.dat'
delete from rfcattrib
select * from rfcattrib
delete from rfcdes
select * from rfcdes
delete from rfcdoc
select * from rfcdoc
delete from rfcsysacl
select * from rfcsysacl
delete from rzllitab
select * from rzllitab
delete from rzlliclass
select * from rzlliclass
delete from sxroute
select * from sxroute
delete from rfccheck
select * from rfccheck
2 ) execute the command R3trans -w <filename>.log <filename.>.ctl , a log file will be created in /usr/sap/trans/bin with the file name <filename>.log , R3trans return code should be 000 0r 004.
3) If you want to reimport it to the same system at a later point of time create a script <filename2>.ctl in /usr/sap/trans/bin
import
file '/usr/sap/trans/data/filename1.dat'
4) R3trans -w filename2.log -u 1268 <filename2>.ctl
The return code should be 000 or 004 , compare the no of table enties in the exported and imported log files , they should be in sync .
Edited by: Mann Mohandas on Feb 20, 2010 8:33 AM
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.