Referential Integrity for Movex
Does this look familiar?
There is a handy housekeeping
tool available for Movex which will go through your database and report on any
problems from orders in the system for a status 90 customer, missing references
in CSYTAB, POs with an invalid status, orphaned records, etc. Over 35,000 individual checks.
There are many events that cause these problems:
- Errors in Modifications
- Changes to data outside Movex, SQL, DFU
- Data Conversion
- Program Failure
- Bugs (yes there are bugs)
You can run the program over individual files or the whole database and make sure that all your files and relationships are in order. A must-have for those companies who have people who know just enough SQL to get themselves in trouble!
