NOT in betweem

[Former Member]

Hi all

From the below statement i need to select the values NOT IN BETWEEN '60000000' (matnr) AND '60000063' (matnr).Like i need select the values excluding the matnr values '60000000' AND '60000063' .Please help

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE

IT_S026 WHERE WERKS = P_WERKS AND

SPTAG IN p_sptag AND MATNR NOT IN

endif.

Vijay

[Former Member]

are u using select options or ranges?

Regards,

Talwinder

[Former Member]

select-options: matno like s026-matnr.

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE

IT_S026 WHERE WERKS = P_WERKS AND

SPTAG IN p_sptag AND MATNR NOT IN matno

endif.

in selec-options provide

'60000000' AND '60000063'

Regards

[Former Member]

This option is alredy in select-options extension. Choose 4th tab.

[former_member188829]

Hi,

tables:s026..

Select-options:s_matnr for s026-matnr default '60000000' to '60000063'.

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE

IT_S026 WHERE WERKS = P_WERKS AND

SPTAG IN p_sptag AND MATNR NOT IN s_matnr.

[Former Member]

hi vishnu

but am if i put select options its geting displayed in input screen but according to my requirememtn it shouldnt.please help

vijay

[former_member188829]

Hi,

Check this Example with Ranges.(You Will Not Get Selection-screen).

TABLES:S026.

RANGES:S_MATNR FOR S026-MATNR.

INITIALIZATION.

S_MATNR-LOW = '000000000060000000'.

S_MATNR-HIGH = '000000000060000003'.

S_MATNR-SIGN = 'I'.

S_MATNR-OPTION = 'BT'.

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE

IT_S026 WHERE WERKS = P_WERKS AND

SPTAG IN p_sptag AND MATNR NOT IN s_matnr.

[arpit_shah]

then in selection screen,

Enter

what u want to exclude in

Exclude single value or Exclude Ranges.

and in select statement not use NOT IN

instead of that only use IN

Regards,

ARPIT

[Former Member]

hi arpit

exclude ranges

vijay

[Former Member]

Hi,

Try like this.

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE IT_S026 WHERE WERKS = P_WERKS

AND SPTAG IN p_sptag

AND (MATNR < v_mat1 " '60000000'

OR MATNR > v_mat2). " '60000063'

Rewards points if helpful.

Regards,

Srinivas Ch

[Former Member]

hi srinivas

its not coming.

please help

vijay

[Former Member]

Hi,

Try like this

data: v_mat1 like s026-matnr default '60000000',

v_mat2 like s026-matnr default '60000063'.

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE IT_S026 WHERE WERKS = P_WERKS

AND SPTAG IN p_sptag

AND (MATNR < v_mat1 " '60000000'

OR MATNR > v_mat2). " '60000063'

Regards

Edited by: K.P.N on Jan 5, 2008 8:19 AM

[Former Member]

Declare ranges .

Ranges ran_matnr for matnr.

Give ran_matnr = s_matnr (Name of select option).

ran_matnr-options = 'NB'.

Use ran_matnr in select query inplace of s_matnr.

Reward Points,

Regards,

Talwinder

[Former Member]

Hi,

Check this,

SELECT * FROM S026 INTO CORRESPONDING FIELDS OF TABLE IT_S026 WHERE WERKS = P_WERKS

AND SPTAG IN p_sptag

AND (MATNR < v_mat1

AND MATNR > v_mat2).

Thanks and Regards,

[Former Member]

hi chandra

can u please explain me abt v_mat1 and v_mat2

vijay

[Former Member]

hi talwinder

can u giv me d code

vijay

[Former Member]

hi,

v_mat1 and v_mat2 are variables of type matnr in s026 table and u r comparing in select statement

Regards

[Former Member]

Hi K.P.N

WE need to give like this.

data: v_mat1 like s026-matnr value '60000000',

v_mat2 like s026-matnr value '60000063'.

VIjay

[Former Member]

Hi vijay,

ranges : r_matnr for matnr.

r_matnr() = s_matnr().

loop at r_matnr.

if -

---

your condition----

---

(like if s_matnr-low = '60000000' and s_matnr-high = '600000003'.)

r_matnr = 'NB'.

endif.

endloop.

Regards,

Talwinder

Edited by: Talwinder Singh on Jan 5, 2008 8:31 AM

[Former Member]

Hi vijay,

ranges : r_matnr for matnr.

r_matnr [] = s_matnr [].

loop at r_matnr.

if -

---

your condition----

---

(like if s_matnr-low = '60000000' and s_matnr-high = '600000003'.)

r_matnr = 'NB'.

endif.

endloop.

Regards,

Talwinder