topic Re: Calculations in Application Development and Automation Discussions

Calculations

Former Member — Tue, 07 Aug 2007 04:26:35 GMT

Hi Guys,

I was trapped into a little bit confusion correlated to my task. Data was populated to my internal table with field’s delivery, customer number, postal code, weight, volume. Now I sorted that internal table based on the customer and postal code. Now I need to perform the following points:

• Read through the list and select deliveries having same ship to party and address.

• Calculate weight and volume of the selected deliveries in the above step.

If I am correct I need to compare the customer and address for the current record with previous one. Please help me out in this query and your help will be will be greatly appreciated. Looking for your kind co-operation.

Regards,

Ravi.

Re: Calculations

Former Member — Tue, 07 Aug 2007 04:44:44 GMT

you all the records in Itab sorted by customer and postal code. so all the records with same customer and postal code will be coming next to each other....

move first records customer and postal code to a work area 2...

loop itab to work area 1.

if customer and postal code in WA1 and wa2 is equal.

calc tot_weight and tot_volume.

else

print the tot_weight and tot_volume.

assign customer and postal code of current record in wa1 to wa2.

reset tot_weight and tot_volume to 0.

endif.

endloop.

print the tot_weight and tot_volume. - last set.

Re: Calculations

Former Member — Tue, 07 Aug 2007 12:02:53 GMT

Hi Damodaran,

Thanks for the immediate response. Infact i was tried and now i got that. I build a new logic which is littlebit parllel to your solution. Thanks for our suggestion.

Regards,

ravi.