‎2008 Feb 05 9:39 AM
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.
‎2008 Feb 05 9:57 AM
Hi Rajesh,
What is the problem you are facing are you not getting the Gallons values as expected.
Thanks & regards,
M.Ramana Murthy
‎2008 Feb 05 10:00 AM
hey thanks for reply im getting evry thing perfect but problem im not getting preceddinng zeros in RIN_NO