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 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
STLTY | BOM category | STLTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
AUSCH | Component scrap in percent | KAUSF | DEC | 5 | 2 | |||||||||||||||||
AVOAU | Operation scrap | AVOAU | DEC | 5 | 2 | |||||||||||||||||
NETAU | Indicator: Net scrap | NETAU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
SANIN | Indicator: item relevant to plant maintenance | SANIN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
SANKA | Indicator for relevancy to costing | CS_SANKA | TCK08 | CHAR | 1 | 0 | ||||||||||||||||
SANKO | Indicator: item relevant to engineering | SANKO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
SANVS | Indicator: high-level configuration | SANVS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
STKKZ | PM assembly indicator | STKKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
REKRI | Indicator: BOM is recursive | REKRI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
REKRS | Indicator: recursiveness allowed | REKRS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
CADPO | CAD Indicator | CADPO | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
VALKZ | Indicator: item in more than one alternative | VALKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
INSKZ | Instance indicator | INSKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
VCEKZ | Indicator: not displayed in configuration editor | VCEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
VSTKZ | Indicator: not displayed in single-level configuration | VSTKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
VACKZ | Indicator: not displayed in automatic configuration | VACKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
EKORG | Purchasing Organization | EKORG | T024E | CHAR | 4 | 0 | ||||||||||||||||
CLOBK | Required Component | CLOBK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
CLMUL | Multiple Selection Allowed | CLMULT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
CLALT | Alternative Display Format | CLALT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
INTRM | Intra Material | INTRM | CHAR | 18 | 0 | |||||||||||||||||
TPEKZ | Indicator: restrictions exist | TPEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 |
Possible values
|
||||||||||||||||
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 | MANDT | T024E | Purchasing Organizations | MANDT |
STPO | EKORG | STPO | EKORG | T024E | Purchasing Organizations | EKORG |
STPO | ERSKZ | STPO | MANDT | T413 | Spare Part Indicators | MANDT |
STPO | ERSKZ | STPO | ERSKZ | T413 | Spare Part Indicators | ERSKZ |
STPO | KLART | STPO | KLART | TCLA | Class Types | KLART |
STPO | KLART | STPO | MANDT | TCLA | Class Types | MANDT |
STPO | LGORT | STPO | MANDT | T001L | Storage Locations | MANDT |
STPO | LGORT | * | T001L | Storage Locations | WERKS | |
STPO | LGORT | STPO | LGORT | T001L | Storage Locations | LGORT |
STPO | LIFNR | STPO | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
STPO | LIFNR | STPO | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
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 | NLFMV | T006 | Units of Measurement | MSEHI |
STPO | NLFMV | STPO | MANDT | T006 | Units of Measurement | MANDT |
STPO | POSTP | STPO | POSTP | T418 | Item Categories | POSTP |
STPO | POSTP | STPO | MANDT | T418 | Item Categories | MANDT |
STPO | POTPR | STPO | MANDT | T418 | Item Categories | MANDT |
STPO | POTPR | STPO | POTPR | T418 | Item Categories | POSTP |
STPO | PRVBE | STPO | PRVBE | PVBE | Production Supply Area | PRVBE |
STPO | PRVBE | STPO | MANDT | PVBE | Production Supply Area | MANDT |
STPO | PRVBE | * | PVBE | Production Supply Area | WERKS | |
STPO | PSWRK | STPO | PSWRK | T001W | Plants/Branches | WERKS |
STPO | PSWRK | STPO | MANDT | T001W | Plants/Branches | MANDT |
STPO | RFORM | STPO | MANDT | T418F | Variable-Size Item Formulas | MANDT |
STPO | RFORM | STPO | RFORM | T418F | Variable-Size Item Formulas | RFORM |
STPO | RFPNT | STPO | MANDT | TCNRFP | Reference Point for BOM transfer | MANDT |
STPO | RFPNT | STPO | RFPNT | TCNRFP | Reference Point for BOM transfer | RFPNT |
STPO | ROMEI | STPO | MANDT | T006 | Units of Measurement | MANDT |
STPO | ROMEI | STPO | ROMEI | T006 | Units of Measurement | MSEHI |
STPO | RVREL | STPO | MANDT | TVRL | Relevance of Bill of Material Items for SD | MANDT |
STPO | RVREL | STPO | RVREL | TVRL | Relevance of Bill of Material Items for SD | RVREL |
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 |