cancel
Showing results for 
Search instead for 
Did you mean: 

Recommended table to exclusive in copy client

former_member200876
Active Participant
0 Kudos

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 ?

Accepted Solutions (1)

Accepted Solutions (1)

ACE-SAP
Active Contributor

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
Active Participant
0 Kudos

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
Active Contributor
0 Kudos

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
Active Participant
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
Active Participant
0 Kudos

Dear Reagan

thanks for all your help

Answers (1)

Answers (1)

divyanshu_srivastava3
Active Contributor
0 Kudos

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
Active Participant
0 Kudos

where i can type this script

kindly explain more

divyanshu_srivastava3
Active Contributor
0 Kudos

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
Active Participant
0 Kudos

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

divyanshu_srivastava3
Active Contributor
0 Kudos

check this link

you may made a wrong script

Regards,

DV

former_member200876
Active Participant
0 Kudos

Dear Divyanshu

many thanks for all your assistance