# SAP Storage Type Design Worksheet > Source: https://netray.co/tools/sap-storage-type-design-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet to design storage types with bin counts, capacity and strategy choices, with computed total capacity and utilization. ## Category sap ## Erp SAP EWM ## Audience - SAP WM consultant - SAP EWM consultant - Warehouse manager ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Storage type **Key:** code **Type:** text #### Description **Key:** name **Type:** text #### Storage behavior **Key:** behavior **Type:** select **Options:** - Pallet rack - Fixed bin - Bulk - Block - Shelf - Staging #### Putaway strategy **Key:** putaway **Type:** select **Options:** - Next empty bin - Fixed bin - Addition to stock - Open storage - Near picking bin #### Removal strategy **Key:** removal **Type:** select **Options:** - FIFO - LIFO - Partial pallet first - SLED #### Bins **Key:** bins **Type:** number #### Units per bin **Key:** cap **Type:** number #### Planned stock units **Key:** stock **Type:** number #### Total capacity **Key:** capacity **Type:** number **Expr:** bins * cap **Format:** integer #### Planned utilization **Key:** util **Type:** number **Expr:** if(gt(bins * cap, 0), stock / (bins * cap) * 100, 0) **Format:** percent **Rows:** #### Pallet reserve rack **Code:** 0010 **Behavior:** Pallet rack **Putaway:** Next empty bin **Removal:** FIFO **Bins:** 1200 **Cap:** 1 **Stock:** 960 #### Pick shelf **Code:** 0020 **Behavior:** Shelf **Putaway:** Fixed bin **Removal:** FIFO **Bins:** 800 **Cap:** 4 **Stock:** 2100 #### Bulk floor storage **Code:** 0030 **Behavior:** Bulk **Putaway:** Open storage **Removal:** LIFO **Bins:** 40 **Cap:** 20 **Stock:** 520 #### Quality block area **Code:** 0040 **Behavior:** Block **Putaway:** Addition to stock **Removal:** FIFO **Bins:** 30 **Cap:** 6 **Stock:** 90 #### Goods receipt staging **Code:** 0050 **Behavior:** Staging **Putaway:** Open storage **Removal:** FIFO **Bins:** 24 **Cap:** 2 **Stock:** 18 **Totals:** #### Total bins **Key:** bins **Agg:** sum **Format:** integer #### Total capacity **Key:** capacity **Agg:** sum **Format:** integer #### Total planned stock **Key:** stock **Agg:** sum **Format:** integer **Summary:** #### Overall planned utilization **Key:** overall_util **Expr:** if(gt(sum_capacity, 0), sum_stock / sum_capacity * 100, 0) **Format:** percent **Primary:** true **Notes:** Use one row per storage type. Add the planning unit that matches your design, such as pallets or cartons. Utilization above about 85 percent in reserve types usually leaves too little room for putaway flexibility. ## Content **Intro:** Storage type design drives everything downstream in SAP WM and EWM: putaway, picking, replenishment and counting. This worksheet lets you compare types side by side and see capacity and planned utilization before you configure anything. **Sections:** #### How to use the worksheet **Body:** Add one row per storage type with its code, behaviour, putaway and removal strategy. Enter the number of bins and the units each bin holds. Enter the planned stock from your slotting or inventory analysis. The sheet computes total capacity and planned utilization per row and for the whole warehouse. Export to Excel to share with the warehouse team and attach the result to the design document. #### Design principles behind the columns **Body:** A storage type represents a physical area with one storage logic. Separate types when the strategy, equipment or control differs. Fixed bin and shelf types support picking, while rack and bulk types hold reserve stock. Staging and block types hold stock that is not available for normal removal. Keep pick types small and reserve types large, and use replenishment to link them. Match putaway and removal strategies to the way the stock is consumed. **Bullets:** - Separate types for different equipment or control. - Pick types small, reserve types large. - Blocked and staging areas as their own types. - Choose removal strategies from product shelf life and demand. #### Reading utilization and avoiding mistakes **Body:** Utilization shows how much of the planned capacity is occupied by stock. Reserve rack types above 85 percent get hard to operate, because the search for a suitable empty bin becomes long. Pick types below 40 percent waste walking distance. A common mistake is to size bins for average stock instead of peak stock. Use a seasonal peak with some buffer, then validate against actual SKU dimensions with the bin capacity calculator. **Cta:** If you want these designs checked against your real stock and movement data, we can build a private assistant on your ERP data that proposes slotting and bin sizing from history. **Faq:** #### Does this apply to both WM and EWM? **Answer:** Yes for the planning logic. Classic WM and EWM both use storage types, sections and bins. The customizing objects and some strategy names differ, so use the sheet for design and check names in your system. #### How many storage types should I plan? **Answer:** Enough to separate different storage logic and equipment, and no more. Dozens of nearly identical types make search sequences and reporting harder. Use sections and bin types for finer variation inside one type. #### Where do I get planned stock numbers? **Answer:** From stock history, peak inventory per product group and growth plans. Use stock per storage type from the current system, then apply expected changes. Avoid using the current average only. #### Can I export my design? **Answer:** Yes. Export to Excel, CSV or PDF from the toolbar. Excel is best for working sessions, PDF for sign-off. ## Search terms sap storage type design, sap wm storage type configuration, sap ewm storage type worksheet, storage type design template excel, sap warehouse layout design template, define storage type sap wm, storage bin structure sap, warehouse blueprint sap template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json