topic Re: Problem in Selection in Application Development and Automation Discussions

Problem in Selection

SG141 — Tue, 13 Nov 2007 22:28:14 GMT

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.

Re: Problem in Selection

Former Member — Tue, 13 Nov 2007 22:32:12 GMT

Karthik,

use % instead of *.

reward if it helps,

Satish

Re: Problem in Selection

SG141 — Tue, 13 Nov 2007 22:36:03 GMT

SELECT-OPTIONS: S_LAEDA FOR MARA-LAEDA OBLIGATORY,
                S_MATNR FOR MARA-MATNR ,
                S_MATKL FOR MARA-MATKL OBLIGATORY DEFAULT 'H*',
*               OPTION CP,  " adding this option
                S_MTART FOR MARA-MTART OBLIGATORY DEFAULT 'FERT',
                S_WERKS FOR MARC-WERKS OBLIGATORY.

Solved the problem.

Re: Problem in Selection

naimesh_patel — Tue, 13 Nov 2007 22:38:01 GMT

Try like this:

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

initialization.
 s_matkl-sign = 'I'
s_matkl-option = 'CP'
s_maktl-low = 'H*'.
append s_matkl.

Regards,

Naimesh Patel

Re: Problem in Selection

Former Member — Wed, 14 Nov 2007 02:20:17 GMT

is not treated as wild character . Instead use %

SELECT-OPTIONS:

S_MATNR FOR MARA-MATNR ,

S_MATKL FOR MARA-MATKL OBLIGATORY DEFAULT 'H%',

S_WERKS FOR MARC-WERKS OBLIGATORY.

Hope this work .

Praveen