topic Re: retrieving zprograms in Application Development and Automation Discussions

retrieving zprograms

Former Member — Mon, 23 Jun 2008 16:03:23 GMT

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

Re: retrieving zprograms

Former Member — Mon, 23 Jun 2008 16:07:02 GMT

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

OBJ_NAME = 'z%'.

Re: retrieving zprograms

Former Member — Mon, 23 Jun 2008 16:09:08 GMT

Use PGMID = R3TR

OBJECT = PROG

obj_name = z*

Regards,

Kiran Bobbala

Re: retrieving zprograms

JanStallkamp — Mon, 23 Jun 2008 16:15:14 GMT

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

Re: retrieving zprograms

Former Member — Tue, 24 Jun 2008 06:02:28 GMT

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

Re: retrieving zprograms

Former Member — Tue, 24 Jun 2008 06:06:25 GMT

Hi,

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

Re: retrieving zprograms

Former Member — Tue, 24 Jun 2008 06:08:23 GMT

Hi,

use the table TSTC

here u can specify the progname and fetch the TCODE

Cheers,

Sai

Re: retrieving zprograms

GauthamV — Tue, 24 Jun 2008 06:08:31 GMT

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.

Re: retrieving zprograms

Former Member — Tue, 24 Jun 2008 06:27:05 GMT

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

Re: retrieving zprograms

JozsefSzikszai — Tue, 24 Jun 2008 06:31:58 GMT

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

Re: retrieving zprograms

Former Member — Tue, 24 Jun 2008 06:33:45 GMT

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

Re: retrieving zprograms

Former Member — Tue, 24 Jun 2008 06:35:03 GMT

thanks alot. ur help was valuable.