Data Displaying issue in ALV report

[Former Member]

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

[Former Member]

Hi,

use the FM --> REUSE_ALV_HIERSEQ_LIST_DISPLAY

and passt he two tables --

one hdr table with order no & qty

second detail with order no materail and other fields

[Former Member]

Thanks all for your reply.

regards,

zafar

[arsul_parshuram]

Hiiiiii Zafar,

have you done above report ?

if yes then let me know. how ?

Regards,

Parshuram

[Former Member]

Hi Zafar,

You can populate your internal table as per the requirement.

• at new order only.

itab-Order = 3000000 .

itab-Order quantity = 100.

append itab

• for all materials for that order

itab-MATERIAL = 610 .

itab-TOTAL QTY = 100 .

itab-SHORTAGE QTY = 5.

append itab.

Cheers,

Suhail

[Former Member]

Hi,

Put your data in to two internal tabels One header table which will contain order no and qty another one will be Item table which will contain material related data with order no. pass these internal tabels in this ALV function module .

REUSE_ALV_HIERSEQ_LIST_DISPLAY

Jitendra

Edited by: Jitendra Singh on May 28, 2010 1:50 PM