STPO SAP (BOM item) Table details
Dictionary Type: Table
Description: BOM item
Description: BOM item
Table field list including key, data, relationships and ABAP select examples
STPO is a standard SAP Table which is used to store BOM item data and is available within R/3 SAP systems depending on the version and release level.
The STPO table consists of various fields, each holding specific information or linking keys about BOM item data available in SAP. These include STLTY (BOM category), STLNR (Bill of material), STLKN (BOM item node number), STPOZ (Internal counter).. 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. .
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 STPO table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
STLTY | BOM category | STLTY | CHAR | 1 | STLTY | ||||
STLNR | Bill of material | STNUM | CHAR | 8 | NUMCV | STNUM | STLNR | ||
STLKN | BOM item node number | STLKN | NUMC | 8 | KNTNR | ||||
STPOZ | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
TECHV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
LKENZ | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
VGKNT | Predecessor Node | VGKNT | NUMC | 8 | KNTNR | ||||
VGPZL | Previous item counter | VGPZL | NUMC | 8 | CIM_COUNT | ||||
ANDAT | Date record created on | ANDAT | DATS | 8 | DATUM | ||||
ANNAM | User who created record | ANNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
IDNRK | BOM component | IDNRK | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
PSWRK | Issuing plant | PSWRK | CHAR | 4 | T001W | WERKS | |||
POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | T418 | POSTP | |||
POSNR | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
SORTF | Sort String | SORTP | CHAR | 10 | CHAR10 | ||||
MEINS | Component unit of measure | KMPME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MENGE | Component quantity | KMPMG | QUAN | 13(3) | MENGV13 | ||||
FMENG | Fixed qty | FMNGE | CHAR | 1 | XFELD | ||||
AUSCH | Component scrap in percent | KAUSF | DEC | 5(2) | DEC3_2 | ||||
AVOAU | Operation scrap | AVOAU | DEC | 5(2) | DEC3_2 | ||||
NETAU | Indicator: Net scrap | NETAU | CHAR | 1 | XFELD | ||||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | T417 | BEIKZ | |||
ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | T413 | ERSKZ | |||
RVREL | Indicator: item relevant to sales | RVREL | CHAR | 1 | TVRL | RVREL | |||
SANFE | Indicator: item relevant to production | SANFE | CHAR | 1 | XFELD | ||||
SANIN | Indicator: item relevant to plant maintenance | SANIN | CHAR | 1 | XFELD | ||||
SANKA | Indicator for relevancy to costing | CS_SANKA | CHAR | 1 | TCK08 | CK_SELKZ | |||
SANKO | Indicator: item relevant to engineering | SANKO | CHAR | 1 | XFELD | ||||
SANVS | Indicator: high-level configuration | SANVS | CHAR | 1 | XFELD | ||||
STKKZ | PM assembly indicator | STKKZ | CHAR | 1 | XFELD | ||||
REKRI | Indicator: BOM is recursive | REKRI | CHAR | 1 | XFELD | ||||
REKRS | Indicator: recursiveness allowed | REKRS | CHAR | 1 | XFELD | ||||
CADPO | CAD Indicator | CADPO | CHAR | 1 | XFELD | ||||
NFMAT | Follow-up material in BOM item - NOT IN USE | CS_NFMAT | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
NLFZT | Lead-time offset | NLFZT | DEC | 3 | NLFZT | ||||
VERTI | Distribution key for component consumption | SA_VERTI | CHAR | 4 | T437V | SA_VERTL | |||
ALPOS | Indicator: alternative item | ALPOS | CHAR | 1 | XFELD | ||||
EWAHR | Usage probability in % (alternative item) | EWAHR | DEC | 3 | DEC3 | ||||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
LIFZT | Delivery time in days | LIFZT | DEC | 3 | DEC3 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
PREIS | Price | CPREI | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
SAKTO | Cost element | SAKTO | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
ROANZ | Number of variable-size items | ROANZ | QUAN | 13(3) | MENG13 | ||||
ROMS1 | Size 1 | ROMS1 | QUAN | 13(3) | MENG13 | ||||
ROMS2 | Size 2 | ROMS2 | QUAN | 13(3) | MENG13 | ||||
ROMS3 | Size 3 | ROMS3 | QUAN | 13(3) | MENG13 | ||||
ROMEI | Unit of measure for sizes 1 to 3 | ROMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ROMEN | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | ||||
RFORM | Formula key | RFORM | CHAR | 2 | T418F | RFORM | |||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
VALKZ | Indicator: item in more than one alternative | VALKZ | CHAR | 1 | XFELD | ||||
LTXSP | Long Text Language, for Creation of a Change Document | LTXSP_CP | LANG | 1 | T002 | ISOLA | SPRAS | ||
POTX1 | BOM Item Text (Line 1) | POTX1 | CHAR | 40 | TEXT40 | ||||
POTX2 | BOM item text (line 2) | POTX2 | CHAR | 40 | TEXT40 | ||||
OBJTY | Object type (BOM item) | OBJTY | CHAR | 1 | Assigned to domain | OBJTY | |||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
DOKAR | Document Type | DOKAR | CHAR | 3 | TDWA | DOKAR | CV2 | ||
DOKNR | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
CSSTR | Average material purity in % | CSSTR | DEC | 5(2) | DEC3_2 | ||||
CLASS | Class number | KLASSE_D | CHAR | 18 | KLASSE | KLA | |||
KLART | Class Type | KLASSENART | CHAR | 3 | TCLA | KLASSENART | KAR | ||
POTPR | Resulting item category | POTPR | CHAR | 1 | T418 | POSTP | |||
AWAKZ | Selection indicator for configurable BOMs | AWAKZ | CHAR | 1 | AWAKZ | ||||
INSKZ | Instance indicator | INSKZ | CHAR | 1 | X | ||||
VCEKZ | Indicator: not displayed in configuration editor | VCEKZ | CHAR | 1 | X | ||||
VSTKZ | Indicator: not displayed in single-level configuration | VSTKZ | CHAR | 1 | X | ||||
VACKZ | Indicator: not displayed in automatic configuration | VACKZ | CHAR | 1 | X | ||||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
CLOBK | Required Component | CLOBK | CHAR | 1 | XFELD | ||||
CLMUL | Multiple Selection Allowed | CLMULT | CHAR | 1 | XFELD | ||||
CLALT | Alternative Display Format | CLALT | CHAR | 1 | XFELD | ||||
CVIEW | Organizational Area | ABTEILUNG | CHAR | 10 | CHAR10 | VIEW | |||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
LGORT | Issue location for production order | CSLGO | CHAR | 4 | T001L | LGORT | LAG | ||
KZKUP | Indicator: co-product | KZKUP | CHAR | 1 | XFELD | ||||
INTRM | Intra Material | INTRM | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
TPEKZ | Indicator: restrictions exist | TPEKZ | CHAR | 1 | XFELD | ||||
STVKN | Inherited node number of BOM item | STVKN | NUMC | 8 | KNTNR | ||||
DVDAT | Date of last date shift | DVDAT | DATS | 8 | DATUM | ||||
DVNAM | Name of the user who carried out the date shift | DVNAM | CHAR | 12 | USNAM | ||||
DSPST | Explosion type | CS_DISPO | CHAR | 2 | T414 | CS_DISPO | |||
ALPST | Alternative item: strategy | CS_ALPST | CHAR | 1 | CS_ALPST | ||||
ALPRF | Alternative item: ranking order | CS_ALPRF | NUMC | 2 | NUM2 | ||||
ALPGR | Alternative item: group | CS_ALPGR | CHAR | 2 | CHAR2 | ||||
KZNFP | Indicator: Follow-Up Item | CS_KZNFP | CHAR | 1 | XFELD | ||||
NFGRP | Follow-up group | CS_NFGRP | CHAR | 2 | CHAR2 | ||||
NFEAG | Discontinuation group | CS_NFEAG | CHAR | 2 | CHAR2 | ||||
KNDVB | Indicator: manual change to sales order BOM | CS_KNDVB | CHAR | 1 | CHAR1 | ||||
KNDBZ | Indicator: BOM item changed/selected via obj. dependencies | CS_KNDBZ | CHAR | 1 | CHAR1 | ||||
KSTTY | BOM category of original sales order BOM item | CS_KSTTY | CHAR | 1 | STLTY | ||||
KSTNR | Bill of material for original sales order BOM item | CS_KSTNR | CHAR | 8 | NUMCV | STNUM | |||
KSTKN | Node number of original sales order BOM item | CS_KSTKN | NUMC | 8 | KNTNR | ||||
KSTPZ | Counter for original sales order BOM item | CS_KSTPZ | NUMC | 8 | CIM_COUNT | ||||
CLSZU | Classification number | CS_CLSZU | NUMC | 8 | NUM8 | ||||
KZCLB | Indicator: classification as selection condition | CS_KZCLB | CHAR | 1 | XFELD | ||||
AEHLP | Date Shift Hierarchy Indicator | CC_AEHLP | NUMC | 2 | CC_AEHLP | ||||
PRVBE | Production Supply Area | PRVBE | CHAR | 10 | PVBE | PRVBE | PVB | ||
NLFZV | Lead-time offset for operation | CS_NLFZV | DEC | 3 | NLFZT | ||||
NLFMV | Unit for lead-time offset for operation | CS_NLFMV | UNIT | 3 | T006 | CUNIT | MEINS | ||
IDPOS | Item group | CS_IDPOS | CHAR | 20 | CS_IDPOS | ||||
IDHIS | History counter | CS_IDHIS | NUMC | 5 | NUMC5 | ||||
IDVAR | Component Variant | CS_IDVAR | CHAR | 5 | CS_IDVAR | ||||
ALEKZ | ALE indicator | CS_ALEKZ | CHAR | 1 | XFELD | ||||
ITMID | External identification of an item | CS_ITMID | CHAR | 8 | CHAR8 | ||||
GUID | Temporarily not used | CS_CHAR22 | CHAR | 22 | SYCHAR22 | ||||
ITSOB | Special procurement type for BOM item | CS_SOBSL | CHAR | 2 | Assigned to domain | SOBSL | |||
RFPNT | Reference point for BOM transfer | CN_RFPNT | CHAR | 20 | TCNRFP | CN_RFPNT | |||
GUIDX | Global identification of an item's change status | CS_GUID | RAW | 16 | SYSUUID | ||||
.INCLU--AP | 0 | ||||||||
CUFACTOR | CU: Number of CU Instances | /CUM/CUFACTOR | NUMC | 6 | Assigned to domain | /CUM/CUFACTOR | |||
.INCLU--AP | 0 | ||||||||
/SAPMP/MET_LRCH | Length Calculation Method | /SAPMP/MET_LRCH | CHAR | 2 | /SAPMP/MET_LRCH | ||||
/SAPMP/MAX_FERTL | Maximum Production Length | /SAPMP/MAX_FERTL | QUAN | 13(3) | /SAPMP/MAX_FERTL | ||||
/SAPMP/FIX_AS_J | Fixed Scrap - Any Length | /SAPMP/FIX_AS_J | QUAN | 13(3) | /SAPMP/FIX_AS_J | ||||
/SAPMP/FIX_AS_E | Fixed Scrap - First Length | /SAPMP/FIX_AS_E | QUAN | 13(3) | /SAPMP/FIX_AS_E | ||||
/SAPMP/FIX_AS_L | Fixed Scrap - Last Length | /SAPMP/FIX_AS_L | QUAN | 13(3) | /SAPMP/FIX_AS_L | ||||
/SAPMP/ABL_ZAHL | Number of Run-In Lengths | /SAPMP/ABL_ZAHL | NUMC | 6 | NUMC6 | ||||
/SAPMP/RUND_FAKT | Rounding Value | /SAPMP/RUND_FAKT | QUAN | 13(3) | /SAPMP/RUND_FAKT | ||||
.INCLU--AP | 0 | ||||||||
FUNCID | Function Identifier | CCC_FUNCID | CHAR | 40 | CHAR40 |
Key field | Non-key field |
How do I retrieve data from SAP table STPO using ABAP code
The following ABAP code Example will allow you to do a basic selection on STPO to SELECT all data from the tableDATA: WA_STPO TYPE STPO.
SELECT SINGLE *
FROM STPO
INTO CORRESPONDING FIELDS OF WA_STPO
WHERE...
How to access SAP table STPO
Within an ECC or HANA version of SAP you can also view further information about STPO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects