How to form query

[Former Member]

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]

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]

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