Regarding Line Items

[Former Member]

Hi

I want to display customer wise open items in a report. In that I want to merge all the items by adding amounts and display it under document no. I used collect statement for this. Is there any other alternative to add the amounts and display them?

plz give me the suggestion ASAP.

Thanks in advance

venkat

[Former Member]

Hi

I want to display customer wise open items in a report. In that I want to merge all the items by adding amounts and display it under document no. I used collect statement for this. Is there any other alternative to add the amounts and display them?

plz give me the suggestion ASAP.

Thanks in advance

venkat

[Former Member]

Use Internal Table events :

at new.

endat

at end of

endat

at last

endat.

Thanks

Seshu

[Former Member]

Hi Venkata,

If you use

SORT <INTERNAL TABLE> BY <column name>
AT NEW  'column name'.
ENDAT.

but make sure that the 'Column name' should be at the first position other wise all data will display.... . AT NEW will not work.