Material Master Views in SAP: The Ultimate Guide

In this tutorial, we will cover all the MM views with the implication on vital processes in standard SAP system. You will see how each of the views is created, its obligatory data, optional fields, and how its creation reflects the system. This tutorial is 7000 words+. For easy reference , we have created a clickable index below , which will take you to various sections of the tutorial

Basic Views

Basic views are views with general information about our material. Obligatory fields you need to insert in order to save changes are

  1. Material description: LCD TV 40" – this can be maintained in various languages.
  2. Base unit of measure (often referred to as Base UOM): PCS – this is the unit of measure in which material stock is managed. For a TV set, it's natural to be a piece. You can also use meter, kilogram, or any other unit you have defined and is suitable for material.
  3. Division: 10 – Division for the material, you could create divisions 10, 20, 30, 40 for finished goods, trading goods, services, and other materials, so you can categorize them in this way. We have selected division 10 for our material since it is finished goods.
  4. General Item category group: NORM – Standard item. Used throughout the system, this indicator has an effect on sales and stock transfer processing as it is used in item category determination.
  5. Weight unit: Kg – unit in which product weight is entered.
  6. Gross weight: 26,988 – gross weight of 1 unit of product in weight unit. Net weight: 24,651 – net weight of 1 unit of product in weight unit

     

Material Master Views in SAP: The Ultimate Guide

Basic data - optional fields

Material group – you can enter material group here Product hierarchy – this field is used in sales and distribution and is maintained in Sales organization 1 view. EAN/UPC – Material EAN code, besides usage in bar coding, it is particularly utilized in Warehouse management as a unique identifier for material and package combination. One material can have several bar codes. One for the base unit of measure. Every alternative unit of measure can also have it's EAN, but it's not a requirement, it's an option. Other fields are optional. NOTE:In the upper part, (marked in green) you can see views that are possible to maintain for current material. You can navigate by clicking on the appropriate view name.

 

Classification View

Materials can be classified in order to be found later by their class, batch characteristics etc. Let's say we have a lot of TV sets with different dimensions colors etc. You can create two classes: dimension and color. Later you can use it to find all the black TV sets, or TV sets of a certain dimension.

Material Master Views in SAP: The Ultimate Guide

Class types available in standard SAP

By choosing Material Class – 001 you are extending material for this class type. Now we have to add a class we want to use for our material. A class called General could consist of two characteristics: Color and Dimension, or anything that you might need while categorizing materials or searching them in MM module, or other modules. After class assignment to the material, you can maintain characteristics that this class contains. In our case, we have a class named General that contains characteristics Color and Dimension. We can populatethe appropriate fields.

Material Master Views in SAP: The Ultimate Guide

Assigning a class and maintaining values for characteristics

It is a good practice to include the color of your product in material description as well; it is extremely useful to other users. For example while creating sales orders in SD, for picking and putaway processes in warehouse management, purchasing department, production planning etc. You can now save your changes.

Material Master Views in SAP: The Ultimate Guide

Saving Classification view

Sales Organization Data 1

When you choose this view, a screen with organizational levels will appear. Here, you can choose for which Plant, Sales organization and Distribution channel you want to extend your material.

After confirming Organizational Levels, you are presented a screen which contains the data regarding sales activities. The only mandatory field is the delivery unit. Others are optional, but they might be needed in order to use some advanced features. For example, if you want to use dynamic rounding profile (must be customized by SD consultant), you have to maintain field Rounding profile. Let's find out what are the most important fields in sales views. The most crucial thing about sales views is that they are open. When we do that people from SD module can sell our material through that Sales Organization / Channel. So essentially you would only have to populate the Delivery unit field and save the data, and immediately material becomes available to be used. To get a better understanding of Sales organization, think of it as an office that sells your products. In this office, you have people that sell products in your home country – they are using distribution channel 01, and you can have people selling abroad, export department that would be channel 02. On the screen below, you can see all of the fields from Sales organization 1 View.

Tax category/indicator: For internal sales, we will have to define a full tax indicator since the tax is applied for sales inside the country. For export, (using division 02 for example) we would set this to 0 – No Tax. It actually depends on the tax policy of your country, but most of the countries have this practice I mentioned. Delivery unit: in most cases it's first alternative unit of measure (box, pallet, something else). You can see that here we will define 1 PAL – pallet as a delivery unit, but that doesn't mean that we can sell only entire pallet. We will also be able to sell a single piece of this material, and the system will indicate to sales person that this material is meant to be delivered as 12 pieces on a pallet. Base unit of measure: this is grayed out field as it is already defined in Basic Data view 1 and cannot be changed afterwards. Division: this is the division we have just selected in our organizational levels screen before current screen. Sales unit: If the field does not contain an entry, the system will assume that the unit of measure is the base unit of measure. If you don't want to use pieces as a default sales unit of measure, you can enter the appropriate unit of measure in this field. It will reflect sales documents in this way: - Sales unit is not defined. Sales person enters quantity of 4 without specifying unit of measure. System will assume that the required quantity is 4 pieces - Sales unit is defined as pallet. System will assume that the required quantity is 4 pallets Sales unit not variable: this check box is used in cases when we require the material to be sold only in sales unit. If you set the sales unit to PAL, and check this box, sales person will only be able to sell this material using the PAL alternative unit of measure. This is being used rarely. Unit of measure group: Used mainly in conjunction with dynamic rounding profile, this is an indicator which represents a group of units of measure that can be used for this material. Material group: material group we discussed during the Basic Data view. Min.order qty: This is a minimal order quantity accepted for this material. Min.dely. Qty: This is a minimal delivery quantity accepted for this material. Rounding profile: Here you can choose a specific rounding profile for material. SD consultant has to create the profiles to be shown as possible entries in this field.

Sales Organization Data 2

With same Organizational Levels, we can create the sales organization data 2 View and maintain its data. Mostly statistical and grouping data are subject of this view.

Important Sales Organization Data 2 View fields

Material Master Views in SAP: The Ultimate Guide

First level of hierarchy

After selecting the appropriate first level, you should click on Next level button just as on the above screen. You will be taken to the screen with possible entries for second level of hierarchy. As you can see in the header of this screen, there is an indication that this second level of hierarchy is for a first level 00100 – LCD TV:

Material Master Views in SAP: The Ultimate Guide

Second level of hierarchy

Final result is as on the screen below:

Material Master Views in SAP: The Ultimate Guide

Product hierarchy on Sales Organization Data 2 View

Other fields in Sales organization Data 2 View Volume rebate group: group used for rebate settlement, can be set to maximum rebate, low rebate, depends on settings in SD module, this information is supposed to be provided by SD team. Pricing Reference Material: material master record that should be used as a reference for pricing purposes. Commission group: you can assign the same commission group to more material as long as the commission is the same for both (for example 5%). Material pricing group: used to group the material with the same pricing procedures. Later in SD condition record can be created based on this field, apart from standard ones (product hierarchy). You can combine material pricing group with the customer number to create a condition. Product attributes: you can assign various product attributes to a material and check if the customer accepts this product attribute.

Sales General / Plant View

This view contains information about general sales characteristics of material. It is maintained on Plant level.

Mandatory fields

Foreign Trade / Export View

This view contains information about freight, foreign trade, exporting of materials.

Mandatory fields in this view are:

  1. Commodity Code/Import Code Number for Foreign Trade: This field contains either a commodity code or a tariff number. It is a unique standardised coding value for a certain type of goods.
  2. Export import group: system can use export/import groups to propose an export procedure for export/import processes in SAP.
  3. Country of origin: it represents the country where this material has been produced. If it's finished goods produced in-house you will enter your country code here (in our example it is DE - Germany). Other fields All the characteristics for sales views are supposed to be provided by the sales department (sales, freight), the role of a material master specialist/user is only to maintain them accurately. Some other information you can be given by your sales department to maintain in material master: CAS number: this field is only used for pharmaceutical products. PRODCOM no. – used only in EU countries for statistical purposes in production. Control code: Consumption tax control code in foreign trade. Region of origin: Besides country you can define a region in the country (for ex. Bavaria, Hessen etc.) CAP product list no. – this is the number of the material in the EU market products group list – if applicable. CAP product group: indicates a product group from CAP product list. Exemption certificate: indicating if the material has been issued a certificate that states that this material doesn't need a license for export. Exemption cert. Number: Number of the exemption certificate. Issuing date of exempt.cert. – Issuing date for an exemption certificate. Military goods: a check box indicating if the material is mainly used in military purposes.

Sales Text View

You can define a sales item text for this material for various languages to be used in the sales documents. This could be some general explanation about the material, or explanation maintained on distribution channel level. If you maintain this text it will show up on the item level in all sales documents, and also in the printing version of sales documents.

MRP View 1

MRP views are maintained mostly for production purposes. This information is supplied by the appropriate MRP controllor or someone else from production planning team. The only mandatory field in MRP 1 View is Planning type. We will cover the most important fields used in a productive environment in more detail.

Purchasing group: this field is used to indicate which purchasing group is the default for purchasing this material. We haven't maintained it yet as this is a finished product of our company, we don't need it to be purchased at any time. We will set up this field for another material that needs to be purchased.

MRP View 2

MRP view 2 contains data about Procurement, Scheduling, and Net requirements calculation.

MRP View 3

MRP view 3 contains several valuable fields mostly used by planning functions.

Other fields in MRP 3 View Planning material: Only for use with planning strategy "planning with planning material".

MRP 4 View

This is the only MRP view that is maintained on Plant / Storage location organizational level. It doesn't contain as much valuable fields as previous, but there are three handy indicators that can be used to optimize processes in some modules.

Work Scheduling View

This view is used by the production to control the scheduling of production and process orders. A production schedule determines how capacity requirements are calculated for all the materials during a scheduling run. Here, you can also activate batch management if material is to be handled in batches (certain quantities of material with slightly different characteristics). Batch management can be activated in several other views.

Plant data – Storage 1 View

Warehouse administration team should supply the data for maintenance of this view. These are mostly storage data valid on the plant level. Let's go through all the essential fields for this view.

Plant data – Storage 2 View

These fields are repeating from Basic view 1 (Weight/Volume section), and Sales – General (General Plant parameters section), we had described them when we covered those views.

Warehouse Management 1 View

This view is maintainable on Plant / Warehouse number organizational level. Warehouse number is the top hierarchy level in warehouse management in SAP. You can see positions 1 & 2 in the picture below representing Plant and Warehouse Number for which we are extending the material. Information for maintaining this view should be supplied by warehouse management administration team.

These settings are very complex and require more in-depth knowledge of Warehouse Management.

Warehouse Management 2 View

This view is maintainable on one more level than the previous view. Here are located palletization data (quantities of material and types of pallets used) in the first section which isn't maintained on storage type level but like previous view on warehouse number level. Lower section of the screen shows several fields that are storage type related settings.

Quality management View

This view is used for material settings for quality inspection processes in Quality Management module. Administrators of that module are responsible for providing the information for maintenance of this view.

Choosing the inspection type on a subscreen of Quality Management view

 

Accounting 1 View

Data entered in this view determines the way that Accounting will be processed for this material. Data is supplied by your FI/CO team, and background customizing by your FI/CO consultant.

Accounting 2 View

This view isn't used very often in production environment, the most common setting for this view is leaving all the fields empty. Basically, it consists of special tax information in Accounting which is hardly ever relevant. Determination of the lowest value of the material, material devaluation through it's status (moving, slow moving) etc. If this view is being used by your financial Accounting department, the department should provide you the information for maintaining this view.

Costing 1 View

Costing view is used to determine the product cost. It can take various inputs, but for production the most important is the costing lot size. That means that an optimal lot size used for product cost estimate can be set here. Product can be produced in a 100 pieces lot or in a 3700 pieces lot; therefore the costing for those two situations are different. That is because there are some fixed expenses (time for setting up appropriate tool, mechanics work. In the first case, our product cost might be as high as 126 USD/pcs while in the other case, it could be 111 USD, which is remarkably different, so production has to try to plan their activities and stock levels of all materials in a plant in a way that our production lot size doesn't vary too much and be as close to our optimal lot as possible.

Costing 2 View

In figure 1 – Valuation data, we can see fields already covered in previous views (Accounting 1 view). Other than that there are fields to maintain planned prices (Standard cost estimate will be copied to Planned price if standard cost estimate is checked and created).

Purchasing View

In purchasing view, we can find several fields already present at previously covered views like Freight group, plant special material status etc. We also have few new fields available only from Purchasing view.

Foreign Trade Import View

Exactly the same view as a foreign trade export view.

Purchase order text View

Exactly the same view as a sales order text view.

Additional data

 

Besides material master views, we have another level of maintenance in MM01 transaction. It is also with no reference to organizational levels. From any View in material master you can choose button Additional data:

Button for switching to additional data maintenance

Once selected, you can see that we can return to MM Views by clicking on Main Data button.

Material Master Views in SAP: The Ultimate Guide

Product descriptions for various languages in additional data

First tab in additional data is about material description. You saw that we have already maintained material description on Basic View 1, but we have only defined a description for the default language (logon language for user in this session). In additional data, we can define descriptions for any other language needed. For example, I have created description for French language. In our case, material description is the same for both languages (in other cases you might need to translate the description). This is important because if you have a customer from France and they are accepting only french product name, you have to define it here, and set communication language for that customer to French (this is done in SD module and is a point where integration between MM and SD is utilized). Maintenance of alternative units of measure is utilized in the second tab. You can see that there is a record for 1 PCS, which equals to 1 PCS, and this is a record for our base UOM. The other one is 1 PAL equals 12 PCS – it means that our company packages LDC TV sets 40" in the amount of 12 pieces on a pallet. You can add as many alternative UOMs as you like, as well as delete them by using the Delete Line button. Here, you can also maintain all EAN codes for all units of measure. In SD module, you can create sales orders by any unit of measure maintained in material master. So practically it's the same creating sales order for 12 pieces, or 1 pallet.

 

YOU MIGHT LIKE: