Smartform Grouping

[former_member377333]

Dear All

using sap smartform, developed the sd invoice printout as below, but while printing same product is printing is multiple line due to batch no based, (batch number not printed in the invoice output) how to print same in single line material wise,

please suggest!!!!

Existing

=============================================

S.No--

---

Material Description--

---

Qty

=============================================

10--

---

WHOLE MILK POWDER - 25 KG--

---

0

11--

---

WHOLE MILK POWDER - 25 KG--

---

22

12--

---

WHOLE MILK POWDER - 25 KG--

---

2

13--

---

WHOLE MILK POWDER - 25 KG--

---

1

*21--

---

Butter 20 KG (Salted) 1--

---

EA*

*22--

---

Butter 20 KG (Salted) 1--

---

EA*

*23--

---

Butter 20 KG (Salted) 1--

---

EA*

*24--

---

Butter 20 KG (Salted) 1--

---

EA*

*25--

---

Butter 20 KG (Salted) 1--

---

EA*

*26--

---

Butter 20 KG (Salted) 1--

---

EA*

*27--

---

Butter 20 KG (Salted) 1--

---

EA*

*28--

---

Butter 20 KG (Salted) 1--

---

EA*

*29--

---

Butter 20 KG (Salted) 1--

---

EA*

*30--

---

Butter 20 KG (Salted) 1--

---

EA*

*31--

---

Butter 20 KG (Salted) 1--

---

EA*

=============================================

Required Like

=============================================

S.No--

---

Material Description--

---

Qty

=============================================

1--

---

WHOLE MILK POWDER - 25 KG--

---

25

2----

---

Butter 20 KG (Salted) -

---

11

=============================================

thanks

anandavel.c

[former_member377333]

Hi Mohaiyuddin,

Thanks for the updation.

I would like to do SUM in the SMARTFORMS only.

Due to that will you please explain more on this?

because of I'm very new for the SMARTFORMS development.

Regards,

Anandavel

[Former Member]

You can Either sum up the Quantity according to material in your driver program (Use logic, or use of aggregate function like AT NEW, AT END etc...)...into new internal table and pass it to SMARTFORM OR

Use Logic in SMARTFORM to aggregate Quantity and print Quantity only on change of Material...You might need to set some flags for change of Material and put condition on all relevant nodes to check for those flags.

If you are having driver program, I would suggest first method.

Thanks,

Regards,

Mohaiyuddin