05-24-2006 4:18 PM
Hi all,
I have a table called ztfin_ftpr.In this I have field called zkprs. Field type is z_dzkprs of length 11 and 4 decimals.Reference field is waers and reference table is T001.
When I try to create an entry in the table through se16 if I specify the value or zkprs as 1.6 it is getting saved as 0.0160.
Can any explain me what the reasonis and how to get rid of this ?
Regads,
Varun.
05-24-2006 8:26 PM
Hi Varun,
Is it an amount field i.e do you want to input amount into this field. If that is the case, then please maintain data type as 'CURR' and check. 'WAERS' is a currency key field and i dont think it should be used.
Cheers,
Vikram
Please reward helpful replies!!
05-24-2006 4:20 PM
Hi,
Sorry no idea !
I misunderstood.
Erwan.
Message was edited by: Erwan LE BRUN
05-24-2006 4:25 PM
Hi,
alway specify 4 decimal degits.
that write 1.6000
i have seen many cases comma is used instead of decimal to enter numeric value.
so try like this
1,6
Message was edited by: Manoj Gupta
05-24-2006 4:27 PM
hii
I guess the problem is it is considering the number as 4 decimals..
so try giving 00001.6000
check with this
Regards
Naresh
05-24-2006 4:31 PM
Hi,
Whan I try to give it as 1.6000 it gives me the following erro message :
<b>Message no. 00 088
Diagnosis
Your entry does not match the specified input format.
</b>
Regards,
Varun.
05-24-2006 4:34 PM
05-24-2006 4:37 PM
Hi Rich,
Yes, I thought there should be something fioshy about the data entry but today when I am trying to create an entry I have the above problem, Can you suggest any remedy ?
Regards,
Varun.
05-24-2006 4:44 PM
hi,
i have seen many cases comma is used instead of decimal to enter numeric value.
so try like this
1,6
05-24-2006 4:48 PM
Hi all,
When I give 1,6 it gives me an error message saying <b>Enter a numeric Value.</b>
I have doubt. While I make an entry from se 16 or sm30 will the system default parameters will be taken into consideration ? I guess, because whe I try to give the entry as 1.6000 it is showing an error messgae.
Can anyone help me on this ?
Regards,
Varun.
Message was edited by: varun sonu
05-24-2006 8:26 PM
Hi Varun,
Is it an amount field i.e do you want to input amount into this field. If that is the case, then please maintain data type as 'CURR' and check. 'WAERS' is a currency key field and i dont think it should be used.
Cheers,
Vikram
Please reward helpful replies!!
05-24-2006 8:47 PM
Varun,
As I tried to explain in the previous post, you have to redefine your field to be a simple decimal field. Is there any pressing reason why you are using CURR field when, in your table, you don't have a corresponding currency key field?
For currency fields, if you don't specify what currency it is, the default is 2 decimals.
Srinivas
05-24-2006 9:50 PM
Hi Srinivas,
Sorry for getting back very late. The problem has been solved. Thanks a lot for explaining the concept so well . I am able to explain the same to many of my colleagues. I cannot pay you back for your help.
Regards,
Varun.
05-24-2006 9:56 PM
Glad to of help. No need for any pay back as this forum is to help each other right? Even then I did get my pay back through your comments and of course the points!!!