topic Re: Select option in Application Development and Automation Discussions

Select option

Former Member — Mon, 15 Sep 2008 13:06:28 GMT

Hi experts,

I reading a TVARV table. In this table I defined some value to a variable.

I want to check whether the BUKRS from a parameter is among this values or not.

I'm using: if p_bukrs in z_tvarv_bukrs.

Is this statement correct or not? Is there any other way to check?

JozsefSzikszai — Mon, 15 Sep 2008 13:10:44 GMT

hi,

the statement is correct in case z_tvarv_bukrs is range of bukrs, but did you try on your own?

If z_tvarv_bukrs is an internal table, where one field is bukrs, than you can use READ TABLE to check if the value exists

saranwin — Mon, 15 Sep 2008 13:10:49 GMT

Hi,

Define like and check . Use the follow coding

Select-options : so_bukrs for table-bukrs.

at selection-screen on value request for p_field.

perform select_value.

Form select_value.

select single field from table into p_field where bukrs in so_bukrs.

Endform.

regards,

Saran

Former Member — Mon, 15 Sep 2008 13:12:53 GMT

Hi,

Try like this:

if p_bukrs CA z_tvarv-bukrs.

Regards,

Bhaskar

Former Member — Mon, 15 Sep 2008 13:14:47 GMT

p_bukrs is not coming from the selection-screen. It's coming after a selection.

So I cannot define as a select-option. It's 1 single value, do you have any idea in this case?

Former Member — Mon, 15 Sep 2008 13:31:32 GMT

data : lv_varname_t type tvarv- .

select single var_name from TVARV into lv_varname_t where var_name eq p_bukrs.

if sy-subrc = 0.

" Value found in the table.

else.

" Value not found in the table.

endif.