Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Table Name for Transport Requests & Program name

Former Member
0 Kudos

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

9 REPLIES 9

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

How about E071? PGMID will give you the program name.

Regards,

Rich Heilman

Message was edited by:

Rich Heilman

uwe_schieferstein
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

tables - E070 and E071

Former Member
0 Kudos

check e071 and

regards

shiba dutta

0 Kudos

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

0 Kudos

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

0 Kudos

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

0 Kudos

Many thanks Shiba/Amit for sharing your thoughts.

For a moment, i was wondering if i am lost(wrong)...:)

Regards

Eswar