topic Re: report - tcode relationship in Application Development and Automation Discussions

report - tcode relationship

Former Member — Mon, 21 Jun 2010 10:36:09 GMT

Hi,

Is there any table or FM which can find out the transaction codes associated to a report program ?

I am aware of the table TSTC, but, that's not what I am looking for as the Key field for TSTC is the transaction code and not the report name.

Regards.

Re: report - tcode relationship

Former Member — Mon, 21 Jun 2010 10:53:02 GMT

Hi,

Check the below FM:

SRT_GET_REPORT_OF_TCODE : Give the Tcode; output will be program name

SRT_FIND_TCODE_FOR_REPORT : Input Program name and get the Tcode.

Hope this helps

Regards

Shiva

Re: report - tcode relationship

former_member585060 — Mon, 21 Jun 2010 10:55:02 GMT

Hi David,

Check the Table TSTC only, it has a secondary index (001) with program name as key field. Just declare internal table with first field as program name, then when select statement is accessed it will take program name as key.

Check whether the secondary is active or not.

001 Inversion by program name

Example:-

TYPES : BEGIN OF ty_itab,
                 pgmna TYPE tstc-pgmna,
                 tcode   TYPE tstc-tcode,
              END OF ty_itab.

DATA : i_itab TYPE TABLE OF ty_itab.


SELECT pgmna tcode FROM tstc
                                   INTO TABLE i_itab
                                   WHERE pgmna = s_pgmna.

Regards

Bala Krishna

Re: report - tcode relationship

Former Member — Mon, 21 Jun 2010 11:25:41 GMT

Hi David,

you could also have a look at table TSTCP:


select * from tstcp
  where param like '%your_program_name%'.

I hope this helps. Kind regards,

Alvaro

Re: report - tcode relationship

Former Member — Mon, 21 Jun 2010 12:05:22 GMT

Used TSTC itself.

Re: report - tcode relationship

Former Member — Mon, 21 Jun 2010 13:37:52 GMT

Will not necessarily be complete.

Rob