topic Ranges table in Application Development and Automation Discussions

Ranges table

Former Member — Tue, 04 Dec 2007 15:30:17 GMT

Hi All,

I have a requirement where in I have to get all the materials based on some 4 material groups.

For this I have declared a ranges table like this :

data : r_mat_group for mara-matkl.

r_mat_group-sign = 'I'.

r_mat_group-option = 'EQ'.

r_mat_group-low = 'mat_grp1'.

APPEND r_mat_group.

r_mat_group-low = 'mat_grp2'.

APPEND r_mat_group.

r_mat_group-low = 'mat_grp3'.

APPEND r_mat_group.

r_mat_group-low = 'mat_grp4'.

APPEND r_mat_group.

Getting the data from mara

loop at r_mat_group.

select matnr from mara

appending table it_matnr

where maktl eq r_mat_group-low.

endloop.

My question is 'Is it the right way to do or is there any other way we can write the

select statement for better performance '..

Regards,

Vishnu.

Re: Ranges table

former_member195698 — Tue, 04 Dec 2007 15:31:59 GMT

Use

select matnr from mara

into table it_matnr

where maktl <b>in r_mat_group</b>

Re: Ranges table

Former Member — Tue, 04 Dec 2007 15:32:27 GMT

For starters:

select matnr from mara 
appending table it_matnr 
where MATKL in r_mat_group.      "<====

(Corrected the field name)

Rob

Message was edited by:

Rob Burbank

Re: Ranges table

Former Member — Tue, 04 Dec 2007 15:33:33 GMT

select matnr from mara into tbale it_matnr

Where matkl IN r_mat_group.

Try this one., but for better performance <u>try to use</u> all key fields

-Pavan

Re: Ranges table

naimesh_patel — Tue, 04 Dec 2007 15:34:12 GMT

You have to do like this:

data : r_mat_group for mara-matkl.

r_mat_group-sign = 'I'.
r_mat_group-option = 'EQ'.
r_mat_group-low = 'MAT_GRP1'.   "<< Group name must be in Upper case
APPEND r_mat_group.
r_mat_group-low = 'MAT_GRP2'.
APPEND r_mat_group.
r_mat_group-low = 'MAT_GRP3'.
APPEND r_mat_group.
r_mat_group-low = 'MAT_GRP4'.
APPEND r_mat_group.


* Getting the data from mara

select matnr from mara 
appending table it_matnr 
where maktl in r_mat_group.  "<<<

Regards,

Naimesh Patel