Skip to Content
0
Apr 08, 2014 at 08:37 AM

SAP B1 Query User defined parameter (checkbox)

505 Views

Hi,

Is it possible in a query to add user defined parameters?

Example, I want to run a query from OITM table with Item Properties as parameter. But I want the users to be able to choose one or more properties as parameters in the query. I would like to use AND as a clause if more than one Item Property is choosed.

Query example:

Select ItemCode, ItemName, ItmsGrpCod

FROM OITM

WHERE ItmsGrpCod = 100 AND (Here I would like to add a parameter where user can choose one or more of the 64 different Item Properties. I.e. a checkbox would be perfect!)

Regards

Kjetil Sandvik