Example: List of Slow-Moving Items

You want to define a query that displays all products that have been purchased infrequently or not at all in the last 6 months. You want the query to display characteristic values for which there is no transaction data for the selected time frame or for which only low values exist.

1. In the Query Designer, select your InfoProvider (that contains the characteristic 0MATERIAL).

2. Define a query in accordance with your requirements (for example, include the key figure Sales in the structure).

3. For the characteristic 0MATERIAL, set the Access Type for Result Value from Master Data property.

4. Save the query and execute it.

   The system displays all values, including values for materials that have not been purchased.

   Note

   Alternatively, you can set a fixed filter for characteristic 0MATERIAL to reduce the size of the list that is generated.

Displaying Slow-Moving Items

If you want to display a list of slow-moving items excluding products that are selling well, proceed as follows:

1. In the Query Designer, define a condition for the Sales key figure in the structure (you can also assign this to InfoObject 0MATERIAL, but this step is optional) to evaluate sales = 0.

2. Save the query and execute it.

   The system displays all materials that have not sold.

Displaying Products with Low Demand

If you want to display a list of products that have not sold or have sold badly, proceed as follows:

1. In the Query Designer, define a condition for the Sales key figure in the structure (you can also assign this to InfoObject 0MATERIAL, but this step is optional). Specify a value that you want to use as the upper limit for a bad sale.

2. Save the query and execute it.

   The system displays all materials that have not sold or have sold badly.