11.6 Material Master Database

From UNHRD Customer Service Sales
Jump to: navigation, search
Check weight/size
Performer: Logistics - Support Office
Role: Logistics Assistant - Storekeeper
Transaction : WingsII – MM03

What is the Material Master Database[edit]

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[edit]

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 link title 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


Request for new material[edit]

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:

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

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 amendment of existing material[edit]

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