SAP Tech Pro

SAP Technical Blog
Topprice Price Comparison

Material Management MM and Purchasing PUR tables and their functionality

Material Management MM and Purchasing PUR tables and their functionality

 

Materials

MAKT

Material Descriptions

MVKE

Sales View

MARA

General Data

MARC

Plant Data

MARD

Storace Loc./Bin Data

MCON

Controlling Data

MBEW

Valuation Data

MSTA

Master Status

 

Material Documents

MKPF

Header Details

MSEG

Item Details

 

BOM Related tables

MCON

Controlling Data

MBEW

Valuation Data

MSTA

Master Status

MLGN

Storage Number Data

MLGT

Storage Type Data

AEOI

Change Revision

AENR

Change Master

PGMI

Product Group/Member Allocation

STPO

BOM Item

STPU

BOM Sub-Item

STKO

BOM Header

MAST

Material to BOM Link

 

Bill of Material (BOM)

A bill of material is a recipe for an assembly, such as a keyboard. The components are the pieces used to make the keyboard such as the keys and board inside. Because the board inside is made up of several pieces such as relays and diodes, the board is referred to as a sub-assembly. As a keyboard changes due to design alterations, component scarcity or other factors, the recipe changes and it is important to track these changes.

This is BOM history and is important because as engineering decides to make an immediate change to the engineering BOM, practical limitations such as a component stockpiles, keep manufacturing from implementing those changes immediately to the manufacturing or production BOM. The changes are identified with change numbers that are each tied directly to one validity date. Identifying components and sub-assemblies on a BOM with a change number that indicates when that component became valid on that BOM allows users to track the development of a BOM.

BOM information is stored in several tables.

MAST

The flow starts with table MAST which identifies the BOMs tied to a given material based on plant and usage. This table yields a BOM number, uniquely identifying the BOM structure.

STKO

Header level data such as BOM creation date is stored in STKO.

STPO

The components for the BOM are stored in STPO along with BOM change history information such as ECOs and validity dates.

STPU

Further detail on components resides in STPU.

This logical path can be accessed in three ways:

1. the user can access the tables one by one

2. the use of logical database CMC

3. the use of function module CS_BOM_EXPL_MAT_V2

The following are other noteworthy materials tables:

MKPF Material Document Header Table

MKPF is the material document header table. This table can be used to filter material documents by date or type. It is important to note that the material document year on this table does not necessarily equate to the fiscal year in the financials tables (for example BKPF). The material document year is tied to the calendar year while the fiscal year is tied to the fiscal calendar. Because of the large number of material movements in the system, it is recommended that a separate index be created on this table for reporting. Some possible indexes may include posting date, document type or user name.

MSEG Material Document Line Item Table

MSEG is the material document line item table. This table can grow to be very large as it contains one record for every line item on a material document. MSEG can be tied to the FI tables through the Object Type and Object Key in BKPF (FI Document Header). For records with the object type = MKPF, field BKPF-AWTYP, the Object key will be a concatenation of the MM document number and calendar year.

EKKO Purchase Order Header Table

EKKO is the purchase order header table. When selecting from this table, it is important to note that deleted purchase orders will not be removed from this table. Purchase orders that are deleted can be identified by the deletion indicator (EKKO-LOEKZ).

EKPO Purchase Order Line Item Table

EKPO is the purchase order line item table. It contains an entry of each material on a given purchase order. Deleted purchase order lines are identified by the deletion indicator (EKPO-LOEKZ). When reporting from this table, units of measure conversion must be taken into account. If a material has a different purchasing or pricing unit from the base unit, the correct conversion values can be found in the QTY conversion fields.

Add comment

Before Buying, Compare Prices at Topprice.in

Topprice.in