Automatic Replenishment Transfer Order Job for Fixed Picking Bins
Short answer: A custom background job that evaluates stock in fixed picking bins together with the pending pick demand of open deliveries, and automatically creates replenishment transfer orders from reserve storage for bins that will fall below their minimum quantity. The bin is refilled before a picker reaches an empty slot.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
LP21 creates transfer requirements for fixed bin replenishment, but it only compares today's stock with the minimum quantity; it ignores the not-yet-picked demand of open deliveries and does not turn the replenishment quantity into a transfer order using a rounding rule. The requirements must then be processed separately in LT04, and during heavy waves bins run empty in the middle of the day.
Who uses it? Warehouse shift supervisors, replenishment planners and LE-WM key users.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| MLGTMaterial Data per Storage Type | Fixed bin, minimum/maximum bin quantity and replenishment quantity (driving table) | Read | ECC + S/4 |
| LQUAQuants | Stock in the fixed bin and source quants in reserve storage | Read | ECC + S/4 |
| LIPSDelivery Item Data | Delivery demand without a transfer order yet | Read | ECC + S/4 |
| LIKPDelivery Header | Loading and goods issue date of the delivery | Read | ECC + S/4 |
| LTAKTransfer Order Header | Header of the created replenishment transfer order | Write | ECC + S/4 |
| LTAPTransfer Order Item | Open picking items from the fixed bin (read) and the created replenishment item (write) | Read / write | ECC + S/4 |
BAPIs and functions used
- L_TO_CREATE_SINGLECreate Transfer Order with One Item. Creates a replenishment transfer order from reserve storage to the fixed bin
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_LGNUM | Warehouse number | Range / multiple | MLGT-LGNUM | Yes | 100 |
| S_LGTYP | Picking (fixed bin) storage type | Range / multiple | MLGT-LGTYP | Yes | 010 |
| S_MATNR | Material | Range / multiple | MLGT-MATNR | No | FG-5003 |
| S_SRCTYP | Reserve (source) storage types | Range / multiple | LQUA-LGTYP | Yes | 001 |
| P_LDDAT | Loading date limit for delivery demand | Single value | LIKP-LDDAT | No | 18.11.2026 |
| P_DLVDEM | Include delivery demand | Checkbox | — | No | X |
| P_TEST | Test mode (list without creating transfer orders) | Checkbox | — | No | X |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Material | MLGT-MATNR |
| 2 | Fixed bin | MLGT-LGPLA |
| 3 | Minimum qty | MLGT-LPMIN |
| 4 | Maximum qty | MLGT-LPMAX |
| 5 | Bin stock | Calculated Sum of LQUA-GESME in the fixed bin |
| 6 | Open demand | Calculated Unconfirmed picking items (LTAP-VSOLM) + delivery quantity without transfer order (LIPS-LFIMG) |
| 7 | Replenishment qty | Calculated If remaining stock < LPMIN: LPMAX − remaining stock, rounded to multiples of MLGT-NSMNG |
| 8 | Source bin | LTAP-VLPLA |
| 9 | Transfer order | LTAK-TANUM |
| 10 | Status | Calculated Created, no replenishment needed, no stock or error |
| 11 | Message | Calculated Message returned by the function |
Sample result list
| Material | Fixed bin | Minimum qty | Maximum qty | Bin stock | Open demand | Replenishment qty | Source bin | Transfer order | Status | Message |
|---|---|---|---|---|---|---|---|---|---|---|
| FG-5003 | 04-12-03 | 40 | 200 | 22 | 60 | 240 | R-02-05-1 | 0000312451 | Created | Transfer order 312451 created |
| FG-5010 | 01-02-01 | 50 | 300 | 210 | 96 | 0 | No replenishment needed | Remaining stock is above the minimum | ||
| FG-6120 | 02-01-02 | 10 | 60 | 4 | 12 | 60 | No stock | No available quant in the reserve storage types |
How does the program work?
- For the selected warehouse number and picking storage types, materials with a fixed bin and their minimum (LPMIN), maximum (LPMAX) and replenishment quantity (NSMNG) are read from MLGT.
- Stock in the fixed bin is summed from LQUA (GESME); picking items from the same bin not yet confirmed (LTAP, PQUIT blank) are deducted as open issues.
- With ‘include delivery demand’ selected, the quantity of delivery items (LIKP/LIPS) up to the selected loading date for this warehouse number and material that has no transfer order yet is also deducted.
- If the remaining stock is below the minimum, replenishment quantity = maximum − remaining stock, rounded to multiples of the replenishment quantity. If no available quant exists in the reserve storage types, the line is logged as ’no stock’.
- In test mode only the calculation is listed. In a real run L_TO_CREATE_SINGLE creates a transfer order from reserve storage to the fixed bin for each material; the source quant is chosen by the storage type’s removal strategy (e.g. FIFO). The result is written to the job log.
Performance notes
Schedule the job with a separate variant per warehouse number every 30–60 minutes; do not run it in parallel for the same warehouse. Restrict LIPS by loading date and warehouse number.
Features
- Runs as a background job
- Test mode (check without posting)
- Line-by-line result and error log
- Send the result by email 'No stock' lines can be sent to the shift supervisor.
Authorization objects
- L_LGNUMAuthorization to create transfer orders by warehouse number and storage type
- L_BWLVSAuthorization for the replenishment movement type
Frequently asked questions
Which movement type is used for replenishment?
The WM movement type set up for replenishment in the warehouse (319 in many systems, or a customer-specific type) is set in the selection-screen variant. Source and destination storage types must match the settings of this movement type.
Can two replenishments be created for the same bin?
No. If an open (unconfirmed) replenishment transfer order to the fixed bin exists, the quantity on its way is added to stock and a new one is created only if a shortfall remains.
Does it run on S/4HANA?
It runs for LE-WM and stock room management on S/4HANA. In EWM replenishment is more complete in the standard and this job is not needed.
Related reports
ABC Slotting Analysis by Pick Frequency Report
A custom ALV report that counts the confirmed picking transfer order items of a period per material, assigns each material an A, B or C class by pick …
Automatic Putaway Transfer Order Creation Job for Goods Receipt Interim Storage
A custom background job that finds open transfer requirements waiting in goods receipt interim storage longer than a set time, converts them into …
Unconfirmed Transfer Orders Aging Report
A custom ALV report that lists transfer order items that were created but not confirmed across a warehouse number, by hours waiting, planned goods …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.