cancel
Showing results for 
Search instead for 
Did you mean: 

Unused BOM components not getting filtered

former_member769142
Discoverer
0 Kudos

I have written a Query for BOM, which is having ECM active.  Earlier there were 14 components.

3 components have been removed. But If I execute my Query--it is getting all the 14 components

instead of 11.

In CS03--If I execute,

with both Valid from and Valid to date as today--Defaulted--Then 11 components are displayed.-OK

If I keep Valid from Only--Then 11 are displayed.--Ok

If I remove both Valid from and Valid to date--Then 14 are displayed.-Ok

If I keep valid to date --Then it is displaying all the 14 components.

That means Valid from is acting a s filter.

If I use the same Valid from--(Tried all the Valid From fields in STPO) in my Query--It is not taking.

The strange thing this, If we give that Particular date (On which the component is changed)--Then it is

taking and showing the output in the query.

The thing I need here is --The same functionality (Filtering criteria) has to be put into my Query.

P.S: Even Standard reports  like CS11/CS12/CS13 are not filtering, in the way--CS02/CS03 are doing.

Any suggestions would be highly appreciable. Thanks in advance.

Wherever we see in the standard reports--The Valid to is coming from structures.

Accepted Solutions (0)

Answers (1)

Answers (1)

rupesh_brahmankar3
Active Contributor
0 Kudos

Hello,

You can try with CS11/CS12 where select Change No. and valid from date.

If you change a Material BOM  with a change number then a new entry is created in the database (tables STPO, STAS).

Best Regards,

R.Brahmankar