problem in SAP Query with currency conversion based on table TCURX

[Former Member]

Hi All,

I have an infoset where tables A903 and KONP are joined . Query is displaying the KONP-KBTER values with currency as stored in the database table .My requirement is to show the KBETR value as per decimals stored in TCURX table for that currency .

For Example If KONP-KBETR = 51.29 JPY , It sholuld display as 5129 as Decimal places for JPY is 0.

There is FM CURRENCY_AMOUNT_SAP_TO_DISPLAY Which gives the equvivalent display value to the databse value value.But it is giving dump because of type conflict with

KONP-KBETR .

Can any body help me how can i solve the problem in My Query ? .Pls any small idea taht may help greatly also warmly welcome .

Thx,

Dharma .

[Former Member]

Hi All,

I have an infoset where tables A903 and KONP are joined . Query is displaying the KONP-KBTER values with currency as stored in the database table .My requirement is to show the KBETR value as per decimals stored in TCURX table for that currency .

For Example If KONP-KBETR = 51.29 JPY , It sholuld display as 5129 as Decimal places for JPY is 0.

There is FM CURRENCY_AMOUNT_SAP_TO_DISPLAY Which gives the equvivalent display value to the databse value value.But it is giving dump because of type conflict with

KONP-KBETR .

Can any body help me how can i solve the problem in My Query ? .Pls any small idea taht may help greatly also warmly welcome .

Thx,

Dharma .

[Former Member]

Hi,

try using CONVERT_TO_LOCAL_CURRENCY.

Thanks,

Sriram Ponna.

[Former Member]

Hi Sriram ,

But how can i use it in Queries . I mean should I go for a additional filed in infoset and then passing the converted value to the the that additional field .

Thx ,

Dharma .