SAP4TECH

SAP and ABAP Free Tutorials
Menu
  • SAP Technical
    • ABAP Code Snippets
    • ABAP WebDynPro
    • SAP GW
    • SAP IDOC (ALE)
    • SAP PI (XI)
    • SAP Screen Personas
    • SAP Workflow
  • SAP Functional
    • SAP FI
    • SAP FSCM
    • SAP HR
    • SAP SD & SAP MM
    • SAP PM
    • SAP PP
    • SAP PS
    • SAP QM
    • SAP VIM
    • SAP WM
  • SAP Fiori
  • SAP HANA
  • SAP BW
  • SAP CRM
  • SAP SRM
  • SAP4TECH
    • About Us
    • Contact Us
    • Terms & Conditions
    • Privacy and Cookie Policy

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

SAP PP

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

January 27, 2016 John

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

  • What BOM ?
  • SAP BOM Tables
  • SAP BOM Retrieve Data
    • Retrieve SAP Material Data
    • SAP BOM – Engineering
    • SAP BOM Usage
    • SAP BOM Header
    • SAP BOM Items
    • SAP BOM Texts Tables

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 TABLESDESCRIPTION
STKOBOM Header
STPOBOM item
STASBOMs – Item Selection
MASTMaterial to BOM Link
MARCPlant Data for Material
MARAGeneral Material Data
MAKTMaterial Descriptions
CABNCharacteristic
USR21Assign user name address key
ADRPPersons (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 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 KEYSSAP BOM JOIN CONDITION
Material NumberMARA-MATNR
Material TypeMARA-MTART
PlantMARC-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 keys field for Material BOM Link are:

MAST KEYSDESCRIPTION
MATNRMaterial Number
WERKSPlant
STLANBOM Usage
STLNRBill 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

The BOM usage in SAP can have the following value :

1PRODUCTION
2Engineering/design
3Universal
4Plant maintenance
5Sales and distribution
6Costing
7Empties
RRework (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 HEADERDESCRIPTION
STLTYBOM category
STLNRBill of material
STLALAlternative BOM
STKOZInternal 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 the fixed value of the STLTY domain in the SAP DDIC.

List of SAP Bill-of-Material Category List

SAP BOM Category can be :

BOM CATEGORYDESCRIPTION
DDocument Structure
EEquipment BOM
KOrder BOM
MMaterial BOM
SStandard BOM
TFunctional Location BOM
PWork Breakdown Structure BOM

To Link BOM with different Objects depending on SAP BOM Categories

RELATED BOM TABLESLINK WITH BOM
MASTlink BOM – Material
KDSTlink BOM – Order
EQSTlink BOM – Equipment
PRSTlink BOM – WBS
STSTlink BOM – Standard
DOSTlink BOM – Document
TPSTlink BOM – Functional Location
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 KEYSDESCRIPTION
STLTYBOM category
STLNRBill of material
STLKNBOM item node number
STPOZInternal counter
DATUVValid-From Date
ANDDATValid-to Date
TECHVTechnical status from
LKENZBOM Item Deletion Indicator
IDNRKBOM component
PSWRKIssuing plant
POSTPItem Category (Bill of Material)
POSNRBOM Item Number
MEINSComponent unit of measure
MENGEComponent quantity

SAP BOM Items Categories

A BOM Items Category can be (STPO-POSTP)

BOM ITEM CATEGORYDESCRIPTION
CCompatible Unit
DDocument item
IPM structure element
KClass item
LStock item
MIntra-material
NNon-stock item
RVariable-size item
TText 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-ZTEXTBOM TEXT
STZU-LTXSPfor 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.

Prev Article
Next Article
Tags:BOM Material SAP Tables

Related Articles

SAP PP Tcodes e1478774325601
SAP MC94 Tcode SAP MC94 Tcode (Change Flexible LIS Planning) …

SAP MC94 Tcode – Change Flexible LIS Planning

SAP Process Order
SAP Process Order IDoc in detail is the main topic …

SAP Process Order IDoc LOIPRO – Structure, User-Exit and Outbound Processing

Search on SAP4TECH

The Most Populars

  • The Most Important SAP ISU Tables
    The Most Important SAP ISU Tables
  • SAP Users Tables
    SAP Users Tables (for Personal, Logon, and Address Data)
  • List of SAP Purchase Order Tables in SAP MM SAP PO Tables
    SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • Full list of SAP Movement Types
    SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP GL Account Tcodes SAP GL Account Tables
    The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables
    SAP BOM Tables for BOM Header, Items and components and Category

Related Posts

  • SAP Batch Management 1
    SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)
  • SAP Production Order Tables e1459012874669
    SAP Production Order Tables and Join Between PO Tables (AUFK, AFVC, AFFL, AFRU…)
  • calendar 1231038 1280 e1458046112993
    How to Link Between PLKO and PLPO for Routine in SAP
  • SAP PP Tcodes e1478774325601
    SAP MC94 Tcode – Change Flexible LIS Planning
  • SAP Process Order
    Get SAP Process Order Status

SAP4TECH

SAP and ABAP Free Tutorials

Trending Posts

  • The Most Important SAP ISU Tables
  • SAP Users Tables (for Personal, Logon, and Address Data)
  • SAP Purchase Order Tables: Main PO tables in SAP MM – SAP PO Tables
  • SAP Good Movement Types – Full list of SAP Movement Types
  • The Main SAP G/L Account Tcodes & SAP GL Account Tables
  • SAP BOM Tables for BOM Header, Items and components and Category

The Most Recents

  • The Most Important SAP ISU Tables
  • SAP Fiori 3 UX and Design of SAP Fiori Apps for SAP S/4HANA, SAP TechEd Lecture
  • The Main SAP Dunning Transaction Codes
  • SAP Accounts Payable Tcodes & Accounts Receivable Tcodes ( SAP AP Tcodes & SAP AR Tcodes)
  • The Most Important SAP Payment Terms Tables (ZTERM, Text…)

Search

SAP Tutorials by Topics

  • SAP Tables
  • SAP Tcodes
  • SAP BAPI
  • ABAP Snippets
  • Top SAP Courses
  • Top SAP Books
Copyright © 2021 SAP4TECH

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy