Skip to Content
Author's profile photo Mohammed Ezzat

Copy Table content between two systems

Dear All

    Hope every SAP basis consultants / users do well . may i’m still beginner in SAP Basis world , but i think it is very good to share our knowledge between us .

Note : if you get bored of reading long articles , kindly forgive me .

one of my big issue i faced in our SAP system in copy clients , some tables not completely copied .


i searched more & more to get way do copy just the missed table contents .

finally i found away & explain it in the attach PDF

Copy Table content between two systems

How to copy table content between two systems

Source : PRD – client 900

Target :  QAS – client 701

Table : CE1ABJD

  1. Be sure that Source & target in Transport Management System – system overview ( T.code : STMS )

/wp-content/uploads/2015/11/1_835171.jpg

system overview

/wp-content/uploads/2015/11/2_835190.jpg

2. In source client Check total Table contents & statistics  ( T.code :  SA38 – Program name : RSTABLESIZE)

/wp-content/uploads/2015/11/3_835191.jpg

/wp-content/uploads/2015/11/4_835192.jpg

/wp-content/uploads/2015/11/5_835193.jpg

3. In source client create manual TR ( T.code :  SE01 )

/wp-content/uploads/2015/11/6_835194.jpg

We select the highlighted option

/wp-content/uploads/2015/11/7_835195.jpg

1 ….. for TR description

                        2 ….. for selecting target System & Client – follow the below steps

/wp-content/uploads/2015/11/8_835200.jpg

/wp-content/uploads/2015/11/9_835201.jpg

/wp-content/uploads/2015/11/10_835202.jpg

/wp-content/uploads/2015/11/11_835203.jpg

/wp-content/uploads/2015/11/12_835204.jpg

/wp-content/uploads/2015/11/13_835206.jpg

4. Double click in TR no. (ABQK900018 )

/wp-content/uploads/2015/11/14_835207.jpg

Change request

/wp-content/uploads/2015/11/15_835208.jpg

/wp-content/uploads/2015/11/16_835209.jpg

5. Enter the program name , object type , and object name as below :

                          R3TR ……….. program for copy

                          TABU ………. object for tables

                          CE1ABJD ….. table name

/wp-content/uploads/2015/11/17_835210.jpg

6. Double click in the highlighted line

  We use * for all table contents

/wp-content/uploads/2015/11/18_835211.jpg

Save , then Back

/wp-content/uploads/2015/11/19_835212.jpg

Save

/wp-content/uploads/2015/11/20_835213.jpg

Then Release

/wp-content/uploads/2015/11/21_835214.jpg

Release running :

/wp-content/uploads/2015/11/22_835215.jpg

After release finish , you should go to target client & import the mention TR. Manually .

Then Check total Table contents & statistics  ( T.code : SA38 – Program name : RSTABLESIZE) as we explained before

hope this was helpful .

kindly forgive me for bad English typing or meaning .

appreciate for all your time

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo SAP Note Display
      SAP Note Display

      Good

      Author's profile photo Elizabeth Muigua
      Elizabeth Muigua

      well done