Skip to Content
avatar image
Former Member

Exporting WE20, WE21 and SM59 Entries

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 07, 2008 at 05:53 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Sep 02, 2011 at 05:32 PM

    For WE20 the tables are not TBDLS and TBDLST stupid answer

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member SAP BASIS

      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

  • avatar image
    Former Member
    Mar 16, 2014 at 01:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded