Maintaining range

[Former Member]

Hi,

in my requiremnet

i have to write the below logic

use table view ZV_MAST_STKO to perform initial select for BoM materials to be exploded using supplied selection criteria. Use a select similar to that below. Create a range r_lkenz to assign value NE u2018Xu2019 if u2018Exclude deleted BOMsu2019 checked(check box)

SELECT * FROM zv_mast_stko

INTO CORRESPONDING FIELDS OF TABLE gt_mast

WHERE matnr IN s_matnr

AND werks IN s_werks

AND stlal EQ p_stlal

AND stlst EQ p_stlst

AND lkenz IN r_lkenz.

could u please guide me little elaborately how to achieve this??

Please help

[former_member770378]

I don't understand

can you explain ?

[Former Member]

Hi,

How to write range??means how to maintain NE x.

[kesavadas_thekkillath]

data:r_lkenz type range of zv_mast_stko-lkenz.

data:wa like line of r_lkenz.

wa-option = 'EQ'.

wa-sign = 'E'.

wa-low = 'X'.

append wa to r_lkenz.

SELECT * FROM zv_mast_stko

INTO CORRESPONDING FIELDS OF TABLE gt_mast

WHERE matnr IN s_matnr

AND werks IN s_werks

AND stlal EQ p_stlal

AND stlst EQ p_stlst

AND lkenz IN r_lkenz.

[Former Member]

Thanks very much.

one more doubt.In my view there is one record with lkenz value is "X".

but i dont know why in this case also select statement fetching record.because i maintained in range that r_lkenz ne 'X'.

Please help..

[Former Member]

Some tips:

Sign is always I (for Include) or E (for Exclude)

Option can be a whole range, which includes:

EQ (Equal)

BT (Between))

CP (Contain Pattern)

So let's say you want to have the range check for all company codes not starting with AB, you will set your code as follow:

ranges: bukrs for zstock-bukrs. 
  
bukrs-sign = 'E'.             "Exclude 
bukrs-option = 'CP'.        "Pattern 
bukrs-low = 'AB*'.            "Low Value 
bukrs-high = ''.                "High Value 
append bukrs. 

Always remember to APPEND your range when you fill it, as the WHERE clause checks against the lines of the range table, not against the header line.

Hope this explains it well enough.

[kesavadas_thekkillath]

instaed of range

just pass

AND lkenz = space.

[Former Member]

Last doubt.

i am writting like this

wr_lkenz-sign = 'I'.

*wr_lkenz-option = 'NE'

.* wr_lkenz-low = 'X'.

APPEND wr_lkenz TO r_lkenz.

CLEAR wr_lkenz.

But till the record is fetching in my where condition.

please answer me . awaiting for ur reply

[Former Member]

Hi asis,

In that case range is not required.

Use SPACE instead of 'X'.

AND lkenz = ' '.

Manas M.

Edited by: Kumar Manas Mishra on Jan 29, 2010 12:53 PM

Edited by: Kumar Manas Mishra on Jan 29, 2010 12:53 PM

[Former Member]

Hi,

I think so range is not required, try using this code...

SELECT * FROM zv_mast_stko

INTO CORRESPONDING FIELDS OF TABLE gt_mast

WHERE matnr IN s_matnr

AND werks IN s_werks

AND stlal EQ p_stlal

AND stlst EQ p_stlst

AND lkenz = ' '.

Hope it helps you,

Regards,

Abhijit G. Borkar