PalletAuditsExporting shipments from SAP EWM for a pallet audit
Where outbound delivery orders live in SAP EWM, how to get the list into Excel, and what to use for a pallet count.
Where the data is
Outbound delivery orders are maintained in /SCWM/PRDO; inbound deliveries in /SCWM/PRDI. The warehouse management monitor (/SCWM/MON) shows lists in a standard ALV grid.
Getting it into Excel
From an ALV list, use List > Export > Spreadsheet. The MHTML and XML formats export the list as displayed; the Excel XXL option ignores your sorting and filtering and exports every column, so filter the data before, or delete rows after.
You need ship date (the actual one, not the requested one), customer or ship-to name and number, BOL or order/load number, and the number of pallets.
Pallet count
Pallets are usually handling units (HUs). Check that one HU equals one pallet at your site before using HU counts.
Sources
SAP Help: EWM delivery processing; SAP Help: ALV export
Find your missing pallets
PalletAudits matches every shipment to a declared transfer and lists what to declare, dispute and recount. Your first audit is free.
Run a free audit See a sampleMore guides
Exporting shipments and receipts from your WMS for a pallet audit
Exporting outbound deliveries from SAP ECC or S/4HANA (VL06O)
Exporting shipments from Oracle WMS Cloud for a pallet audit
Exporting shipment orders from Infor WMS for a pallet audit
Exporting shipments from NetSuite for a pallet audit
Exporting loads and shipments from Dynamics 365 Supply Chain Management
General information, not advice about any specific contract. Your agreement with the pallet company sets the actual fees and deadlines.