retrieving zprograms

[Former Member]

Hai

i have the table TADIR having all the program names.

can anyone tell me what is the condition that i have to put to retrieve program names starting with "Z".

\[removed by moderator\]

Edited by: Jan Stallkamp on Jun 23, 2008 6:28 PM

[Former Member]

write select on TADIR where OBJ_NAME like 'Z%' or

OBJ_NAME = 'z%'.

[Former Member]

Use PGMID = R3TR

OBJECT = PROG

obj_name = z*

Regards,

Kiran Bobbala

[Former Member]

Hi

in my report i am able to display zprograms now how can idisplay respective t-codes.

can anyone tell me the select stmnt r condition please

[Former Member]

Hi,

for each program name u can fetch its transaction codes from table TSTC.

[Former Member]

Hi,

use the table TSTC

here u can specify the progname and fetch the TCODE

Cheers,

Sai

[GauthamV]

hi,

u can get respective tcodes for ur programs from TSTC table if provided tcodes r created for them.

write select statement for this table based on program name.

[Former Member]

hi

i have written the following select statement to retrieve z programs and corresponding tcodes but its not giving any result.in debugging mode internal table is not having any data.

select tcode pgmna from tstc into table it_itab where pgmna = 'z%'.

can anyone correct my select statement please

[JozsefSzikszai]

hi Ravi,

the WHERE condition has to look like:

select tcode pgmna from tstc into table it_itab where pgmna LIKE 'Z%'

(instead of = or EQ)

hope this helps

ec

[Former Member]

Hi,

from your first question its like u already have the programnames..

so give your select as follows..

select tcode pgmna from tstc into table itab for all entries in (previous table where u have fetched the progname)

where pgmna = forallentries table-program name.

Cheers,

Sai

Edited by: Saikumar on Jun 24, 2008 8:34 AM

[Former Member]

hi

thanks alot. ur help was valuable.

[JanStallkamp]

Hi.

Ok, you already know that the information you need is in table TADIR. You know that your selection criteria is 'everything starting with Z'. What else should you know? Ok, go to transaction se11 and have a look into the table's structure...

Have a look on the fields of the key index: OBJ_NAME is the name you want to be 'LIKE Z%'. Most likely you want to restrict PGMID and OBJECT to some values too. Z-Reports most likely have values R3TR and PROG but perhaps you want to list all classes too?

Building the actual Select should be no problem.

Best regards,

Jan Stallkamp