topic Re: redundant data in Application Development and Automation Discussions

redundant data

Former Member — Sat, 07 Oct 2006 11:00:51 GMT

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?

Re: redundant data

Former Member — Sat, 07 Oct 2006 11:04:21 GMT

1. sort the internal table on the kunnr.

2. use delete adjacent duplicates kunnr.

this will remove the duplicates.

hope this helps.

Re: redundant data

Former Member — Sat, 07 Oct 2006 11:09:55 GMT

first step sort the table.

next delete adjacent duplicates.

Regards

Re: redundant data

Former Member — Sat, 07 Oct 2006 11:10:14 GMT

hi again

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING KUNNR.

is the exact code you will need after sorting

Re: redundant data

Former Member — Sat, 07 Oct 2006 11:26:51 GMT

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.

delete adjacent duplicates from t_orders comparing netwr. the tab was sorted based on costno, kunnr