Datatype conversion error

[Former Member]

Hai SAP Equery Experts

I am using FMS in Sales invoice for bringing Net Rate by adding Two field (Total LC and TaxAmount)

The calculation is = U_NTRT = INR Total LC + INR Tax Amount LC

here Total LC and Tax Amount LC are Character type and U_NTRT is numering type.

But while running the FMS query, the error is showing like this

"Data Type Conversion Error" , I know that this error is showing because of the data type difference.

I would like to know , what type of query will be suitable for fetching the total amount (Netrate).

please give me a suitable solution.

Thanks

Regards

[Former Member]

Hi,

Try this one:

SELECT $[$38.21.number\] + $[$38.82.number\]

Thanks,

Gordon

[former_member325312]

Hi

check out this i think this will solve ur prob

SELECT (CONVERT(DECIMAL(10,2),T0.[VatSum])+

CONVERT(DECIMAL(10,2),T1.[LineTotal]))

FROM OPCH T0 INNER JOIN PCH1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.[DocNum] ='287'

cheers

Jenny