Skip to Content
0
Former Member
May 16, 2008 at 07:20 AM

Problem with Group By clause .......

35 Views

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