topic Re: select option in Application Development and Automation Discussions

select option

Former Member — Fri, 06 Jul 2007 09:29:50 GMT

Hi All,

i have lfart(delivery type) field on selction screen defiend as select-option.whenever i click on the multiple selection arrow button besides the lfart field then i n that i have selected "=" as values for opyion field of select-option table(sign,option,low,high).then an icon of "=" is displayed behind the lfart field.

then i have wriiten a qery like this

SELECT lfart,lfdat,.....

INTO TABLE tb_likp

FROM likp

FOR ALL ENTRIES IN tb_get_del1

WHERE vbeln = tb_get_del1-vbeln

AND lfart IN s2_lfart

AND lfdat IN s_lfdat,......

but it is failing.then how to write the correct query .

Thanks&Regards,

Padma.

Re: select option

former_member150733 — Fri, 06 Jul 2007 09:34:20 GMT

YOu can do similar to the example below

Example :

select-options : s_statu for ekpo-statu.

....

Initialization.

FORM put_default_values.

s_statu-sign = 'I'. " I or E for In clude / Exclude

s_statu-option = 'EQ'.

s_statu-low = ''.

append s_statu.

ENDFORM.

....

Re: select option

Former Member — Fri, 06 Jul 2007 09:34:53 GMT

Hi,

Try to add bracket after select option variable.

SELECT lfart,lfdat,.....

INTO TABLE tb_likp

FROM likp

FOR ALL ENTRIES IN tb_get_del1

WHERE vbeln = tb_get_del1-vbeln

AND lfart IN s2_lfart[]

AND lfdat IN s_lfdat[]

Re: select option

Former Member — Fri, 06 Jul 2007 09:34:54 GMT

Hi,

The query is correct. Check the entries in DB tables. May be there are no entries.

Regards,

Atish

Re: select option

Former Member — Fri, 06 Jul 2007 09:38:08 GMT

Try to append the values in the report..

s2_lfart-sign = 'I'.

s2_lfart-option = 'EQ'.

s2_lfart-low = ''.

append s2_lfart.

s2_lfdat-sign = 'I'.

s2_lfdat-option = 'EQ'.

s2_lfdat-low = ''.

append s2_lfdat.

Regards,

Pavan P.

Re: select option

Former Member — Fri, 06 Jul 2007 09:43:57 GMT

Query is looking fine.

Data may not be there, so the query is failing.

Check in the table.