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:Β 

get list of envs

0 Kudos

hi all , i hope my question will be clear this time !

Is there a way to get the list of environments dynamically, NOT to declare them manually like this :

FORM get_list_of_envs.
     CLEAR gt_s_envs.
     gt_s_envs = 'DGA'
     APPEND gt_s_envs to gt_envs.
     gt_s_envs = 'DGB'.
     APPEND gt_s_envs TO gt_envs.
     gt_s_envs = 'DGC'.
     APPEND gt_s_envs TO gt_envs.
    .
    .
    .
ENDFORM.

with 'environments' i mean the result of STMS transaction -> itinerary of transport.
I remain available if my question is not clear enough .

THANKS πŸ™‚

1 ACCEPTED SOLUTION

venkateswaran_k
Active Contributor

Hi lexouille

You can get the environments from this table TMSCSYS.

SELECT domnam, sysnam, systxt FROM tmscsys.

Regards,

Venkat

6 REPLIES 6

0 Kudos

is there any way to do it with Tables : TCEDELI, TCERELE, TCETARG and TCETARGHDR ?

Nitish2027
Participant

As suggested by lexouille, you can select distinct system name from TCEDELI Table to get list of all the environments that are configured in STMS transaction. You can also use target system field from TCETARG Table to get the same output.

There is input help check table TCESYST available for both the above tables which definitely will have the values.

I think the below code should work.

  SELECT DISTINCT sysname
  FROM tcesyst
  INTO TABLE @DATA(lt_systems).

Thanks.

0 Kudos

thanks, but my selection didn't works, i get no data !

Sandra_Rossi
Active Contributor
0 Kudos

What data do you have in TCEDELI, TCERELE, TCETARG, TCETARGHDR?

venkateswaran_k
Active Contributor

Hi lexouille

You can get the environments from this table TMSCSYS.

SELECT domnam, sysnam, systxt FROM tmscsys.

Regards,

Venkat

0 Kudos

thanks it works