Skip to Content
-1

hide duplicate entries in 3 fields

Apr 25, 2017 at 09:09 AM

72

avatar image
Former Member

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

untitled.jpg (146.5 kB)
untitled1.jpg (122.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Apr 25, 2017 at 12:57 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Sandra Rossi Apr 25, 2017 at 07:28 PM
1

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?

Share
10 |10000 characters needed characters left characters exceeded
Mangesh Parihar Apr 26, 2017 at 05:46 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded