01-27-2010 12:25 PM
Hi,
In my classical report, Am having four columns. I have shown below.
orderno. order date, matl code, qty
1234567 02012010 ball bearing 10
1234567 02012010 ball bearing 20
1234567 02012010 ball bearing 30
But my requirement is to delete the repeated orderno date and matl code.
As shown below.
1234567 02012010 ball bearing 10
20
30.
Thanks
Arvind
01-27-2010 12:30 PM
loop at itab into wtab.
at new field1
write : wtab-f1 , wtab-f2,wtab-f3.
endat.
write : wtab-f4
endloop.
specify ur vline and uline position according to ur requirement
01-27-2010 12:29 PM
Hi ,
Is this done for the report display or only internal table sorting?
Report display Try for the At new or on change of in the Loop to display in the output.
Regards,
Bharani.
01-27-2010 12:30 PM
loop at itab into wtab.
at new field1
write : wtab-f1 , wtab-f2,wtab-f3.
endat.
write : wtab-f4
endloop.
specify ur vline and uline position according to ur requirement
01-27-2010 12:37 PM
Hi,
Try as below ---
sort <internal table> by orderno,date,matl code.
delete adjacent duplicated from <internal table> comparing orderno,date,matl code.
Regards
Arbind