Skip to Content
Author's profile photo Former Member

Step By Step Guide to Transport Table Contents from One Environment to Other in SAP

Step By Step Guide to Transport Table Contents from One Environment to Other in SAP


SAP Structure:

A typical SAP project will have three environments namely

1.    Development: In this environment we develop new objects or make changes to the existing object.

2.    Quality: In this environment we will test functionality of the developed or changed object.

3.    Production: In this environment actual business processing takes place. Real (Live) data of the company’s business available here.

Transport Request Overview:

SAP uses Transport concept to move the changes or objects from environment to another. We have T-CODES SE01 (Transport Organizer – (Extended View)), SE10 or SE09 (Transport organizer) for creating a transport requests.

To Import transport Request we use T-CODE STMS (Transport Management System)

When do we use transport request for transferring data from table in one environment to another environment?

We use transactions se11 and se16 for table content display and for maintenance of table like inserting or deleting values in the table.

In some cases we will not have maintain access on the table in environment say Quality Or Production and we need some values in that table to be maintained.

In such case we use transport request to move the contents of the table from the development environment to quality.

How do we transport the table contents?

To transfer the contents of the table we create a new transport request and move it.

Below is the step-by-step guide to transport the contents. Follow the below steps.

Step 1:

Go-to transaction code SE10 or SE09 (Transport Organizer).

Click on ‘create’ button which is highlighted in below screenshot.


You will get the below screen select the workbench request and click on ‘Tick’ symbol or ‘enter key’.


You will get a window where you have to select the request type. Select ‘Workbench request’ radio button and click check button.

Once you click ‘check button’ the transport gets created you will get the below screen.


We can see that a task ‘BWDKA0JJD’  of type ‘Unclassified’ is created under the request ‘BWDKA0JJC’.We should change the type to ‘Development/Correction’ in order to capture changes into it.

To do this select the Task and go-to Request/Task and select the option ‘Change Type’ you get below screen. Select ‘Development/Correction’.


Now the Task type will be changed and will be displayed as below.


Now double click on the Task of the Transport request. You will be directed to the below screen.

Now click on the change<->Display button highlighted in the below screenshot.



You get the following window. Now give the values as follows

Program id: R3TR

Object Id: TABU (this is for table)

Object name: Give the name of the table from which you need to transport the entries.


Now click on the ‘display object list’ button you will get the below screen and then click on new values.


Now click on the key like symbol (Function key) highlighted in the above screenshot.

The below screen will appear. Now double click on the space (yellow colored) in the below screen.


The below screen will appear showing the key figures of that table. Give value for key figure and press enter.



Now you can check for the entries that would be transported as per the given condition, by clicking on the table content button highlighted in the screenshot above.

Select the display Table content option as per your requirement.

Entire Table: This option will display all table contents.

Table contents specified by request: content specified by selection.

Table contents specified by current key: this option will display the records having the current key value.


You will get below screen showing the selected data.


Click on back button and click on the save button. You will get a warning message shown in below screenshot. Ignore the message and click ‘Yes’.


Once clicked ‘yes’ object list will be created for the transport. You can see that the table contents are captured in the ‘Object list of the Transport’ when you display the transport. Please see the below screenshot.


Now you can transport this request to the target environment Remember while releasing the transport first release the task (Highlighted in above screenshot) and then the main Request/Task.

To import the request go to STMS transaction select the Transport request and import it.

In this way we can achieve this activity.

Reference(s) ,

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo NISHTHA KHANDELWAL


      I have one query - By using this method to Transport Table Contents from like quality to production, the content of quality's table will replace the whole content of production's table or it will be appended i.e will add content to the existing table of production??

      Author's profile photo S. Bouwknegt
      S. Bouwknegt

      Hy Nishtha,

      If you use this, the whole contents will be replaced.
      Every entry in the target system which is matched to the given condition (in this case everything) will be replaced by the entries in the source system.

      Only entries in the target system which do not match the given selection will stay in the target system as is.



      Author's profile photo madhukar manda
      madhukar manda

      Nice deck from you Ramesh Pagidala 🙂

      Author's profile photo NISHTHA KHANDELWAL

      And what about the entries which is in source system but not in target system??

      Author's profile photo S. Bouwknegt
      S. Bouwknegt

      If the entry in the source system is within the given selection, it will be taken over.


      1. In the target system all entries match the condition are removed.

      2. The target system will be filled with the entries from the source system which match the condition.

      This means that entries in the source system which does not match the selection, will not move to the target system.

      Author's profile photo Bhavesh Jain
      Bhavesh Jain

      Thank you. It was helpful.


      Author's profile photo Damola Agbelusi
      Damola Agbelusi


      I have a scenario where entries can be maintained directly in production. And I have a transports in Test with two new entries which I have just maintained (I didn't realise I could maintain directly in Prod). When this transport gets into Prod will it override every VKOA data in Prod or just the new entries I have maintained

      Author's profile photo Bhavesh Jain
      Bhavesh Jain

      Very Helpful

      Author's profile photo Former Member
      Former Member

      Simple and clear. Good job