Answer / davidm

Use the following procedure to copy table contents between
two clients:

After verifying the client copy log, due to some storage
probslems in table MOFF, this table could not be completely
copied. To avoid having to perform the whole client copy
process, just hte entries on table MOFF from the source
client will be copied to the table MOFF on the target client
010 in thte target system T12.

1. In the source system (C12), create a control file, for
example, expmoff.ctrl with the following contents:

export client
select * from moff where mandt = '002".

2. Run the R3trans utility with the previous control file:

R3trans -w expmoff.log -u 18 expmoff.ctrl

The -w flag indicates the log file, the -u flag sets
unconditional modes for the transport. In the export
phonase, unconditional mode 1 indicates the system to ignore
the wrong status of transport requests.
Mode 8 allows direct selection of tables when the default
modes are not allowed. By default, the previous command
generates the data file trans.dat in the directory where the
export has been executed. If both source and target systems
share the transport directory, it wont be necessary to copy
the trans.dat file. Otherwise you must use ftp.

3. Check the export log file, expmoff.log and verify it did
not contain any errors.

4. Once in the target system, create the import control
file, for example impmoff.ctrl with the following content:
import client

5. Then execute it with the R3trans tool: R3trans -w
impmoff.log -u 248 impmoff.ctrl

By default it uses the data file trans.dat generated by the
previous commnad file. The unconditional modes used in the
import phase are :

2 for enabling the overwriting of the original, 4 which
ignores that the transport request was intended for a
different target system, and

8 which allows for importing tables which are restricted by
their table types. If you use the default options for the
import, you do not need a control file.

The import can be performed directly with R3trans -i <file>.

6. Check the import log file, impmoff.log to check that the
import runs fine without errors. You can also log on to the
target client, 010, in the target system and look up the
table contents with se16.

THX..... DAVIDM.

How u will apply OCS patches? If a user wants to execute a background job immediately but there is no Background work process available. How u will do? How you will do client copy? If SAP * user is not available at all in your system then how u will do client copy?

8 Answers   Bosch, IBM, Infosys,

---

What is your organization’s security philosophy? What level of security does your data require? How much risk are you willing to assume in each application area?

0 Answers  

---

What are the port nos of Dispatcher,Gateway, Message Server, Printer in windows,niping,Router ?

10 Answers   IBM,

---

What is the state of Processes once it is started?

5 Answers  

---

During backup what kind of files you take?

1 Answers  

---

there are 500 users logged into the sap system, the system goes down and one cannot login using sapgui. Whyen check the workprocess from dpmon the dialog workprocesses are free. what action does one take as basis consultant

12 Answers   IBM,

---

What are common background jobs that will run in your system?

0 Answers  

---

Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?

0 Answers   IBM,

---

hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me

2 Answers  

---

If a background job runs more than the time it should be completed normally then what actions will u take?

0 Answers  

---

steps to congigure CMS in XI ?

0 Answers  

---

How you will rate yourself in SAP, Oracle from a scale 1 - 10?

0 Answers  

---