Application Development 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: 

Sorting in Classical report

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

3 REPLIES 3

P561888
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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