on 01-27-2016 7:41 AM
hello Experts:
I need to vizualise the as-built summary for an archived SFC
I launch the CT700_ODS Activity, I fill the SFC number and when I click on the link of SFC
but I receive this error message :
(Message 13101)
your query returned no data.
I need to vizualise the time based components assembled in a SFC .
Can you guide me
Thank you
Hello Houssem,
Normally, the data that is not needed anymore and will not be needed anymore in production is archived.
There are no standard SAP ME reports for archived data. Even most of the relevant data for time-based assembly still can be stored in ODS_ tables, it won't be enough to rely on standard ODS reports in case the SFC was archived.
As discussed in the other forum thread, as of the newest 6.1 SP and higher there is a new feature of archiving time-based data, so that time-based data can be located not only in WIP tables and ODS_* tables but in AR_* tables also. I think you can easier create your custom report from AR_ tables only once you upgrade to SAP ME version that has this feature.
Br, Alex.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Houssem,
Here could be several questions:
- CT700_ODS might not show time-based assembly at all;
- ODS_COMP_TIME_LOG and ODS_RESOURCE_TIME_* tables might not have time-based data for the SFC for some reason (for example, as result of ODSWIPAging script run before ODS processing or due to ODS Extract Lag setting).
For the former, it would be good to collect SQL trace for the report to check which tables are queried.
For the latter, just have a look inside the tables for the SFC's data.
Regards,
Sergiy
Hi!
I guess that CT700_ODS can show you the data from ODS_* tables but not from AR_* tables where archiving moves SFCs to.
Normally, archived data is not touched by reports.
Regards,
Sergiy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.