SAP STZU Permanent BOM data Table data and field list

STZU is a standard SAP Table which is used to store Permanent BOM data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The STZU table consists of various fields, each holding specific information or linking keys about Permanent BOM data data available in SAP. These include STLTY (BOM category), STLNR (Bill of material), STLAN (BOM Usage), EXSTL (BOM group)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

STZU table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP STZU table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the STZU table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
STLTYBOM category STLTYCHAR1STLTY
STLNRBill of material STNUMCHAR8NUMCVSTNUMSTLNR
STLANBOM Usage STLANCHAR1T416STLANCSV
EXSTLBOM group EXSTLCHAR18EXSTLCSG
ALTSTIndicator: Alternatives ALTSTCHAR1XFELD
VARSTIndicator: variants VARSTCHAR1XFELD
KBAUSIndicator: configurable BOM KBAUSCHAR1XFELD
LTXSPLong Text Language, for Creation of a Change Document LTXSP_CPLANG1T002ISOLASPRAS
STLBEAuthorization group for bills of material STLBECHAR4BEGRU
ZTEXTBOM text CSTEXTCHAR40TEXT40
WRKANPlant where BOM or alternative/variant created WRKANCHAR4T001WWERKS
HISDTIndicator: BOM with history (date) HISDTCHAR1XFELD
HISSRIndicator: BOM with history (technical status) HISSRCHAR1XFELD
HISTKIndicator: BOM was changed with history HISTKCHAR1CHAR1
STUEZMaximum number of counters in a BOM STUEZNUMC8CIM_COUNT
MAXKNMaximum number of nodes within a BOM MAXKNNUMC8KNTNR
KZPLNIndicator: BOM can only be changed from the routing KZPLNCHAR1CHAR01
AENRLLast change number AENRLCHAR12Assigned to domainAENNRAENNR
CLSMXMaximum classification number CS_CLSMXNUMC8NUM8
STLDTDate on which the BOM was last changed STLDTDATS8DATUM
STLTMTime when BOM was last changed CS_STLTMTIMS6UZEIT
MAXKANMaximum edge MAXKANNUMC6STKAN
TSTMPTime stamp: BOM change relevant to explosion CS_TSTAMPDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table STZU using ABAP code

The following ABAP code Example will allow you to do a basic selection on STZU to SELECT all data from the table
DATA: WA_STZU TYPE STZU.

SELECT SINGLE *
FROM STZU
INTO CORRESPONDING FIELDS OF WA_STZU
WHERE...

How to access SAP table STZU

Within an ECC or HANA version of SAP you can also view further information about STZU and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to STZU

    STKO - BOM Header
        DOST - Assign document to bill of material
    STPO - Bill of material item
        STPU - BOM Subitem
        STPN - Bill of material--- successor control
        EQST - Assign equipment to bill of material
        KDST - Assign sales order to bill of material
        MAST - Assign material to bill of material
        STST - Assign standard bill of materials
        TPST - Assign functional location bill of materials
        PRST - Project-BOM Assignment
        STZU - Central bill of materials data
        STAS - Assign position to alternative