01-02-2008 5:29 AM
Hi,
How to Dispaly sign in left side for amount fields in ALV GRID function module?
Ex : Amount = 1234-
I want to dispaly it as -1234.
Is there any option in ALV Grid function module?
01-02-2008 6:16 AM
Hi sreedhar,
Use FM 'CLOI_PUT_SIGN_INFRONT'
it will giv the value like '-1234' if u pass '1234-'.
DATA : v_field(17).
MOVE v_amount to v_field.
CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'
CHANGING
VALUE = v_field.
MOVE v_field to v_amount.
OR
FORM change_sign changing var type c.
if var LT 0.
shift var right deleting trailing '-'.
shift var left deleting leading ' '.
concatenate '-' var into var.
else.
shift var left deleting leading ' '.
endif.
ENDFORM.
reward pts if it helps.
Edited by: venkat reddy on Jan 2, 2008 7:19 AM
01-02-2008 5:42 AM
Hi Sreedhar,
Move minus sign from end to begining of number value
i.e. from 100.00- to -100.00
check if negative amount
IF p_amount LT 0.
SHIFT p_amount RIGHT DELETING TRAILING '-'.
SHIFT p_amount LEFT DELETING LEADING ' '.
CONCATENATE '-' p_amount INTO p_amount.
ELSE.
SHIFT p_amount LEFT DELETING LEADING ' '.
ENDIF.
Reward Points if helpfull.
Regards,
Sameer.
01-02-2008 6:16 AM
Hi sreedhar,
Use FM 'CLOI_PUT_SIGN_INFRONT'
it will giv the value like '-1234' if u pass '1234-'.
DATA : v_field(17).
MOVE v_amount to v_field.
CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'
CHANGING
VALUE = v_field.
MOVE v_field to v_amount.
OR
FORM change_sign changing var type c.
if var LT 0.
shift var right deleting trailing '-'.
shift var left deleting leading ' '.
concatenate '-' var into var.
else.
shift var left deleting leading ' '.
endif.
ENDFORM.
reward pts if it helps.
Edited by: venkat reddy on Jan 2, 2008 7:19 AM