topic Negative sign for Values in Application Development and Automation Discussions

Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:19:15 GMT

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

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:22:08 GMT

Hello Srini,

Please refer to the following post -

Regards,

Anand Mandalika.

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:22:42 GMT

IF var LT 0.

WRITE : '-'.

ENDIF.

WRITE var NO-SIGN.

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:23:22 GMT

hi Srini...

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

or use EDIT MASK Option

here is that thread

Regards,

Santosh

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:25:13 GMT

Hi Srini,

Please find the same thread posted today with same reqmts:

Cheers

Sunny

rewrd points, if found helpful

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:25:59 GMT

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

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:27:23 GMT

YOU CAN USE A FM CLOI_PUT_SIGN_IN_FRONT FOR CHANGINT THE SIGN POSITION.

IF THIS IS USEFUL PLEASE REWARD POINTS

REGARDS

ANOOP

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:27:39 GMT

Hello Srini,

Use this FM CLOI_PUT_SIGN_IN_FRONT.

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:28:07 GMT

Hi,

use following FM

CLOI_PUT_SIGN_IN_FRONT

Regards,

Shashank

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:29:28 GMT

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

Re: Negative sign for Values

Former Member — Fri, 24 Mar 2006 10:40:19 GMT

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