finding sum as per date in dialog program

[Former Member]

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.

[Former Member]

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