August 29, 2011 at 3:18 am
UTS testing is goin on and as a part of it few entries need to be deleted from VTBFHAPO.When the select query is executed it throws the right number of entries but with the error message
"Conversion failed when converting the varchar value 'ABAS 200' to data type int"
I have tried deleting the entries but the entries were not deleted.The error message is same.Could you kindly assist.
uts.VTBFHAPO where RFHA=62 and BUKRS = 'US01'
error -Conversion failed when converting the varchar value 'ABAS 200' to data type int.
Please suggest
August 29, 2011 at 3:41 am
Implicit conversion is failing. Try this:
...where RFHA='62' and BUKRS = 'US01'
August 29, 2011 at 4:53 am
As mentioned in the error message, it is due to the conversion of the data. Just use quotes to enclose data as suggested by Suresh and it should work.
September 1, 2011 at 1:01 am
uts.VTBFHAPO where RFHA=62 and BUKRS = 'US01'
error -Conversion failed when converting the varchar value 'ABAS 200' to data type int.
Please suggest
PLease share the data type info of the RFHA and BUKRS . There is chance that data type of BUKRS is int
Regards
Ashok
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply