Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

redundant data

Former Member
0 Likes
594

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?

4 REPLIES 4
Read only

Former Member
0 Likes
456

hi

1. sort the internal table on the kunnr.

2. use delete adjacent duplicates kunnr.

this will remove the duplicates.

hope this helps.

Read only

Former Member
0 Likes
456

first step sort the table.

next delete adjacent duplicates.

Regards

Read only

Former Member
0 Likes
456

hi again

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING KUNNR.

is the exact code you will need after sorting

Read only

0 Likes
456

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