topic Re: table control in Application Development and Automation Discussions

table control

Former Member — Mon, 31 Mar 2008 09:32:03 GMT

how can you find duplicate entries in a column of table control?

Re: table control

Former Member — Mon, 31 Mar 2008 09:36:47 GMT

You need to sort your itab before passing data to table control.

If you are entering data in your table control then

at flow-logic of screen

PAI

Loop at itab.

module check-duplicate-entry.

endloop.

module check-duplicate-entry.

read table itab with key (compare all keys with itab-key fields)

if sy-subrc = 0.

duplicate entry found.

endif.

Regards

Aditya

Re: table control

RemiKaimal — Mon, 31 Mar 2008 11:05:46 GMT

Hi,

Before the Table control is assigned Data, use a similar ligic as follows :


TYPES:
BEGIN OF strtab,
  carrid TYPE s_carr_id, "------ column whose duplicate entry needs to be found
END OF strtab.

DATA  it_tab TYPE TABLE OF strtab.

SELECT carrid FROM spfli "------ your table 
              INTO CORRESPONDING FIELDS OF TABLE it_tab
              GROUP BY carrid HAVING COUNT( * ) > 1.

it_tab will have the values in the column that has duplicate entries.

Cheers,

Remi