Recommended table to exclusive in copy client

[former_member200876]

Dear All

when we doing Copy Client from PRD to QAS or DEV

what is recommended Recommended table to exclusive ??

what it the steps to transfer the exclusive tables to serves after client copy finish ?

[ACE-SAP · Accepted solution]

Hello

Seems there is a mistake here... if your purpose is a performing a client copy and exclude some tables you do not need to go through an export/import of table. This is only required for system copy.

You just simply need to define an exclusion list by going in menu  / Edit / Expert setting in the client copy transaction.

I the "table" tab you can list the table you want to exclude.

Watch out that exclusion is also used when deleting a client... so do not forget to empty that list when performing a client deletion.

Regards

70290 - CC-INFO: Excluding tables with 'RSCCEXPT'

Table	Table desc.
TBD00	Views of customer model
TBD00T	Short Description of View of Distribution Model
TBD05	Distribution model for message types
TBD06	Distribution model for methods
TBDBR	Distribution Model: BAPI Reduction
TBDBRF	Distribution Model: Fields in Reduced Parameter
EDIPOD	Table for File Port Definitions
EDIPOA	Table for ALE Port Definitions
EDIPORT	Summary Table for all Port Types for IDoc Processing
EDP12	Partner Profile: Outbound with Message Control
EDP13	Partner Profile: Outbound (technical parameters)
EDP21	Partner Profile: Inbound
EDPI1	EDI: Partner profiles (inbound)
EDPP1	EDI Partner (general partner profiles - inb. and outb.)
EDIDS	Status Record (IDoc)
USL04	CUA: Assignment of Users to Local Profiles
USLA04	CUA: Assignment of Users to Roles
USRSYSACT	CUA: Roles in Distributed Systems
USRSYSPRF	CUA: Profiles in Distributed Systems
VARID	Variant directory (prog variant for background)
VARIS	Assignment of variant to selection screen

[former_member200876 · Accepted solution]

i know the way to exclude tables ,

my inquiry what is the most common tables should i exclude before copy client ??

till now i exclude these tables ( CE1ABJD / KOCLU / RMPSC_TRF_VALUE / LIPS )

[ACE-SAP · Accepted solution]

Hello

I thought you were not aware how it worked as importing excluded tables after a copy is not needed...

I did provide you with quite a bunch of tables that could be excluded to preserve some technical configuration points like ALE, IDOC...

Excluding SD tables like LIPS or KOCLU could be dangerous as you are crippling application data by doing so.

By the way little words like "Thank you" are always appreciated, It's a kind of old fashion usage between humans, at least in the pre-Internet times...

Regards

[former_member200876 · Accepted solution]

Dear Yves

     thanks for your good recommendations , as i understand it is unrecommended to exclude tables for modules (FI - SD - MM ) , but i can exclude tables for some configuration

but my main issue that some tables take more than 7 hours and not finish , by this way the copy client take too many hours

any way I'm still searching may i find any solution to avoid taken many hours

[Reagan · Accepted solution]

Hello

If a table from the source system is not relevant in the target system then you can exclude the table using the report RSCCEXPT.

70290 - CC-INFO: Excluding tables with 'RSCCEXPT'

446485 - CC-ADMIN: Special copying options

I would seek the assistance of the functional team before I exclude a set of tables in a copy.

Is there any reason why you don't want to use backup and restore ?

Regards

RB

[former_member200876 · Accepted solution]

Dear Reagan

thanks for all your help

[divyanshu_srivastava3]

Hi Ezzat,

You should take export of RFC and EDI tables and them import them back when copy is done.

Simply use R3trans -w logfile export/import file from OS level.

eg: to export RFC tables

export script with following commands - "rfc_export"

export

client=100

file ='/home/sidadm/rfc_exp'

select * from RFCATTRIB

select * from RFCDES

select * from RFCSYSACL

select * from RSECACHK

select * from RSECACTB

select * from RSECTAB

Import script with following commands - "rfc_import"

import

client=100

file='/home/sidadm/rfc_exp'

Regards,

Divyanshu

[former_member200876]

where i can type this script

kindly explain more

[divyanshu_srivastava3]

Hi Ezzat,

Create a new file and name it as export_rfc.cfg

Copy the below content to the this file and save it

export

client=(client no)

file ='/home/sidadm/rfc_exp'

select * from RFCATTRIB

select * from RFCDES

select * from RFCSYSACL

select * from RSECACHK

select * from RSECACTB

select * from RSECTAB

Now run the following command

R3trans -w export.log export_rfc.cfg

Once copy is done.

create a new import_rfc.cfg file

and add

import

client=100

file='/home/sidadm/rfc_exp'

And save it

Now run

R3trans -w import.log import_rfc.cfg

Regards,

Divyanshu

[former_member200876]

i get error it appears when i used small letters or capital letters for word " client "

[divyanshu_srivastava3]

check this link

you may made a wrong script

Regards,

DV

[former_member200876]

Dear Divyanshu

many thanks for all your assistance