Skip to Content
0
Former Member
Nov 10, 2011 at 08:32 PM

Add qty by using SUM in control break statement based on a condition.

278 Views

Hi,

I have an internal table t_confirm containing fields vbeln(Delivery) posnr(Item) tanum(TO) tapos(TO item) nistm(Qty) vltyp(Storage Location).

I have a internal table t_picklist having lgnum(warehouse) and vltyp(Storage type).

The table has One warehouse and many storage types.

I need to sum nistm(qty) for each new delivery and its item.But i need to neglect(do not sum) the record in table t_confirm having storage type(vltyp) as the storage type from t_picklist.

This can be done using two loops.

Loop at t_confirm.

Read from t_picklist having same storage type.

Delete the obtained record.

Sort t_confirm by vbeln and posnr.

Loop at t_confirm again.

At end of posnr

Sum.

Is there a way to do it in a single loop?