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:
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
