Managing the Warehouse

Objectives

After completing this lesson, you will be able to:
  • Use the Warehouse Management Monitor.
  • Create a tailored measurement service.
  • Create a calculated measurement service.
  • Integrate measurement services in the warehouse cockpit.
  • Plan warehouse excellence.

Warehouse Management Monitor Basics

The SAP EWM Warehouse Management Monitor is a central tool to keep warehouse managers informed about the current situation in the warehouse. This information enables them to take appropriate actions depending on the current warehouse situation.

The warehouse management monitor also contains alert-monitoring capabilities. These highlight any actual and/or potential problems in the warehouse, and provide exception-handling tools to help correct any problem situations.

The tool is highly customizable and the information displayed can also be extended. For example, you can create custom nodes and custom monitors. The following figure shows the basic screen layout of the Warehouse Management Monitor.

Represetantion of the screen layout in the Warehouse Management Monitor.

Hint

With hotspots, you can jump directly to the details of the selected object. If you do not want the system to open a new mode for this, use the user parameter "/scwm/monnav" = "X".

SAP Warehouse Management Monitor

You can use the standard SAP Warehouse Management Monitor or you can create your own monitor in customizing. Regardless of whether you use the standard SAP monitor or your own monitor, you can tailor it to your needs by hiding nodes or creating new variant nodes based on the standard nodes. Creating variant nodes enables you to create your own nodes, which are based on standard nodes but with specific selection criteria or a specific layout.

By default, object information displays as a list view. The list view is displayed in an SAP List Viewer (ALV) grid, and it offers all standard ALV functionality, including sorting, filtering, and printing. You can toggle to form view for a selected object. The form view provides a focused view of the object, and more-detailed information than the list view. The form view is displayed in an HTML viewer. Other options to display object information are (depending on the installed plug-ins or viewers):

  • List output (a very "classic" display)
  • Excel inplace
  • Crystal Reports

There are different ways in SAP EWM to be notified about alert situations:

  • Alert Nodes in the Warehouse Management Monitor
  • Alerts in the SCM Alert Monitor

The Alert Node can for example show warehouse tasks that have not been completed within a certain time frame. The time parameter is set in the selection screen for the node.

The Warehouse Management Monitor is often used to display stock balances. Physical and available stocks can be displayed using a variety of selection parameters from the Stock and Bin node. From the Warehouse Management Monitor, stocks are visible in the following locations:

  • In storage bins
  • On resources, for example forklifts and HUs
  • In transportation units (TUs) that are in the yard
  • In the Difference Analyzer in physical inventory processing

The Warehouse Management Monitor offers several Methods which offer direct processing steps. These can be used as fallback, or in smaller warehouses, where there is no requirement to use the dedicated transactions. The methods are depended on the object which is selected. Example for methods are:

  • For warehouse requests (like inbound deliveries or outbound delivery orders):
    • Post goods receipt or goods issue
    • Create warehouse tasks
  • For warehouse tasks or warehouse orders:
    • Confirmation or cancellation
    • Display creation logs
  • For warehouse stock:
    • Creation of warehouse tasks for internal movements
    • Posting of stock changes

Warehouse Management Monitor Layout

The Warehouse Management Monitor screen is divided into three sections:

Node Hierarchy tree: The node hierarchy tree contains all predefined nodes. These nodes represent different object classes. The hierarchy tree is used for navigation. You can use the tree to display information from a selected node in the upper right frame. This information can be based on selection criteria. The warehouse management monitor contains nodes for object classes relating to the following:

  • Documents, such as warehouse requests (WRs), warehouse orders (WOs), warehouse tasks (WTs), and physical inventory documents

  • Processes, such as stock and bin and resource management processes

  • Alerts, such as overdue waves or overdue deliveries without goods issue or goods receipt

You can also switch on and off the display of the hierarchy tree to use the full screen for the other sections.

Upper-Right Frame: This is where parent data displays on the warehouse management monitor. This shows high-level information about the node that you select.

Lower-Right Frame: This is where child data displays on the warehouse management monitor. This allows you to drill-down to the detailed information about the parent. It allows you to continue drilling-down until you have come to the lowest-level of information available.

Measurement Services

Analytics

You use Measurement Services to define your own key figures for the warehouse that are supported by the system. You can map your key figures using tailored and calculated measurement services (TMS and CMS). Start these tools from the Start Measurement Services program. You can schedule this program to run regularly.

Examples of warehouse key figures include:

  • Outbound deliveries that have left the warehouse over 24 hours late

  • Number of open physical inventory documents that are over 24 hours old

  • Number of handling units that are in goods receipt

A measurement service performs a query and returns a key figure. Basic, tailored, and calculated services can be built, used by other SAP EWM applications, and extracted to SAP BI. The key figures that are returned (by the query) are used in the these functions:

  • Warehouse management monitor, for creating a tailored measurement service (TMS) under certain conditions

  • Operational planning in Labor Management and for calculating engineered labor standards

  • Warehouse Cockpit, to monitor results graphically

  • BI Content of Extended Warehouse Management

Basic measurement services (BMS) can be grouped together based on business requirements such as inbound, outbound, VAS, and transportation requirements.

SAP delivers BMS groups and several individual BMS functions. A BMS is a function module and you can create additional BMS functions.

Tailored Measurement Service (TMS)

A tailored measurement service (TMS) is based on a basic measurement service (BMS) that you choose. You add special selection criteria to the BMS, such as the activity area, by creating a selection variant. The result is a key figure in the base unit of measure of the warehouse.

An example that illustrates a Tailored Management Service

Calculated Measurement Service

A calculated measurement service (CMS) is a reuse of a tailored measurement service to build more complex formulas.

A calculated measurement service involves a calculation that uses one or more formulas.

The figure and video show an example of using tailored and calculated measurement services.

A measurement service:

  • Can be evaluated (reported)

  • Returns a numeric value. In the case of non-numeric values, 1 is returned

  • Can be used in the Easy Graphics Framework (EGF) or by other KPI reporting tools

  • Contains functionality to evaluate and list results

  • Can be used to trigger alerts

The figure shows an example of using tailored and calculated measurement services. Each morning, the warehouse manager wants to know the number of warehouse orders that a processor executed on the previous day. To calculate that, the manager:

  1. Defines a TMS based on the required BMS.

    • Selects BMS 1 (Number of Warehouse Orders) and BMS 2 (Number of Processors).
  2. Adjusts these BMSs to match the requirements, by creating selection variants 1 and 2.

  3. Creates CMS 1 in the formula editor. This formula divides TMS 1 by TMS 2. As a result, the average number of warehouse orders per processor is calculated. For example, 40 warehouse orders per processor.

Integrating Measurement Services in Warehouse Cockpit

Measurement Services can be scheduled to run periodically in the background. The results can be saved in a local file on a PC or in a logical file on the server.

The measurement service results can be displayed in the Warehouse Cockpit, where they are automatically refreshed.

Images of a gauge, a graph, a pie chart and traffic lights, ilustrating functions of Warehouse Cockpit

Analytics and Planning

To improve the deployment of your warehouse workers and to develop your warehouse strategy, you use SAP NetWeaver Business Warehouse. This enables you to analyze and compare warehouse data and to perform strategic planning and simulation based on delivery data.

BI Content and BI Content Extensions are delivered as an add-on to SAP NetWeaver Business Warehouse. They are a pre-configured set of role and task-related information models that are based on consistent metadata in SAP NetWeaver Business Warehouse. BI Content provides selected roles within a company with the information that the roles need to perform their tasks.

These information models include workbooks, queries, InfoSources, InfoCubes, DataStore objects, key figures, characteristics, update rules, and extractors for SAP applications.

BI Content and BI Content Extensions can:

  • Be used in specific industries without the need to modify it

  • Be adapted so that you can work with it to any degree of detail

  • Serve as a template or as an example for customer-defined BI Content and BI Content Extensions

The BI Content for EWM includes, but is not limited to, the following data flows:

  • Measurement Service Results

  • Executed Workload

  • Exceptions

  • Warehouse Order - Warehouse Task

  • Delivery Items

  • Storage Bins

  • Value-Added Services

  • Strategic Planning

You can use strategic planning to perform long-term planning based on your historical data. You can change values, and conduct planning based on these changed values, for example, to calculate the number of workers required for each month of the year.

Analytics and Strategic Planning with SAP NetWeaver Business Warehouse

Proof of Delivery (POD)

To verify the picking and outbound worked as requested, the proof of delivery is a valuable tool. When you use SAP ERP, the proof of delivery is registered in the ERP system and can be uploaded into SAP EWM. You can then use the Warehouse Management Monitor to review these PODs. The data can also be uploaded to SAP Business Information Warehouse for reporting purposes to see information on a daily, weekly, or monthly basis.

Warehouse Costs and Full-Time Equivalents (FTEs)

SAP EWM offers the possibility to maintain the daily average number of full-time equivalents (FTEs) working in the warehouse, the labor costs per FTE per day, and the daily fixed costs for your warehouse. This information can be used for analysis purposes in BI. The defined query provides information such as:

  • Daily average ratio of the number of outbound delivery items per FTE

  • Daily average ratio of total costs per outbound delivery item

  • Labor costs per FTE, fixed costs, and total costs for the warehouse

  • Daily FTE average

SAP S/4HANA Embedded Analytics

With the seamless integration of analytics features in SAP S/4HANA, you can benefit from a variety of analysis options in an environment with simplified data model, new user experience, advanced processing and deployment options suitable to your business needs. Often transactions and analytics are handled separately. However, in most cases, business processes consists of a recurring sequence of transactions and analytics, so that analytics are embedded in the daily work with transactional data.

All the analytical tools consume Core Data Services (CDS views), which make up the Virtual Data Model (VDM) of SAP S/4HANA. In addition, to use CDS views of type analytical queries, you must set up the Analytic Engine, which is used to evaluate and execute analytical queries at runtime.

Visualization, access, modelling, and persistency in SAP S/4HANA Embedded Analytics

The end user can use the SAP Fiori Launchpad to access both transactional and analytical applications coming from SAP S/4HANA system. The user can navigate between the applications, which enables insight to action in real time without need for data replication.

The Embedded Analytics approach is recommended for operational reporting, not for historical data reporting. For this purpose and also to include other data sources, you still use SAP BW.

Warehouse KPIs - Operations

With the Warehouse KPIs - Operations app, you can view an overview of key performance indicators (KPIs) relevant to your warehouse operations, for example, the total number of open warehouse tasks to be processed on the current date. On the overview page, you can see different types of KPI cards. As a warehouse clerk, these cards help you to better manage and process your daily tasks.