update button in module pool program

Former Member — Tue, 05 Feb 2008 09:39:03 GMT

Hi Experts,

i have problem with my report, i developed my own DDIC table, screen to insert data in to table,

so my prb is, i have screen on which there r 3 buttons called(INSERT,UPDATE,EXIT)

so insert n exit is ok but when i press UPDATE its not working upto my requirement,

my requiremnt is :-

i have a fields called end_gallons n rin_no ,so im adding end gallons for every record entered

n it is concatenating and displays in rin_no.

so in concatenation it should display data with added values and with preceeding zeros for easy to understand ill send u my code so plz correct it

WHEN 'CHN'.

SELECT END_GALLONS

RIN_NO FROM ZRIN INTO TABLE I_ZRIN WHERE FILL_DATE =

ZRIN-FILL_DATE.

EGALLONS = ZRIN-END_GALLONS.

SUM = 0.

LOOP AT I_ZRIN.

SUM = EGALLONS + I_ZRIN-END_GALLONS.

ENDLOOP.

ZRIN-END_GALLONS = SUM.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'

EXPORTING

INPUT = GALLONS

IMPORTING

OUTPUT = GALLONS

I_ZRIN-END_GALLONS = GALLONS.

MOVE ZRIN-BILL_OF_LADING TO T_ZRIN-BILL_OF_LADING.

MOVE ZRIN-ASSIGNED_RIN TO T_ZRIN-ASSIGNED_RIN.

MOVE ZRIN-CALENDAR_YEAR TO T_ZRIN-CALENDAR_YEAR.

MOVE ZRIN-EPA_COMPANY_ID TO T_ZRIN-EPA_COMPANY_ID.

MOVE ZRIN-EPA_FACITILY_ID TO T_ZRIN-EPA_FACITILY_ID.

MOVE ZRIN-RIN_BATCH_CODE TO T_ZRIN-RIN_BATCH_CODE.

MOVE ZRIN-EQUIVA_VALUE TO T_ZRIN-EQUIVA_VALUE.

MOVE ZRIN-CELLULOSIC TO T_ZRIN-CELLULOSIC.

MOVE ZRIN-START_GALLONS TO T_ZRIN-START_GALLONS.

MOVE ZRIN-END_GALLONS TO T_ZRIN-END_GALLONS.

CONCATENATE T_ZRIN-BILL_OF_LADING

T_ZRIN-ASSIGNED_RIN

T_ZRIN-CALENDAR_YEAR

T_ZRIN-EPA_COMPANY_ID

T_ZRIN-EPA_FACITILY_ID

T_ZRIN-RIN_BATCH_CODE

T_ZRIN-EQUIVA_VALUE

T_ZRIN-CELLULOSIC

T_ZRIN-START_GALLONS

T_ZRIN-END_GALLONS INTO ZRIN-RIN_NO.

UPDATE ZRIN SET END_GALLONS = ZRIN-END_GALLONS

RIN_NO = ZRIN-RIN_NO

WHERE FILL_DATE = ZRIN-FILL_DATE.

UPDATE ZRIN SET ASSIGNED_RIN = ZRIN-ASSIGNED_RIN

CALENDAR_YEAR = ZRIN-CALENDAR_YEAR

EPA_COMPANY_ID = ZRIN-EPA_COMPANY_ID

EPA_FACITILY_ID = ZRIN-EPA_FACITILY_ID

RIN_BATCH_CODE = ZRIN-RIN_BATCH_CODE

EQUIVA_VALUE = ZRIN-EQUIVA_VALUE

CELLULOSIC = ZRIN-CELLULOSIC

START_GALLONS = ZRIN-START_GALLONS

*END_GALLONS = ZRIN-END_GALLONS

*RIN_NO = ZRIN-RIN_NO

TRANSFER_OR_EPA = ZRIN-TRANSFER_OR_EPA

FILL_DATE = ZRIN-FILL_DATE

VOL_TRANSFERED = ZRIN-VOL_TRANSFERED

WHERE BILL_OF_LADING = ZRIN-BILL_OF_LADING.

Re: update button in module pool program

Former Member — Tue, 05 Feb 2008 09:57:56 GMT

Hi Rajesh,

What is the problem you are facing are you not getting the Gallons values as expected.

Thanks & regards,

M.Ramana Murthy

Re: update button in module pool program

Former Member — Tue, 05 Feb 2008 10:00:57 GMT

hey thanks for reply im getting evry thing perfect but problem im not getting preceddinng zeros in RIN_NO

topic Re: update button in module pool program in Application Development and Automation Discussions

update button in module pool program

Re: update button in module pool program

Re: update button in module pool program