Mobile Warehouse Count App with Bin and Barcode Scanning: Bin Checks, Difference Approval and Posting
Short answer: A Fiori app in which warehouse staff enter counts from a phone, tablet or handheld by scanning the bin and the product barcode. The app checks that the scanned bin belongs to the right warehouse and to a storage type open for counting, writes the count to the EWM physical inventory document, routes differences above tolerance to approval and posts approved differences directly.
- Estimated effort
- L · 15–25 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
Standard EWM counting is document-driven: a physical inventory document is created first, then the count is entered per document and item in the RF menu or in /SCWM/PI_COUNT. The RF screens use technical terms and expect the counter to know the document number; a bin without an open document cannot be counted by simply scanning it. Approval of differences above tolerance by a second person is only separated by authorization in the standard flow; there is no approval list. This app starts the count by scanning the bin, finds or opens the document in the background and brings difference approval into one screen.
Who uses it? Warehouse count teams, warehouse supervisors, stock control and inventory owners, cost accounting.
Closest standard alternatives
- /SCWM/PI_COUNT Enter Physical Inventory Count. Enters counts per document and item; the document must exist first and there is no bin scan check.
- /SCWM/RFUI EWM RF Framework Logon. Standard RF count transactions; document-driven and without a difference approval list.
- MI04 Enter Inventory Count with Document. Count entry with a document for storage locations outside EWM; not mobile.
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| /SCWM/LAGPEWM Storage Bins | Storage bin: warehouse number, storage type, storage section; bin check | Read | ECC + S/4 |
| /SCWM/AQUAEWM Available Quantity | Available quantity, batch and HU in the bin; book side of the difference | Read | ECC + S/4 |
| /SCWM/QUANEWM Quants | Quant quantities; updated when the approved count is posted | Read / write | ECC + S/4 |
| /SCWM/HUHDREWM Handling Unit Header | Header of the scanned handling unit | Read | ECC + S/4 |
| MARAGeneral Material Data | Product master and barcode resolution | Read | ECC + S/4 |
| MAKTMaterial Descriptions | Product description | Read | ECC + S/4 |
| MATDOCMaterial Documents (S/4HANA) | Material documents of posted count differences (S/4HANA) | Read | S/4HANA only |
| IKPFPhysical Inventory Document Header | IM physical inventory document header for storage locations outside EWM | Read / write | ECC + S/4 |
| ISEGPhysical Inventory Document Items | IM physical inventory item: counted quantity, book quantity, difference flag | Read / write | ECC + S/4 |
BAPIs and functions used
- BAPI_MATPHYSINV_CREATE_MULTCreate Physical Inventory Documents. Creates a physical inventory document for a storage location outside EWM
- BAPI_MATPHYSINV_COUNTEnter Physical Inventory Count. Writes the count result to the IM physical inventory document
- BAPI_MATPHYSINV_GETDETAILRead Physical Inventory Document Details. Reads book quantity and status of the IM physical inventory document
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_LGNUM | Warehouse number (user setting) | Single value | /SCWM/LAGP-LGNUM | Yes | W100 |
| S_LGTYP | Storage types open for counting | Range / multiple | /SCWM/LAGP-LGTYP | No | 0010–0050 |
| P_BLIND | Blind count (hide book quantity) | Checkbox | — | No | X |
| P_TOLPC | Quantity tolerance for posting without approval (%) | Single value | — | No | 2 |
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 | Bin barcode | /SCWM/LAGP-LGPLA | Yes |
| 2 | Product barcode | MARA-MATNR | Yes |
| 3 | Batch | /SCWM/AQUA-CHARG | No |
| 4 | Handling unit (HU) | /SCWM/AQUA-HUIDENT | No |
| 5 | Counted quantity | ISEG-MENGE | Yes |
Sample upload file
| 1 | Bin barcode * | Product barcode * | Batch | Handling unit (HU) | Counted quantity * |
|---|---|---|---|---|---|
| 2 | A-01-02-03 | HM-1001 | B2611-04 | 48 | |
| 3 | A-01-02-04 | YM-2040 | 100000000000004521 | 120 | |
| 4 | B-03-01-01 | 0 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Warehouse | /SCWM/LAGP-LGNUM |
| 2 | Storage bin | /SCWM/LAGP-LGPLA |
| 3 | Storage type | /SCWM/LAGP-LGTYP |
| 4 | Product | MARA-MATNR |
| 5 | Product description | MAKT-MAKTX |
| 6 | Batch | /SCWM/AQUA-CHARG |
| 7 | Book quantity | /SCWM/AQUA-QUAN |
| 8 | Counted quantity | Calculated Quantity entered in the app |
| 9 | Difference | Calculated Counted quantity − book quantity |
| 10 | Unit | /SCWM/AQUA-UNIT |
| 11 | Status | Calculated Posted, awaiting approval, recount or empty bin confirmed |
Sample result list
| Warehouse | Storage bin | Storage type | Product | Product description | Batch | Book quantity | Counted quantity | Difference | Unit | Status |
|---|---|---|---|---|---|---|---|---|---|---|
| W100 | A-01-02-03 | 0010 | HM-1001 | Kraft paper reel 120 g | B2611-04 | 50 | 48 | -2 | ST | Posted |
| W100 | A-01-02-04 | 0010 | YM-2040 | Corrugated board sheet | 100 | 120 | 20 | AD | Awaiting approval | |
| W100 | B-03-01-01 | 0030 | 0 | 0 | 0 | Empty bin confirmed | ||||
| W100 | B-03-01-02 | 0030 | AM-3315 | Stretch film 23 micron | 36 | 30 | -6 | RL | Recount |
How does the program work?
- When the user opens the app, the warehouse number and the storage types the user may count come from the user settings; the EWM physical inventory authorization (/SCWM/PIPR) is checked. The app runs on an OData service and can be used from a browser, a handheld or a phone camera.
- The bin barcode is scanned. The app checks that the bin exists in /SCWM/LAGP for the selected warehouse number, that its storage type is open for counting and that the bin is not reserved for another count. If a wrong warehouse or storage type is scanned, the screen shows a red warning and the count does not start.
- The product, GTIN or handling unit barcode is scanned; the product name comes from MARA/MAKT. A batch is requested for batch-managed products and the HU number for handling units. If blind counting is on, the book quantity is not shown to the counter.
- The counted quantity is entered. If an open EWM physical inventory document exists for the bin, the count is written to its item; otherwise an ad hoc document is created for the bin and the count is entered in the same step. An empty bin is confirmed as ’empty’ with one tap.
- The difference is calculated against the available quantity in /SCWM/AQUA. Differences within the quantity and value tolerance set during installation are ready to post. For differences above tolerance, the /SCWM/EX_PI_PREVENT_POST BAdI blocks posting; the difference goes to the warehouse supervisor’s approval list, where the supervisor either requests a recount or approves it.
- Approved counts are posted in EWM: the quant quantity is updated and the difference is passed to accounting through the difference analyzer; in S/4HANA the difference material document is created in MATDOC. For storage locations not managed by EWM, the same screen opens an IM physical inventory document with BAPI_MATPHYSINV_CREATE_MULT and writes the count to IKPF/ISEG with BAPI_MATPHYSINV_COUNT (this path is also used in ECC).
- Every scan, count and approval is logged with user and time; the count list can be exported to Excel.
Performance notes
Use a single select per scan for the bin and stock checks; read /SCWM/AQUA by warehouse number and bin key. Cache the product barcode resolution. Post differences at the approval step in packages rather than at the moment of counting; on busy count days, leave the mass posting from the approval list to a background job.
Features
- Line-by-line result and error log Every scan, count and approval is traced with user and time.
- Double-click drill-down to the document The bin stock and the physical inventory document can be opened from the approval list.
- Export to Excel The count and difference list can be exported to Excel.
Authorization objects
- /SCWM/PIPRCreate EWM physical inventory documents and enter counts
- /SCWM/PIBKPost inventory differences in EWM (approvers)
- M_ISEG_WZBEnter IM counts for storage locations outside EWM
- S_SERVICECall the app's OData service
Frequently asked questions
Do we need to create a physical inventory document beforehand?
No. If an open document exists for the bin, the app uses it; otherwise it creates an ad hoc document for the bin itself. Planned periodic or cycle count documents can be counted with the same screen.
Can the counter post the difference directly?
Only within the tolerance set during installation. Differences above tolerance are stopped before posting by the standard BAdI and go to a person with approval authorization; the approver can request a recount.
Is scanning with a phone camera enough?
For low-volume counts, yes. For intensive counting, a handheld with a trigger scanner is recommended; the app works with the same screen on both devices.
Related reports
Physical Inventory Count and Difference Pack
A four-component pack that runs a count campaign from start to finish: storage bins due for counting, bulk entry of count results from handheld …
Physical Inventory Count Differences and Recount Analysis Report by Material and Storage Location
A custom ALV report that reads all physical inventory documents of a period and shows, per material and storage location, the difference quantity, the …
Cycle Count Due Bins and Count Progress Report
A custom ALV report that shows the storage bins whose count is due or overdue based on the last count date and the material's cycle counting …
WM Count Result Upload from Scanner File with Tolerance Check Program
A custom upload program that enters WM count results made with handheld scanners or Excel into inventory documents in bulk, calculates the difference …
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.