2006 Mar 10 1:46 PM
Hi,
in my programming, my amount and quantity fields are showing -VE values like this .. 43.56-. but i want-43.56. I tried several ways. I didn't get any clue. i don't want to change my field technical attributes(i need these for further processing .i.e. amount and quanity. we can achieve this for Character fields). if any body help me out from this.
Thanks in Advance.
Please guide me.
Regards,
Nagesh.
Hi,
in my programming, my amount and quantity fields are showing -VE values like this .. 43.56-. but i want-43.56. I tried several ways. I didn't get any clue. i don't want to change my field technical attributes(i need these for further processing .i.e. amount and quanity. we can achieve this for Character fields). if any body help me out from this.
Thanks in Advance.
Please guide me.
Regards,
Nagesh.
2006 Mar 10 1:50 PM
Hi Nagesh,
I don't think you can do it without moving it to a CHAR field.. SAP does it the same way in the function module CLOI_PUT_SIGN_IN_FRONT.
Regards,
Suresh Datti
2006 Mar 10 1:55 PM
data : l_amt(15) value '435.46-'.
CALL FUNCTION 'CLOI_PUT_SIGN_IN_FRONT'
CHANGING
VALUE = l_amt.
write : l_amt.Message was edited by: Sekhar
2006 Mar 10 2:04 PM
2006 Mar 10 2:29 PM
2006 Mar 10 2:43 PM
Hi Mann,
i tried this(ABS), concatenate option.. still.. i'm getting the above mentioed result.
Nagesh.
Message was edited by: Nagesh Ganisetti
2006 Mar 10 2:49 PM
Hi,
if ur problem is summing up for that field , try changing it string instead of char and try summation
2006 Mar 10 2:55 PM
u said u want that field for further processing. so in this case put ur variable into another field of type char n display it.. and use ur original field for processing...
Regards,
Bikash
2006 Mar 10 2:59 PM
i need Amounts and Quantity data type for next process. Even if i change it to char data type into new variable i can't use that. That value i need to download into XL file. from there another System will pickup that...
Thanks in advance.
Nagesh.
Message was edited by: Nagesh Ganisetti
2006 Mar 10 3:01 PM
Hi Nagesh,
Move it to the char field & do the concatenation just before writing on to the screen.
2006 Mar 10 3:02 PM
is it possible for u to do ur next process first and then put the negative sign in front by changing it to char or string
2006 Mar 10 3:09 PM
i tried thse codes...
data: amount like vbap-netwr value'34.45',
text(18) type c.
amount = abs(amount) * -1.
next one:
move amount to text.
concatenate '-' text."-34.45'
if i do move here to amount..
move text to amount "34.45-"
any suggetions? i need to download this data to XL file. from there back ground job will pick that job?
I think there is no option..
Thanks a lot guys spending time on issue.. i think SAP won't support that...
Nagesh.
2006 Mar 10 3:28 PM
Try:
DATA: amt LIKE bseg-wrbtr VALUE '-123.45'.
WRITE /001 amt USING EDIT MASK 'RRV_________.__'.
Rob