Extended Warehouse Master Data

Extended Warehouse management Master Data

In Extended Warehouse Management we deal with various master data to execute warehouse operation. We can classify Master Data as follows;

· Enterprise Organizational structure

· Warehouse Structure Master Data

· Supply Chain Unit

· Custodian

· Party Entitled to Dispose

· Material Master Data

· Warehouse Product Master

· Handling Unit Data

· Packaging Material Data

· Warehouse Resource Data

1. Enterprise Organizational Structure

· Company Code: NVRS

· Company: NVRS

· Plant: NVRP- EWM Managed, NVRS- WM Managed

· Purchase Organization: NVRS

· Purchasing Group: NVG

· Plant Storage Location: ROD-(Received on Dock), AFS (Available for Sale)

· Sales Organization: NVRS

· Distribution Channel: NV

· Division: 01- Product Division

· Shipping Point- NVSP for Plant NVRP, NVPS for Plant NVRS

· ERP Warehouse Number: NWM

2. EWM Warehouse Organizational Structure

• EWM Warehouse Number: NVWM

• Storage Type: YHGH, NV01, NV02, NV03, NV04

• Storage Section: Pallet, Warehouse Rack, Fast Moving, Slow Moving

• Storage Bin Type: Short Bulk Storage Bin

3. Supply Chain Unit

Physical or Organizational unit that used within a logistical process (Example; RO-Goods Receipt Office, SO-Shipping Office, INV-Warehouse (Inventory Management)

SCU is the physical location of address

· When manufacturing plant owned warehouse location will be same as plant location

· When manufacturing plant have 3rd party logistics

4. Custodian

Custodian is the Owner of the warehouse. In case of Plant having own warehouse plant is the owner of the warehouse. In case of 3rd party logistics owner will be 3rd party.

5. Party Entitled to Dispose

SAP EWM allows the connection of multiple ERP systems to your warehousing system without the need to segregate stocks, meaning no loss of capacity in your warehouse. An entity called 'Party Entitled to Dispose' (PETD) allows for having stock from one system sat in a bin next to stock from another system.

An organization, defined as a business partner that is entitled to dispose of stock. Usually Disposal party is the plant in EWM.

If in EWM warehouse you are storing material belongs to multiple plants we need to define Party Entitled to Dispose or Plant as vendor for each plant. We must have Business Partner with BP Role

BP General Role

FLVN00- FI Vendor- Company Code Data

FLVN01- Vendor – Purchasing Data

We need to assign the plant to a vendor

Note: We don’t assign Party Entitled to dispose as default in EWM warehouse if we are managing storage of multiple plant material in single warehouse

6. Material Master

Material Master will maintain in ERP system. We can create, or change material in ERP system

T-code: MM01- Create Material

Material Number: NVRP-EWM-MAT1

Industry Type: Mechanical

Material Type: FERT

Select View:

o Basic Data 1, Basic Data 2, Sales Org Data-1, Sales Org Data-2, Sales Genera/Plant Data, Purchasing, Plant Storage Data-1, Plant Storage Data-2, Accounting-1, Accounting-2

Organizational Data

o Plant- NVRP

o Storage Location- ROD

o Sales Organization- NVRS

o Distribution Channel- NV

Enter Data

o Basic Data 1-

- Material Number, Material Description,

- General Data- Base unit of Measure, Material Group, Division, Gen Item Category Group

- Dimension EAN- Net Weight, Gross Weight

o Basic Data 2

o Sales Org Data 1

- Delivering Plant- NVRP

- Tax Data

o Sales Org Data 2

- Gen Item Category Group- NORM, Item Category Group-NORM

o Sales Org General/Plant Data

- General Data, Unit of Measure, Net Weight, Gross Weight, Availability Check

- Shipping Data- Transportation Group- 0001, Loading Group- 0001

- Packaging Material Data

o Purchasing Data

- General Data, Purchasing Group- NVG

- Purchasing Value Key

- Other Data

o Plant Storage Data 1

o Plant Storage Data 2

o Accounting 1

- Valuation Class- 7920

- Pricing Control, S-Standard or V-Moving Average Price

o Accounting 2

Save- Material Created

7. Warehouse Product Master

After creating Material Master we need to create Warehouse Product Master. We can create Warehouse Product in two ways.

T-code: /N/SCWM/MAT1- Create Warehouse Product Master for single material

Menu Path:

SAP Easy Access> SAP Menu> Logistics> SCM EWM> Extended Warehouse Management> Master Data> Product> Maintain Warehouse Product

Warehouse Product Master

Properties, Unit of Measure, Additional GTINs/EANs, Classification, Packaging and Storage Material are maintained in ERP Material Master this is triggering in Warehouse Product Master from ERP Material Master.

Warehouse Data

We maintain, Process Type Determination Indicator, Put-away, and stock removal control data

Slotting

We maintain slotting related configuration

Storage Type Data

Here we maintain storage data for Replenishment

2. T-Code: /N/SCWM/MON

Menu Path: SAP Easy Access> SAP Menu> Logistics> SCM EWM> Extended Warehouse Management>Monitoring> Warehouse Management Monitor

8. Handling Unit Management

A handling unit is a physical unit consisting of packing materials (load carriers/ packing material) and the goods contained on/in it. A handling unit (HU) always a combination of products and packing materials. All the information contained in the product items, for example, about batches, is retained in the handling units and is always available. Handling units can be nested, and you can create a new handling unit from several other handling units.

A handling unit has a unique scan able identification number that you can construct according to industry standards such as EAN 128 or SSCC.

· Quantitative Classification of HU

HU – without any fixed quantity

QC- Always with fixed quantity

Cartoon 10 Qty: 5 Qty: Unique ID

In ECC & EWM system both

1. Packaging Material

2. Unique Identification number

If we are generating HU in ERP it should be recognized in EWM.

o Internal Number Range in ERP should be External in EWM.

o Internal Number Range in EWM should be External in ERP

Structure of Handling Unit

The Handling Unit contains the following attributes

Unique Identification number

· Dimension

· Weight

· Volume

· Status

· Products & quantities

· Packaging material

· Packaging specification

A handling unit consists of a handling unit header and handling unit items. It receives a unique number that is used for identification purpose.

· Handling Unit header

The header data of handling unit is divided as follows

o Weight/Volume/ Dimension

o General data

o Storage specific data

· Status

The handling unit is connected to general status management. This enables you to do document the various physical statuses, such as planned or realized. Other attributes like weighed, loaded, blocked or posted for GI for a handling unit.

· Handling Unit Item

The items of a handling unit can consist of material items,

Packaging material VERE in ECC system

9. Packaging Material Data

Type of Packaging Material ECC & EWM

1. Main packaging material – Example, Wooden Pallets, Plastic Pallets, Cartoon boxes etc.

2. Auxiliary packaging material – Example Bubble wrap , plastic wrap ,

10. Warehouse Resource Data

Warehouse resource which can use to perform warehouse activities, in warehouse we have following types of resources

Manual Resource:

A man can be a warehouse resource

Mechanical Resources:

For example heavy duty crane, high rack fork lift, small forklift, Manual drive fork lift etc.

Resource management maximizes the efficiency of warehouse processes by:

• Facilitating the management and distribution of work via queues Enabling the execution of work by resources in a radio frequency (RF) and non-RF environment

• Optimizing the selection of warehouse orders for resources requesting work Enabling effective monitoring and controlling of resources

Controlled Distribution of Work via Queues The assignment of resources to queues enables focused management and distribution of work in the warehouse. For more information, see Queue.

Warehouse Order Execution in RF and Non-RF Environments Resources can execute work via RF and non-RF transactions. For more information about RF transactions, see Standard RF Functions.

Manual and Automatic Assignment of Warehouse Orders to Resources Warehouse orders (WOs) can either be manually assigned to a resource by a warehouse manager, or automatically assigned by the system. For more information, see Assignment of Warehouse Order to Resource.

Optimized Warehouse Order Selection Resources that require system-guided work are offered the most appropriate WOs. Here a number of factors are taken into consideration, for example, the mode, latest start date (LSD), execution priorities, assigned queues, qualification of resource type, and WO status. For more information, see Warehouse Order Selection.

Resource Controlling and Monitoring Warehouse managers can use the warehouse management monitor to do the following:

• Analyze resource workload

• Monitor WO execution by resources

• Send messages to resources

• Logon and logoff resources

• Assign resource groups to queues and remove this assignment

• Create and maintain users and resources

• Change the queue of a WO

• Change the LSD of a WO

Rajesh Sharma

SAP MM/WM/EWM Functional Consultant

§ Linked in profile

https://www.linkedin.com/in/rajesh-sharma-3a565821/

§ Twitter

RajeshS98151512