Step By Step Guide to Transport Table Contents from One Environment to Other in SAP
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.
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.