topic Re: select-option : variant in Application Development and Automation Discussions

select-option : variant

Former Member — Fri, 21 Dec 2007 07:09:34 GMT

HI,

I have a select query like :

select a b c d from db table into internal table

where

zbranch in c0, c1, c2, c3...so on.

where c0, c1, c2, c3 are constants.

My question is : how to store these constants in select-option and to create a variant for that.

I can use constants however I would like to keep in select option by creating a variant for maintanance purpose so that I can change them whenever required.

Regards,

Aakash

Re: select-option : variant

Vijay — Fri, 21 Dec 2007 07:14:49 GMT

select option has facility to enter multiple values.

just click on the arrow on the right hand side and enter all the values u want into the window opened.

now press the save button it will save these values as variant.

regards

vijay

reward points if helpfull

Re: select-option : variant

Former Member — Fri, 21 Dec 2007 07:16:25 GMT

Hi Try this way.

ranges: ra_branch for db table-zbranch.

ra_branch-sign = 'I'.

ra_branch-option = 'EQ'.

ra_branch-low = 'c0'.

append ra_branch.

ra_branch-low = 'c1'.

append ra_branch.

ra_branch-low = 'c2'.

append ra_branch.

select a

d from db table into internal table

where zbranch in RA_BRANCH.

where c0, c1, c2, c3 are constants.

- Selvapandian Arunachalam

Re: select-option : variant

jayanthi_jayaraman — Fri, 21 Dec 2007 07:19:26 GMT

Hi,

You can create select-options for zbranch.

tables zbranch.

select-options s_branch for db-zbranch.

initialization.

s_branch-low = C0.

s_branch-sign = 'I'.

s_branch-option = 'EQ'.

append s_branch.

Re: select-option : variant

Former Member — Fri, 21 Dec 2007 07:19:53 GMT

Hi Chandra,

tables spfli.

select-options s_carrid for spfli-carrid.

In the selection screen give values and save it, it's asking for varient name give varient name and meaning and save it then your varient is available for you.

Note: After Create varient if u again active your program your varient is deleted, create varient your program at final stage.

Plz Reward,

Mahi.

Re: select-option : variant

Former Member — Fri, 21 Dec 2007 07:21:05 GMT

U can create the variant as similar to other variants.

While Executing Goto The Field for which u want the Variant.

Click the Button ( Multiple Selection Button) that is next to the second field. Here It prompts to enter values.

Enter Ur Values one by one in each line.

Click Run.

Now Click Save button on the Toolbar which asks to save the variant. Now give name and description for the Variant and save.

Awrd Points If Useful.*

Bhupal.

Re: select-option : variant

Former Member — Fri, 21 Dec 2007 07:29:37 GMT

Hi,

My program is background,

and to create a variant for a field in select query.

Aakash.