topic Re: Select duplicates in Application Development and Automation Discussions

Select duplicates

Former Member — Thu, 28 May 2009 10:20:28 GMT

Hi experts,

I want to select those function names from table fupararef where all the given parameters are existing.

I use this selection:

SELECT * FROM fupararef

INTO TABLE i_list

WHERE parameter = 'I_RLTYP' OR

parameter = 'I_AKTYP'.

I need only those function names where all two parameters existing, so if it is only 1 of the two is existing I don't need that anymore.

Re: Select duplicates

Former Member — Thu, 28 May 2009 10:28:11 GMT


SELECT * FROM fupararef
INTO TABLE i_list
WHERE parameter = 'I_RLTYP'.

SELECT * FROM fupararef
INTO TABLE i_list2
WHERE parameter = 'I_AKTYP'.

loop at i_list.
  read table i_list2 with key funcname = i_list-funcname.
  if sysubrc = 0.
    append i_list to i_list_final.
  endif.
endloop.

Edited by: Florian Kemmer on May 28, 2009 12:28 PM

Re: Select duplicates

Former Member — Thu, 28 May 2009 10:32:05 GMT

just replace the OR with AND...

wont that solve ur case??

Re: Select duplicates

Former Member — Thu, 28 May 2009 10:32:15 GMT

SELECT * FROM fupararef

INTO TABLE i_list

WHERE (parameter = 'I_RLTYP' AND parameter = 'I_AKTYP').

Re: Select duplicates

Former Member — Thu, 28 May 2009 10:32:47 GMT

Hi,

Use like this

SELECT DISTINCT * FROM fupararef INTO TABLE i_list

WHERE ( parameter = 'I_RLTYP' OR parameter = 'I_AKTYP' ).

Regards,

Vijay

Re: Select duplicates

Former Member — Thu, 28 May 2009 10:51:25 GMT

Try This:

SELECT *

FROM FUPARAREF

WHERE parameter EQ 'I_RLTYP'

AND parameter EQ 'I_AKTYP'.

Sometimes = sign acts as an assignment operator and hence leads to retrival of records which are not expected, so it is always prefrable to make use of EQ, NE, GT, LT, etc in where as well as in IF conditions.

Regards

Gaurav.

Re: Select duplicates

Former Member — Thu, 28 May 2009 10:58:01 GMT

Hi ,

you can use the following code



select fieldname 
from table name
into internal_table
where field in ('value1','value2').

or you can use a ranges table



ranges: r_range for table-fieldname.

r_range-sign = 'I'.
r_range-option = 'EQ'.
r_range-low = 'value1'.
append r_range. clear r_range.


r_range-sign = 'I'.
r_range-option = 'EQ'.
r_range-low = 'value2'.
append r_range. clear r_range.

select fieldname 
from table name
into internal_table
where field in range.

Regards,

Abdullah

Re: Select duplicates

Former Member — Thu, 28 May 2009 11:08:34 GMT

you could try something like this

SELECT funcname FROM fupararef
INTO TABLE i_list WHERE parameter = 'I_RLTYP'
AND funcname IN ( SELECT funcname FROM fupararef WHERE parameter =
'I_AKTYP' ).

Re: Select duplicates

Former Member — Thu, 28 May 2009 11:15:57 GMT

hi ,

try this

DATA : i_list TYPE TABLE OF fupararef WITH HEADER LINE,

i_list_tmp TYPE TABLE OF fupararef,

w_list LIKE LINE OF i_list_tmp.

SELECT DISTINCT * FROM fupararef INTO TABLE i_list

WHERE ( parameter = 'INTERNAL_ERROR' OR parameter = 'SEND_ERROR' ).

IF sy-subrc = 0.

APPEND LINES OF i_list TO i_list_tmp .

SORT i_list_tmp BY funcname r3state parameter paramtype.

DELETE ADJACENT DUPLICATES FROM i_list_tmp COMPARING funcname.

LOOP AT i_list_tmp INTO w_list .

READ TABLE i_list INTO w_list WITH KEY funcname = w_list-funcname

parameter = 'I_RLTYP' .

IF sy-subrc = 0.

READ TABLE i_list INTO w_list WITH KEY funcname = w_list-funcname

parameter = 'I_AKTYP'.

IF sy-subrc NE 0.

DELETE i_list WHERE funcname = w_list-funcname.

ENDIF.

ELSE.

DELETE i_list WHERE funcname = w_list-funcname.

ENDIF.

ENDLOOP.

REFRESH i_list_tmp.

clear : w_list,i_list.

ENDIF.

kindly give points if u find it useful.

Re: Select duplicates

Former Member — Fri, 29 May 2009 09:44:45 GMT

Thanks