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!
Good one @ Kallol Chakraborty
Is there any standard option offered by SAP, which can limit the number of tasks appended to a TR. As far as i knew, there is no limit, but is it possible to limit it like no more than 10 tasks entitled under one TR.
Kindly provide your views if you have came across this.
Many thanks
Br,
Irfan