topic Re: how to avoid duplicates values from alvgird see below code in Application Development and Automation Discussions

how to avoid duplicates values from alvgird see below code

laxman_sankhla3 — Fri, 03 Nov 2006 05:51:10 GMT

how to avoid duplicates values from alvgird see below code

in below query docno no is repeated again and again

how i can avoid duplication in this query.

select * into corresponding fields of table itab

from J_1IEXCHDR

inner join J_1IEXCDTL

on J_1IEXCDTL_{lifnr = J_1IEXCHDR}lifnr

where J_1IEXCHDr~status = 'P'.

Re: how to avoid duplicates values from alvgird see below code

seshatalpasai_madala — Fri, 03 Nov 2006 05:59:21 GMT

Hi,

There are two options based on your need.

If the entire row of the table is same then you can sort the internal table using SORT . And then delete the duplicate entreis using DELETE ADJACENT DUPLICATES.

Then your ALV Will display only unique rows.

But if only docno fileds has sames values and other fileds have different values you can use the following code to display only one value for the same doc number.

DATA: ls_sort TYPE lvc_s_sort.

DATA: lt_sort TYPE lvc_t_sort.

ls_sort-spos = column position.

ls_sort-fieldname = column fieldname.

ls_sort-group = abap_true.

APPEND ls_sort TO lt_sort.

then pass this to the it_sort import parameter of the ALV's SET_TABLE_FOR_FIRST_DISPLAY method.

Regards,

Sesh

Re: how to avoid duplicates values from alvgird see below code

former_member184495 — Fri, 03 Nov 2006 06:15:42 GMT

hi,

you can either use SELECT DISTINCT, but better avoid using this if the fields in the query are not a part of index,

hence use DELETE ADJACENT DUPLICATES from the internal table and then pass to ALV,

Cheers,

Aditya.

Re: how to avoid duplicates values from alvgird see below code

Former Member — Fri, 03 Nov 2006 06:30:48 GMT

Hi Laxman,

after that select statement

select * into corresponding fields of table itab

from J_1IEXCHDR

inner join J_1IEXCDTL

on J_1IEXCDTL_{lifnr = J_1IEXCHDR}lifnr

where J_1IEXCHDr~status = 'P'.

if sy-subrc = 0.

delete adjucent duplicates from itab comparing <field name of itab internal table>

endif.

this will delete your duplicate entries.once you done with this call the alv FM.

call function 'REUSE_ALV_GRID_DISPLAY'

exporting

I_INTERFACE_CHECK = ' '
I_BYPASSING_BUFFER = ' '
I_BUFFER_ACTIVE = ' '

i_callback_program = v_repid

I_CALLBACK_PF_STATUS_SET = ' '
I_CALLBACK_USER_COMMAND = 'IT_USER_COMMAND'
I_CALLBACK_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_TOP_OF_PAGE = ' '
I_CALLBACK_HTML_END_OF_LIST = ' '
I_STRUCTURE_NAME =
I_BACKGROUND_ID = ' '

i_grid_title = 'Purchase Order Details'

I_GRID_SETTINGS = I_GRID_SETTINGS

is_layout = wa_layout

it_fieldcat = it_fieldcat

IT_EXCLUDING = IT_EXCLUDING
IT_SPECIAL_GROUPS = IT_SPECIAL_GROUPS

it_sort = it_sort

IT_FILTER = IT_FILTER
IS_SEL_HIDE = IS_SEL_HIDE
I_DEFAULT = 'X'
I_SAVE = ' '
IS_VARIANT = IS_VARIANT

it_events = it_event

IT_EVENT_EXIT = IT_EVENT_EXIT
IS_PRINT = IS_PRINT
IS_REPREP_ID = IS_REPREP_ID
I_SCREEN_START_COLUMN = 0
I_SCREEN_START_LINE = 0
I_SCREEN_END_COLUMN = 0
I_SCREEN_END_LINE = 0
I_HTML_HEIGHT_TOP = 0
I_HTML_HEIGHT_END = 0
IT_ALV_GRAPHICS = IT_ALV_GRAPHICS
IT_HYPERLINK = IT_HYPERLINK
IT_ADD_FIELDCAT = IT_ADD_FIELDCAT
IT_EXCEPT_QINFO = IT_EXCEPT_QINFO
IR_SALV_FULLSCREEN_ADAPTER = IR_SALV_FULLSCREEN_ADAPTER
IMPORTING
E_EXIT_CAUSED_BY_CALLER = E_EXIT_CAUSED_BY_CALLER
ES_EXIT_CAUSED_BY_USER = ES_EXIT_CAUSED_BY_USER

tables

t_outtab = ITAB

exceptions

program_error = 1

others = 2

if sy-subrc <> 0.

message id sy-msgid type sy-msgty number sy-msgno

with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

endif.

Thanks

Vikranth Khimavath

Re: how to avoid duplicates values from alvgird see below code

Former Member — Fri, 03 Nov 2006 06:56:39 GMT

good

if you r getting the duplicate value in your alv grid than you can't do anything by the select statement, you have to pass that particular varible through a funtion module which ll return you only single value , and than you can use that value as per your requirement.

thanks

mrutyun^