‎2008 Nov 21 1:05 PM
Dear Friends,
i want to update one Ztable field from customized screen.
the field is for amount.
i hv defined it's screen attributes from dictionary as CHAR (6)
I want that amount to be entered less than 1000 i.e 0 to 999.99
if it is not so , i will display Error message.
It's working fine UPTO 999.49 , but from 999.50 to 999.99 it gives error which is supposed to be given for values equal to or greater than 1000.
Can anybody helps me out.
<<< REMOVED BY MODERATOR >>>
Please see the [Forum Rules of Engagement|https://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement] for more informations.
Edited by: Marcelo Ramos on Nov 21, 2008 11:44 AM
‎2008 Nov 21 1:20 PM
hi,
first thing why are going with char. go with with the data type DEC and give the length as needed and in the decimals you give as 2 places it will resolve your issue.
cheers!!
VEnk@
‎2008 Nov 21 1:14 PM
‎2008 Nov 21 1:14 PM
Hi,
are you sure that data type for Amount is CHAR(6),because i think it should be CURRENCY...
‎2008 Nov 21 1:20 PM
hi,
first thing why are going with char. go with with the data type DEC and give the length as needed and in the decimals you give as 2 places it will resolve your issue.
cheers!!
VEnk@
‎2008 Nov 21 1:26 PM
change ztabke field to currency field then you will find solution