Doubt on Currency Data Type

[Former Member]

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

[Former Member]

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

[Former Member]

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

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

[Former Member]

Your are apsolutely correct.

Venkat.

[Former Member]

Hi Venkata,

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

Thanks,

Mick

[Former Member]

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

[Former Member]

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 )

[Former Member]

Thanks Srinivas. Points awarded.