how to show all transport orders with all system

[Former Member]

Hi

I want develop in abap a programm who show in ALV all order transport and ALL system they have been and they are like DVS QAS PRS ...

Iin ALV with the table e070, I can show transport order but how show other collumn for know if one of transport order like 'DCDK907673' have been in DVS, PRS and now it is in QAS

I use the directory /usr/sap/trans/DCD/log for look all transaction order and all system

There is any another directory or table for know this?

THX FOR REP

[former_member186052]

Thanks Pradeep for referring this to me.

Hi Guillaume,

You can use the function module TR_READ_GLOBAL_INFO_OF_REQUEST.

The code would be

S_tport is select option on screen with transport number.

INITIALIZATION.

  ls_settings-point_to_missing_steps = 'X'.

  ls_settings-detailed_depiction = 'X'.

START-OF-SELECTION.

  LOOP AT s_tport.

    CALL FUNCTION 'TR_READ_GLOBAL_INFO_OF_REQUEST'

      EXPORTING

        iv_trkorr   = s_tport-low

        iv_dir_type = 'T'

        is_settings = ls_settings

      IMPORTING

        es_cofile   = ls_cofile

        ev_user     = gv_user.

    wa_log-tport = s_tport-low.

    wa_log-tlog  = ls_cofile.

    APPEND wa_log TO it_log.

    CLEAR: wa_log, ls_cofile.

  ENDLOOP.

Your IT_LOG table will have the entire transport log.

If the field TLOG-IMPORTED in the IT_LOG table is initial then "TRANSPORT IS NOT YET RELEASED".

in IT_LOG for each record, check TLOG-SYSTEMS nested table. That should be able to help you in getting the release details for each system.

Hope this helps.

Regards,

Sandeep

[Former Member]

not working Sandeep sry

I search always I fond only transaction history in directory /usr/sap/trans/DCD/log

I dont find the right table

[Former Member]

Hi Guillaume,

If I understand you correctly you are looking for a output which you provide you info on which systems  the transport request has been imported? Something like the below:

Transport request          DEV                        QAS                    PRD

DCDKXXXXX1               Released               Imported                Imported

DCDKXXXXX2               Not Released     Not imported          Not Imported

DCDKXXXXX3               Released               Imported               Not imported

Please confirm if my understanding the requirement is correct so that we could guide you in the right path.

Regards,

Pradeep

[Former Member]

THIS IS EXACTLY WHAT I need

Have you any solution?

[Former Member]

Hi Guillaume,

I am not sure of the solution. But I know someone who worked on this before.

I will check with them and will update you.

Regards,

Pradeep