Table details
Hi All,
I have to build and perform sql (in order to change large data) for below details for EAM.
But I am not sure what are the all tables I have to consider. Can you have look on below details and suggest me if anything
wrong or I missed, please.
- Spare Parts: All item numbers in BP140 which are at status P:
Set to status O. - F4102
2. Assets (Systems, Equipment Instruments) at status IN (in service):
Set to status to DC. - F1201
3. Preventative Maintenance Routines:
Deactivate all Model WOs. - No idea.
4. Planned and Unplanned Maintenance Work Orders - All WM and WS Work Order at status M to ME: