SAP Online Portal

Latest SAP News, Solutions, Error Codes, Help Files, Jobs, Documentations, Articles

Exporting and importing sap tables with controlfile

Exporting client

In order to export sap tables, create a controlfile (under /usr/sap/trans/bin/controlfile_export) with following content.


client = 500

file = export_file

select * from VARI

select * from VARID

select * from VARIT

select * from VARIS

select * from VARINUM

and execute following command

R3trans -w /usr/sap/trans/bin/vari_exp.log -u 1 /usr/sap/trans/bin/controlfile_export


In order to import the exported tables into target client, create a controlfile /usr/sap/trans/bin/controlfile_import with the following content


client = 500

file = export_file

execute following command on target system.

R3trans -w /usr/sap/trans/bin/vari_imp.log -u 1 /usr/sap/trans/bin/controlfile_import

Leave a Reply

Your email address will not be published.

Related topics

Language Import

The language import must always be performed in client 000. The supplementation must first be performed in client 000 and can then be scheduled in […]

How to remove a cloned resource adapter in sap pi system

Case You have created or cloned a resource adapter in SAP PI system and now want to remove it. But delete button is not active […]

How to get latest SAP news and messages by whatsapp

How to get latest SAP news, technology developments in WhatsApp ? Whatsapp is not an only messaging platform any more. More and more vendors, software […]

How to lock unlock SDCCN

You want to lock or unlock SDCCN In SE38 run report /BDL/SETUP  (BDLSETUP) with the following parameters: KEY = LOCKED VALUE = space(unlock) oder X […]

Delete source systems in RSA1 after BW system copy

Case  You want to delete all source systems in BW system after a system copy Solution  1. Go to Transaction SE16 – table RSBASIDOC to […]