07-23-2007 8:49 PM
07-23-2007 8:53 PM
Anytime you have to equate to multiple values in your programs. Say for example, you need to get data for two company codes from a table.
data: it001 type table of t001.
ranges: r_bukrs for t001-bukrs.
r_bukrs-sign = 'I'.
r_bukrs-option = 'EQ'.
r_bukrs-low = '0010'.
append r_bukrs.
r_bukrs-sign = 'I'.
r_bukrs-option = 'EQ'.
r_bukrs-low = '0020'.
append r_bukrs.
select * into table it001 from t001 where bukrs in r_bukrs.
Regards,
Rich Heilman
07-23-2007 8:53 PM
Hi,
It is used to group a range of values into an internal table similar to the selection table when we decalre select-options on the selection screen. The selection table consist of the field SIGN, OPTION, LOW and HIGH fields.
You use the IN operator in conjunction with SUBMIT, CHECK, IF, WHILE or SELECT statements.
Regards,
Ferry Lianto