hii all,
i have a internal table in which data is coming like this
VBELN LFIMG
20000018 50,000
80003370 1,000
80003371 5,000
80003371 5,000
80003371 4,000
80003371 4,000
80003372 10,000
80003373 10,000
80003375 4,000
80003375 5,000
80003375 4,000
80003375 3,000
80003376 2,000
80003376 4,000
80003376 4,000
80003376 5,000
80003377 5,000
80003377 6,000
80003377 4,000
80003377 7,000
80003378 1,000
80003378 5,000
80003378 6,000
80003378 7,000
80003379 7,000
80003379 4,000
80003379 3,000
80003379 5,000
80003380 1,000
80003380 1,000
80003380 2,000
80003380 1,000
80003381 2,000
80003381 3,000
80003381 1,000
80003381 1,000
80003382 2,000
80003382 3,000
80003382 1,000
80003382 1,000
80003383 3,000
80003383 2,000
80003383 2,000
80003383 1,000
80003384 5,000
80003384 6,000
80003384 6,000
80003384 7,000
80003385 3,000
80003385 3,000
80003385 5,000
80003385 6,000
80003386 3,000
80003386 6,000
both fields coming from lips.
now i want count vbeln when:
vbeln is not change:
and correponding values of lfimg would be added
and display.
the OUTPUT SHOULD BE:
vbeln lfimg no. of records
20000018 50,000 1
80003370 1,000 1
80003371 18000 4
80003372 10,000 1.
and so on.....................
please provide me the suitable code.
thanks
babbal.