Skip to Content
0
Feb 22, 2006 at 05:02 AM

Select Query.

36 Views

Hi All,

I've a select query in code, which is not able to

select any data from database table. When i goto se16,

and give the same criteria as in the query at runtime,

it displays data.

I've checked various possibilities, but no luck.

This query works fine in our internal system, but is giving problem for a particular system.

The query is:

SELECT * INTO CORRESPONDING FIELDS OF TABLE et_tspl

FROM /sapsll/tspl

WHERE lgreg IN is_sel_options-lgreg

AND spl_list_type IN is_sel_options-spl_list_type

AND spl_data_ref_id IN is_sel_options-spl_data_ref_id

AND datbi >= is_sel_data-sk_datbi

AND spl_valid_from >= lv_ts_valfrom

AND spl_valid_to <= lv_ts_valto

AND crtsp IN lr_crtsp

AND chtsp IN lr_chtsp

AND ernam IN is_sel_options-ernam

AND aenam IN is_sel_options-aenam.

Thanks,

Rohit.