Skip to Content

This post is for checking the

Transport Requests

moved to

Other Systems

from

Development System


with the execution of program in SE38 of the Dev System.

The list is displayed in ALV format and one can know the
status of a Transport Request. The concept of RFC comes into picture

wherein the Function Module

TMS_TM_GET_TRLIST

is been used for
the retrieval of the status of the Request Numbers.

On the

selection screen

the variables like

Request/task

&

Type of Request/task

&

Status of Request/task

&

Request or task category

are been
declared as Select-Options.

select-options:

s_trkorr for e070-trkorr,

s_trfunc for e070-trfunction,

s_trstat for e070-trstatus,

s_kdev for e070-korrdev.

Various additional variables & field-symbols &
internal tables need to be declared for use within the program.

1) Using

Select

statement the Transport Request details are

been fetched from database based on the Selection-Screen details.

2) The

field catalog

list should be prepared for various fields

which will be used at the time of displaying the report.

3) The code for the same is as below…

4) SELECT atrkorr bas4text atrfunction atrstatus a~korrdev

aas4user aas4date a~as4time

cmandt csourcemand ctstamp cfinal_stat

FROM e070 AS a JOIN e07t AS b ON atrkorr = btrkorr AND b~langu =

syst-langu

LEFT OUTER JOIN cccflow AS c ON atrkorr = ccomfile INTO

CORRESPONDING FIELDS OF

TABLE i_getlist WHERE atrkorr IN s_trkorr AND atrfunction IN

s_trfunc

AND atrstatus IN s_trstat AND akorrdev IN s_kdev AND a~strkorr =

space.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Stephen Johannes
    Quick question:

    Can you explain to me the advantages of using this example program instead of SE01?  The logs in SE01 provide everything that would be desired about a transport?

    Thank you,

    Stephen

    (0) 
    1. Anonymous
      Say, we have 1000 requests and we want to see what are the status of all the requests. From SE01 we can see the request log one at a time.
      But, this report can be used which is displayed as an ALV and can see all 1000 requests in the ALV at one time.
      I have just shown for 1 client whereas in our last project we have implemented for almost 9 clients.

      Even, the users can check the report. The thing is some of them will not have access to either SE01 or SE09.

      (0) 
  2. Michael Nicholls
    A lot of system administrators want to write their first ABAP program and often end up trying to do things similar to this. I know I did! Back in 3.0 days when TMS wasn’t as sophisticated, I played around with similar reports.

    Here are a few suggestions:

    You might want to add a checkbox list of remote systems to access for checking the logs. That way the user can select the systems themselves.

    It could alse be useful to have some other selection criteria, such as by request owner,as this is often what a developer wants to see, and some date ranges etc.

    Once a line is selected from the ALV, it should launch the appropriate transaction to see the log files..

    Cheers

    (0) 
    1. Anonymous
      U can have as many feasible fields as u can in the selection-screen fields option. This way U can use them in fetching of data.

      Tofind request owner once the ALV is displayed, U can sort the list over the request owner. This way u can check the owner request one by one but all at a time.

      (0) 

Leave a Reply