Transportation Operational Planning - Delete

This document explains how you delete 'Transport Operation Interface' (TOI) records. When TOI records reach the final status of 90, 91, or 99, they will no longer be updated and can be deleted.

Outcome

Completed TOI messages are deleted, including related details in these 4 tables:

  • MYOPIH stores message header displayed in 'Transport Operation Planning. Open' (MYS450).
  • MYOPID stores downloaded deliveries displayed in 'Downloaded deliveries. Open' (MYS451).
  • MYOPIU stores uploaded deliveries displayed in 'Uploaded deliveries. Open' (MYS453).
  • MYOPAD stores downloaded delivery information displayed in 'Downloaded Additional Information. Open' (MYS454).

Before you start

  • TOI messages must have a status 90, 91, or 99.
  • If you are scheduling the deletion of TOI records, the M3 Job Scheduler must be configured. See Administrator's Guide M3 Java Job Scheduler.

Delete TOI messages:

  1. Open the 'Transport Operation Planning. Delete' (MYS490).
  2. Select a range for the entry date.

    All records in MYOPID with an Entry within the set range will be included in the deletion.

  3. Select a range of status. Only records with a status higher than 90 can be deleted:

    90='Upload' - Executed, no errors. M3 BE is updated

    91='Download/Upload' - Closed, no update

    99='Download' - Deleted

  4. Select a range of warehouses, or a range of places of load.
  5. Select a partner. This is not a mandatory field.
Related topics