Negative sign for Values

[Former Member]

Hi Experts,

I am woking on BW and know some ABAP.

While i am feching data from table i am getting value as Ex: 100-(negative), but i want to show this as -100. I am downloading data into flat file, not for display.

Data i am getting now:

Mat Customer Value Qty

M100 C100 100- 10-

But i want to show this as below.

Mat Customer Value Qty

M100 C100 -100 -10

I am not expert in ABAP, plese give some suggitions or sample coding(if possible).

Thank you a lot.

Srini

[Former Member]

Hi Experts,

I am woking on BW and know some ABAP.

While i am feching data from table i am getting value as Ex: 100-(negative), but i want to show this as -100. I am downloading data into flat file, not for display.

Data i am getting now:

Mat Customer Value Qty

M100 C100 100- 10-

But i want to show this as below.

Mat Customer Value Qty

M100 C100 -100 -10

I am not expert in ABAP, plese give some suggitions or sample coding(if possible).

Thank you a lot.

Srini

[Former Member]

Hello Srini,

Please refer to the following post -

Regards,

Anand Mandalika.

[Former Member]

Thank you all for quick and prompt reply.

But unfortunately the function module(CLOI_PUT_SIGN_IN_FRONT) is not available in BW.

But i created in BW by coping from R/3. Problem solved.

Thank you once again.

Srini

[Former Member]

IF var LT 0.

WRITE : '-'.

ENDIF.

WRITE var NO-SIGN.

[Former Member]

hi Srini...

The solution for this is already posted in this Forum ... i.e, Use FM <b>CLOI_PUT_SIGN_IN_FRONT</b>

or use <b>EDIT MASK</b> Option

here is that thread

Regards,

Santosh

[Former Member]

Hi Srini,

Please find the same thread posted today with same reqmts:

Cheers

Sunny

rewrd points, if found helpful

[Former Member]

hi srini,

just find if the value is negative..

data : char(20).
 data : val type i.
  val = val - 50.
 if val < 0.
   write val to char.
   concatenate '-' char into char .
   condense char no-gaps.
 endif.
 write : / char.

regards

satesh

[Former Member]

HI

YOU CAN USE A FM <b>CLOI_PUT_SIGN_IN_FRONT</b> FOR CHANGINT THE SIGN POSITION.

IF THIS IS USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

[Former Member]

Hello Srini,

Use this FM CLOI_PUT_SIGN_IN_FRONT.

[Former Member]

Hi,

use following FM

CLOI_PUT_SIGN_IN_FRONT

Regards,

Shashank

[Former Member]

try this

loop at itab.

CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'
       CHANGING
            VALUE = itab-qty.

endloop.

but ito do this the field must of char type