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

Sorting in Classical report

Former Member
0 Likes
405

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
Read only

Former Member
0 Likes
370

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
Read only

BH2408
Active Contributor
0 Likes
370

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.

Read only

Former Member
0 Likes
371

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

Read only

Former Member
0 Likes
370

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