topic finding sum as per date in dialog program in Application Development and Automation Discussions

finding sum as per date in dialog program

Former Member — Fri, 01 Feb 2008 09:32:50 GMT

Hi Experts,

i have problem with report,plz help me out

my problem is, i have a ddic table for which i createsd a screen to enter values into table,

n i kept buttons called GENERATE, UPDATE ,LIST.and fields in my screen are

BILL_OF_LADING TYPE ZRIN-BILL_OF_LADING,

ASSIGNED_RIN TYPE ZRIN-ASSIGNED_RIN,

CALENDAR_YEAR

EPA_COMPANY_ID

EPA_FACITILY_ID

RIN_BATCH_CODE

EQUIVA_VALUE

CELLULOSIC

START_GALLONS,

END_GALLONS

RIN_NO

TRANSFER_OR_EPA ,

FILL_DATE

VOL_TRANSFERED

so when i enter data through this screen there r two field called(END_GALLONS ) it should get SUM with previous END_GALLONS with respect to FILL_DATE , how to do that.its MODULE POOL PROGRMMING,plz help me out,very urgent.

Re: finding sum as per date in dialog program

Former Member — Fri, 01 Feb 2008 17:37:13 GMT

Hi Rajesh,

It appears you need to sum up the gallons field by date field. Now instead of racking one's brain over this, why dont we leave the solution to SAP by using ALV here.

You can create a new screen with a container and call an object oriented ALV. Sort the ALV output by FILL_DATE and perform SUM.

This would group together records with same FILL_DATE and also show the sums as a new row .... this would also allow you to perform operations like downloading etc. which I am sure would be useful.

To call the ALV, you can add a button on the application toolbar, when clicked, it would call the ALV dialog screen.

Cheers,

Aditya