11-04-2008 7:23 AM
Hi all,
I am working on ALV using oops concepts. I am not getting the -ve sign of amounts while downloading data to excel sheet. It is shown in ALV output correctly. Please help.
11-04-2008 8:41 AM
11-04-2008 8:55 AM
11-05-2008 9:28 AM
Hi Jayasri,
I will tell a scenario where i downloaded the values in an excel sheet with negative sign at the end instead at the front. e.g 4551653-. But this negative sign appeared automatically after downloading.I have to display this negative sign at the front.For this i have used the following function module.
IF <source-field> LT 0.
MOVE <source-field> TO w_negative.
CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'
CHANGING
value = w_negative.
MOVE w_negative TO <target-field>.
CLEAR w_negative.
ELSE.
MOVE <source-field> TO <target-field>.
ENDIF.
I guess you can use this code before calling your function module for downloading. Pass the table after appending this field value with negative sign to the download function module.Hope it works.
With Regards,
Sasikala
11-11-2008 7:21 AM
Hi, my problem is solved. I have used REUSE_ALV_GRID_DISPLAY.Then automatically my problem is solved . Earlier it was developed with oops concepts.