Data Displaying issue in ALV report

37 Views

Hi,

I have made a ALV report, the presetn display layout is as below

it is displaying the material shortage reprot against issued production order

ORDER NO. Order Qty. MATERIAL TOTAL QTY SHORTAGE QTY

3000000 100 610 100 5

3000000 100 101 200 43

3000000 100 8795 400 400

3000000 100 456 100 67

3000001 50 548 50 33

3000004 62 710 62 3

3000005 15 7895 15 15

3000020 11 456 22 10

now the user requirement is the report should come as per below formate

AT EACH NEW ORDER NUMBER :

****************first display main order no. and order qty.

ORDER NO. Order Qty

3000000 100

************************then below this display the indiviual material and qty.

MATERIAL TOTAL QTY SHORTAGE QTY

610 100 5

101 200 43

8795 400 400

456 100 67

*******again at new order******

ORDER NO. Order Qty

3000001 50

**********then below display the items

MATERIAL TOTAL QTY SHORTAGE QTY

548 50 33

how to do this is there any output layout with this i can get this formate in LAV report

regards,

zafar