SAP BOM Tables details how SAP BOMs (Bill Of Material) are stored in SAP’s database.
It helps in understanding how to retrieve BOM Data or check the Bill of Material Data.
The article about the BOM table in sap will start with the important SAP BOM Tables then a short help on how to retrieve SAP BOM Data.
Table of Contents
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)
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) |
This part will help you through data extraction for SAP Material and SAP BOM.
As you already know, the main tables for SAP 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 |
First, start by retrieving the BOM link from SAP Table MAST. The MAST table stores the Material to BOM Link.
Some keys field for Material BOM Link are:
MAST KEYS | DESCRIPTION |
---|---|
MATNR | Material Number |
WERKS | Plant |
STLAN | BOM Usage |
STLNR | Bill of Material |
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.
The BOM usage in SAP can have the following value :
1 | PRODUCTION |
---|---|
2 | Engineering/design |
3 | Universal |
4 | Plant maintenance |
5 | Sales and distribution |
6 | Costing |
7 | Empties |
R | Rework (copy of production) |
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.
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 |
Functionality, there is no better than help.sap.com to get the definition of BOM Categories.
Technically, the BOM Category is set on the fixed value of the STLTY domain in the SAP DDIC.
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 |
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 |
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 |
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.
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.
SAP ISU Tables for Technical master data, for Billing Master Data, Billing and invoicing Tables?…
SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd…
Dunning is the business practice of informing a customer of past due payment. Dunning letters…
SAP AP Tcodes & SAP AR Tcodes: House Banks Tcodes, Advance Payments or Down Payments,…
What are the main SAP Payment Terms Tables ? What are the related Tables in…
Work center consists of master data related to routing of products. It contains data related…