SAP Table STPO
BOM item
STPO (BOM item) 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 STPO to other SAP tables.
STPO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||
|
STLTY
BOM category
|
STLTY |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STLNR
Bill of material
|
STNUM |
CHAR
|
8 | 0 | ||||||||||||||||||
|
STLKN
BOM item node number
|
STLKN |
NUMC
|
8 | 0 | ||||||||||||||||||
|
STPOZ
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||||||||
|
DATUV
Valid-From Date
|
DATUV |
DATS
|
8 | 0 | ||||||||||||||||||
|
TECHV
Technical status from
|
TECHV |
CHAR
|
12 | 0 | ||||||||||||||||||
|
AENNR
Change Number
|
AENNR | AENR |
CHAR
|
12 | 0 | |||||||||||||||||
|
LKENZ
Deletion Indicator
|
LKENZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
VGKNT
Predecessor Node
|
VGKNT |
NUMC
|
8 | 0 | ||||||||||||||||||
|
VGPZL
Previous item counter
|
VGPZL |
NUMC
|
8 | 0 | ||||||||||||||||||
|
ANDAT
Date record created on
|
ANDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
ANNAM
User who created record
|
ANNAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
AEDAT
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
IDNRK
BOM component
|
IDNRK |
CHAR
|
18 | 0 | ||||||||||||||||||
|
PSWRK
Issuing plant
|
PSWRK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||
|
POSTP
Item Category (Bill of Material)
|
POSTP | T418 |
CHAR
|
1 | 0 | |||||||||||||||||
|
POSNR
BOM Item Number
|
SPOSN |
CHAR
|
4 | 0 | ||||||||||||||||||
|
SORTF
Sort String
|
SORTP |
CHAR
|
10 | 0 | ||||||||||||||||||
|
MEINS
Component unit of measure
|
KMPME | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
MENGE
Component quantity
|
KMPMG |
QUAN
|
13 | 3 | ||||||||||||||||||
|
FMENG
Fixed qty
|
FMNGE |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
AUSCH
Component scrap in percent
|
KAUSF |
DEC
|
5 | 2 | ||||||||||||||||||
|
AVOAU
Operation scrap
|
AVOAU |
DEC
|
5 | 2 | ||||||||||||||||||
|
NETAU
Indicator: Net scrap
|
NETAU |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SCHGT
Indicator: Bulk Material
|
SCHGT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
BEIKZ
Material Provision Indicator
|
BEIKZ | T417 |
CHAR
|
1 | 0 | |||||||||||||||||
|
ERSKZ
Indicator: spare part
|
ERSKZ | T413 |
CHAR
|
1 | 0 | |||||||||||||||||
|
RVREL
Indicator: item relevant to sales
|
RVREL | TVRL |
CHAR
|
1 | 0 | |||||||||||||||||
|
SANFE
Indicator: item relevant to production
|
SANFE |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SANIN
Indicator: item relevant to plant maintenance
|
SANIN |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SANKA
Indicator for relevancy to costing
|
CS_SANKA | TCK08 |
CHAR
|
1 | 0 | |||||||||||||||||
|
SANKO
Indicator: item relevant to engineering
|
SANKO |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
SANVS
Indicator: high-level configuration
|
SANVS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STKKZ
PM assembly indicator
|
STKKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
REKRI
Indicator: BOM is recursive
|
REKRI |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
REKRS
Indicator: recursiveness allowed
|
REKRS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
CADPO
CAD Indicator
|
CADPO |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
NFMAT
Follow-up material in BOM item - NOT IN USE
|
CS_NFMAT | MARA |
CHAR
|
18 | 0 | |||||||||||||||||
|
NLFZT
Lead-time offset
|
NLFZT |
DEC
|
3 | 0 | ||||||||||||||||||
|
VERTI
Distribution key for component consumption
|
SA_VERTI | T437V |
CHAR
|
4 | 0 | |||||||||||||||||
|
ALPOS
Indicator: alternative item
|
ALPOS |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
EWAHR
Usage probability in % (alternative item)
|
EWAHR |
DEC
|
3 | 0 | ||||||||||||||||||
|
EKGRP
Purchasing Group
|
EKGRP | T024 |
CHAR
|
3 | 0 | |||||||||||||||||
|
LIFZT
Delivery time in days
|
LIFZT |
DEC
|
3 | 0 | ||||||||||||||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||
|
PREIS
Price
|
CPREI |
CURR
|
11 | 2 | ||||||||||||||||||
|
PEINH
Price Unit
|
PEINH |
DEC
|
5 | 0 | ||||||||||||||||||
|
WAERS
Currency Key
|
WAERS | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||
|
SAKTO
Cost element
|
SAKTO |
CHAR
|
10 | 0 | ||||||||||||||||||
|
ROANZ
Number of variable-size items
|
ROANZ |
QUAN
|
13 | 3 | ||||||||||||||||||
|
ROMS1
Size 1
|
ROMS1 |
QUAN
|
13 | 3 | ||||||||||||||||||
|
ROMS2
Size 2
|
ROMS2 |
QUAN
|
13 | 3 | ||||||||||||||||||
|
ROMS3
Size 3
|
ROMS3 |
QUAN
|
13 | 3 | ||||||||||||||||||
|
ROMEI
Unit of measure for sizes 1 to 3
|
ROMEI | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
ROMEN
Quantity of variable-size item
|
ROMEN |
QUAN
|
13 | 3 | ||||||||||||||||||
|
RFORM
Formula key
|
RFORM | T418F |
CHAR
|
2 | 0 | |||||||||||||||||
|
UPSKZ
Indicator: sub-items exist
|
UPSKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
VALKZ
Indicator: item in more than one alternative
|
VALKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LTXSP
Long Text Language, for Creation of a Change Document
|
LTXSP_CP | T002 |
LANG
|
1 | 0 | |||||||||||||||||
|
POTX1
BOM Item Text (Line 1)
|
POTX1 |
CHAR
|
40 | 0 | ||||||||||||||||||
|
POTX2
BOM item text (line 2)
|
POTX2 |
CHAR
|
40 | 0 | ||||||||||||||||||
|
OBJTY
Object type (BOM item)
|
OBJTY |
CHAR
|
1 | 0 | ||||||||||||||||||
|
MATKL
Material Group
|
MATKL | T023 |
CHAR
|
9 | 0 | |||||||||||||||||
|
WEBAZ
Goods Receipt Processing Time in Days
|
WEBAZ |
DEC
|
3 | 0 | ||||||||||||||||||
|
DOKAR
Document Type
|
DOKAR | TDWA |
CHAR
|
3 | 0 | |||||||||||||||||
|
DOKNR
Document number
|
DOKNR |
CHAR
|
25 | 0 | ||||||||||||||||||
|
DOKVR
Document Version
|
DOKVR |
CHAR
|
2 | 0 | ||||||||||||||||||
|
DOKTL
Document Part
|
DOKTL_D |
CHAR
|
3 | 0 | ||||||||||||||||||
|
CSSTR
Average material purity in %
|
CSSTR |
DEC
|
5 | 2 | ||||||||||||||||||
|
CLASS
Class number
|
KLASSE_D |
CHAR
|
18 | 0 | ||||||||||||||||||
|
KLART
Class Type
|
KLASSENART | TCLA |
CHAR
|
3 | 0 | |||||||||||||||||
|
POTPR
Resulting item category
|
POTPR | T418 |
CHAR
|
1 | 0 | |||||||||||||||||
|
AWAKZ
Selection indicator for configurable BOMs
|
AWAKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
INSKZ
Instance indicator
|
INSKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
VCEKZ
Indicator: not displayed in configuration editor
|
VCEKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
VSTKZ
Indicator: not displayed in single-level configuration
|
VSTKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
VACKZ
Indicator: not displayed in automatic configuration
|
VACKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
EKORG
Purchasing Organization
|
EKORG | T024E |
CHAR
|
4 | 0 | |||||||||||||||||
|
CLOBK
Required Component
|
CLOBK |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
CLMUL
Multiple Selection Allowed
|
CLMULT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
CLALT
Alternative Display Format
|
CLALT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
CVIEW
Organizational Area
|
ABTEILUNG |
CHAR
|
10 | 0 | ||||||||||||||||||
|
KNOBJ
Number of Object with Assigned Dependencies
|
KNOBJ |
NUMC
|
18 | 0 | ||||||||||||||||||
|
LGORT
Issue location for production order
|
CSLGO | T001L |
CHAR
|
4 | 0 | |||||||||||||||||
|
KZKUP
Indicator: co-product
|
KZKUP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
INTRM
Intra Material
|
INTRM |
CHAR
|
18 | 0 | ||||||||||||||||||
|
TPEKZ
Indicator: restrictions exist
|
TPEKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STVKN
Inherited node number of BOM item
|
STVKN |
NUMC
|
8 | 0 | ||||||||||||||||||
|
DVDAT
Date of last date shift
|
DVDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
DVNAM
Name of the user who carried out the date shift
|
DVNAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
DSPST
Explosion type
|
CS_DISPO | T414 |
CHAR
|
2 | 0 | |||||||||||||||||
|
ALPST
Alternative item: strategy
|
CS_ALPST |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ALPRF
Alternative item: ranking order
|
CS_ALPRF |
NUMC
|
2 | 0 | ||||||||||||||||||
|
ALPGR
Alternative item: group
|
CS_ALPGR |
CHAR
|
2 | 0 | ||||||||||||||||||
|
KZNFP
Indicator: Follow-Up Item
|
CS_KZNFP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
NFGRP
Follow-up group
|
CS_NFGRP |
CHAR
|
2 | 0 | ||||||||||||||||||
|
NFEAG
Discontinuation group
|
CS_NFEAG |
CHAR
|
2 | 0 | ||||||||||||||||||
|
KNDVB
Indicator: manual change to sales order BOM
|
CS_KNDVB |
CHAR
|
1 | 0 | ||||||||||||||||||
|
KNDBZ
Indicator: BOM item changed/selected via obj. dependencies
|
CS_KNDBZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
KSTTY
BOM category of original sales order BOM item
|
CS_KSTTY |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
KSTNR
Bill of material for original sales order BOM item
|
CS_KSTNR |
CHAR
|
8 | 0 | ||||||||||||||||||
|
KSTKN
Node number of original sales order BOM item
|
CS_KSTKN |
NUMC
|
8 | 0 | ||||||||||||||||||
|
KSTPZ
Counter for original sales order BOM item
|
CS_KSTPZ |
NUMC
|
8 | 0 | ||||||||||||||||||
|
CLSZU
Classification number
|
CS_CLSZU |
NUMC
|
8 | 0 | ||||||||||||||||||
|
KZCLB
Indicator: classification as selection condition
|
CS_KZCLB |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
AEHLP
Date Shift Hierarchy Indicator
|
CC_AEHLP |
NUMC
|
2 | 0 | ||||||||||||||||||
|
PRVBE
Production Supply Area
|
PRVBE | PVBE |
CHAR
|
10 | 0 | |||||||||||||||||
|
NLFZV
Lead-time offset for operation
|
CS_NLFZV |
DEC
|
3 | 0 | ||||||||||||||||||
|
NLFMV
Unit for lead-time offset for operation
|
CS_NLFMV | T006 |
UNIT
|
3 | 0 | |||||||||||||||||
|
IDPOS
Item group
|
CS_IDPOS |
CHAR
|
20 | 0 | ||||||||||||||||||
|
IDHIS
History counter
|
CS_IDHIS |
NUMC
|
5 | 0 | ||||||||||||||||||
|
IDVAR
Component Variant
|
CS_IDVAR |
CHAR
|
5 | 0 | ||||||||||||||||||
|
ALEKZ
ALE indicator
|
CS_ALEKZ |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ITMID
External identification of an item
|
CS_ITMID |
CHAR
|
8 | 0 | ||||||||||||||||||
|
GUID
Temporarily not used
|
CS_CHAR22 |
CHAR
|
22 | 0 | ||||||||||||||||||
|
ITSOB
Special procurement type for BOM item
|
CS_SOBSL |
CHAR
|
2 | 0 | ||||||||||||||||||
|
RFPNT
Reference point for BOM transfer
|
CN_RFPNT | TCNRFP |
CHAR
|
20 | 0 | |||||||||||||||||
|
GUIDX
Global identification of an item's change status
|
CS_GUID |
RAW
|
16 | 0 | ||||||||||||||||||
|
YY_RDS_PP
Reference Designator (RDS-PP)
|
Y_RDS_PP |
CHAR
|
40 | 0 | ||||||||||||||||||
|
YY_PDMLINKID
PDMLink BOM Component ID
|
Y_PDMLINKID |
CHAR
|
36 | 0 | ||||||||||||||||||
|
YY_ITEM_COMMONID
BOMCommonID
|
Y_COMMONID |
CHAR
|
36 | 0 | ||||||||||||||||||
|
CUFACTOR
CU: Number of CU Instances
|
/CUM/CUFACTOR |
NUMC
|
6 | 0 | ||||||||||||||||||
|
FUNCID
Function Identifier
|
CCC_FUNCID |
CHAR
|
40 | 0 | ||||||||||||||||||
STPO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| STPO | AENNR | STPO | MANDT |
AENR
Change Master
|
MANDT |
| STPO | AENNR | STPO | AENNR |
AENR
Change Master
|
AENNR |
| STPO | BEIKZ | STPO | MANDT |
T417
Material Provision Indicators
|
MANDT |
| STPO | BEIKZ | STPO | BEIKZ |
T417
Material Provision Indicators
|
BEIKZ |
| STPO | DOKAR | STPO | MANDT |
TDWA
Document Types
|
MANDT |
| STPO | DOKAR | STPO | DOKAR |
TDWA
Document Types
|
DOKAR |
| STPO | DSPST | STPO | MANDT |
T414
Explosion Types
|
MANDT |
| STPO | DSPST | STPO | DSPST |
T414
Explosion Types
|
DISPO |
| STPO | EKGRP | STPO | MANDT |
T024
Purchasing Groups
|
MANDT |
| STPO | EKGRP | STPO | EKGRP |
T024
Purchasing Groups
|
EKGRP |
| STPO | EKORG | STPO | EKORG |
T024E
Purchasing Organizations
|
EKORG |
| STPO | EKORG | STPO | MANDT |
T024E
Purchasing Organizations
|
MANDT |
| STPO | ERSKZ | STPO | MANDT |
T413
Spare Part Indicators
|
MANDT |
| STPO | ERSKZ | STPO | ERSKZ |
T413
Spare Part Indicators
|
ERSKZ |
| STPO | KLART | STPO | MANDT |
TCLA
Class Types
|
MANDT |
| STPO | KLART | STPO | KLART |
TCLA
Class Types
|
KLART |
| STPO | LGORT | * |
T001L
Storage Locations
|
WERKS | |
| STPO | LGORT | STPO | LGORT |
T001L
Storage Locations
|
LGORT |
| STPO | LGORT | STPO | MANDT |
T001L
Storage Locations
|
MANDT |
| STPO | LIFNR | STPO | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| STPO | LIFNR | STPO | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| STPO | LTXSP | STPO | LTXSP |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| STPO | MANDT | STPO | MANDT |
T000
Clients
|
MANDT |
| STPO | MATKL | STPO | MANDT |
T023
Material Groups
|
MANDT |
| STPO | MATKL | STPO | MATKL |
T023
Material Groups
|
MATKL |
| STPO | MEINS | STPO | MANDT |
T006
Units of Measurement
|
MANDT |
| STPO | MEINS | STPO | MEINS |
T006
Units of Measurement
|
MSEHI |
| STPO | NFMAT | STPO | MANDT |
MARA
General Material Data
|
MANDT |
| STPO | NFMAT | STPO | NFMAT |
MARA
General Material Data
|
MATNR |
| STPO | NLFMV | STPO | MANDT |
T006
Units of Measurement
|
MANDT |
| STPO | NLFMV | STPO | NLFMV |
T006
Units of Measurement
|
MSEHI |
| STPO | POSTP | STPO | MANDT |
T418
Item Categories
|
MANDT |
| STPO | POSTP | STPO | POSTP |
T418
Item Categories
|
POSTP |
| STPO | POTPR | STPO | MANDT |
T418
Item Categories
|
MANDT |
| STPO | POTPR | STPO | POTPR |
T418
Item Categories
|
POSTP |
| STPO | PRVBE | STPO | MANDT |
PVBE
Production Supply Area
|
MANDT |
| STPO | PRVBE | * |
PVBE
Production Supply Area
|
WERKS | |
| STPO | PRVBE | STPO | PRVBE |
PVBE
Production Supply Area
|
PRVBE |
| STPO | PSWRK | STPO | MANDT |
T001W
Plants/Branches
|
MANDT |
| STPO | PSWRK | STPO | PSWRK |
T001W
Plants/Branches
|
WERKS |
| STPO | RFORM | STPO | MANDT |
T418F
Variable-Size Item Formulas
|
MANDT |
| STPO | RFORM | STPO | RFORM |
T418F
Variable-Size Item Formulas
|
RFORM |
| STPO | RFPNT | STPO | RFPNT |
TCNRFP
Reference Point for BOM transfer
|
RFPNT |
| STPO | RFPNT | STPO | MANDT |
TCNRFP
Reference Point for BOM transfer
|
MANDT |
| STPO | ROMEI | STPO | MANDT |
T006
Units of Measurement
|
MANDT |
| STPO | ROMEI | STPO | ROMEI |
T006
Units of Measurement
|
MSEHI |
| STPO | RVREL | STPO | RVREL |
TVRL
Relevance of Bill of Material Items for SD
|
RVREL |
| STPO | RVREL | STPO | MANDT |
TVRL
Relevance of Bill of Material Items for SD
|
MANDT |
| STPO | SANKA | STPO | MANDT |
TCK08
Indicator for Relevancy to Costing
|
MANDT |
| STPO | SANKA | STPO | SANKA |
TCK08
Indicator for Relevancy to Costing
|
SELKZ |
| STPO | VERTI | STPO | MANDT |
T437V
Distribution key in MRP
|
MANDT |
| STPO | VERTI | * |
T437V
Distribution key in MRP
|
WERKS | |
| STPO | VERTI | STPO | VERTI |
T437V
Distribution key in MRP
|
VERTL |
| STPO | WAERS | STPO | MANDT |
TCURC
Currency Codes
|
MANDT |
| STPO | WAERS | STPO | WAERS |
TCURC
Currency Codes
|
WAERS |