12-12-2013 6:23 AM
Hi,
As we know, when we create any TR to move any development from Dev server to quality server all these TR request can be seen from SE09.
My question is --- Is it possible to write some report which will take a date range as a input and show all the TRs generated on that period of time.
If possible could you please help me to write it . As I am working in SAP PI/XI module, I dont have in depth idea about ABAP coding.
Thanks in advance.
12-12-2013 6:35 AM
Hi,
Not sure about your requirement.
but You can check table E070CREATE / E070 & then for 1st table you can give
CRE_DATE range & for 2nd table AS4DATE range & will get TR Number.
Check it.
Thanks
Gourav.
12-12-2013 6:32 AM
Hi ,
Y do you want to write a program for that ? You want to check all the TR's for a particular date range ,is it? Then go the the table - E070.. there u can give a date range or user and many more .
simple give your date range and get the results .
Thanks & Regards ,
Shiv
12-12-2013 6:33 AM
12-12-2013 6:35 AM
Hi,
Not sure about your requirement.
but You can check table E070CREATE / E070 & then for 1st table you can give
CRE_DATE range & for 2nd table AS4DATE range & will get TR Number.
Check it.
Thanks
Gourav.
12-12-2013 6:44 AM
12-12-2013 7:22 AM
Hi Apu,
You can get the required data from E070/E071/E07T dictionary tables.
Or use the tool mentioned in following link
Regards,
Sheetal.
12-12-2013 7:58 AM
or even simpler, just use the standard reporting. From SE09 menu choose "Goto -> Transport Organizer Tools" and then "Find Requests" from the tree.
Thomas
12-12-2013 8:53 AM
12-12-2013 9:15 AM
Hi Apu,
There is option to see the all the TR's for a particular date range in the standard Tcode i.e SE03.
If you really need the custom report then this is not the right option.
Best regards
Kris
12-12-2013 9:30 AM
Hi Apu Das,
There is a table in SAP which contains all the TR in it with the date .
Table : E070
Short Description : Change & Transport System: Header of Requests/Tasks.
Below is a screenshot for your convenience.
Hope this will help you.
Regards
Rounak
12-12-2013 11:20 AM
Three or four people suggested E070 already, plus this is available as standard report (see above), just what makes you suggest E070 once again? Are you not reading all previous posts before replying?
Thomas
12-12-2013 7:50 PM
Thomas, but this one is "new and improved" with a screenshot! Perhaps OP would have trouble finding it otherwise.
(Sorry, couldn't resist!)
12-13-2013 5:53 AM
12-13-2013 6:09 AM
Hi Apu,
Glad to know its solved your problem.
Can you mark it answered so as to close the discussion and it'll be easily searched when someone else encounters same problem.
Thank you in advance.
Regards,
SHeetal.