topic Re: Doubt on Currency Data Type in Application Development and Automation Discussions

Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 07:37:07 GMT

Hi,

Have a basic question. When we have a field with type currency defined as length 13 and decimal places 2 and output length 16, what does this mean?

Does it mean that there are 13 places to the left of the decimal, 2 places after the decimal and 1 place for the decimal so making a total of 16 places as output length?

Thanks in advance.

Mick

Re: Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 07:47:59 GMT

it means 11 places to the left of decimal , decimal places 2 .. and three

places for comma or '.'(separator .. depends on the settings)

Re: Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 07:48:06 GMT

Your are apsolutely correct.

Venkat.

Re: Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 08:19:18 GMT

Hi Venkata,

I am a little confused. Who is correct me or Srinivas.

Thanks,

Mick

Re: Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 08:26:50 GMT

hi mick srinivas is correct , and you also saying the right thing

...because the data type takes 13 decimals take.. and the decimals take 2 and the separator will be like '.'

or you can check the fields in standard table..

ex: 123456789123._12_

13 2

regards,

venkat

Re: Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 08:30:33 GMT

it contains only 11 places before decimals ...

below program gives a dump with

'Overflow when converting from "1234567890123.11"'

data : v_curr type PAD_AMT7S. "( Curr 13 , 2)

v_curr = '1234567890123.11'.

while it runs perfectly when we give

v_curr = '12345678901.11'. " ( 11 + 2 )

Re: Doubt on Currency Data Type

Former Member — Thu, 29 May 2008 08:59:30 GMT

Thanks Srinivas. Points awarded.