Skip to Content
0
Jun 24, 2010 at 05:54 AM

Problem with CURR type field?

67 Views

Hi all,

I have one ztable in which there is one field of type CURR of length 13.when i trying to read the value of this field through select statement the problem is as follows:

SELECT SINGLE USR06 FROM PRPS INTO GV_SITE_CASH_LIMIT

WHERE POSID = GV_SITE.

this will give output of 10,000.

but when i am doing it as follows:

SELECT SINGLE USR06 FROM PRPS INTO CORRESPONDING FIELDS OF PRPS WHERE POSID = GV_SITE.

this will give output of 1,00,000.

the actual output is 1,00,000.but when i am fetching it in another variable it is 10,000.

Regards