cancel
Showing results for 
Search instead for 
Did you mean: 

BW Query Error: Validity table row not found

Guilherme_MR
Discoverer
0 Kudos

Hello!

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

The data in the validity table is as follows:

Guilherme_MR_0-1717018888477.png

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

Guilherme_MR_1-1717018934706.png

Guilherme_MR_3-1717019108922.png

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

Guilherme_MR_6-1717019547831.png

I get the following errors:

Guilherme_MR_5-1717019389394.png

 

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.

Guilherme_MR_7-1717019604407.png

 

 

View Entire Topic
nachtaktiv
Participant
0 Kudos

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

Guilherme_MR
Discoverer
0 Kudos

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.