Difference between revisions of "11.6 Material Master Database"

From UNHRD Customer Service Sales
Jump to: navigation, search
(Display materials from Material Master Database)
(Display materials from Material Master Database)
Line 115: Line 115:
  
 
'''7) Warehouse management 1'''
 
'''7) Warehouse management 1'''
 +
 
This view contains part of the information recorded in other views, and the Storage Strategies which are used in the Warehouse Management system (WMS), to optimize the storage of goods in the warehouse (thru the '''Storage Placement''') and ease the picking when despatching from the warehouse ('''thru the Storage Removal''').  
 
This view contains part of the information recorded in other views, and the Storage Strategies which are used in the Warehouse Management system (WMS), to optimize the storage of goods in the warehouse (thru the '''Storage Placement''') and ease the picking when despatching from the warehouse ('''thru the Storage Removal''').  
 
When material is put away in the warehouse, it is generally transferred from the goods receipt interim storage area. The information about the source (interim storage type, interim storage section, and interim storage bin) is either stored in the transfer requirement or the system determines it from the WMS movement type.
 
When material is put away in the warehouse, it is generally transferred from the goods receipt interim storage area. The information about the source (interim storage type, interim storage section, and interim storage bin) is either stored in the transfer requirement or the system determines it from the WMS movement type.
Line 121: Line 122:
 
'''NOTE''' In both cases, Storage type/storage bin proposed by the system at putaway or picking stages can be overwritten by the user by applying a specific Storage type/storage bin
 
'''NOTE''' In both cases, Storage type/storage bin proposed by the system at putaway or picking stages can be overwritten by the user by applying a specific Storage type/storage bin
  
[[File:mm03-1s.png]]
+
[[File:mm03-1s.png|400px]]
  
 
In case there are multiple receiving areas in the warehouse, '''Special movement''' field has to be edited by selecting the options available in the dropdown menu:
 
In case there are multiple receiving areas in the warehouse, '''Special movement''' field has to be edited by selecting the options available in the dropdown menu:
  
[[File:mm03-1s1.png]]
+
[[File:mm03-1s1.png|400px]]
  
 
== Request for new material ==
 
== Request for new material ==

Revision as of 07:14, 29 September 2021

Check weight/size
Performer: Logistics - Support Office
Role: Logistics Assistant - Storekeeper
Transaction : WingsII – MM03

What is the Material Master Database

The Material Master Database (often referred to it simply as the "material master", comprising all the individual material master records stored in the system) contains descriptions of all materials that UNHRD procures and/or keeps in stock. It is the central repository of information on materials (such as inventory levels) for the enterprise. The integration of all material data in a single materials database eliminates the problem of data redundancy. A unique number is assigned to each material master record for items stored across the UNHRD Network. This number identifies a specific material. UNHRD policy has restrict access to Material Master Database. Access restriction is intended to prevent unauthorized users from changing a material master record. Generally, UNHRD staff can view all data for a material. Users at Support Office have the authorization to change data centrally. This means that they have authorization to enter and change all data in a material master record.

Display materials from Material Master Database

To display the material's information go to transaction MM03 or follow the path below:

Logistics > Logistics Execution > Master Data > Material > Material > Display > Display Current Status

Mm03.png

Enter the material number, if known, otherwise click on the icon circled below to search for the material:

Mm03-1.png

Enter the searching term (a keyword contained in the material description) in the Material Description field by including it in the ‘*’ symbol, to include all the variants:

Mm03-2.png

Hit the start search icon 1.2.2 13.png. The system will return the following screen (i.e. all the entries existing in the system that contain the word "Tamiflu"):

Mm03-3.png

To get the information on the searched item double click on it; the system will fill in the material code in the initial screen:

Mm03-4.png

Hit on Enter icon 1.2.2 13.png:

1.5 1.png

Select the item's views required by clicking on the rectangles on the let side of the views' descriptions; the screenshot below includes the most common views selected:

Mm03-5.png

Click on 1.2.2 13.png.


Note Hint:Save the preferred views selected as default values by clicking on the icon Savesdefault.png.


The system prompts with the Organizational Levels fields:

Mm03-6.png

Select the plant from the list of plants available, and enter 'SHRD' as Sales Org. and 'CS' as Distr., channel as shown in the print-shot above:

Mm03-7.png

Hit on Enter icon 1.2.2 13.png:

The system displays the data starting form the first view selected:

Mm03-8.png

The following list shows some types of information that WINGS material master record contains:

1) Basic view - data 1 Contains basic information about the material regarding the material group to be associated to it, the product hierarchy that is related to the Cluster's classification, weight and dimension of the material:

MM03.1.png

2) Basic view - data 2 If the Partner requires to store its own or supplier's code, this info can be recorded in the Proc./insp. memo field:

MM03.2.png

3) Sales: General/plant view In this view it can be specified if the material has to be handled with batch management (e.g. in case of perishable items, or items with high value)

MM03.3.png

4) Plant data / stor. 1 view General information relating to the storage/warehousing of a material, such us storage conditions and shelf life data, are recorded in this view:

MM03.4.png

Warehouse staff has to specify if the material has to be stored under the below Temperature and Storage conditions:

MM03.6.png

5) Additional data views / Unit of measure view Further information on the material can be retrieved by clicking on MM03.8.png:

MM03.7.png

The Unit of measure lists details on levels of packaging if applicable:

MM03.9.png.

6) Additional data views / Inspection Text This field contains the long description of the material that provides further information on the item and represents the description of the material in the electronic catalogue card on UNHRD website:

Mm03-10.png

7) Warehouse management 1

This view contains part of the information recorded in other views, and the Storage Strategies which are used in the Warehouse Management system (WMS), to optimize the storage of goods in the warehouse (thru the Storage Placement) and ease the picking when despatching from the warehouse (thru the Storage Removal). When material is put away in the warehouse, it is generally transferred from the goods receipt interim storage area. The information about the source (interim storage type, interim storage section, and interim storage bin) is either stored in the transfer requirement or the system determines it from the WMS movement type. The system can determine in which storage type the material should be put away by defining this information in the storage strategy view. The storage strategies are based on a search sequence customized in WM. This means that the system uses the search sequence to search for a destination storage type starting from the first free storage type/storage bin specified in the sequence: if there are no free bins on the first storage type specified in the sequence, the system proposes the next free storage type/storage bin foreseen by the sequence. The storage type list is constructed hierarchically, which means that the system searches for empty storage bins in the first storage type first, then in the second storage type, and so on. Same approach can be applied on the Storage Removal field if a strategy is specified: the system proposes the FIFO (First In First Out) strategy, meaning that the oldest quant for the stock pick, by applying combination of storage type and storage bin. The system calculates the age of a quant using the date of the goods receipt posting that was set in the quant by the transfer requirement and the transfer order. In case of perishable items, the strategy is based on the expiration date of the items. NOTE In both cases, Storage type/storage bin proposed by the system at putaway or picking stages can be overwritten by the user by applying a specific Storage type/storage bin

Mm03-1s.png

In case there are multiple receiving areas in the warehouse, Special movement field has to be edited by selecting the options available in the dropdown menu:

Mm03-1s1.png

Request for new material

Requests for creation of new materials have to be submitted to the Support Office by sending the Material Request form, filling in all the required data, to include the long text (400 digits) that represents the description of the material in the electronic catalogue card on UNHRD website, its levels of packagings -if any- and pictures of the outer package and of the material itself. The form contain the following sections:


Standard request for new material

1) General Information

It lists a field for the item name which should contain minimum 10 / maximum 40 characters (special characters not allowed). The item name should follow the standard format that specify first the type of item, and then its specs (e.g. Vehicle, LC76, Hardtop, 10 seater, LHD):

MMCF1.PNG

The following field is the Description of the material which should contain minimum 500 / maximum 2000 characters (special characters not allowed):

MMCF2.PNG

In case of longer descriptions, information can be inserted in the attachment section

The requesting Hub and the Owneship to specify if it is WFP or NON WFP materials, can be selected from the drop-down menu:

MMCF3.PNG

The requestor has to oick the most appropriate Material Group by selecting it from the drop-down menu. The list is generated from same available in WINGS:

MMCF4.PNG

The requestor has to pick the most appropriate Hierarchy Code by selecting it from the drop-down menu. The list is based on the Logistics Cluster classification of materials:


MMCF5.PNG

The requestor has to pick the most appropriate UNCSS Code by clicking on link to the UNCCS classification:

MMCF12.png

When UNCSS code database is displayed, enter the main word of the description in the Search field (e.g. vehicle) and click on MMCF8.PNG:

MMCF7.PNG

Click on the pages of results displayed to find the most appropriate code to adopt and click on the MMCF10.png:

MMCF9.png

The database shows the full description of the code selected:

MMCF11.png

The requestor paste the code selected in the Material Master Creation form.

MMCF6.PNG

The following fields are related to the attachments such as pictures of material and manuals or shipping documents. These files are required to populate the electronic catalogue on UNHRD website:

MMCF13.png


2) STORAGE TECHNICAL DETAILS

This section contains specific information such as the Specification for each which is related to the weight and dimensions of the unit (e.g. a blanket), of its first level of packaging (e.g. a bales of 25 blankets each), and of its second level of packaging (e.g. a pallet of 5 bales), if any:

MMCF14.png

Other information have to entered in the Warehouse Information section to specify if the material is considered as Dangerous Good, its storage conditions, and the warehouse strategy for the placement and removal of stock. Good receipt area has to be specified for those hubs that have multiple receiving area in their warehouses:

MMCF15.png

3) OTHER

Further information and comments can be entered in this section that also contain info on the staff that provided the information for the form and him/her supervisor that checks its contents before it is submitted to Support Office:

MMCF16.png

NOTE The Harmonised System Customs Code (HS code) can be inserted in the Remarks field.

Once all above information are filled in, the Material Master Creation form can be sent to Support Office by clicking on MMCF17.png

Select MMCF19.png and click on MMCF20.png.

MMCF18.png

The form is automatically sent to Support Office and the material is created.

You can also save the MMCF as ADOBE format


Request for new material for On-demand procurement

As On-demand procurement is applied to those sales that involve procurement of items that don’t fall under the standard variety of goods procured by UNHRD, also in this case a request to create new material has to be submitted to Support Office by following the standard procedure.

A dedicated range of material codes is assigned to on-demand items: those materials start with the letter 'BO' and remaining part follows the standard criteria (e.g. BO48233001). The creation of new materials to be managed thru on-demand process should be limited make available a restricted range of generic material codes that can be adapted to any forthcoming on-demand sale.

By definition the on-demand process is applied for Dubai's procurement of specific items that transit the warehouse in a short lapse of time. As of that, at the time the procurement process is started with Purchase Request creation, items warehouse specifications are not known. This is why the request to create new on-demand materials is submitted by logistics staff when the procurement process is completed, before the Purchase Order is issued. In order to create on-demand material a Material Master Request form is required to contain only the main information such us the item name, the appropriate Material Group, Hierarchy Code, UNCSS Code and the HS code. The remaining information are not strictly required. Material created for the on-demand process are not managed with batches and not treated as perishable items.

Logistics staff edits the remaining information for the on-demand materials such Gross and Net Weight, and Volume, at Outbound Delivery stage.

Request for amendment of existing material

Requests to change information on material already existing in the Material Master Database has to be submitted by filling in the Material Request form