Mass Post Goods Issue from a Warehouse Confirmation File Program
Short answer: A custom program that reads the picking confirmation file from an external warehouse or warehouse system, writes the picked quantity and batch to the deliveries and then posts goods issue. It checks everything in test mode first, then lists the material document and error message for every delivery.
- 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?
VL06G posts goods issue collectively but expects the deliveries to be picked in the system already and the user to select them from a list; it does not read the file from the external warehouse and does not write the picked quantity and batch to the delivery. VL02N processes one delivery at a time. An external warehouse that sends hundreds of delivery confirmations a day needs a program that reads the file, checks it and posts goods issue.
Who uses it? Logistics and shipping teams, companies working with a third-party logistics (3PL) provider and SD consultants.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| LIKPDelivery Header | Delivery header; the actual goods issue date is written | Write | ECC + S/4 |
| LIPSDelivery Item Data | Delivery item; the picked quantity and batch are written | Write | ECC + S/4 |
| MKPFMaterial Document Header | Material document header of the goods issue | Write | ECC + S/4 |
| MSEGMaterial Document Item | Material document items of the goods issue | Write | ECC + S/4 |
| VBFASales Document Flow | Document flow from the delivery to the material document | Read | ECC + S/4 |
| VBUKSales Document Header Status (ECC) | Goods issue status check in ECC | Read | ECC only |
S/4HANA notes
- MKPF → MATDOC: In S/4HANA new material documents are written to MATDOC; reading MKPF works through a compatibility view. Use MATDOC or I_MaterialDocumentItem_2 directly in new reports.
- MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
- VBUK → VBAK: VBUK is not used in S/4HANA. The status fields moved to the respective document header: VBAK for sales, LIKP for deliveries, VBRK for billing. It is one of the most common fixes when custom reports move from ECC.
BAPIs and functions used
- WS_DELIVERY_UPDATEUpdate Delivery (Picking, Packing, Goods Issue). Writes the picked quantity and batch to the delivery and posts goods issue
- BAPI_OUTB_DELIVERY_CONFIRM_DECConfirm Outbound Delivery from Decentralized System. Alternative for the delivery confirmation in a decentralized warehouse scenario
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Saves successful deliveries permanently
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Confirmation file (CSV or XLSX) | Single value | — | Yes | /interface/3pl/in/onay_20261117.csv |
| P_SERVER | Read the file from the application server | Checkbox | — | No | X |
| S_VSTEL | Shipping point (allowed values) | Range / multiple | LIKP-VSTEL | No | 1000 |
| P_GIDATE | Goods issue date when the file has none | Single value | — | No | 17.11.2026 |
| P_TEST | Test mode (check without posting) | Checkbox | — | No | X |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Delivery | LIKP-VBELN | Yes |
| 2 | Item | LIPS-POSNR | Yes |
| 3 | Material | LIPS-MATNR | Yes |
| 4 | Batch | LIPS-CHARG | No |
| 5 | Picked quantity | LIPS-LFIMG | Yes |
| 6 | Unit | LIPS-VRKME | No |
| 7 | Storage location | LIPS-LGORT | No |
| 8 | Actual goods issue date | LIKP-WADAT_IST | No |
Sample upload file
| 1 | Delivery * | Item * | Material * | Batch | Picked quantity * | Unit | Storage location | Actual goods issue date |
|---|---|---|---|---|---|---|---|---|
| 2 | 80004620 | 10 | FG-5001 | B261101 | 120 | PC | 0001 | 11/17/2026 |
| 3 | 80004620 | 20 | FG-5002 | B261044 | 80 | PC | 0001 | 11/17/2026 |
| 4 | 80004633 | 10 | FG-6100 | 40 | SET | 0002 | 11/17/2026 | |
| 5 | 80004641 | 10 | FG-5001 | B261101 | 300 | PC | 0001 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row | Calculated Row number in the file |
| 2 | Delivery | LIKP-VBELN |
| 3 | Item | LIPS-POSNR |
| 4 | Material | LIPS-MATNR |
| 5 | Posted quantity | LIPS-LFIMG |
| 6 | Material document | MKPF-MBLNR |
| 7 | Status | Calculated From the checks and the update: goods issued, test OK or error |
| 8 | Message | Calculated First error message or the success message |
Sample result list
| Row | Delivery | Item | Material | Posted quantity | Material document | Status | Message |
|---|---|---|---|---|---|---|---|
| 2 | 80004620 | 10 | FG-5001 | 120 | 4900012345 | Goods issued | Delivery 80004620 posted |
| 3 | 80004620 | 20 | FG-5002 | 80 | 4900012345 | Goods issued | Delivery 80004620 posted |
| 4 | 80004633 | 10 | FG-6100 | 0 | Error | Batch is required for a batch-managed material | |
| 5 | 80004641 | 10 | FG-5001 | 0 | Error | Picked quantity exceeds the delivery quantity (250) |
How does the program work?
- The file (CSV or XLSX) is read from the user’s PC or, in a background job, from the inbound folder on the application server.
- Every row is checked: the delivery (LIKP) must exist and must not be goods-issued yet (VBUK-WBSTK in ECC, LIKP-WBSTK in S/4HANA), the item and material must match the delivery item (LIPS), the picked quantity must not exceed the delivery quantity, and a batch must be given for batch-managed materials.
- Rows are grouped per delivery; the picked quantity and batch are written to the delivery with WS_DELIVERY_UPDATE (or BAPI_OUTB_DELIVERY_CONFIRM_DEC), and the delivery quantity is adjusted to the picked quantity.
- In the same call goods issue is posted with the actual goods issue date from the file (or the date in the parameter when empty). In test mode the update is not called; only the checks run.
- The material document created is read from VBFA (VBTYP_N = R); results and messages are listed per row, failed rows are written to a separate file and the processed file is moved to an archive folder.
Performance notes
Run daily files as a background job. Make one update call and commit per delivery; the goods issue status is re-read right before each call in case the same delivery arrives in more than one file.
Features
- Test mode (check without posting)
- Line-by-line result and error log
- Download failed lines as a separate file Failed rows can be corrected and uploaded again with the same template.
- Runs as a background job The folder where the external warehouse drops its file can be processed at fixed intervals during the day.
- Export to Excel
Authorization objects
- V_LIKP_VSTDelivery authorization by shipping point
- M_MSEG_BWAGoods movement authorization by movement type
Frequently asked questions
What happens if the external warehouse picks less?
The delivery quantity is reduced to the picked quantity and goods issue is posted with it. The remaining quantity stays open on the sales order and can be delivered again in the next delivery creation run.
Is it suitable for deliveries managed by WM or EWM?
For deliveries linked to warehouse management, picking is done by confirming the transfer order or warehouse task; this program does not skip that step. It is designed for deliveries whose stock is kept only at inventory management level or managed in an external warehouse.
Does it work on S/4HANA?
Yes. The functions used exist on S/4HANA as well; only the goods issue status is read from LIKP instead of VBUK, and the material document is written to MATDOC.
Related reports
Picked but Not Goods-Issued Deliveries Report
A custom ALV report that lists deliveries whose picking is complete but whose goods issue has not been posted, with the number of days they have been …
Scheduled Billing Job with Pre-Billing Checks and Hold List
A custom background job that bills goods-issued, unbilled deliveries at set times and runs customer-specific checks before billing. Deliveries that …
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.