currency type

[Former Member]

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

[former_member188685]

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..?

[Former Member]

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.

[Former Member]

Can you divide the field with 100000?

12345.000 / 100000 = 123.45

[Former Member]

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.

[Former Member]

I used the split statement to get the value out.

[Former Member]

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.

[Former Member]

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!