topic Re: -ve sign missing while downloading in Application Development and Automation Discussions

-ve sign missing while downloading

Former Member — Tue, 04 Nov 2008 07:23:47 GMT

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.

Re: -ve sign missing while downloading

Former Member — Tue, 04 Nov 2008 08:41:54 GMT

are you sure , double check it once.

Re: -ve sign missing while downloading

Former Member — Tue, 04 Nov 2008 08:55:56 GMT

hi vijay,

-ve sign is missing. i have checked it.

Re: -ve sign missing while downloading

Former Member — Wed, 05 Nov 2008 09:28:21 GMT

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

Re: -ve sign missing while downloading

Former Member — Tue, 11 Nov 2008 07:21:44 GMT

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.