Locate Transport Request containing a Workflow

[Former Member]

Method 1:- Transaction SE03

 

Step 1: Click the highlighted option

Step 2:- In this screen enter the ‘PDWS’ to identify transport for workflow template or ‘PDTS’ to look for workflow task transport request.

 Workflow Template 

Enter ‘PDWS’ and check the box on left side. As soon you check the left box Description will appear automatically ‘Workflow templates’.

Enter workflow template Number In input field on right side and execute it.

Output displaying Transport details

Workflow Task 

Follow same procedure as mentioned for workflow template except Object type which will be ‘PDTS’ here.

Output displaying Transport details

 

Method 2:- Custom report to display transport details in bulk.

 

This report will display all transport details for workflow templates and workflow task in bulk. We have select options to enter multiple workflow template numbers or task number to get details in consolidated form. This report also displays high level transport request under which all other workflow objects are created 

Step 1:- Execute report ZWF_TRANSPORT.

 

Output displaying transport details

 

*************************************************

Source Code

************************************************

*&---------------------------------------------------------------------*
*& Report  ZWF_TRANSPORT
*&
*&---------------------------------------------------------------------*
*&
*& REPORT  zwf_transport.
*& Author : Anil Kumar Raina
*&---------------------------------------------------------------------*

REPORT  zwf_transport.
INCLUDE zwf_transport_top.

SELECTION-SCREEN: BEGIN OF BLOCK b1 WITH FRAME TITLE text-100.
SELECT-OPTIONS : p_task FOR e071-obj_name.
SELECTION-SCREEN: END OF BLOCK b1.

INITIALIZATION.
  %_p_task_%_app_%-text = 'Workflow OR Task Number'.

START-OF-SELECTION.

  SELECT e071~trkorr
         e071~obj_name
         e07t~as4text
         e070~as4date
         e070~strkorr
         INTO TABLE t_final
              FROM  e071
              INNER JOIN e07t ON e071~trkorr = e07t~trkorr
             INNER JOIN e070 ON e070~trkorr = e07t~trkorr
              WHERE e071~obj_name IN p_task
                AND ( e071~object = 'PDTS' OR
                      e071~object = 'PDWS').

  IF sy-subrc <> 0.
    EXIT.
  ENDIF.

  w_fieldcat-fieldname   = 'TRKORR'.
  w_fieldcat-seltext_m   = 'Request/Task'.
  w_fieldcat-col_pos     = '1'.
  APPEND w_fieldcat TO t_fieldcat.

  w_fieldcat-fieldname   = 'OBJ_NAME'.
  w_fieldcat-seltext_m   = 'Workflow/Task Number'.
  w_fieldcat-col_pos     = '2'.
  APPEND w_fieldcat TO t_fieldcat.

  w_fieldcat-fieldname   = 'AS4TEXT'.
  w_fieldcat-seltext_l   = 'Transport Description'.
  w_fieldcat-col_pos     = '3'.

  APPEND w_fieldcat TO t_fieldcat.

  w_fieldcat-fieldname   = 'AS4DATE'.
  w_fieldcat-seltext_m   = 'Last change Date'.
  w_fieldcat-col_pos     = '4'.
  APPEND w_fieldcat TO t_fieldcat.

  w_fieldcat-fieldname   = 'STRKORR'.
  w_fieldcat-seltext_m   = 'Higher-Level Request'.
  w_fieldcat-col_pos     = '5'.
  APPEND w_fieldcat TO t_fieldcat.

  w_layout-no_input          = 'X'.
  w_layout-colwidth_optimize = 'X'.

  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'
    EXPORTING
      i_callback_program = 'ZWF_TRANSPORT'
      i_grid_title       = 'Identify Worfklow Transport'
      is_layout          = w_layout
      it_fieldcat        = t_fieldcat
    TABLES
      t_outtab           = t_final
    EXCEPTIONS
      program_error      = 1
      OTHERS             = 2.
  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.