Skip to Content
0
Former Member
Apr 21, 2009 at 08:48 AM

Invalid Field [Message 10-47] when inserting Value on Query Wizard

77 Views

Hi guys,

First time posting, and while I'm familiar with SQL, it's my first time trying the Query Wizard in SAP B1.

I'm experiencing a problem where, on Step 4 of 5, I want a condition that says IF Business Partner EQUALS "some name" (I'm not actually using quotations around the string, but I tried that and it didn't work either). However, if I try and insert a string in the "Field / Value" field, I receive an error "Invalid Field [Message 10-47]".

Do I need to escape the string with quotations, hash, or some other tag? I can only select another field as a variable.

The only help on this was from the SAP Help files:

http://help.sap.com/saphelp_sbo2005asp1/helpdata/en/b4/cdd46f2206414b9a667ce2a004fe60/content.htm

where it says I can query against a string or a number.

I also haven't been able to find any further help on the forums, so hopefully this isn't a duplicate n00b post.

Thanks for the help!

James.