Skip to Content
0
Nov 13, 2007 at 10:28 PM

Problem in Selection

25 Views

These are the select options.

SELECT-OPTIONS: 
                S_MATNR FOR MARA-MATNR ,
                S_MATKL FOR MARA-MATKL OBLIGATORY DEFAULT 'H*',
                S_WERKS FOR MARC-WERKS OBLIGATORY.

This is the select query

SELECT MARA~MATNR
             MARA~MATKL
             MARC~WERKS      
             FROM MARA AS MARA INNER JOIN MARC AS MARC
            ON MARA~MATNR = MARC~MATNR INTO TABLE GT_MARA
            WHERE MARA~MATNR IN S_MATNR AND
            MARA~MATKL IN S_MATKL AND
            MARC~WERKS IN S_WERKS.

S_MATKL internal table is having

s_sign = 'I'
s_option = 'EQ'
s_low = H*.

I know this works if <b>S_OPTION = CP</b>.

Let me know how can it be done.