Blog

Preface – This post is part of the SAP MM series.

Introduction

In this section we have discussed SAP MM Tables. We have provided the table name with its description as well as its explanation. Feel free to ask the name of the SAP MM tables that we have missed in the comment section.

Material master:

MARA- Material Master: General data

It is a standard SAP table which is used to store general material data information.

MAKT- Material Master: Description

It is a standard SAP table which is used to store material descriptions information.

MARM- Material Master: Unit of Measure

It is a standard SAP table which is used to store units of measure for material information.

MARC- Material master: Plant data

It is a standard SAP table which is used to store plant data for material information.

MARD- Material master: Storage location

It is a standard SAP table which is used to store storage location data for material information.

MAST- Material link to BOM

It is a standard SAP table which is used to store material to BOM link information.

MBEW- Material valuation

It is a standard SAP table which is used to store material valuation information.

It will show the stock as on current date. And not period wise details of stock is available.

MBEWH- Material Valuation: History

It table is updated whenever there is change in Moving Average Price.

It is basically the History table for MBEW – Material Valuation table.

MLGN- Material Master: WM Inventory

It is a standard SAP table which is used to store Material Data for Each Warehouse Number information.

MLGT- Material Master: WM Inventory type

It is a standard SAP table which is used to store Material Data for Each Storage Type information.

MVKE- Material Master: Sales <Sales Org, Distr Ch>

It is a standard SAP table which is used to store Sales Data for Material information.

 

MLAN- Material Master: Tax indicator

It is a standard SAP table which is used to store Tax Classification for Material information.

MAPR- Material Master: Forecast

It is a standard SAP table which is used to store Material Index for Forecast information.

 

Vendor master:

LFA1- Vendor Master: General data

It is a standard SAP table which is used to store Vendor Master (General Section) information.

LFB1- Vendor Master: Company data

It is a standard SAP table which is used to store Vendor Master (Company Code) information.

LFM1- Vendor Master: Purchasing Data (Purchasing organization)

It is a standard SAP table which is used to store Vendor master record for purchasing organization.

LFM2- Vendor Master: Purchasing Data (Plant, Vendor subrange)

It is a standard SAP table which is used to store purchasing data for vendor master record.

 

 

Purchasing:

EBAN   Purchase requisition: items

It is a standard SAP table which is used to store Purchase Requisition information.

EBKN   Purchase Requisition: account assignment

EBKN is a standard SAP table which is used to store Purchase Requisition Account Assignment information.

EKKO   Purchasing document header

EKKO is an SAP table used to store Purchasing Document Header information.

EKPO   Purchasing Document: Item

It is a standard SAP table which is used to store Purchasing Document Item information.

EKET    Purchasing Document: Delivery Schedules

It is a standard SAP table which is used to store Scheduling Agreement Schedule Lines information.

EKKN- Account assignment in purchasing document

It is a standard SAP table which is used to store Account Assignment in Purchasing Document information.

EORD- Purchasing Source List

It is a standard SAP table which is used to store Purchasing Source List information.

EIPA- Order price history record

It is a standard SAP table which is used to store Order Price History information.

EKAB- Release documentation

It is a standard SAP table which is used to store Release Documentation information.

EKBE- Purchasing document history

It is a standard SAP table which is used to store History per Purchasing Document information.

EKBZ- Purchasing document history: delivery costs

It is a standard SAP table which is used to store history of delivery costs information per purchasing document.

EINA- Purchase Info Record: General

It is a standard SAP table which is used to store purchasing info record for general data information.

EINE- Purchasing info record: purchasing organization data

It is a standard SAP table which is used to store purchasing info record for purchasing organization.

 

 

Inventory Management:

ISEG- Physical inventory document items

It is a standard SAP table which is used to store Physical Inventory Document Items information.

MKPF- Material document: Header

It is a standard SAP table which is used to store Header: Material Document information.

MSEG- Material document: item

It is a standard SAP table which is used to store Document Segment: Material information.

RKPF- Reservation: Header

It is a standard SAP table which is used to store Document Header: Reservation information.

RESB- Reservation: Item

It is a standard SAP table which is used to store Reservation/dependent requirements information.

 

Invoice Verification:

MYMFT- FIFO results table

It is a standard SAP Table which is used to store FIFO Results Table information.

MYMP1- Receipt data LIFO/FIFO valuation

It is a standard SAP Table which is used to store Receipt Data LFIO/FIFO Valuation information.

RBCO- Document item, incoming invoice account assignment

It is a standard SAP Table which is used to store Document Item, Incoming Invoice, Account Assignment information.

RBDIFFKO- Invoice Verification: conditions

It is a standard SAP Table which is used to store Invoice Verification – Conditions information.

RBDIFFME- Invoice Verification: quantity differences

It is a standard SAP Table which is used to store Batch Invoice Verification – Quantity Differences information.

RBDRSEG- Invoice Verification batch: invoice document items

It is a standard SAP Table which is used to store Batch Invoice Verification: Invoice Document Items information.

RBKP- Document header: incoming invoice

It is a standard SAP Table used to store Document Header: Invoice Receipt information.

RBTX- Taxes: incoming invoice

It is an SAP Table used to store Taxes: Incoming Invoice information.

RBVD- Invoice document: summarization data

It is a standard SAP Table which is used to store Invoice Document – Aggregation Data information.

RBVDMAT- Invoice Verification: summarization data, material

RKWA- Consignment withdrawals

It is a standard SAP Table used to store Consignment Withdrawals information.

RSEG- Document item, incoming invoice

It is a standard SAP Table which is used to store Document Item: Incoming Invoice information.

Preface – This post is part of the SAP MM series.

Important T-codes in MM

In this section we will discuss all the SAP MM Tcodes. These transactional codes are sub divided into groups for your better understanding. Feel free to ask the Tcodes which we have missed in the comment section.

Material Master Tcodes

Create material master : MM01

Change material master : MM02

Display material master : MM03

Material master list : MM60

Display Material document : MB03

Vendor Master Tcodes

Create vendor master : XK01

Change vendor master : XK02

Display vendor master : XK03

Source list Tcodes

Maintain source list : ME01

Display source list : ME03

Change source list : ME04

Purchase Requisition Tcodes

Create Purchase Requisition : ME51N

Change Purchase Requisition : ME52N

Display Purchase Requisition : ME53N

Release Purchase Requisition : ME54

Collective release of Purchase Requisition : ME55

Assign source of supply to requisitions : ME56

Request for Quotation Tcodes

Create Request for quotation :  ME41

Change Request for quotation : ME42

Display Request for quotation : ME43

Purchase Order Tcodes

Create Purchase Order : ME21N

Change Purchase Order : ME22N

Display Purchase Order : ME23N

Release Purchase Order : ME29N

Reservation Tcodes

Create Reservation : MB21

Change Reservation : MB22

Display Reservation : MB23

Reservation by Material : MB24

Reservation by Account Assignment : MB25

Goods Receipt Tcodes

Create Goods Receipt : MIGO

Cancellation/display Goods Receipt : MIGO

Physical Inventory Document Tcodes

Create Physical Inventory Document : MI01

Change Physical Inventory Document : MI02

Display Physical Inventory Document : MI03

Enter Inventory Count : MI04

Change Inventory Count : MI05

Display Inventory Count : MI06

Post Inventory Difference : MI07

List of Inventory Difference : MI20

Invoice Verification Tcodes

Display Of Invoice Document : MIR5

List Of GR/IR Balance : MB5S

MM configuration Tcodes

Create Company : OX15

Create Company Code : OX02

Create Plant : OX10

Create Storage Location : OX09

Create Purchasing Organization : OX08

Create Purchasing Group : OME4

Assign Plant to Company Code : OX18

Assign Purchasing Organization to Company Code : OX01

Assign Purchasing Organization to Plant : OX17

Assign output device to Purchasing Group : OMGF

Assign tax indicator to Plant : OMKN

Preface – This post is part of the SAP MM series.

Introduction

In the SAP ERP, SAP MM Organizational Structure is used to represent the legal and organizational structure of the company. The organizational structures form a framework according to which the whole business runs.

The organizational structure in Material management consists of the following levels:

• Client
• Company Code
• Plant
• Storage location
• Purchasing Organization
• Purchasing Group

The following diagram represents the organizational structure of SAP MM:

Let’s discuss them briefly.

Client

A client is a group or combination of legal, organizational, business and/or administrative units with a common purpose. It is the highest hierarchy of the organizational structure in SAP.

Company code

A company code represents an independent unit within a client. This organizational unit is created in finance and the same is linked with the Materials Management module. Each company code maintains its own balance sheet and its own profit and loss statement.

Plant

A plant is an operational unit in a company code. In SAP, the plant is a broad term depending on the functionality.  As in Material management, it is referred to as a facility where materials are stored, and inventory is maintained. Whereas in the Production planning module, it is referred to as a facility where materials are produced.

Storage location

A storage location is an organizational unit where stocks are kept physically, and inventory is maintained. A plant can consist of multiple storage location which differentiates between different materials are stocked in a plant.

Purchasing Organization

A purchasing organization is an organizational unit responsible for procuring materials/services for one or more plants. It is responsible for negotiating general conditions of purchase with vendors and holds legal responsibility for all external purchase transactions.

Purchasing organizations can be centralized or decentralized. In centralized, a single purchasing organization is assigned to one or more plant whereas in decentralized, different purchasing organization is assigned to a different plant.

Purchasing group

A purchasing group is an organizational unit responsible for day-to-day procurement activities in an organization. It may be an individual or group of individuals responsible for carrying out procurement activities.

Preface – This post is part of the SAP MM series.

Introduction

Procurement starts with requirement gathering and ends with procuring goods/services from vendors. This involves an internal document that contains a list of requirements, be it goods or services, which need to be procured from the vendors, known as Purchase requisition. It is a request made to the purchasing department to procure a certain list of materials. It contains information about the materials such as the date of delivery, and quantity.

A purchase requisition is defined for the following procurement types:

• Standard: Requisition created for getting finished material from the vendor.
• Subcontracting: Requisition created for providing raw material to the vendor and getting finished material.
• Consignment: Requisition created for procuring material that is kept in the company’s premises and paying to the vendor for that.
• Stock transfer: Requisition created for transferring stocks from one plant to another.
• External service: Requisition created for procuring services like maintenance from third-party vendor.

Creation of Purchase requisition

A purchase requisition can be created manually (with or without master data) or automatically. Let’s explore them one by one.

Manual creation of Purchase requisition

A purchase requisition can be created manually means when the purchasing document is created by the requesting department manually.

A purchase requisition can be created manually in multiple ways:

Purchase requisition with master data:

Step 1: Enter T-code ME51N in common field. A “Create purchase Requisition” screen will appear.

Step 2: It will ask to enter the following information:

• The material number of item or service (e.g. B-R123)
• Quantity to be procured (e.g. 20)
• Delivery date of the material (e.g. today’s date + 3)
• Plant location (e.g. 1203)

Step 3: On hitting enter, the data of the material is fetched from the material master data and the requisition process will fill up the default information in some of the blank fields.

After clicking on “Save”, a new purchase requisition will be created.

Purchase requisition without master data:

Step 1: In order to do that, enter T-code ME51N in common field. A “Create purchase Requisition” screen will appear.

Step 2: As there is no material master record for the material the following information will have to be entered:

• Account assignment category (e.g. U)
• Short text for description (e.g. Laptop Dell with an i5 processor)
• Quantity to be Supplied (e.g., 4)
• Unit of measure (e.g. PC)
• Delivery date of the material (e.g. today’s date + 4)
• Material group (e.g. Testing)
• Plant location (e.g. SAP SE)
• Purchasing group (e.g. 011)

In this scenario, the account assignment category is required to direct the cost to a specific account. Use ‘U’ to direct the purchase requisition to an unknown account. Other options available are:

• A for Asset and sub number
• F for production order number
• K for cost center and general ledger account number
• C for sales order and general ledger account number
• P for project number and general ledger account number

 

 

After clicking on “Save”, a new purchase requisition will be created.

Automatic creation of Purchase requisition:

A purchase requisition can be created automatically means when the purchasing document is created by other SAP processes that include:

• Production Order: A production order defines what materials need to be produced, the quantity of goods to be required, where it needs to be produced and at what time.

On creation of Purchase order in PP, BoM (Bill of Materials) is determined and a purchase requisition is created for materials required through MM.

• Plan Maintenance Order: A maintenance order consists of a list of operations that specifies what needs to be done and the material needed for each step. There may be a need for non-stock material. So, a purchase requisition is created automatically.
• Project System: In the Project system of Sap, a network is an object that creates a purchase requisition for non-stock materials.
• Material Planning: The consumption-based planning module can create a purchase requisition for materials based on calculation.

Preface – This post is part of the SAP MM series.

Introduction

Under Inventory Management in SAP MM, Procurement starts with requirement gathering and ends with procuring goods/services from vendors.

Once the goods/services are procured from the vendor, it is required to place them at the company’s premises. Inventory management deals with the management of the stock and goods movement, either on value or quantity basis. It includes planning and keeping records of all the goods movement.

There are several transactions and functions in inventory management. The most important of them are:

1. Movement Types
2. Goods Receipt
3. Reservation
4. Goods Issue

Let’s explore them one by one.

Movement Types

When goods movement is entered into the system, a movement type is defined to differentiate between the various goods movement. It is a 3-digit identification number for goods movement.

When a goods movement is entered into the system, following chain of events starts in the system:

• A material document is generated, that updates all the stock quantity and value in the inventory.
• Accounting documents are generated if the movement is relevant to Financial accounting.
• The stock quantities are updated.
• The stock values in the master record are updated.

All the updates are based on the information contained in the material document and the financial account document.

The important movement types are:

• 101: Goods receipt(GR) for purchase order(PO) into warehouse/stores
• 102: Goods receipt(GR) for purchase order(PO) into warehouse – reversal
• 201: Consumption for cost center from warehouse

To know more movement types, enter T-code MIGO in common field. A new screen will appear.

Select “Goods receipt” from the drop-down. On pressing F4 on the goods receipt input box, a list of movement types will appear. Depending upon the requirement, select the appropriate movement types for different goods movement.

Goods Receipt

After receiving the material from the vendor, the purchasing department prepares a goods receipt that can be used later for any discrepancy. A goods receipt is a goods movement that is used to post goods received from the external vendors or from in-plant production which results in an increase in stock in the warehouse.

Goods receipt has 2 scenarios:

• Creation Goods receipt
• Cancellation of Goods receipt

To create a Goods receipt

Step 1: Enter T-code MIGO in common field. A new screen will appear.

A Goods receipt can be posted against various documents. Select the required document from the drop-down list. Select the movement type as per the requirement.

Step 2: Enter reference document. Based on the reference document, it will fetch all the details such as material, quantity, storage location, plant, etc.

Step 3: Select the check tab and click on Save.

After click on “Save”, goods receipt is posted against the selected document and a material document number is generated.

To cancel a Goods receipt

Step 1: Enter T-code MIGO in common field. A new screen will appear.

Select “Cancellation” against the material document from the drop-down list. Enter the material document number.

Step 2: The system will fetch all the details from the material document number.

Step 3: Select the check tab and click on “Save”.

After clicking on “Save”, the goods receipt is cancelled, and a material document number is generated.

Reservation

Reservations are made to block the materials in advance so that that they can be available at some particular time. It ensures the availability of the stock at a particular point of time.

T-code to view the reserved quantity is MMBE.

To make a reservation

Step 1: Enter T-code MB21 in common field. A “Create Reservation” screen will appear.

Enter the date, the movement type and the plant for which the reservation has to be made.  Click on the “New Items” button.

Step 2: Enter the order number against the reservation has to be made. Provide details of the materials and the quantity that has to be reserved.

After clicking on “Save”, a reservation has been made for the order.

Goods Issue

To post Goods Issue

 Step 1: Enter T-code MIGO in common field. A new screen will appear.

Select Goods Issue from the drop-down list. A Goods Issue can be posted against various documents. Select the required document from the drop-down list. Select the movement type as per the requirement.

Step 2: Enter reference document. Based on the reference document, it will fetch all the details such as     material, quantity, storage location, plant, etc.

Step 3: Select the check tab and click on Save.

After click on “Save”, Goods Issue is posted against the selected document and a material document number is generated.

Preface – This post is part of the SAP MM series.

Introduction

Before we discuss about Master Data in SAP MM, let us discuss about type of Data in SAP.

SAP R/3 works on real-time data i.e. it makes sure that there is no time lag between data availability and data storage.

Data stored in SAP R/3 is categorized as:

• Master data: Data that is created centrally and is the core used as base data for any transaction is called Master Data in SAP. For example, Material and Vendor are types of master data.
• Transactional data: Data that is related to business transactional processes.

Types of Master Data

1. Material Master data
2. Vendor Master data

Material Master Data

Materials in SAP are a logistic representation of certain goods/services that is an object of production, sales, inventory management, etc. Material master data is the central source of information of the material that an enterprise can procure, produce or sell.

Characteristics of material master data are:

• Material types: Materials having some basic common attributes are grouped together and are assigned a material type. Most common material types are:

 

M Type	Material type description
FERT	Finished Product
HALB	Semi-finished Product
ROH	Raw material

 

• Material group: A material group is a wider term for a material type. Materials with some common attributes are grouped together and are assigned a material group. Let’s take an example of a finished product (material type), TV. Then the material group can be used to categorize them as Plasma TV, color TV etc.
• Number Range: When a material master record is created, a unique number is assigned to the material, known as material number.
  The following are the two ways to assign material number.
• External number assignment: When material number is assigned manually while creating a material.
• Internal number assignment: The system automatically assigns the material number while creating a material.

Internal number assignment is known as Number range.

Steps to create Material Master Data

Step 1: Enter T-code MM01 in common field. A “Create Material” screen will appear.

Enter all the information such as Material number, Material type, Industry sector, etc.

Step 2: Select the views to maintain the material.

Step 3: Enter plant name and storage location for the material.

Step 4: Provide the necessary details such as moving price, standard price, unit of measure, etc.

Click on “Save” and new material is created.

To change or display material master data, use T-code MM02 and MM03 respectively.

Vendor Master Data

A vendor is the one who provides goods/ services to a company. Vendor master data is the central source of information of the vendors from an enterprise can procure. It contains information such as name, address, the currency for the transaction, payment terms, Tax details, etc.

Data in a vendor master record is categorized into:

• General Data − It is maintained at the client level and is valid at all organizational levels.
• Accounting Data − It is maintained at the company level and is valid for all plants belonging to that company.
• Purchasing Data − It is maintained at the purchasing organization level.

Characteristics of vendor master data are:

• Account group: Vendors having some common attributes are grouped together and are assigned an account group.
• Number range: When a vendor master record is created, a unique number is assigned to the vendor, known as vendor number. A vendor number is assigned to a vendor as in the case of the material number i.e. external number assignment and internal number assignment.

Steps to create Vendor Master Data

Step 1: Enter T-code XK01 in common field. A “Create Vendor” screen will appear.

Enter all the information such as Vendor number, Company Code, Purchase Organization, Account Group, etc.

Step 2: Provide address details of the vendor.

Step 3: provide bank details, accounting information, terms of payment between the company and the vendor. Click on “Save” and a new vendor is created.

To change or display vendor master data, use T-code XK02 and XK03 respectively.