Skip to Content

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

Introduction

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.

/wp-content/uploads/2013/07/1_247912.jpg

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

/wp-content/uploads/2013/07/2_247919.jpg

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.

/wp-content/uploads/2013/07/3_247920.jpg

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’.

/wp-content/uploads/2013/07/4_247925.jpg

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

/wp-content/uploads/2013/07/5_247926.jpg

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.

/wp-content/uploads/2013/07/6_247927.jpg

 

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.

/wp-content/uploads/2013/07/7_247937.jpg

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

/wp-content/uploads/2013/07/8_247938.jpg

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.

/wp-content/uploads/2013/07/9_247939.jpg

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

/wp-content/uploads/2013/07/10_247958.jpg

/wp-content/uploads/2013/07/11_247959.jpg

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.

/wp-content/uploads/2013/07/12_247960.jpg

You will get below screen showing the selected data.

/wp-content/uploads/2013/07/13_247964.jpg

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’.

/wp-content/uploads/2013/07/14_247965.jpg

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.

/wp-content/uploads/2013/07/15_247966.jpg

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)

www.sdn.sap.com , http://scn.sap.com

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. NISHTHA KHANDELWAL

    Hello,

    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??

    (0) 
    1. 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.

      BR,

      Sander

      (0) 
    1. S. Bouwknegt

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

      So:

      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.

      (0) 

Leave a Reply