2008 Jun 04 3:12 AM
Hi guys,
Will the collect statement also sum up the data with type numc?
thanks!
rgds,
Mark
2008 Jun 04 3:19 AM
Hi guys,
Will the collect statement also sum up the data with type numc?
thanks!
rgds,
Mark
2008 Jun 04 3:19 AM
2008 Jun 04 3:19 AM
2008 Jun 04 3:23 AM
Thanks guys!
How about the packed number?
Thanks again!
Rgds,
Mark
2008 Jun 04 3:36 AM
yah , as i told u for every field it will sum except char field and date filed.
Collect will work :
suppose u have three fileds : MATNR DATE MENGE
000001 01-01-2008 10.000
000002 01-01-2008 10.000
000001 01-01-2008 10.000
000003 01-01-2008 10.000
000003 01-01-2008 10.000
000001 01-01-2008 10.000
000002 01-01-2008 10.000
When u will use collect .
MATNR and DATE are char and Date types.
and MENGE is Quantity field.
so whenever MATNR and DATE will same , MENGE will SUM.
so o/p will be
: MATNR DATE MENGE
000001 01-01-2008 30.000
000002 01-01-2008 20.000
000003 01-01-2008 20.000