Mass Creation of Material Master - Master Data

In order to create multiple materials at once, you should have access to a function like

1. eCatt tool
2. LSMW(Legacy System Migration Workbench)
3. BDC (Batch Data Communication) recordings
4. BAPI (Business Application Programing Interface)

You can also use mass maintenance transaction MM17 to create views in some cases.

But you must keep in mind that not all of the organizational levels should contain the same data (MM17 requires that all data for the materials and organizational levels you select should be the same).

Mass creation is never considered to be end users responsibility.But as a module specialist you may need to work on MM17 . In case of LSMW, BDC or BAPI, it is considered to be developers or consultants work. So you do not have to understand in detail, you just have to know the concept, and that there is this kind of possibility for mass data maintenance.

You can use MM17 for mass changing of material master data (if something can’t be accomplished by this transaction it can be done using LSMW, BDC or BAPI).

Step 1)

How to copy Material Master

In this tutorial we will go throught the process of copying an existing material master data into new material

Step 1) In transaction MM01

1. Enter material number that you want to create.
2. Enter our existing material from which we want to copy the data.
3. Click on Select Views button.

How to Change Material Master - Master Data

It may be needed to change certain option in our material master (due to the organizational changes, or changes in processes). We cannot use MM01 as that is the transaction code used only for creating views that are not maintained for certain material. In this case, we need to use MM02 and MM03 transaction codes.

In SAP transactions ending with 01 are for creating, ending with 02 for editing/changing, and the ones ending in 03 are used for viewing data without possibility to change it.

Process to change Material Master

Step 1)

1. Enter transaction code MMO2 in the command prompt
2. Enter the material number whose material master data we want to change.
   

SAP MM Sample Questions for Certification (Set.3) Answers

1. What does the system do when you perform the function Reducing Invoices?

1. Reduce an invoice
2. Post invoice for the actual quantities and values
3. Post a credit memo for the amount reduced
4. Post a debit memo for the amount reduced
5. Facilitate generation of a letter of complaint to the vendor.

2. A vendor is issued a purchase order for 200 pieces at 10 UNI/pc and 10% tax. There was a goods receipt of 140 Pieces. The vendor sends an invoice for 200 pieces at 12 UNI/pc. The Purchase manager decides on a partial reduction with quantity variance. What will be accounting entries for the invoice and credit memo?

1. Stock account in the invoice document is 300+
2. Stock account does not get affected.
3. Input tax in credit memo is 60-
4. Vendor account in the credit memo is 660+
5. Vendor account in the credit memo is 440+

3. What can be the possible entries the system can make during invoice verification if a valuated good receipt is defined for a purchase order with account assignment and there is a price variance?

1. Debit consumption
2. Credit consumption
3. Debit GR/IR
4. Credit GR/IR
5. Credit Vendor

4. Which costs are entered at item level in the purchase order?

1. Planned delivery costs
2. Unplanned delivery costs

5. In Total Based acceptance what validations can the system do before deciding that the balance is too large for the invoice to be posted?

1. First checks whether the variance falls within the defined invoice reduction limit.
2. First checks whether the variance falls within the small difference.
3. If the difference is greater than the small difference it checks whether the variance falls within the defined invoice reduction limit.
4. If the positive difference is greater than the small difference it checks whether the variance falls within the defined invoice reduction limit.
5. If the invoice reduction limits are set to do not check, the system compares the variance with the acceptance limit.

6. When does the system propose current account assignment?

1. Goods receipt
2. Invoice Verification

7. A purchase order has been issued on a vendor for two materials. 150 units of material A has been ordered at 4 UNI/pc. 20 units of material B has been ordered at 45 UNI/pc. The vendor has supplied all the materials. The invoice for the supply has been received and posted. He now sends an invoice that includes 875 UNI as freight charges and 125 UNI as custom duty that was not planned. The system has been configured to distribute delivery costs amongst items. How will the cost be apportioned when the invoice is posted?

1. Stock account for Material A 380 +, Stock account for Material B 570 +
2. Stock account for Material A 500 +, Stock account for Material B 450 +
3. Freight clearing 875+
4. Custom clearing 125 +

Sample SAP MM Questions for Certification (Set.3)

1. What does the system do when you perform the function Reducing Invoices?

1. Reduce an invoice
2. Post invoice for the actual quantities and values
3. Post a credit memo for the amount reduced
4. Post a debit memo for the amount reduced
5. Facilitate generation of a letter of complaint to the vendor.

2. A vendor is issued a purchase order for 200 pieces at 10 UNI/pc and 10% tax. There was a goods receipt of 140 Pieces. The vendor sends an invoice for 200 pieces at 12 UNI/pc. The Purchase manager decides on a partial reduction with quantity variance. What will be accounting entries for the invoice and credit memo?

1. Stock account in the invoice document is 300+
2. Stock account does not get affected.
3. Input tax in credit memo is 60-
4. Vendor account in the credit memo is 660+
5. Vendor account in the credit memo is 440+

3. What can be the possible entries the system can make during invoice verification if a valuated good receipt is defined for a purchase order with account assignment and there is a price variance?

1. Debit consumption
2. Credit consumption
3. Debit GR/IR
4. Credit GR/IR
5. Credit Vendor

4. Which costs are entered at item level in the purchase order?

1. Planned delivery costs
2. Unplanned delivery costs

5. In Total Based acceptance what validations can the system do before deciding that the balance is too large for the invoice to be posted?

1. First checks whether the variance falls within the defined invoice reduction limit.
2. First checks whether the variance falls within the small difference.
3. If the difference is greater than the small difference it checks whether the variance falls within the defined invoice reduction limit.
4. If the positive difference is greater than the small difference it checks whether the variance falls within the defined invoice reduction limit.
5. If the invoice reduction limits are set to do not check, the system compares the variance with the acceptance limit.

6. When does the system propose current account assignment?

1. Goods receipt
2. Invoice Verification

7. A purchase order has been issued on a vendor for two materials. 150 units of material A has been ordered at 4 UNI/pc. 20 units of material B has been ordered at 45 UNI/pc. The vendor has supplied all the materials. The invoice for the supply has been received and posted. He now sends an invoice that includes 875 UNI as freight charges and 125 UNI as custom duty that was not planned. The system has been configured to distribute delivery costs amongst items. How will the cost be apportioned when the invoice is posted?

1. Stock account for Material A 380 +, Stock account for Material B 570 +
2. Stock account for Material A 500 +, Stock account for Material B 450 +
3. Freight clearing 875+
4. Custom clearing 125 +

Introduction to Master Data - SAP MM

What is Master Data ? 

Master data in SAP is used as a base for any transaction. If you are producing, transferring stock, selling, purchasing, doing physical inventory, whatever your activity may be , it requires certain master data to be maintained. We have material master data, customer master data, vendor master data, pricing/conditions master data, warehouse management master data (storage bin master data) etc.

The ones we will focus in MM module are material master and purchase info record.

Few things you should know about Master Data:

1. Material in SAP is a logical representation of certain goods or service that is an object of production, sales, purchasing, inventory management etc. It can be a car, a car part, gasoline, transportation service or consulting service, for example. outoutout
2. All the information for all materials on their potential use and characteristics in SAP are called material master. This is considered to be the most important master data in SAP (there are also customer master data, vendor master data, conditions/pricing master data etc), and all the processing of the materials are influenced by material master. That is why it’s crucial to have a precise and well maintained material master.
3. In order to be confident in your actions you need to understand material master views and its implications on processes in other modules, business transactions and a few more helpful information like tables that store material master data, transactions for mass material maintenance (for changing certain characteristics for a large number of materials at once).

What is Material Type ?

According to SAP ERP, every material has a characteristic called “material type” which is used throughout the system for various purposes.

Why is it necessary to differentiate between material types and what does that characteristic represent?

1. It can represent a type of origin and usage – like a finished product (produced goods ready for sale), semifinished product (used as a part of a finished product), trading goods (for resale), raw materials (used for production of semifinished and finished products) etc. These are some of the predefined SAP material types among others like food, beverages, service and many others.
2. We can define our custom material types if any of standard ones doesn’t fulfill our need.

Most used material types in standard SAP installation