how to export RFC destination to file in order to import it in an other sys

[Former Member]

Hello,

i would like to export all RFC destination to a file in order to import it after a refresh, could you please help to know how to do it

Thank's

[guillermo_olive]

***REMEMBER****

When you create a request, you'll create like as "Transport of copies".

Best Wishes.

Guillermo olive

[Former Member]

to close

[Former Member]

The best and easiest way...

Goto SE01, create transport request (Transport of Copies)

R3TR TABU RFCATTRIB *

R3TR TABU RFCDES *

R3TR TABU RFCDOC *

R3TR TABU RFCSYSACL *

If you take only RFCDES you will be missing the Documentation part of RFCs in order to take everything you need to have export of all the above mentioned tables.

Pls check if you get the passwords and everything because I heard in ECC6 its giving some issue related to password saved for the user in RFCs.

All the best !!

[Former Member]

Below are the steps that we follo -

When customer requests additional definitions then you must add them to the export control file /usr/sap/trans/bin/QAS_exp_rfccon.ctl

Example of ctl-file: Contents of export ctl-file i.e. /usr/sap/trans/bin/QAS_exp_rfccon.ctl

########################################

1. RFC Destinations export

########################################

export

client = 500

file = "/usr/sap/trans/bin/data/QAS_rfccon.dat"

select * from RFCATTRIB

select * from RFCDES

select * from RFCDOC

select * from ZI2ATPASGN

select * from ZI2ATPENG

select * from ZZPHASEDBL

select * from RZLLITAB

select * from TPFID

select * from BTCOMSET

select * from TVARV

select * from E070L

Actions:

u2022 QASadm> cd /usr/sap/trans/bin

u2022 check if data directory exists

u2022 QASadmadm> mkdir data (if it does not exists already)

u2022 QASadm> R3trans u2013w QAS_exp_rfccon.log QAS_exp_rfccon.ctl

.... Continued on next

[Former Member]

R3trans u2013w QAS_exp_rfccon.log QAS_exp_rfccon.ctl

This uses the commands in QAS_exp_rfccon.ctl and writes the log to QAS_exp_rfccon.log. Check the logfile to make sure the datafile was created.

Below command will import RFC

Import exported RFC connections (as QASadm)

oraQAS> cd /usr/sap/trans/bin

oraQAS> R3trans u2013w QAS_imp_rfccon.log QAS_imp_rfccon.ctl

You need follow this steps as shown in my message. It will perform export and import of RFC.

Thanks and Regards,

Kedar

[Former Member]

Hi,

I hope your database is oracle.

Please find the step below

RFC Destinations u2013 Export the tables holding the RFC information.

As ora<SID>, create a file (say rfc_export) with the following contents.

Export

File=u2019<Destination filename>u2019 (say rfc_dump)

Select * from rfcattrib

Select * from rfcdes

Select * from rfcdoc

As <SID>adm,

Cd /usr/sap/trans/bin

R3trans -w exp_rfc.log rfc_export

Import RFC information

As ora<SID>, create a file (say rfc_import) with the following contents.

Import

File=u2019 rfc_dumpu2019

As <SID>adm,

Cd /usr/sap/trans/bin

R3trans -w imp_rfc.log rfc_import

Please ensure to put the path details along with the file names. And try creating the files in any directories other that /usr/sap/trans/bin. Just to keep this system directory clean of all these files.

Hope this will help.

Regards,

Sanujit

[Former Member]

Goto SE01, create transport request with modifiable

Program ID : R3TR

Object type : TABU

Object Name : RFCDES

Then double click RFCDES, give * in Table Keys.

Finally Release the transport requests without fail.

[Former Member]

Small Correction ( I tried by SE01 but unable to create the same hence followed via SE09)

SE09 --> Select Modifiable --> Click on Create ---> WorkBench Request --> OK --> Put Short Description --> OK

Double click in the created request

Now Put

Program ID : R3TR

Object Type : TABU

Object Name : RFCDES (Press Enter)

Double Clieck on RFCDES --> put * in table keys --> Save

Finally Release the request.

Edited by: Mukesh Khamparia on Aug 16, 2011 3:35 PM