topic Re: How to form query in Application Development and Automation Discussions

How to form query

Former Member — Tue, 22 Jan 2008 04:30:49 GMT

Hi Experts

How to form the query for data reading when i have multiple seleciton options as follow.

SELECTION-SCREEN BEGIN OF BLOCK bk1 WITH FRAME TITLE text-001.

SELECT-OPTIONS: zso FOR vbak-vbeln.

SELECT-OPTIONS: zli FOR afpo-kdpos.

SELECT-OPTIONS: zmat FOR mara-matnr.

SELECT-OPTIONS: zwork FOR crhd-ARBPL.

SELECT-OPTIONS: zdat FOR afru-BUDAT.

SELECT-OPTIONS: zpl FOR afru-werks OBLIGATORY.

SELECT-OPTIONS: zmrp FOR afko-DISPO.

SELECT-OPTIONS: zauf FOR AFKO-AUFNR.

SELECT-OPTIONS: zedat FOR AFRU-ISDD.

SELECT-OPTIONS: zline FOR AFRU-GRUND.

SELECTION-SCREEN END OF BLOCK bk1.

Regards

Rajaram

Former Member — Tue, 22 Jan 2008 04:34:54 GMT

Hi,

You can use use IN operator in WHERE cluase.

Eg:-

select-options: s_kunnr FOR kna1-kunnr.

Query:

select * from kna1 into gt_kna1

where kunnr IN s_kunnr.

awrd points if useful

Ganesh

Former Member — Tue, 22 Jan 2008 05:00:10 GMT

hi ,

try like this in select stmt.

select <Column List> from <DB tab> into table <itab>

where vbeln in ZSO and

kdpos in ZLI and

matnr in zmat and so on........... up to the last select option.

using Join conditions b4 where clause.

Reward points if useful

Chandra