topic Re: Negative Sign Format in Application Development and Automation Discussions

Negative Sign Format

arpit_shah — Sat, 05 Jan 2008 06:18:55 GMT

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

Re: Negative Sign Format

Lakshmant1 — Sat, 05 Jan 2008 06:21:19 GMT

Hi Arpit,

Use FM CLOI_PUT_SIGN_IN_FRONT

Thanks

Lakshman

Re: Negative Sign Format

arpit_shah — Sat, 05 Jan 2008 06:38:12 GMT

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

Re: Negative Sign Format

Former Member — Sat, 05 Jan 2008 06:51:27 GMT

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

Re: Negative Sign Format

arpit_shah — Sat, 05 Jan 2008 06:57:00 GMT

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

Re: Negative Sign Format

Former Member — Sat, 05 Jan 2008 07:35:09 GMT

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

Re: Negative Sign Format

Former Member — Sat, 05 Jan 2008 07:50:53 GMT

Hi,

You can use the FM CLOI_PUT_SIGN_IN_FRONT .

Thanks,

Sriram Ponna.

Re: Negative Sign Format

arpit_shah — Sat, 05 Jan 2008 07:58:52 GMT

i don't want to use any FM.

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

Re: Negative Sign Format

Former Member — Sat, 05 Jan 2008 08:21:52 GMT

Hi,

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

Thanks,

Sriram Ponna.

Re: Negative Sign Format

arpit_shah — Sat, 05 Jan 2008 08:41:57 GMT

Hi Sriram,

In SU01 where it is?...

pls provide more details.

Regards,

Arpit

Re: Negative Sign Format

arpit_shah — Mon, 07 Jan 2008 07:31:58 GMT

Any Idea?..

points will be assured...

Re: Negative Sign Format

Former Member — Mon, 07 Jan 2008 08:57:36 GMT

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.

Re: Negative Sign Format

arpit_shah — Tue, 08 Jan 2008 07:39:35 GMT

Any Idea?.......

Re: Negative Sign Format

arpit_shah — Wed, 09 Jan 2008 13:14:45 GMT

Re: Negative Sign Format

Former Member — Wed, 09 Jan 2008 13:18:32 GMT

hi arpit try to use the Fm cloi_pvt_sign_in_front

reward points if useful

Re: Negative Sign Format

Former Member — Wed, 09 Jan 2008 13:23:57 GMT

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

Re: Negative Sign Format

ChrisPaine — Thu, 22 Apr 2021 07:04:18 GMT

|{ l_amount SIGN = LEFT }|.