how to build a query to get the item properties is tick or not?

[Former Member]

hello everybody. i'm 1 of the sap b1 user. i face a problem in build a query to check one of the item properties is tick or not? pls help...

[AdKerremans · Accepted solution]

Hi Grace,

your query could look like this:

Select itemcode from oitm where qrygroup1= "Y"

qrygroup1 is item property 1, qrygroup2 is item property 2 etc.

Regards

Ad