BW Query Error: Validity table row not found

[Guilherme_MR]

Hello!

I have a query with non-cumulative key figures (Stock).

The data in the validity table is as follows:

When running the query with a date that falls within the date range, I encounter the following error.

If I input some value in the filter for Plant (Centro) the query runs OK. But, if I try to filter like this:

I get the following errors:

Does anyone know how to fix this errors?

I want to run the query without having to input the plant.

Attached is a screenshot of the stock parameter configuration in the InfoCube.

[nachtaktiv · Accepted solution]

Have you checked SAP-support-notes before ?
Maybe something like 1962699 ?

[Guilherme_MR · Accepted solution]

Hello, nachtaktiv! Good afternoon!

Yes and yes, checked the note 1962699 but it didn't help with my case.

I ended up setting a fixed filter in the query to exclude empty values (!= #) and that solved it!

Nonetheless, thank you for your answer.