topic Re: range in Application Development and Automation Discussions

range

Former Member — Wed, 30 May 2007 13:15:51 GMT

hi all,

Please tell me if this statement is wrong:

delete t_mat where matnr in r_matnr[].

presently, r_matnr ( defined as range) is empty but still t_mat is getting deleted.

Thanks.

Former Member — Wed, 30 May 2007 13:17:08 GMT

If there is nothing in the range then all records will be deleted.

You need to do a

CHECK NOT R_MATNR[] IS INITIAL

Former Member — Wed, 30 May 2007 13:18:04 GMT

Hello,

because the range-table is empty every record is deleted. An empty range table is used as "all".

Best regards

Frank

Former Member — Wed, 30 May 2007 13:19:52 GMT

try this..

if not r_matnr[] is initial.
delete t_mat where matnr in r_matnr[].
endif.

Former Member — Wed, 30 May 2007 13:23:29 GMT

the funcionnality is like that.

so try like this..

ranges: r_matnr for mara-matnr.

data:

t_mara type table of mara with header line.

select *

from mara

up to 5 rows

into table t_mara.

if not r_matnr[] is initial.

delete t_mara where matnr in r_matnr.

endif.

write: 'test'.