select-option : variant

[Former Member]

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

[Vijay]

hi

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

[Former Member]

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

b

c

d from db table into internal table

where zbranch in RA_BRANCH.

where c0, c1, c2, c3 are constants.

- Selvapandian Arunachalam

[jayanthi_jayaraman]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Hi,

My program is background,

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

Aakash.