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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
VARST | Indicator: variants | VARST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
KBAUS | Indicator: configurable BOM | KBAUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
HISSR | Indicator: BOM with history (technical status) | HISSR | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |