topic Select-options problem in Application Development and Automation Discussions

Select-options problem

Former Member — Tue, 16 Dec 2008 08:59:11 GMT

hello all,

i have a field MATNR in SELECT-OPTIONS but without passing it in query i selected the data in itab.

after getting data in itab now i want if user put the value in selection-screen then it must show only those selected values in output, so i did coding like..

code:

LOOP AT ITAB.

IF MATNR-LOW NE ''.

IF ITAB-MATNR NE MATNR-LOW.

DELETE ITAB.

CLEAR ITAB.

CONTINUE.

ENDIF.

endloop.

it is working for single value, but when i give 15 or 20 values then again its showing for single value.

can anyone please help me?

regards saurabh.

Re: Select-options problem

Former Member — Tue, 16 Dec 2008 09:02:58 GMT

u can pass the directly in select query like where matnr = MATNR-LOW . if you want any internal calulations you need to use seperate internal table and query with full data.

Re: Select-options problem

Former Member — Tue, 16 Dec 2008 09:06:46 GMT

Hi,

when ever you use select option, you have to use IN operator for that it will work like bwlow code, i hope you requirement will meet.

LOOP AT ITAB.

IF ITAB-MATNR IN MATNR.

DELETE ITAB.

CLEAR ITAB.

CONTINUE.

ENDIF.

endloop.

Re: Select-options problem

SuhaSaha — Tue, 16 Dec 2008 09:08:31 GMT

Hello,

Plz change ur code as follows:


LOOP AT ITAB.
* IF MATNR-LOW NE ''. 
* IF ITAB-MATNR NE MATNR-LOW.
IF MATNR IS NOT INITIAL.
  IF ITAB-MATNR NOT IN MATNR.
    DELETE ITAB.
    CLEAR ITAB.
    CONTINUE.
  ENDIF.
ENDIF.
ENDLOOP.

Hope this is clear.

BR,

Suhas

Edited by: Suhas Saha on Dec 16, 2008 10:09 AM

Edited by: Suhas Saha on Dec 16, 2008 10:10 AM

Re: Select-options problem

Former Member — Tue, 16 Dec 2008 09:09:15 GMT

Use :: Delete ITAB where MATNR NOT IN MATNR.

Re: Select-options problem

Former Member — Tue, 16 Dec 2008 09:17:52 GMT

Hi Saurab,

Check the below code.


TABLES : MARA.
DATA : BEGIN OF T_MARA OCCURS 0,
        MATNR TYPE MARA-MATNR,
        MTART TYPE MARA-MTART,
        NAME(5),
       END OF T_MARA.
SELECT-OPTIONS : S_MATNR FOR MARA-MATNR.

SELECT MATNR
       MTART FROM MARA INTO TABLE T_MARA
             UP TO 200 ROWS.
IF NOT S_MATNR[] IS INITIAL.
  LOOP AT T_MARA.
    IF T_MARA-MATNR IN S_MATNR[].
      DELETE T_MARA INDEX SY-TABIX.
    ENDIF.
  ENDLOOP.
ENDIF.

Re: Select-options problem

Former Member — Tue, 16 Dec 2008 09:21:57 GMT

Hi,

You can use IN and NOT IN statement instead of NE.

Try it.

Regards,

Chris Gu

Re: Select-options problem

Former Member — Tue, 16 Dec 2008 09:24:43 GMT

Hi Saurabh,

You can directly code as below:

Delete ITAB where matnr not in MATNR.

Regards,

Zafar Ali