-ve sign missing while downloading

[Former Member]

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.

[former_member188685]

are you sure , double check it once.

[Former Member]

hi vijay,

-ve sign is missing. i have checked it.

[Former Member]

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

[Former Member]

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.