topic Re: Maintaining range in Application Development and Automation Discussions

Maintaining range

Former Member — Fri, 29 Jan 2010 10:55:01 GMT

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

Re: Maintaining range

former_member770378 — Fri, 29 Jan 2010 10:58:12 GMT

I don't understand

can you explain ?

Re: Maintaining range

Former Member — Fri, 29 Jan 2010 11:00:41 GMT

Hi,

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

Re: Maintaining range

kesavadas_thekkillath — Fri, 29 Jan 2010 11:12:07 GMT

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.

Re: Maintaining range

Former Member — Fri, 29 Jan 2010 11:33:40 GMT

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..

Re: Maintaining range

Former Member — Fri, 29 Jan 2010 11:38:53 GMT

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.

Re: Maintaining range

kesavadas_thekkillath — Fri, 29 Jan 2010 11:40:59 GMT

instaed of range

just pass

AND lkenz = space.

Re: Maintaining range

Former Member — Fri, 29 Jan 2010 11:44:45 GMT

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

Re: Maintaining range

Former Member — Fri, 29 Jan 2010 11:46:37 GMT

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

Re: Maintaining range

Former Member — Fri, 29 Jan 2010 11:53:04 GMT

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