Export Role and users before QAS system refresh

[Former Member]

HI All

Can anyone suggest here for Export Roles and users before QAS system refresh with PRD.

1.I want export all roles before system refresh and want import it again after refresh.

2.I want retransport few important Transport Request.

3.if anything other i have to keep in Mind please let me know.

Regards,

YR

[Former Member]

Hi ,

Go to SCC8 --> select SAP_USER profile and export , it will create the transport request at os level, Go to OS level paste these Transport Requests in another location or your desktop safely ..

Now After refresh add this TR through STMS and import.

Also check the Client Refresh guide before do anything.

Regards

Pranay.

[Former Member]

HI

Can we do for roles through TX PFCG Mass Download?

in scc8 SAP_USER will carry both things Roles along with user or not?

Can we export RFC connection? if Yes pls guide how?

Regards,

YR

[Former Member]

Hi Yograj.

User Export - You can done this with SCC8 t-code and SAP_USER profile

Roles Export - You can download the each role to front end and then you can improt after refresh..

RFC export -You have to do this at OS level with R3TRANS tool,for this you you have to create .dat file and .ctl file wit all the RFC tables

Let me know if you want know the exact commands for RFC export.

-Srinivas Chapa.

[Former Member]

Hi Srinivasa

Thanks for your reply can you please let me the command for RFC export or Import. and i have to delete all PRD RFC after refresh that comes on QAS.? or i command will overwrite these.?

2. SCC8 only carry users profile? means no Roles along with? And after refresh when i will import all roles then i will automatic set with user or need to do other exercise.?

regards

YR

[JPReyes]

This is plain basic stuff... Client copy profile SAP_USER will carry users, roles and profiles... read the documentation please.

Regards

Juan

[Former Member]

Dear All,

I think as per my previous post - SAP_USER profile export is sufficient to take a backup of users and roles .

Regards

Pranay

[former_member185031]

I think this infomration is easily available on everywhere to understand what SAP_USER profile contains and other stuff. What needs to be done is to read the document to understand the requirement and the option available to achieve this.

Regards,

Subhash

[Former Member]

Hi YR,

SAP_USER profile export will export all users and their associated roles

RFC Export --

go to trans dir.. and then create .ctl file as below

#cd /usr/sap/trans/bin

#vi export_rfc_<sid>_<date>.ctl

#Please create the data file as u201Cexport_<SID>_rfc_<Date>.datu201D

Export

Client=<XXX>

file '/usr/sap/trans/data/export_<SID>_rfc_<Date>.datu2019

delete from rfcattrib

select * from rfcattrib

delete from rfcdes

select * from rfcdes

delete from rfcdoc

select * from rfcdoc

delete from rzllitab

select * from rzllitab

delete from ZTCA_USER_LANG

select * from ZTCA_USER_LANG

delete from rfcsysacl

select * from rfcsysacl

delete from rzllitab

select * from rzllitab

#After that excute export command as below.

R3trans u2013w <export_rfc_<targetSID>_date.log> export_rfc_<targetSID>_date.ctl>

(Format is: R3trans u2013w <logfile> <controlfile>)

Export is finished....

Import

Example:

#cd /usr/sap/trans/bin

#vi import_rfc_pta_11042004.ctl

#Please enter the exported RFC data file in the import control as follows:

import

file '/usr/sap/trans/data/export_pta_rfc_11042004.dat'

(Enter the file name, which is created during the export process)