topic Re: selecting DISTINCT values from ITABS in Application Development and Automation Discussions

selecting DISTINCT values from ITABS

Former Member — Wed, 09 Mar 2005 14:48:23 GMT

How can I select distinct values from an internal table?

I'd like to do the following:

DATA: BEGIN OF ITAB_CAT OCCURS 0,
      AISCATALOG LIKE ZDOLTARC02-AISCATALOG,
      END OF ITAB_CAT.
DATA: BEGIN OF ITAB_FLDCAT,
      SEARCHFLD LIKE ZDOLTARC03-SEARCHFLD,
      VALUE LIKE ZDOLTARC03-VALUE,
      CATALOG LIKE ZDOLTARC02-AISCATALOG,
      END OF ITAB_FLDCAT.
*
*
*
SELECT DISTINCT CATALOG INTO ITab_CAT FROM ITAB_FldCat.

please help if you have a chance,

N L

Re: selecting DISTINCT values from ITABS

andreas_mann3 — Wed, 09 Mar 2005 14:51:13 GMT

hi,

look f1 to read table !

read table ITAB_CAT with key f1 = fl1

f2 = fl2

...

regards Andreas

Re: selecting DISTINCT values from ITABS

juan_suros — Wed, 09 Mar 2005 18:43:48 GMT

This may be the simplest solution:

LOOP AT itab_fldcat.
  APPEND itab_fldcat-catalog TO itab_cat.
ENDLOOP.
SORT itab_cat.
DELETE ADJACENT DUPLICATES FROM itab_cat.