topic Re: Processing an intenal table in Application Development and Automation Discussions

Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:01:14 GMT

Hi All,

I have an internal table which has following values:

Project Indicator Cost

P001 I 10000

P001 I 20000

P001 D 500

P001 D 1000

P002 I 2000

P002 I 1000

I need to do a processing in such a way that i get following data in another internal table.

Project Indicator Cost

P001 I 30000

P001 D 1500

P002 I 3000

How do I achieve this ?

Regards,

Satya

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:03:51 GMT

append the all the records to internal table then use delete adjacent duplicates command.

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:04:46 GMT

Hi,

You can create a new internal table with just the three fields and then use COLLECT to sum up the records..



LOOP AT ITAB INTO WA.

* move the values.
  WA_COLLECT-PROJECT = WA-PROJECT.
  WA_COLLECT-INDICATOR = WA-INDICATOR.
  WA_COLLECT-COST = WA-COST. 

* Use collect.
   COLLECT WA_COLLECT TO ITAB_COLLECT.  

ENDLOOP.

* Now the values will be consolidated based on project and indicator..

Thanks,

Naren

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:05:41 GMT

hi Satya,

do this way ..


sort itab by project indicator.
loop at itab.
at new project.
sum.
it_final-project = itab-project.
it_final-indicator = itab-indicator.
append it_final.
clear : it_final, itab..
endloop.

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:06:09 GMT

HI Satya ,

Use the collect statement.

The code will look some thing like this

Loop at it_1 into wa_1.
 collect wa_1 into it_2.
endloop.

Hope this helps.

Regards

Arun

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:06:14 GMT

hi satya,

welcome to sdn,

use collect statement in loop to calcualte project related costs,

reward points if helpful,

regards,

seshu.

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:07:38 GMT

Write

sort itab by project indicator.

Loop at ITAB.

at end of indicator.

read table itab index sy-tabix.

sum.

move-corresponding itab to itab1.

append itab1.

endat.

clear itab1.

endloop

Reward points for useful Answers

Regards

Anji

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:07:41 GMT

sort itab1 by firstfieldname secondfieldname

loop at itab1 into wa1

amount = amount + wa1-thirdfield name .

at end of second field name .

wa2-thirdfield name = amount.

append wa2 to itab2 .

clear amount.

end at.

endloop.

itab2 will contains the required entires

Re: Processing an intenal table

S0025444845 — Tue, 12 Jun 2007 05:10:32 GMT

Hi,

for this You can use collect statement,write collect on abap editor and press F1 help, u will get it.

regards,

sudha

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:14:08 GMT

use the below logic for you display


sort  you itab so that the  sequence will be there
sort  itab  by  PROJECT INDICATOR.
LOOP AT ITAB .
*****for  new  Project  based on sorting  .
Atnew PROJECT .
Endat .

Atend INDICATOR.
***** Total will be done  on  indicator  Using  sum
SUM .
final-PROJECT = WA-PROJECT.
final -INDICATOR = WA-INDICATOR.
final -COST = WA-COST. 
Endat
****appending in new  table
Append  final . 
ENDLOOP.

****DIsplay Output
LOOP AT  FINAL.
WRITE : / final-PROJECT ,final -INDICATOR ,final -COST  .
ENDLOOP.

Girish

Re: Processing an intenal table

Former Member — Tue, 12 Jun 2007 05:21:13 GMT

Hi,

fallow the fallowing steps

1. first sort the internal table (sort).

2.then based on previous value check with current value.

ex: take some temp workarea and store 1st record , when internal table workarea is holding the value of 2nd record then compare those records....... if both char datatype values are same then add the integer types.( equal operator ).

3. store those new value into an new internal table.(append).

4. loop that new internal table . then U will get the acctual result (loop).

don't forget to give points of itis usefill for U.