In the R/3 transport management system you can find a lot of
information about transports, but a list with the status (import
date/time) of transports for the development system, quality system and
production is hard to build from standard SAP. So i have created a
Z-program for it.

The basic part of the program is the data retrieval from the relevant tables and using the relevant function modules :

• Function modules:
  
  1.  STRF_READ_COFILE : Read and interpret contents of the COFILE

The select-options for my report are :

1. S_TRKORR (type E070-TRKORR) : transport request or task id
2. S_AS4TXT
   (type E07T-AS4TEXT) : transport request or task description (transports
   description belonging to project starts with project relevant prefix,
   so we can select easily all project related transports)

The following systems are uses :

1. DEV for development
2. QAS for quality
3. PRD for production 

The code for the data retrieval is :

FORM get_data CHANGING pi_output TYPE tt_output.

<br /> DATA: li_output2 TYPE tt_output,<br /> lwa_output LIKE LINE OF li_output2,<br /> li_cofi_lines TYPE TABLE OF tstrfcofil,<br /> lwa_cofi LIKE LINE OF li_cofi_lines.<br /> 1. get all relevant transport request/task based on select-options<br /> SORT li_cofi_lines BY tarsystem trdate trtime.<br /> get first DEV date/time in the log