Dynamic DropDownByKey

[Former Member]

Hi,

I'm creating a DropDownByKey:

select * from ycenas into corresponding fields of table lt_cenas.
loop at lt_cenas into ls_cenas.

    l_palias-value = ls_cenas-palias.
    l_palias-text = ls_cenas-palias.
    insert l_palias into table lt_palias.

endloop.

attribute_cenas->set_attribute_value_set(
      name = 'PALIAS'
      value_set = lt_palias ).

This inserts all values from ls_profile-palias in the DropDownByKey by I don't want to display duplicate values, how can I do that?

Regards

[Former Member · Accepted solution]

hi,

select * from ycenas into corresponding fields of table lt_cenas.

loop at lt_cenas into ls_cenas.

l_palias-value = ls_cenas-palias.

l_palias-text = ls_cenas-palias.

insert l_palias into table lt_palias.

endloop.

DELETE ADJACENT DUPLICATES FROM lt_palias COMPARING value.

attribute_cenas->set_attribute_value_set(

name = 'PALIAS'

value_set = lt_palias ).

Regards,

akshay

[Former Member]

hi,

select * from ycenas into corresponding fields of table lt_cenas.

loop at lt_cenas into ls_cenas.

l_palias-value = ls_cenas-palias.

l_palias-text = ls_cenas-palias.

insert l_palias into table lt_palias.

endloop.

DELETE ADJACENT DUPLICATES FROM lt_palias COMPARING value.

attribute_cenas->set_attribute_value_set(

name = 'PALIAS'

value_set = lt_palias ).

Regards,

akshay

[Former Member]

Hi,

Also, after the select, you can sort the internal table (SORT ABAP sentence) and then delete duplicates (DELETE ADJACENT DUPLICATES ABAP sentence).

Regards,

[Former Member]

Probably the following sql statement with distinct key word do the trick

select distinct * from ycenas into corresponding fields of table lt_cenas.
loop at lt_cenas into ls_cenas.