Skip to Content
avatar image
Former Member

report - tcode relationship

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 21, 2010 at 10:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 10:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 11:25 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 21, 2010 at 12:05 PM

    Used TSTC itself.

    Add comment
    10|10000 characters needed characters exceeded