topic currency type in Application Development and Automation Discussions

currency type

Former Member — Thu, 23 Oct 2008 11:39:23 GMT

Hi all......

Can some one tell me how to display a field of currency type which is stored in sap transparent table as amount(type:DEC). for eg., in sap table it is stored as 12345.000 but i need to display it as 123.45, because this 123.45 is compared with another field coming from a third party system, which gives the value 123.45

Re: currency type

Former Member — Thu, 23 Oct 2008 11:43:42 GMT

what is the Decimal notation you are following..?

since you mentioned 12345.000 , but you are asking to show it as 123.45 what happened to the rest of the zeroes.

what is the currency type..?

Re: currency type

Former Member — Thu, 23 Oct 2008 13:38:38 GMT

hi vijay,

The value i need to display comes from sap table.

I need to show it as 123.45 for the value 12345.000 which comes from sap table. The currency type for this data field(12345.000) varies like usd, xaf, jpy, euro. This data field has a key in which the type is defined.

as for the zeroes, i need two decimal places in the currency.

Re: currency type

Former Member — Thu, 23 Oct 2008 14:54:51 GMT

Can you divide the field with 100000?

12345.000 / 100000 = 123.45

Re: currency type

Former Member — Fri, 24 Oct 2008 04:45:11 GMT

No, i cant divide or use shift for the field. I am asked to copy the amount from the sap table into a currency variable and this currency variable has to be encoded with currency code.

Re: currency type

Former Member — Thu, 18 Dec 2008 12:31:33 GMT

I used the split statement to get the value out.

Re: currency type

Former Member — Fri, 19 Dec 2008 04:58:06 GMT

Hi Ghousia,

You cannot use split statement for a Packed decimal value.

You just have to define a temporary variable of type p decimals 2 and assign the value to it and display the same.

Thats it.

If you carry on working with the split statement, it might give errors in the future.

Regards,

-Syed.

Re: currency type

Former Member — Fri, 19 Dec 2008 08:35:19 GMT

yes, absolutely. I tried that too but it didnt work out. so i used it since that value needs to be displayed only.

Thanks syed!