hide duplicate entries in 3 fields

[former_member260061]

i want to hide duplicate entries of these column ( Dispatch , Order , Sap Order , Reference table) . can any one help?

select vbap~vbeln vbap~charg vbak~knumv vbap~kwmeng vbkd~bstkd
likp~vbeln lips~vgpos as posnr lips~ernam lips~matnr lips~lfimg
lips~meins lips~arktx lips~werks lips~vgbel lips~lgort
vbap~netpr lips~netwr likp~wadat likp~lifex
lips~werks lips~bwart
from lips
inner join vbap on
lips~vgbel = vbap~vbeln
join vbak on
vbak~vbeln = vbap~vbeln
join vbkd on
vbkd~vbeln = vbak~vbeln
join likp on
lips~vbeln = likp~vbeln
into corresponding fields of table
itab
where
lips~vgpos = vbap~posnr and
lips~werks = lv_werks and
lips~lgort = lv_lgort and
lips~bwart = lv_bwart and
likp~wadat in lv_wadat.

Answer will be

regard

khurram

[Former Member]

if you are using ALV then you can use SORT functionality in the ALV FM, otherwise you need to do manually looping your table and using AT statements, you cannot hid these fields just changing select query.

[Sandra_Rossi]

With SELECT, this is impossible, and not desired as per SQL philosophy.

But you could do it at the time your output the SQL result.

Could you please tell us which technology you use?

[mangesh_parihar]

Hi,

Use Control Break Statements in the final table.

1. Sort the final table on Dispatch, Order, SAP order and reference table.
2. Use At New Dispatch.

Hope it helps.

Regards,

Mangesh