topic Table Name for Transport Requests & Program name in Application Development and Automation Discussions

Table Name for Transport Requests & Program name

Former Member — Thu, 11 Jan 2007 20:52:45 GMT

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

Re: Table Name for Transport Requests & Program name

RichHeilman — Thu, 11 Jan 2007 20:54:12 GMT

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

Regards,

Rich Heilman

Message was edited by:

Rich Heilman

Re: Table Name for Transport Requests & Program name

uwe_schieferstein — Thu, 11 Jan 2007 21:18:37 GMT

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 but not when and where 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 TR_READ_GLOBAL_INFO_OF_REQUEST will return you very interesting data about the transport requests.

Regards

Uwe

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 03:34:12 GMT

Hi Anand

Am not sure, if you checked table: VRSD.

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: KORRNUM.

Hope this is what you are looking for...

Kind Regards

Eswar

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 03:53:32 GMT

tables - E070 and E071

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 04:00:43 GMT

check e071 and

regards

shiba dutta

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 04:08:37 GMT

Hi Amit/ Shiba

Please let me understand a way to identify the last active request of a program from table E071 apart from MAX(TRKORR) as this can be incorrect in few cases if i am not wrong.

Kind Regards

Eswar

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 04:17:57 GMT

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

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 04:43:14 GMT

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

Re: Table Name for Transport Requests & Program name

Former Member — Fri, 12 Jan 2007 05:22:56 GMT

Many thanks Shiba/Amit for sharing your thoughts.

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

Regards

Eswar