SAP BOM Tables details how SAP BOM ( Bill Of Material ) are stored in database.
It helps understanding 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.
What BOM ?
A bill of materials or product structure (sometimes bill of material, BOM or associated list) is a list of the raw materials, sub-assemblies, intermediate assemblies, sub-components, parts and the quantities of each needed to manufacture an end product. (source: wiki )
SAP BOM Tables
Let’s start by the Most important SAP BOM Related 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.
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, Start by retrieving 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 .
T146: SAP BOM Usage Table
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
STKO SAP BOM Header Table
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
Functionality, 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.
List of SAP Bill-of-Material Category List
SAP 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
| Related BOM Tables | Link with BOM |
|---|---|
| MAST | link BOM – Material |
| KDST | link BOM – Order |
| EQST | link BOM – Equipment |
| PRST | link BOM – WBS |
| STST | link BOM – Standard |
| DOST | link BOM – Document |
| TPST | link BOM – Functional Location |
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
Check the SAP Table STZU in order to read BOM.
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.
