topic Re: Regarding Line Items in Application Development and Automation Discussions

Regarding Line Items

Former Member — Thu, 10 May 2007 02:46:38 GMT

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

Re: Regarding Line Items

Former Member — Thu, 10 May 2007 02:48:44 GMT

Use Internal Table events :

at new.

endat

at end of

endat

at last

endat.

Thanks

Seshu

Re: Regarding Line Items

Former Member — Thu, 10 May 2007 02:54:32 GMT

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.