Delete entries from table /PACG/ECM_ARMAT - E4C: Reseved Materials Stock. Selection of orders' user/system status available since
| Status | ||
|---|---|---|
|
Purpose of the affected table
The table stores information about reserved materials. It’s used for managing reserved material status and quantities.
Order | Operation/Activity | Activity number | WBS Element | Material | Plant | Storage Location | WBS Element | Batch | Serial number | Process type | Adv. shipment type | Original quantity | Actual quantity | Shipped quantity | Used quantity | Trans. quantity | Other quantity | Original plant | FSM Company ID | Created on | Time | Created by | Changed on | Time of change | Changed by | Status | Comments | Changed on | Time of change | Changed by | Arrival date |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
000004005656 | 0010 | 0100011588 | 0 | H20 | 1000 | 0 | R | 0,000 | 0,000 | 0,000 | 0,000 | 0,000 | 0,000 | 1 | 18.11.2020 | 14:44:06 | CHP | 18.11.2020 | 14:45:41 | WF-BATCH | 00:00:00 |
Expected results after execution
Performance optimization.
Execution recommendations
The table is relatively small-sized. Execute the program periodically via a background job, preferably based on order status (see fields Order system status and Order user status).