Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

report - tcode relationship

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

former_member585060
Active Contributor
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

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

former_member585060
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

Used TSTC itself.

0 Kudos

Will not necessarily be complete.

Rob