01-11-2007 8:52 PM
Am looking for a table that stores the details like
1. The program name
2. The details of the last active transport for that program.
Please be specific with your answer as I have already gone through the likes of E070, TRDIR, TADIR etc.
Anand
01-11-2007 8:54 PM
01-11-2007 9:18 PM
Hello Anand
The you will find the description of reports in table TRDIRT (text table of TRDIR). As Rich already mentioned you will find in E070 and E071 the transport requests in which the reports were included.
However, this data only show when a request was released <b>but not when and where</b> it was imported to other systems.
In order to gain these information please refer to my answer in thread
<a href="https://forums.sdn.sap.com/click.jspa?searchID=708104&messageID=2473030">Exception Report</a>
The function module <b>TR_READ_GLOBAL_INFO_OF_REQUEST</b> will return you very interesting data about the transport requests.
Regards
Uwe
01-12-2007 3:34 AM
Hi Anand
Am not sure, if you checked table: <b>VRSD</b>.
Check the entry by passing the details as below:
1. OBJTYPE = 'REPS'.
2. OBJNAME = <Report Name>
3. VERSNO = '00000' --> Via SE16 you should check as = SPACE.
This will give the active/latest released request number in field: <b>KORRNUM</b>.
Hope this is what you are looking for...
Kind Regards
Eswar
01-12-2007 3:53 AM
01-12-2007 4:00 AM
01-12-2007 4:08 AM
Hi Amit/ Shiba
Please let me understand a way to identify the <b>last active request of a program</b> from table E071 apart from MAX(TRKORR) as this can be incorrect in few cases if i am not wrong.
Kind Regards
Eswar
01-12-2007 4:17 AM
yes eswar you are correct only but why should we go for max if we see the table contents in alv list or grid display mode we can sort in descending order then we can get the first request as the max. But here also problem is there because it is a character field. But let us hope for the best.
regards
shiba dutta
01-12-2007 4:43 AM
agreed with shiba and
eswar ,in table VRSD ..u can use the field LASTVERSNO to find out the lates active request..select max( LASTVERSNO )..
Amit Tyagi
01-12-2007 5:22 AM
Many thanks Shiba/Amit for sharing your thoughts.
For a moment, i was wondering if i am lost(wrong)...:)
Regards
Eswar