SAP MM - MASTER DATA INTERVIEW QUESTIONS AND ANSWERS

Q.1 How to Flag a material for deletion?

Ans- DPRL Change Material When Profile Deleted

MBAD -Delete Material Documents

MM06 -Flag Material for Deletion

MM16 -Schedule Material for Deletion

MM70 -Sel. Materials Flagged for Deletion

MMDE -Delete All Materials

PPRL- Change Material When Profile Deleted

Q.2 What is Valuation Category?

Ans- The valuation category determines which valuation types are allowed to use. The valuation category indicates that whether the material ‘s stock is to be valuated as one unit or in parts. The valuation category used as a key that indicates the criteria for defining partial stock.

Q.3 What is Basic Unit of Measure & explain Purpose?

Ans-  Base unit of measure

This is the unit of measure in which the stocks of a material are managed. The system converts all quantities entered in other units to the base unit of measure

Q.4 What are important field in Accounting

Ans – Division

Valuations class

Valuation cat.

Price

Price unit

Price control

Q.5 What is Valuation Class?

Ans – Group of material having same account determination is called valuation class. We can group together different materials with similar properties by valuation class. Eg Raw material, Finished Goods, Semi-Finished. We can define the following assignments in customizing: All materials with the same material type are assigned to just one valuation class.

Different materials with the same material type can be assigned to different valuation classes. Materials with different material types are assigned to a single valuation class.

The Valuation Class in Accounting 1 View in Material Master is the main link between Material Master and Finance. This Valuation Class along with the combination of the transaction keys (BSX, WRX, GBB, PRD) defined above determine the GL account during posting

From the IMG screen: Materials Management -> Valuation and Account Assignment -> Account Determination -> Account Determination without Wizard -> Define valuation classes

Valuation Class is like a bridge to link material with G/L account

Q.6 What is price control in Material Master?

Price Control is an indicator defined in the material master data. It indicates the method used to valuate the stock of a material. It can either be S (standard price) or V (Moving average price).

Q.7 What is Moving Average Price & What is the formula?

Moving Average Price: a price which changes in consequence of goods movement and invoice postings.

The moving average price is calculated by dividing the value of the material by the quantity of material in stock. It is automatically recalculated by the system after each goods movement or invoice entry

Moving average price = total stock value / total stock quantity

Q.8 What is Standard Price?

Standard price

 

 During the valuation using the standard price (price control .S.), there are many stock postings to a price determined in the material master record, the standard price. Variances to this standard price are posted to the price differences accounts.

For statistical purposes, the system also calculates the moving average price for materials that are valuated at standard price in the material master record. The system calculates the total stock value for materials with standard price control as follows:

Total value = standard price (per base unit of measure) * total stock

Q.9 What is Source List and what is the transaction code for creating Source List?

Ans– To identify sources of supply for materials a source list is used. To create a source, list the transaction code used is ME01.

Q.10 What are the various type of Master Data in MM Module?

Ans- Material master records

Vendor master records

Purchase info records

Source list records

Quota arrangement records

Service master record

Batch master record

Condition record, etc.

Q.11 What is Material Type and Why it is required?

Ans- Material Type: Certain attributes of Material called Material Type or Grouping of materials with the same basic attributes/characteristics. Ex: Raw Materials, Semi-finished or finished products.

Q.12 What is Purchasing Info Record?  – (ME11)

SAP R/3 works on all real-time data that includes material master and vendor master. Material and vendor master are separate data records for keeping information of materials and vendors from where material is procured. The combined information of material and vendor altogether is kept in a record that we call as purchase info record. The key points about purchase info record are as follows −

 

Purchasing info record stores information on material and vendor, supplying that material. For example, a vendor’s current price of a particular material is stored in info record.

 

Purchase info record can be maintained at the plant level or at the purchasing organization level

Q.13 – How do I find a material list in SAP?

Ans. Use MB5L – FI MM recon- double click on the account and you will get a list of materials, stock and value

Q.14 What is the T-code to extend Material Master in Storage Location?

AnsMM50 for mass-extend material master view. To extend the material master storage location view in quick and simple way run SAP transaction MMSC

Q.15 Can you assign a plant to many companies?

Ans. It is not possible A plant belongs to only one company code. It is one to one relationship between them. Also the same lies with storage location and plants. A storage location only can be assigned to single plant. Because for all the purchasing documents when you specify plant you must have to specify company code which is specific.

Q.16 What are basic tables used for Material Master?

Ansbasic tables used in Material master are:

MAKT: Material Descriptions

MARA: General Material Data

MARD: Storage Location Data for Material

MVER: Material Consumption

MARC: Plant Data for Material

MVKE: Sales Data for Material

MAST: Material to BOM link

MARM: Unit of Measurement

MBEW: Material Valuation

Q.17 How to deactivate a vendor so that it cannot be used for further transactions?

Ans – go to T-code XK06, there you can set a deletion flag for that vendor master. Then the basis people will archieve that to delete it permanently from the database.

Q.18 What is a Profit Center?

Ans – A profit center is an organizational unit in accounting that reflects a management-oriented structure of the organization for the purpose of internal control. You can analyze operating results for profit centers using either the cost-of-sales or the period accounting approach.

Q.19 What information is maintained in Accounting View of material master?

Ans – it contains important information such as valuation class and price control. Valuation class

Q.20 What is the use of Material Master Data

Ans–  The material master record contains all information about the materials a company procures, manufactures, stores and ships. The material master database contains descriptions of all materials that an enterprise procures, produces, and keeps in stock.

Q.21 What Are The Main Purchasing Tables?

Ans -EKPO – Purchasing Document Item

 

EKKO – Purchasing Document Header

 

EBAN – Purchase Requisition

 

EKBE – History per Purchasing Document

 

EKET – Scheduling Agreement Schedule Lines

 

EINE – Purchasing Info Record: Purchasing Organization Data

 

EKKN – Account Assignment in Purchasing Document

 

EINA – Purchasing Info Record: General Data

 

EKES – Vendor Confirmations

 

EBKN – Purchase Requisition Account Assignment

 

EORD – Purchasing Source List

 

T024 – Purchasing Groups

 

EKBZ – History per Purchasing Document: Delivery Costs

 

AMPL – Table of Approved Manufacturer Parts

 

EKAN – Vendor Address: Purchasing Document

Q.22 When Creating A New Material, What are Some Of The Possible Material Types?

AnsPressing F4 gives a list of choices. Select the material type for the material you are creating. For example, FHMI for Prod. Resources/tools, ROH for Raw Materials, FERT for Finished Products, etc

Q.23 How to Create A Vendor Number Range?

AnsTransaction Code  XKN1

 SAP IMG Menu  SPRO > IMG > Financial Accounting > Accounts Receivable & Accounts Payable > Vendor Accounts > Master data > Create number ranges for vendor accounts

Q.24 – Can We Change The Material Type Of A Material?

Ans- Yes, we can change the material type of a material.

Q.25 What Is A One-time Vendor?

Ans –  A one-time vendor is the vendor who rarely or only once supplies the materials or articles to your company. For such vendors, you do not need to create a separate master record because the master records have no use after the business transaction is completed. Therefore, you can collectively create a master record for all the one-time vendors.