SAP Table STZU

Permanent BOM data

STZU (Permanent BOM data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link STZU to other SAP tables.

STZU table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLNR Bill of material STNUM CHAR 8 0
STLAN BOM Usage STLAN T416 CHAR 1 0
EXSTL BOM group EXSTL CHAR 18 0
ALTST Indicator: Alternatives ALTST CHAR 1 0
X Yes
NULL No
VARST Indicator: variants VARST CHAR 1 0
X Yes
NULL No
KBAUS Indicator: configurable BOM KBAUS CHAR 1 0
X Yes
NULL No
LTXSP Long Text Language, for Creation of a Change Document LTXSP_CP T002 LANG 1 0
STLBE Authorization group for bills of material STLBE CHAR 4 0
ZTEXT BOM text CSTEXT CHAR 40 0
WRKAN Plant where BOM or alternative/variant created WRKAN T001W CHAR 4 0
HISDT Indicator: BOM with history (date) HISDT CHAR 1 0
X Yes
NULL No
HISSR Indicator: BOM with history (technical status) HISSR CHAR 1 0
X Yes
NULL No
HISTK Indicator: BOM was changed with history HISTK CHAR 1 0
STUEZ Maximum number of counters in a BOM STUEZ NUMC 8 0
MAXKN Maximum number of nodes within a BOM MAXKN NUMC 8 0
KZPLN Indicator: BOM can only be changed from the routing KZPLN CHAR 1 0
AENRL Last change number AENRL CHAR 12 0
CLSMX Maximum classification number CS_CLSMX NUMC 8 0
STLDT Date on which the BOM was last changed STLDT DATS 8 0
STLTM Time when BOM was last changed CS_STLTM TIMS 6 0
MAXKAN Maximum edge MAXKAN NUMC 6 0
TSTMP Time stamp: BOM change relevant to explosion CS_TSTAMP DEC 15 0

STZU foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
STZU LTXSP STZU LTXSP T002 Language Keys (Component BC-I18) SPRAS
STZU MANDT STZU MANDT T000 Clients MANDT
STZU STLAN STZU MANDT T416 BOM Usage - Item Statuses MANDT
STZU STLAN STZU STLAN T416 BOM Usage - Item Statuses STLAN
STZU WRKAN STZU MANDT T001W Plants/Branches MANDT
STZU WRKAN STZU WRKAN T001W Plants/Branches WERKS