topic Re: selection query in Application Development and Automation Discussions

selection query

Former Member — Mon, 01 Jan 2007 12:19:00 GMT

hi guys,

I have a data in internal table.

iam extracting based upon the fields KURST and GDATU.

If i have more than one same currencey conversion like given below , i should display a error message,

kurst fcurr tcurr gdatu

TCL GBP EUR 13.03.2006

TCL GBP EUR 31.03.2006

It should not have more than one time same currency conversion.

GBP-->EUR

GBP-->EUR.

how can i do it.

please help.

Re: selection query

Former Member — Mon, 01 Jan 2007 13:05:13 GMT

Hi Ahmed

Please try with a logic similar to below:

data: tabix like sy-tabix,
      wa like itab.

sort itab by kurst fcurr tcurr.

loop at itab.
     tabix = sy-tabix.
     tabix = tabix + 1.
     read table itab index tabix.
     if sy-subrc eq 0 and 
        itab-kurst = wa-kurst and
        itab-fcurr = wa-fcurr and
        itab-tcurr = wa-tcurr.
        Write:/ 'Duplicate Record:', itab.
     endif.
endloop.

Kind Regards

Eswar

Re: selection query

Clemenss — Mon, 01 Jan 2007 15:25:55 GMT

Hi,

store the currency combinations into an internal table. As soon as one combination apperas more than once, it can not be stored and you can do what you want in this case to be done.


data:
  begin of ls_conv,
  fcurr like...
  tcurr like...
  end of ls_conv,
  lt_conv like hashed table of ls_conv
   with unique key table_line.
loop at itab.
  move-corresponding itab to ls_conv.
  insert ls_conv into table lt_conv.
  if sy-subrc <> 0.
"Alarm: Here comes the duplicate
*  TAKE ACTION
  endif.
endloop.

At least this is the fastest solution.

Regards,

Clemens