WM Program Custom development Background program

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

  • LP21 WM Replenishment for Fixed Bins. Creates transfer requirements for fixed bin replenishment; ignores open delivery demand.
  • LT10 Create Transfer Order from Stock List. Used for manual stock transfers; does not calculate the replenishment need.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
MLGTMaterial Data per Storage TypeFixed bin, minimum/maximum bin quantity and replenishment quantity (driving table)ReadECC + S/4
LQUAQuantsStock in the fixed bin and source quants in reserve storageReadECC + S/4
LIPSDelivery Item DataDelivery demand without a transfer order yetReadECC + S/4
LIKPDelivery HeaderLoading and goods issue date of the deliveryReadECC + S/4
LTAKTransfer Order HeaderHeader of the created replenishment transfer orderWriteECC + S/4
LTAPTransfer Order ItemOpen picking items from the fixed bin (read) and the created replenishment item (write)Read / writeECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
S_LGNUMWarehouse numberRange / multipleMLGT-LGNUMYes100
S_LGTYPPicking (fixed bin) storage typeRange / multipleMLGT-LGTYPYes010
S_MATNRMaterialRange / multipleMLGT-MATNRNoFG-5003
S_SRCTYPReserve (source) storage typesRange / multipleLQUA-LGTYPYes001
P_LDDATLoading date limit for delivery demandSingle valueLIKP-LDDATNo18.11.2026
P_DLVDEMInclude delivery demandCheckbox—NoX
P_TESTTest mode (list without creating transfer orders)Checkbox—NoX

Result list columns

#ColumnSource
1MaterialMLGT-MATNR
2Fixed binMLGT-LGPLA
3Minimum qtyMLGT-LPMIN
4Maximum qtyMLGT-LPMAX
5Bin stockCalculated Sum of LQUA-GESME in the fixed bin
6Open demandCalculated Unconfirmed picking items (LTAP-VSOLM) + delivery quantity without transfer order (LIPS-LFIMG)
7Replenishment qtyCalculated If remaining stock < LPMIN: LPMAX − remaining stock, rounded to multiples of MLGT-NSMNG
8Source binLTAP-VLPLA
9Transfer orderLTAK-TANUM
10StatusCalculated Created, no replenishment needed, no stock or error
11MessageCalculated Message returned by the function

Sample result list

MaterialFixed binMinimum qtyMaximum qtyBin stockOpen demandReplenishment qtySource binTransfer orderStatusMessage
FG-500304-12-03402002260240R-02-05-10000312451CreatedTransfer order 312451 created
FG-501001-02-0150300210960No replenishment neededRemaining stock is above the minimum
FG-612002-01-02106041260No stockNo available quant in the reserve storage types
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. 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.
  3. 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.
  4. 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’.
  5. 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

WM Report Custom ALV report

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 …

LTAP · LTAK · MLGT · LAGP

WM Report Custom ALV report

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 …

LTAK · LTAP · LIKP · T301

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.

Related report: Automatic Replenishment Transfer Order Job for Fixed Picking Bins