topic Re: Summarization in table in Application Development and Automation Discussions

Summarization in table

Former Member — Thu, 25 Nov 2010 10:47:01 GMT

Hi experts,

Am having one table with 7 fields, in which 5 fields are numeric n remaining 2 are character.

In this table 1 field is "Description" which contents either "Agency" or "Non Agency" ,am having 10 record in the table in which 5 are Agency and 5 are Non Agency.

Now i want to summarize all records which are Agency n All records which are Non Agency.

In end of summarization i only want two record in table.

One for "AGENCY"

and Other "NON AGENCY".

There is no key in table.

thx in advance.

Re: Summarization in table

Former Member — Thu, 25 Nov 2010 10:56:35 GMT

U can create a new internal table is equal to the yours table, then you can COLLECT the record of old table to the new one:

LOOP AT ITAB INTO ITAB2.
   COLLECT ITAB2.
ENDLOOP.

See the help for COLLECT statament

Max

Re: Summarization in table

Former Member — Thu, 25 Nov 2010 11:00:55 GMT

I cant use COLLECT becoz collect will summarize all the record n i dont want all records to summarize.

Re: Summarization in table

Former Member — Thu, 25 Nov 2010 14:46:59 GMT

And which record you need to elaborate?

Max

Re: Summarization in table

Former Member — Thu, 25 Nov 2010 14:59:33 GMT

Thx everyone prob solved

Re: Summarization in table

Former Member — Thu, 25 Nov 2010 15:04:24 GMT

Well

Close the post and write the solution you've used, so it'll be able to be used by somebody with a problem like yours in the future

Max