Material Management MM and Purchasing PUR tables and their functionality

SAP Tech Pro

SAP Technical Blog
Magzter [CPS] IN

Material Management MM and Purchasing PUR tables and their functionality

Material Management MM and Purchasing PUR tables and their functionality




Material Descriptions


Sales View


General Data


Plant Data


Storace Loc./Bin Data


Controlling Data


Valuation Data


Master Status


Material Documents


Header Details


Item Details


BOM Related tables


Controlling Data


Valuation Data


Master Status


Storage Number Data


Storage Type Data


Change Revision


Change Master


Product Group/Member Allocation


BOM Item


BOM Sub-Item


BOM Header


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.


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.


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


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


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