Maintaining Master Data for SAP EWM

Objective

After completing this lesson, you will be able to use master data records in SAP EWM

Data Transfer Between SAP ERP and SAP EWM

Note

See the following video to learn more about master data in SAP ERP and in SAP Extended Warehouse Management:

Master Data Transfer Between ERP and Decentralized SAP EWM 9.5

Up to SAP EWM 9.5, the distribution of master data from the ERP system was done by using the Core Interface (CIF). CIF has always been used to distribute data to SCM-based system and was re-used only for master data for SAP EWM purposes.

Diagram illustrating the integration between ERP and EWM (Business Suite) using CIF Distribution Model: On the left, under ERP, there are modules or elements including Plant, Shipping Point, Material, Batch, and Customer/Vendor. On the right, under EWM (Business Suite), corresponding elements are Location which connects to SCU, Location to SCU, SCM Product, SCM Batch, and Location to SCU, followed by Business Partner. Each module from ERP to EWM is connected through CIF (qRFC) lines via the central CIF Distribution Model.

The ERP system can be an SAP Business Suite ERP or an SAP S/4HANA system. The Supply Chain Units (SCUs) are objects coming from the SCM basis and are used in SAP EWM for structural settings (a warehouse number always has to be connected to a SCU). Locations are used for the route determination.

Master Data in SAP S/4HANA with Embedded EWM

In embedded EWM, it is not necessary to distribute master data. SAP EWM simply uses the shared master data from ERP. The SCM product is automatically created in the background, but SCUs have to be created manually.

A graphic titled Master data S/4HANA with embedded EWM displays the structure of master data between ERP and embedded EWM. On the left side under ERP, there are boxes labeled Plant, Shipping Point, Material Master, Batch, Batch Classification, and Business Partner. On the right side under EWM, there are boxes labeled SCU, and SCM Product. A dotted double-headed arrow connects Material Master from ERP to SCM Product under EWM, indicating a relationship between these two components.

Locations do not exist automatically in embedded EWM, but they can be created if required.

Master Data Transfer Between ERP and SAP S/4HANA Decentralized EWM

If the decentralized EWM system is based on SAP S/4HANA, it is not possible to use the Core Interface for master data transfer from ERP. The reason for that is that the EWM part again uses the master data in the ERP part of the decentralized system, just like an embedded EWM. And the CIF cannot create this master data, it can only create SCM-based master data.

Because of this, the master data is transferred by an ALE distribution model using IDocs or with the Data Replication Framework (DRF) using services.

The image is a diagram comparing the ERP system to the decentralized EWM on S/4HANA. The ERP section on the left, highlighted in blue, includes components such as Plant, Shipping Point, Material, Batch, Batch Classification, and Customer/Vendor Business Partner. These elements are connected to their counterparts in the decentralized EWM on S/4HANA section on the right, which is highlighted in green. The decentralized EWM on S/4HANA is split into two sub-sections: ERP and EWM. In EWM, there are two SCUs. The arrows indicate data flow between systems, labeled as IDOC/Service. The diagram also includes terms ALE Dist. Model/DRF and CVI for system integration methods.

For the initial release of decentralized EWM with SAP S/4HANA the distribution was only possible with an ALE distribution model. This technology is replaced step by step with the DRF.

The plant and the supply chain units for the warehouse and shipping points have to be created manually in the decentralized EWM. Also in a decentralized EWM based on SAP S/4HANA, locations do not exist automatically, but they can be created if required.

Note

SAP Note 3376455 - Release information and restrictions of Decentralized EWM on SAP S/4HANA 2023 FPS00, FPS01, FPS02 and FPS03 includes a guide for the ERP/EWM integration which explains the steps for setting up the master data distribution using the DRF for Business Partners and an ALE distribution model for the other objects. Similar notes and guides are available for earlier and later releases as well.

How to Transfer Master Data Using an IDoc

DemoStart Demo

Product Master Data and Warehouse Product Master Data

Flowchart describing the process of creating a warehouse product from an ERP material master. The process starts with the ERP Material Master. An arrow labeled IDOC points from ERP Material Master to a green box labeled EWM SCM-Product. Another arrow labeled Create points from EWM SCM-Product to a green box labeled Warehouse Product, . The warehouse product is specific to the warehouse number E100 and the party entitled to disposeSPCW.

Through the transfer of the material master data from ERP to SAP EWM, the product master data is created in the SAP EWM system. Use the Maintain Product transaction to access basic product master data. That transaction is available at:

Extended Warehouse Management→Master Data→Product→Maintain Data.

Data in the product master view is global data. It is applicable to all warehouses in which that product is stored.

Product data contains the following information:

properties
Units of measure
classification/Item category group/Serial number profile
Packaging data (in cases where the product is a packaging material)

It is not mandatory, but to add specific warehouse information, but you can create a warehouse product. This is an extension of the product master data with information relevant to a specific warehouse and party entitled to dispose. You create and maintain a warehouse product when you want to control processes like putaway or picking product dependant. For certain processes it might be necessary, for example in order to maintain replenishment quantities, to create a warehouse product. There are different possibilities to create, change, or display a warehouse product:

The transaction /SCWM/MAT1
- Extended Warehouse Management→Master Data→Product→Maintain Warehouse Product.
Note
Entry of this information is mandatory:
Warehouse number
Party entitled to dispose
In the Warehouse Management Monitor
With the Manage Product Master Data app
Using the Slotting function
The SAP Note 3081583: Automatic Creation of Warehouse Product when creating Products describes a customer-specific solution using BTE (business transaction events) to automatically create warehouse products.

Warehouse Product Properties

The warehouse product includes all the properties of a product that relate to its storage in a certain warehouse within the framework of SAP Extended Warehouse Management (EWM), for example, the putaway and removal control indicators.

There are three tabs for warehouse-specific entries:

Tab	Used to
Warehouse Data	Maintain general data or data that can influence putaway or stock removal.
Slotting	Maintain the parameters that are used in the slotting and rearrangement processes. This information can be determined by the slotting process, but can also be maintained manually.
Storage Type Data	Maintain data that is specific to a particular storage type where a product is stored. This generally consists of indicators used in replenishment and storage bin management.

How to Maintain Warehouse Product Master Data

DemoStart Demo

Maintain Warehouse Product Master Data

ExerciseStart Exercise

Packaging Specifications

A packaging specification is another important piece of master data in SAP Extended Warehouse Management. This is used to specify how to pack a product for putaway or for transportation.

A simple example for the use of a packaging specification in the warehouse is for palletization data. Palletization data for a product specifies how that product is packed and putaway.

For example, in your warehouse, you place 50 pieces of Product A on a pallet for putaway. In that case, you:

Create a packing specification for Product A with:
- Main packaging material of pallet
- Contents of product A
Specify a target quantity of 50

If 100 pieces are delivered, the system uses the packing specification to create two warehouse tasks for 50 pieces each, that is 2 pallets of Product A.

Packing Specification

The packing specification defines the necessary packing levels for a product and the related packaging materials. The packing specification includes the steps that must be performed during the packing process.

A packaging specification has a predefined structure as outlined in the following table:

Structure	Contains
Header	The name of the packaging specification, the user who created it, and its status.
Contents	The name of the product to be packed or the number of another packaging specification.
Level	The level associated with the packaging specification. (A packaging specification can have one or more levels).
Element Group	The element group associated with the packaging specification. (A packaging specification can have one or more element groups. An element group can have one or more elements. Element groups can be re-used.)
Element	A packaging material and/or a work step.

A packaging material is a product that is used to pack products upon, or to pack products in. Packaging materials must be defined as products, using fields that define the characteristics of the packaging such as:

maximum packing weight
maximum volume

A work step is defined separately and is assigned to a packaging specification element. It is an instruction for a warehouse worker on how to apply a specific step of a packaging specification.

Packaging Specification Determination and the Condition Technique

Packaging specifications are stored using the Integrated Product and Process Engineering (iPPE) database engine. To determine if a packaging specification is to be applied, the condition technique is used.

Packaging specification determination is used in following processes:

During automatic packing in goods receipt processing (inbound delivery).
Determining packaging material in warehouse order creation.
Determining packaging material in delivery processing (goods issue).
Determining packaging material during consolidation.
Slotting
During other internal warehouse processes, for example, palletization, determining unit of measure, and so on.

Unified Package Builder

As several applications in Transportation Management (TM), Extended Warehouse Management (EWM) and Logistics (LO) use differing packing engines that are based on different packing rules, it is possible to use the unified package builder (UPB) in SAP S/4HANA to reduce master data maintenance.

Describing the Unified Package Building supporting different packaging components and layers of packaging management. At the center is the Unified Package Building, highlighted in orange. From the top, there are three applications in yellow—Extended Warehouse Management (EWM), Transportation Management (TM), and Logistics General (LO) with arrows pointing to the central component. Below the central component, two alternative packaging approaches are listed: Packaging Specification Engine and Packing Instruction Engine. Arrows point from these to Unified Package Building. At the bottom, Packaging Specification Master Data and Packing Instruction Master Data are indicated in green and blue respectively, each arrow heading upwards toward their corresponding engines. These components represent a structured flow of packaging management systems and data integration.

Technically UPB is not restricted to embedded EWM. However, for the UPB all the required master data (either packing instructions, packaging specifications, or packing instructions) are required to be in the same system - which is usually not the case in a decentralized EWM.

Handling Units

In certain product movement processes, a handling unit is required. A handling unit has a unique identification number that provides the details of that handling unit.

Note

The unique number for a handling unit number can be created from an internal number range or according to the industry standard EAN128, Serial Shipping Container Coding (SSCC-18).

All information that is relevant to a packed product (for example, batch numbers) are available in the handling unit.

Image of a visual aid illustrating the concept of a 'Handling Unit,' which is described as a physical collection of goods. On the left, there is a simple graphic of a hand truck with a blue box labeled 123456 indicating a unique identifier or item number. Above the box are two smaller rectangles, one green and one blue. The text on the right explains that a Handling Unit consists of packaging materials, such as pallets, cartons, shrink wrap, and containers, as well as products that need to be transported, stored, or used. Bullet points highlight these components: Packaging materials and Products.

Handling Unit Management

In SAP EWM, whether products need to be processed in handling units or not, depends on a number of factors.

If the use of handling units is an enterprise-standard, then products are normally received, warehouse managed, and issued in handling units.

In warehouses where products are not generally managed in handling unit form, certain SAP EWM processes require that products (received or issued) are packed into handling units. This may be only temporarily, for example, to facilitate the internal SAP EWM processes. In those cases, the putaway process in SAP EWM requires that the item is packed in a handling unit (HU). Once the physical storage of that item is complete, the HU number can be removed from the item (on the system).

Handling units can only be stored in storage bins within a storage type that has been configured to allow handling units. In SAP EWM customizing of storage types, you indicate whether putaway with HUs is mandatory in the storage type or if HUs are allowed or forbidden.

Summary

Master data, such as business partner (vendor/customer), and material should only be maintained once in SAP ERP and then distributed to SAP EWM. In SAP EWM the product master data record can then be created to support your warehouse processes for each warehouse number.
The packaging specification defines packing levels for a product in order, for example, to put away or transport the product.
A handling unit is a packaged material that can be moved, or stored as one item in the warehouse. The handling unit can be identified through the handling unit number.

How to Create a Packaging Specification

DemoStart Demo

Create a Packaging Specification

ExerciseStart Exercise

Continue to quiz