Hi Experts i ve a data in my internal table in that there are some common fields with amount value.
in first col i ve 3 projects, for every project there are many rows.
but i want to loop that table and add amount for rows which those are satisfy my condition.
how to use group by clause.
my data will be like:
field1 field2 field3 field4 f5 f6 f7 f8 f9
SG-0143 StevenTan SG-0143.01.01 2007 32 1 KABG USD 114,385.93
SG-0143 StevenTan SG-0143.01.01 2007 32 1 KABG USD 114,385.93
SG-0143 StevenTan SG-0143.01.01 2007 32 1 KABG USD 114,385.93
SG0143 StevenTan SG-0143.01.01 2007 32 1 KABG SGD 114333.93
SG0143 StevenTan SG-0143.01.01 2007 32 1 KABG USD 1145555.93
SG-0143 StevenTan SG-0143.01.01 2007 32 1 KABG SGD 7457694
SG-1000 StevenTan SG-0143.01.01 2007 32 1 KABG USD 114,385.93
SG-1000 StevenTan SG-0143.01.01 2007 32 1 KABG USD 114,385.93
could anyone give how to procede..
Thanks in advance,
sudeer.
Edited by: sudeer kumar on May 16, 2008 9:20 AM