Easy Way to get the SAP TR/Task(Request/Task) details

Introduction

We generally use the Tcodes: SE01, SE09, SE10 for getting the transport details. The program called for all these Tcodes is RDDM0001. But, extracting the output in an excel sheet & doing some operations on them can be a difficult task sometimes.

Solution

First of all, please change the below-mentioned settings of the SE16(Data Browser) of SAP GUI.

Please follow the below steps:

1. Go to SE16
2. Enter the table name
3. Go to settings -> User Parameters
4. Select the Data Browser tab (Already selected by default) & then make the changes shown in the screenshot below.

Click the radio button of ALV Grid Display & Field Label for showing the contents of the table in the ALV Grid format & with the labels of the field names.

The field name change is optional for the developers.

There are a few standard tables provided by SAP that stores these Requests/Tasks related information. (The tables mentioned in point 4 & 5 are not of much use to a functional/technical person in general.)The names of few & their descriptions are the followings:

1. E070: Change & Transport System: Header of Requests/Tasks: If the Higher-Level Request column is empty, then the entry is for a TR else for a Task. You can filter the Requests/Tasks by Type, Status of Request/Tasks, etc.

2. E07T: Change & Transport System: Short Texts for Requests/Tasks: This table is for only a short description of the Request/Task.

3. E071: Change & Transport System: Object Entries of Requests/TasksThis table will provide you all the objects included in the requests/tasks. You can also get the status of the request/task from the status column.

You can also filter the entries by the column: Obj. (Object Type)

4. E070A: Change & Transport System: Attributes of a Request: This table is for fetching the request/task attributes.

5. E070C: CTS: Source/Target Client of Requests/Tasks: This table is for the Source/Target Client.