how can we transport one or two tables in client copy from
one client to another client?
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
While applying support patch or importing DDIC will get stuck what you do?
Where will you change the parameters in three profiles?
Last step of kernel upgrade in unix Root.sh?
what are authorisation object?tell me any five.
What is Consolidation route and delivery routes?
How do you create a password exception list?
Hi , Can any one tell me , How to take back up to local disk . And also tell me where i need to change the parameters to take back up , please give me the list of parameters and appropriate values. Please provide me the steps to take back up.......
What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?
How to login in to SAP from command level?
does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.
Have you done load balancing?
how to increase table space in brtools?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)