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

[kallolathome]

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.

So, I am writing this blogpost.

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.

That's all 🙂

If I have missed anything, feel free to add them in the comment section.