SCCL - Table export/import

[former_member201054]

Hi,

Perfoming local copy(SCCL) with few tables exclusion..

now need to export tables from the source client A and import into target client B.

Please tell me the procedure to follow for both..

1. Excluded tables export with transport from source client A  --- where files will get stored at OS level?

2. Excluded tables import with transport into target client B    -- how to do this?

guide me for exact procedure

I will appreciate it

Thanks a ton

[ahmed_ibrahim2]

Hi Daniel,

Perfoming local copy(SCCL) with few tables exclusion..

if you are performing the local Client copy, it is not required to save the exported file on OS Level, just you create new client by using SCC4 T-code

login to new client by using SAP* or any other authorized user  if the client Exist before

run SCCL T-code

Goto Edit Menu ==> Expert settings

go to  Table TAB and insert the tables Name to be Excluded

back

Start immediately or in Background 

---

if it is not local copy you can use SCC9 (EXPORT/IMPORT) T-code

Goto Edit Menu ==> Expert settings

go to  Table TAB and insert the tables Name to be Excluded

start

you will find the Transport Request in the following Directory

/usr/sap/trans/datafile

/usr/sap/trans/cofile

Best Regards

AhMeD

[former_member188883]

Hi Daniel,

For your query 1:

Tables can be excluded using the expert settings option in SCCL. See details below.

Improving client copy performance: Excluding data

1. You can improve the performance of the client copy by, for example, by excluding tables or packages, with Edit → Expert Settings.

You can exclude tables from the client copy, for example if they are not relevant for the target client, in the Tables tab. For further information about excluding tables from the client copy, choose the Help button in the expert settings.

For further information about expert settings in the client copy, see the SAP note 446485.

For your query 2:

You may use R3trans utility to export client specific data from excluded tables and import the same into the target client.

Refer steps in the link http://www.erwinki.com/2011/11/copy-table-using-r3trans.html

Hope this helps.

Regards,

Deepak Kori