selecting DISTINCT values from ITABS

[Former Member]

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

[Former Member]

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

[andreas_mann3]

hi,

look f1 to read table !

read table ITAB_CAT with key f1 = fl1

f2 = fl2

...

regards Andreas

[juan_suros]

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.