topic Re: amout fields in Application Development and Automation Discussions

amout fields

Former Member — Thu, 15 May 2008 12:08:23 GMT

hi to all

for amount fields

if the value is coming from tables is 132.00-

i need - sign in from of the value

like -132.00

please help me

how to do it

Re: amout fields

Former Member — Thu, 15 May 2008 12:10:39 GMT

multiply the value by -1

move the value to character field of same length...

now use concatenate command to append '-' sign in front of the char field..

Re: amout fields

Former Member — Thu, 15 May 2008 12:14:55 GMT

is there is any standard key word for this

please tell me i need to do it for lot of times

Re: amout fields

asik_shameem — Thu, 15 May 2008 12:16:48 GMT

IF amount LT 0.
  WRITE:/ '-', amount NO-SIGN.
ELSE.
  WRITE:/ amount.
ENDIF.

Re: amout fields

Former Member — Thu, 15 May 2008 12:18:28 GMT

Hi,

Use the function module CLOI_PUT_SIGN_IN_FRONT to bring the sign to front.

if itab-shkzg = 'H'.

v_amount = itab-shkzg.

else.

CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'

CHANGING

VALUE = itab-shkzg.

v_amount = itab-shkzg

endif.

Also check this thread.

Regards,

Shiva Kumar

Re: amout fields

Former Member — Thu, 15 May 2008 12:20:14 GMT

hi Radha,

do this way ...


data: string type string value '1100.00-'.
data: d type i.
 
d = strlen( string ).
d = d - 1.
 
SHIFT string BY d PLACES CIRCULAR.
 
write:/ string.


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,

Santosh

Re: amout fields

Former Member — Thu, 15 May 2008 12:29:18 GMT

Hi,

Use the function module CLOI_PUT_SIGN_IN_FRONT to bring the sign to front.

if itab-shkzg = 'H'.

v_amount = itab-shkzg.

else.

CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'

CHANGING

VALUE = itab-shkzg.

v_amount = itab-shkzg

endif.

Regards,

Raj.