on 11-14-2017 7:23 AM
I am making a query for an API. I make the query in the query editor. I get there by clicking tools->queries->user queries-> select a query
In the editor I write the following:
select * from "@FR_RETAILADDR" where "U_FR_STORECODE" = [%code]
that does not work. I am given the following error:
"" (SWEI)
Any user defined table does not allow a parameter to be given. I can do the exact save with the OCRD table.
It works, but SAP B1 does not know that it works. so just run the query in the api and it will work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try this
select * from [@FR_RETAILADDR] where U_FR_STORECODE = '[%0]'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.