WITHOUT INPUT VALUES

[Former Member]

hi to every body,

i have 2 fields city and empcode in one table,and i have one selection-option for empcode and i have on parameter for city in output.now issue is with out giving input values i want to retrive all the data,but i am validating on these fields when i retrive data from the table

select empcode

city from z_akemp into it_emp when empcode in s_empcode

city = p_city.

[Former Member]

Declare City also as select-option with NO INTERVALS option

[Former Member]

Hi,

Declare City also as select-option with NO INTERVALS and NO EXTENSION option.

Keep the Select query as it is...

Regards,

Kunjal

[Former Member]

Hello Sekhar,

With your code all the data will be fetched when the input fields are empty.

There will be no issue. But If u have any validation in selection screen U just check if the fields are initial.

But with the above syntax there will be no problem

Regards,

Subbu

[vinod_vemuru2]

Hi,

Small correction to Kunjals reply.

Declare city also as select option with no intervals no-restriction.

But in select query where clause instead of equal to u have to use IN operator

SELECT-OPTIONS: s_city FOR kna1-city NO INTERVALS NO-RESTRICTION.

select empcode

city from z_akemp into it_emp when empcode in s_empcode

city IN s_city.

Here s_city looks like parameter but acts as select option.

thanks,

Vinod.