REPORT YTEST.

data : gv_func_module_name type rs38l_fnam,
   gs_control_parameters type ssfctrlop,
   gs_output_options type ssfcompop.

constants: cn_form(30) value 'YTEST'.


parameters: pa_prm1 type c length 30.
parameters: pa_prm2 type c length 30.


call function 'SSF_FUNCTION_MODULE_NAME'
   exporting
      formname = cn_form
   importing
      fm_name = gv_func_module_name
   exceptions
      no_form = 1
      no_function_module = 2
      others = 3.
if sy-subrc <> 0. exit. endif.

gs_control_parameters-preview = 'X'.
gs_output_options-tdnewid = 'X'.
gs_output_options-tddelete = 'X'.
gs_output_options-tdimmed = 'X'.

call function gv_func_module_name
   exporting
      control_parameters = gs_control_parameters
      output_options = gs_output_options
      user_settings = ' '
      pa_param1 = pa_prm1
      pa_param2 = pa_prm2
*   tables
*      gi_ytest = gi_ytest
   exceptions
      formatting_error = 1
      internal_error = 2
      send_error = 3
      user_canceled = 4
      others = 5.

create proc sp_lock2
as select * from (
SELECT
s.spid,
s.blocked,
DB_NAME(s.dbid) DatabaseName,
s.program_name,
s.loginame,
OBJECT_NAME(s.dbid) ObjectName,
CAST(text AS VARCHAR(MAX)) SQL

FROM
sys.sysprocesses s
CROSS APPLY
sys.dm_exec_sql_text (sql_handle)
where blocked <> 0

union all


SELECT
s.spid,
s.blocked,
DB_NAME(s.dbid),
s.program_name,
s.loginame,
OBJECT_NAME(s.dbid),
CAST(text AS VARCHAR(MAX))
FROM
sys.sysprocesses s
CROSS APPLY
sys.dm_exec_sql_text (sql_handle)


where spid in (
SELECT
s.blocked
FROM
sys.sysprocesses s
CROSS APPLY
sys.dm_exec_sql_text (sql_handle)
where blocked <> 0 )

) B order by spid

REPORT ysanto_11 .

TABLES : tstc, tadir, modsapt, modact, trdir, tfdir, enlfdir.
TABLES : tstct.

DATA : jtab LIKE tadir OCCURS 0 WITH HEADER LINE.
DATA : field1(30).
DATA : v_devclass LIKE tadir-devclass.

PARAMETERS : p_tcode LIKE tstc-tcode OBLIGATORY.

SELECT SINGLE * FROM tstc WHERE tcode EQ p_tcode.

IF sy-subrc EQ 0.

SELECT SINGLE * FROM tadir WHERE pgmid = 'R3TR' AND object = 'PROG' AND obj_name = tstc-pgmna.

MOVE : tadir-devclass TO v_devclass.
IF sy-subrc NE 0.

SELECT SINGLE * FROM trdir WHERE name = tstc-pgmna.
IF trdir-subc EQ 'F'.

SELECT SINGLE * FROM tfdir WHERE pname = tstc-pgmna.
SELECT SINGLE * FROM enlfdir WHERE funcname = tfdir-funcname.

SELECT SINGLE * FROM tadir WHERE pgmid = 'R3TR' AND object = 'FUGR' AND obj_name EQ enlfdir-area.

MOVE : tadir-devclass TO v_devclass.
ENDIF.
ENDIF.

SELECT * FROM tadir INTO TABLE jtab WHERE pgmid = 'R3TR' AND object = 'SMOD' AND devclass = v_devclass.

SELECT SINGLE * FROM tstct WHERE sprsl EQ sy-langu AND tcode EQ p_tcode.

FORMAT COLOR COL_POSITIVE INTENSIFIED OFF.

WRITE: /(19) 'Transaction Code – ',
20(20) p_tcode,
45(50) tstct-ttext.

SKIP.

IF NOT jtab[] IS INITIAL.

WRITE:/(95) sy-uline.
FORMAT COLOR COL_HEADING INTENSIFIED ON.
WRITE:/1 sy-vline,
2 'Exit Name',
21 sy-vline ,
22 'Description',
95 sy-vline.
WRITE:/(95) sy-uline.

LOOP AT jtab.
SELECT SINGLE * FROM modsapt WHERE sprsl = sy-langu AND name = jtab-obj_name.

FORMAT COLOR COL_NORMAL INTENSIFIED OFF.
WRITE:/1 sy-vline,
2 jtab-obj_name HOTSPOT ON,
21 sy-vline ,
22 modsapt-modtext,
95 sy-vline.
ENDLOOP.

WRITE:/(95) sy-uline.
DESCRIBE TABLE jtab.

SKIP.

FORMAT COLOR COL_TOTAL INTENSIFIED ON.
WRITE:/ 'No of Exits:' , sy-tfill.

ELSE.

FORMAT COLOR COL_NEGATIVE INTENSIFIED ON.

WRITE:/(95) 'No User Exit exists'.

ENDIF.

ELSE.
FORMAT COLOR COL_NEGATIVE INTENSIFIED ON.
WRITE:/(95) 'Transaction Code Does Not Exist'.
ENDIF.

AT LINE-SELECTION.
GET CURSOR FIELD field1.
CHECK field1(4) EQ 'JTAB'.
SET PARAMETER ID 'MON' FIELD sy-lisel+1(10).
CALL TRANSACTION 'SMOD' AND SKIP FIRST SCREEN.