‎2006 Oct 07 12:00 PM
i have built a complex report using kna1 , vbak ,vbap.
i want the customer number to be displayed once for the various order numbers placed by the same customer.in a sentence how to avoid redundancy?
‎2006 Oct 07 12:04 PM
hi
1. sort the internal table on the kunnr.
2. use delete adjacent duplicates kunnr.
this will remove the duplicates.
hope this helps.
‎2006 Oct 07 12:09 PM
first step sort the table.
next delete adjacent duplicates.
Regards
‎2006 Oct 07 12:10 PM
hi again
DELETE ADJACENT DUPLICATES FROM ITAB COMPARING KUNNR.
is the exact code you will need after sorting
‎2006 Oct 07 12:26 PM
i've sorted the table based on the customer nmo. n in the syn u gave i m using t_orders(combo of all 3 tabs(selected cols)) tab n netwr i.e. order no.
but it didn't work.
like
delete adjacent duplicates from t_orders comparing netwr. the tab was sorted based on costno, kunnr