topic How exclude multiple values which are not in sequence ( range ) in Application Development and Automation Discussions

How exclude multiple values which are not in sequence ( range )

Former Member — Sat, 30 Aug 2008 05:39:31 GMT

Hi Abapers,

My Requiremnt is to exclude multiple values which are not in sequence in selection screen.

I want to restrict some values .

please provide sample code.

thanks & regards,

Hari priya

Re: How exclude multiple values which are not in sequence ( range )

Former Member — Sat, 30 Aug 2008 05:43:57 GMT

hi Hari Priya

use select options Multiple selection Box

there you can you single value/range of value and with Include or Exclude Function

Regards

Deva

Re: How exclude multiple values which are not in sequence ( range )

Former Member — Sat, 30 Aug 2008 05:46:46 GMT

Hi,

Go through the below coding. Here in the selection screen you can exclude the all the PO number which starts from series 72.

SELECT-OPTIONS : s_ebeln FOR ekko-ebeln .

s_ebeln-low = '72*'.

s_ebeln-sign = 'E'.

s_ebeln-option = 'CP'.

append s_ebeln.

clear s_ebeln.

Re: How exclude multiple values which are not in sequence ( range )

kesavadas_thekkillath — Sat, 30 Aug 2008 05:53:08 GMT

Explain Clearly !!!

Re: How exclude multiple values which are not in sequence ( range )

former_member585060 — Sat, 30 Aug 2008 06:56:28 GMT

SELECT-OPTIONS : s_matnr FOR mara-matnr.

INITILIZATION.

s_matnr-sign = 'E'. " E means Excluding.

s_matnr-option = 'EQ'.

s_matnr-low = '1000'.

append s_matnr.

s_matnr-sign = 'E'.

s_matnr-option = 'EQ'.

s_matnr-low = '1500'.

append s_matnr.

s_matnr-sign = 'E'.

s_matnr-option = 'BT'.

s_matnr-low = '2000'.

s_matnr-high = '3000'.

append s_matnr.

START_OF_SELECTION.

SELECT * FROM MARA INTO TABLE itab WHERE mara IN s_matnr.

the above s_matnr has values 1000,1500, 2000 - 3000.

so the above code fetches all the values excluding 1000,1500 and between 2000 and 3000.

Regards

Bala Krishna