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

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 […]

Check sso from portal to abap

You want to check if single sign on (SSO) from sap portal to abap is working Log on to portal Try to run an abap […]

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 […]

SAP erp java abap application server Enhancement Package version matrix

With last version of SAP, especially Enhancement Packages you are not quite sure any more which versions of  ERP-ABAP and Java Application Server are integrated […]

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 […]