Negative Sign Format

[arpit_shah]

Hi,

I want to put negative sign in front.

i.e in standard SAP 15.23- will be display,

but my requirement is instead of that i want -15.23.

i want this type of settings in all reports.

so without programming, there is any option for changing the format of negative sign.

Regards,

Arpit

[Lakshmant1]

Hi Arpit,

Use FM CLOI_PUT_SIGN_IN_FRONT

Thanks

Lakshman

[arpit_shah]

hi Lakshman,

i don't want through programming,

bcoz for using this FM i have to convert into character and change.

so using this i can not use sum,subtotal etc function that is in alv.

so ,

there is any setting for that,

Negative Sign format,

in that option like,

in which type of format u want negative sign.

like,

-1.1

1.1-

etc.

Regards,

Arpit

[Former Member]

Hi Arpit

try from follwoing code explaination.

Data : l_dmbtr(13).

it_bsik-dmbtr = 15.23- "supposed value

if it_bsik-dmbtr < 0.

l_dmbtr = abs(it_bsik-dmbtr).

concatenate '-' l_dmbtr into l_dmbtr.

write :/10 l_dmbtr.

else.

l_dmbtr = it_bsik-dmbtr.

write :/10 l_dmbtr.

endif.

reward point if helpfull.

Regards

Rajesh

[arpit_shah]

hi, Rajesh

i m using this with ALV.

so write is not useful to me.

& i want to use function that is provided by alv like

sum, sorting, subtotal etc.

Regards,

Arpit

[Former Member]

then in ur inetnal table add an extra text field and follow the code.

Data : begin of it_bsik occurs 0.

dmbtr like bsik-dmbtr,

l_dmbtr(13), " extra field

end of it_bsik.

for example.

loop at it_bsik.

if it_bsik-dmbtr < 0.

it_bsik-l_dmbtr = Abc(it_bsik-dmbtr)

concatenate '-' it_bsik-l_dmbtr into it_bsik-l_dmbtr.

else.

it_bsik-l_dmbtr = it_bsik-dmbtr.

endif

modify it_bsik.

endloop.

use this inernal table field to display.

reward point if usefull.

regards

rajesh

[Former Member]

Hi,

You can use the FM CLOI_PUT_SIGN_IN_FRONT .

Thanks,

Sriram Ponna.

[arpit_shah]

i don't want to use any FM.

Is there any settings for that?.......

[Former Member]

Hi,

Please check in SU01 TCode, but doing this it may effect entire systems.

Thanks,

Sriram Ponna.

[arpit_shah]

Hi Sriram,

In SU01 where it is?...

pls provide more details.

Regards,

Arpit

[arpit_shah]

Any Idea?..

points will be assured...

[Former Member]

Hi,

I dont think we can make some setting changes to get the negetive in front, you will have to write the code before you pass the value to ALV field.

Reward Points if useful.

[arpit_shah]

Any Idea?.......

[arpit_shah]

t

[Former Member]

hi arpit try to use the Fm cloi_pvt_sign_in_front

reward points if useful

[Former Member]

Hi,

Try this sample code.

DATA: TEXT1(1) TYPE C,

VALUE(5) type c.

value = '90-'.

SEARCH VALUE FOR '-'.

IF SY-SUBRC = 0 AND SY-FDPOS 0.

SPLIT VALUE AT '-' INTO VALUE TEXT1.

CONDENSE VALUE.

CONCATENATE '-' VALUE INTO VALUE.

ELSE.

CONDENSE VALUE.

ENDIF.

Regards,

Satish

[ChrisPaine]

|{ l_amount SIGN = LEFT }|.