Problem with CURR type field?

[arpita_churi3]

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

[Former Member]

Hi,

I assumed that GV_SITE_CASH_LIMIT is a variable which is of type CURR and length 13.

It is better when you are selecting currency fields from database , declare a variable

of type as it is in the database (in your case variable is GV_SITE_CASH_LIMIT it is not type as Database).

I had seen in the SE11 the field which you are selecting ( USR06 ) has type CURR of 13 and 3 Decimals.

So During conversion it may Problem because you declared a variable of length 13.

so Declared a variable(GV_SITE_CASH_LIMIT) of type PRPS-USR06.

after getting into this variable copy to your Z structure

It may solve your problem.

Regards,

Raghava Channooru

[arpita_churi3]

Thanks for replay.

I have tried this...

GV_SITE_CASH_LIMIT TYPE PRPS-USR06.

The output is

10000.000 instead of 100000.00

Regards,

Arpita