on 04-24-2015 12:40 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.