Technical Articles
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.
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:
- Go to SE16
- Enter the table name
- Go to settings -> User Parameters
- 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:
- 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.
- 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.
- 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.
Well, and not forget to mention table E071K which is my favourite table in transport requests :).
I think this table is the fastest way to find out if/when a certain customizing entry has been changed.
e.g. "when was the customizing for delivery type ZLF changed?" ->
voilá:
That is a nice alternative when configuration tables change logs are off. I'd rather have them on.
BR
Dominik Tylczynski
Additionally: E070CTV which is a view over E070, E07T and E070C
Thanks for sharing! Every time I go into the transport-related transactions I think how outdated they are and how difficult to use at times. We shouldn't need to use such work-arounds.
IMO, the easiest way to find objects in TRs or finding TRs in general is to use the transaction SE03 (Transport Organizer Tools).
The tools which i use often are:
Why do you prefer using the workaround(s) over these standard reports?
Thanks for checking out my blog post Suhas Saha
I think these reports are outdated that's why I am going for the workarounds.Â
If you know the tables then, you are having better flexibility over these tcodes when it comes to extraction & manipulation.
Â
Why "outdated"? If SE03 is outdated, then all SAP reports are outdated too... I think that options not available in SE03 are more valid arguments to look directly tables (like searching transport requests by table key in table E071K).
Dear Sandra Rossi & Suhas Saha,
Thank you for checking out my blog post. My intention is not to hurt the sentiments
By these reports, I wanted to mean SE01, SE09 & SE10, not SE03. I think this has been misunderstood.
At sometimes, I find these reports challenging to extract particular information in excel so, I came up with this workaround.
Please treat this post as just a piece of information, not an essential thing. ?
Many people access SE03 via SE01, SE09 & SE10 without knowing it's SE03. The button "Tools" is just at the top of the initial screen of each transaction.
Sentiments? Not me, I discuss facts :). The fact is that it's nice to have blog posts who tell people what tools exist to search transport requests, and the limits, and the workarounds 😉
Sandra has resonated my sentiments.
The use cases you have presented in your blog can be fulfilled using SE03 reports. No need to manually extract & manipulate the E07* data.
This small tutorial is really helpful. Thanks for sharing this!