How to Split data in table using Smartforms

[Former Member]

Hi

Considering internal table data, can any let me know how to design the below listed output using table in smartforms.

Internal table

Order | Ship-to | material | mat desp| qty

1001 | aaaaaa | MAT101 | xxxxxxx | 1

1001 | aaaaaa | MAT102 | yyyyyyy | 4

1002 | bbbbbb | MAT101 | xxxxxxx | 2

1002 | bbbbbb | MAT103 | zzzzzzz | 10

Output

-

---

Order | ship-to | total qty

1001 | aaaaaa| 5

Material| Mat desp| qty

MAT101| xxxxxxx | 1

MAT102| yyyyyyy | 4

-

---

Order | ship-to | total qty

1002 | bbbbbb| 12

Material| Mat desp| qty

MAT101| xxxxxxx | 2

MAT103| zzzzzzz | 10

-

---

Thanks

[Former Member]

Thanks for all in viweing my question, solved.

Regards

Shinoy

[Former Member]

hi Shinoy N ,

declare it_mat, wa_mat, it_order, wa_order in global definitoins....

in the program lines....

sort itab by order.

loop at itab.

wa_order-order = itab-order.

wa_order-shipto = itab-shipto.

wa_order-qty = itab-qty.

wa_mat-material = itab-material.

wa_mat-shipto = itab-shipto.

wa_mat-qty = itab-qty.

collect it_mat from wa_mat.

collect it_order from wa_order.

endloop.

feel free to contact me if issue is not resolved/.....

all the best...

Regards,

Sreeniasa Sarma K.

[Former Member]

Hi kashi,

Thanks for the reply, my question is how to display corresponding data based on order no. in smartform output. i want to use table for this(correct if am wrong with this scenario) and thinking how to group the data (what exclusive logic have to use in table)as shown in example above.

can i proceed to display the above output in main window without table template?

Thanks

Edited by: Shinoy N on Mar 29, 2008 10:39 AM