SAP BOM tables

SAP BOM Tables for BOM Header, Items and components and Category

SAP BOM Tables details how SAP BOM ( Bill Of Material ) are stored in database. It helps undestanding how to retrieve BOM Data or check Bill of Material Data.
The article about bom table in sap will start with the important SAP BOM Tables then a short help how to retrieve SAP BOM Data.

SAP BOM Tables

The main SAP Tables for BOM ( Bill Of Material ) are:

SAP BOM Tables Description
STKO  BOM Header
STPO  BOM item
STAS  BOMs – Item Selection
MAST  Material to BOM Link
MARC  Plant Data for Material
MARA  General Material Data
MAKT  Material Descriptions
CABN  Characteristic
USR21  Assign user name address key
ADRP  Persons (Business Address Services)

SAP BOM Retrieve Data

This part will help you through data extraction for SAP Material and SAP BOM.

Retrieve SAP Material Data

As you already know, the main table for material are MARA, MARC and MAKT.

Check also   How to link STKO and STPO for BOM in SAP

Find the full list for SAP Material Master Tables.

Here how to extract some Material important fields to prepare BOM Data

BOM Keys SAP BOM Join condition
Material Number  MARA-MATNR
Material Type MARA-MTART
Plant MARC-WERKS  where MARC-MATNR = MARA-MATNR

SAP BOM – Engineering

First, retrieve the BOM link from SAP Table MAST. The MAST table stores the Material to BOM Link.
Some of keys fields for Material BOM Link are:

MAST Keys Description
MATNR  Material Number
WERKS  Plant
STLAN  BOM Usage
STLNR  Bill of material

SAP BOM Usage

BOM Usage defines in which process the Material is linked to the BOM.
In order to get all value of STLAN ( BOM usage ), go to SAP Table T146 .

So the BOM usage can be :

1 Production
2 Engineering/design
3 Universal
4 Plant maintenance
5 Sales and distribution
6 Costing
7 Empties
R Rework (copy of production)

SAP BOM Header

Once the Material Link to BOM is retrieved, the field MAST-STLNR will have the BOM number and the Alternative BOM is on MAST-STLAL.

  • STKO-STLNR = MAST-STLNR
  • STKO-STLAL = MAST-STLAL

To Read BOM Header, select on table STKO
The main fields for BOM keys are:

SAP BOM Header Description
STLTY  BOM category
STLNR  Bill of material
STLAL  Alternative BOM
STKOZ  Internal counter

SAP BOM Category

Functionnality, there is no better than help.sap.com to get the definition of BOM Categories.

Technically, the BOM Category is set on Fixed value of STLTY domain in the SAP DDIC.

BOM Category can be :

BOM Category Description
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM

In order to Link BOM with different Objects depending on SAP BOM Categories

SAP BOM Tables: BOM Categories Links

SAP BOM Items

Read BOM items details for STPO. Join on 

STKO-STLNR = STPO-STLNR

here a list of some important fields for BOM items

BOM Items keys Description
STLTY BOM category
STLNR  Bill of material
STLKN BOM item node number
STPOZ Internal counter
DATUV Valid-From Date
ANDDAT Valid-to Date
TECHV Technical status from
LKENZ BOM Item Deletion Indicator
IDNRK BOM component
PSWRK Issuing plant
POSTP  Item Category (Bill of Material)
POSNR BOM Item Number
MEINS  Component unit of measure
MENGE  Component quantity

SAP BOM Items Categories

A BOM Items Category can be ( STPO-POSTP )

BOM Item Category Description
C Compatible Unit
D Document item
I PM structure element
K Class item
L Stock item
M Intra material
N Non-stock item
R Variable-size item
T Text item

All Values are in the SAP reference table T418. 

SAP BOM Texts Tables

In order to read BOM, consider the SAP Table STZU

Retrieve data with keys  STLTY BOM category and STLNR Bill of material, the SAP BOM Text is set on

STZU-ZTEXT  BOM text
STZU-LTXSP  for language of text

Here it is the main SAP BOM Tables covering the data model of BOM ( Bill-of-materials ) and the BOM tables for BOM’s header, BOM Items, BOM Category and BOM text.

Leave a Reply

Your email address will not be published. Required fields are marked *