cancel
Showing results for 
Search instead for 
Did you mean: 

Exporting WE20, WE21 and SM59 Entries

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

For WE20 the tables are not TBDLS and TBDLST stupid answer

former_member204746
Active Contributor
0 Kudos

Thanks Peter for this very interesting post...

maybe you have a better answer to share instead of just basing this topic (Even, if you were right!)

martin_haller
Discoverer
0 Kudos

HI Peter / Eric

The post is very old. However: the tables for WE20 are:

EDP12 / EDP13 / EDP21 / EDPP1

former_member188065
Participant
0 Kudos

Actually it is not that easy to distinguish, while some tables are in use by other transactions as well. The 3 mentionend


Martin Haller wrote:

EDP12 / EDP13 / EDP21

are used for BD64 (Distribution model) as well AFAIK

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Bidwan,

Thanks for the trick. Pl. also let me know while adding to buffer, importing the transport file with tp command what should be the sequence of the file.

Regards,

Raj

Former Member
0 Kudos

What do you mean by sequence of file? Can you plz be clearer?

Former Member
0 Kudos

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

Former Member
0 Kudos

This sounds very interesting.

Is this procedure documented anywhere or tested by anyone ? Does it really works ...?

Harshal

Former Member
0 Kudos

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