SAP table STPO (BOM item)

SAP table STPO has 5 primary key fields being MANDT,STLTY,STLNR,STLKN,STPOZ.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
STLTY BOM category CHAR 1 0 STLTY
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
P Work Breakdown Structure BOM
S Standard BOM
T Functional Location BOM
STLNR Bill of Material CHAR 8 0 STNUM
STLKN BOM item node number NUMC 8 0 STLKN
STPOZ Internal counter NUMC 8 0 CIM_COUNT
DATUV Valid-From Date DATS 8 0 DATUV
TECHV Technical status from CHAR 12 0 TECHV
AENNR Change Number CHAR 12 0 AENR AENNR
LKENZ Deletion Indicator CHAR 1 0 LKENZ
VGKNT Predecessor Node NUMC 8 0 VGKNT
VGPZL Previous item counter NUMC 8 0 VGPZL
ANDAT Date Record Created On DATS 8 0 ANDAT
ANNAM User who created record CHAR 12 0 ANNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
IDNRK BOM component CHAR 40 0 IDNRK
PSWRK Issuing Plant CHAR 4 0 T001W PSWRK
POSTP Item category (bill of material) CHAR 1 0 T418 POSTP
POSNR BOM Item Number CHAR 4 0 SPOSN
SORTF Sort String CHAR 10 0 SORTP
MEINS Component Unit of Measure UNIT 3 0 T006 KMPME
MENGE Component Quantity QUAN 13 3 KMPMG
FMENG Fixed Quantity CHAR 1 0 FMNGE
AUSCH Component Scrap in Percent DEC 5 2 KAUSF
AVOAU Operation Scrap DEC 5 2 AVOAU
NETAU Net Scrap Indicator CHAR 1 0 NETAU
SCHGT Indicator: bulk material CHAR 1 0 SCHGT
BEIKZ Material Provision Indicator CHAR 1 0 T417 BEIKZ
ERSKZ Indicator: Spare Part CHAR 1 0 T413 ERSKZ
RVREL Indicator: item relevant to sales CHAR 1 0 TVRL RVREL
SANFE Indicator: item relevant to production CHAR 1 0 SANFE
SANIN Indicator: item relevant to plant maintenance CHAR 1 0 SANIN
SANKA Indicator for relevancy to costing CHAR 1 0 TCK08 CS_SANKA
SANKO Indicator: item relevant to engineering CHAR 1 0 SANKO
SANVS Indicator: high-level configuration CHAR 1 0 SANVS
STKKZ PM assembly indicator CHAR 1 0 STKKZ
REKRI Indicator: BOM is recursive CHAR 1 0 REKRI
REKRS Indicator: recursiveness allowed CHAR 1 0 REKRS
CADPO CAD Indicator CHAR 1 0 CADPO
NFMAT Follow-up material in BOM item - NOT IN USE CHAR 40 0 MARA CS_NFMAT
NLFZT Lead-time offset DEC 3 0 NLFZT
VERTI Distribution key for component consumption CHAR 4 0 T437V SA_VERTI
ALPOS Indicator: alternative item CHAR 1 0 ALPOS
EWAHR Usage Probability in % (Alternative Item) DEC 3 0 EWAHR
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
LIFZT Delivery time in days DEC 3 0 LIFZT
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
PREIS Price CURR 11 2 CPREI
PEINH Price unit DEC 5 0 PEINH
WAERS Currency Key CUKY 5 0 TCURC WAERS
SAKTO Cost element CHAR 10 0 SAKTO
ROANZ Required Number of Variable-Size Items QUAN 13 3 ROANZ
ROMS1 Size 1 QUAN 13 3 ROMS1
ROMS2 Size 2 QUAN 13 3 ROMS2
ROMS3 Size 3 QUAN 13 3 ROMS3
ROMEI Unit of measure for sizes 1 to 3 UNIT 3 0 T006 ROMEI
ROMEN Variable-Size Item Quantity per Piece (PC) QUAN 13 3 ROMEN
RFORM Formula Key for Variable-Size Items CHAR 2 0 T418F RFORM
UPSKZ Indicator: sub-items exist CHAR 1 0 UPSKZ
VALKZ Indicator: item in more than one alternative CHAR 1 0 VALKZ
LTXSP Long Text Language, for Creation of a Change Document LANG 1 0 T002 LTXSP_CP
POTX1 BOM Item Text (Line 1) CHAR 40 0 POTX1
POTX2 BOM Item Text (Line 2) CHAR 40 0 POTX2
OBJTY Object type (BOM item) CHAR 1 0 OBJTY
MATKL Material Group CHAR 9 0 T023 MATKL
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
DOKAR Document Type CHAR 3 0 TDWA DOKAR
DOKNR Document number CHAR 25 0 DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
CSSTR Average material purity in % DEC 5 2 CSSTR
CLASS Class number CHAR 18 0 KLASSE_D
KLART Class Type CHAR 3 0 TCLA KLASSENART
POTPR Resulting item category CHAR 1 0 T418 POTPR
AWAKZ Selection indicator for configurable BOMs CHAR 1 0 AWAKZ
Optional component
1 Required component
2 Object dependencies determine whether comp. used
INSKZ Instance indicator CHAR 1 0 INSKZ
VCEKZ Indicator: not displayed in configuration editor CHAR 1 0 VCEKZ
VSTKZ Indicator: not displayed in single-level configuration CHAR 1 0 VSTKZ
VACKZ Indicator: not displayed in automatic configuration CHAR 1 0 VACKZ
EKORG Purchasing organization CHAR 4 0 T024E EKORG
CLOBK Required Component CHAR 1 0 CLOBK
CLMUL Multiple Selection Allowed CHAR 1 0 CLMULT
CLALT Alternative Display Format CHAR 1 0 CLALT
CVIEW Organizational Area CHAR 10 0 ABTEILUNG
KNOBJ Number of Object with Assigned Dependencies NUMC 18 0 KNOBJ
LGORT Issue Location for Production Order CHAR 4 0 T001L CSLGO
KZKUP Indicator: co-product CHAR 1 0 KZKUP
INTRM Intra Material CHAR 40 0 INTRM
TPEKZ Indicator: restrictions exist CHAR 1 0 TPEKZ
STVKN Inherited node number of BOM item NUMC 8 0 STVKN
DVDAT Date of last date shift DATS 8 0 DVDAT
DVNAM Name of the user who carried out the date shift CHAR 12 0 DVNAM
DSPST Explosion type CHAR 2 0 T414 CS_DISPO
ALPST Alternative item: strategy CHAR 1 0 CS_ALPST
1 Manual maintenance/by usage probability
2 100% check
ALPRF Alternative item: ranking order NUMC 2 0 CS_ALPRF
ALPGR Alternative item: group CHAR 2 0 CS_ALPGR
KZNFP Indicator: Follow-Up Item CHAR 1 0 CS_KZNFP
NFGRP Follow-up group CHAR 2 0 CS_NFGRP
NFEAG Discontinuation group CHAR 2 0 CS_NFEAG
KNDVB Indicator: manual change to sales order BOM CHAR 1 0 CS_KNDVB
KNDBZ Indicator: BOM item changed/selected via obj. dependencies CHAR 1 0 CS_KNDBZ
KSTTY BOM category of original sales order BOM item CHAR 1 0 CS_KSTTY
KSTNR Bill of material for original sales order BOM item CHAR 8 0 CS_KSTNR
KSTKN Node number of original sales order BOM item NUMC 8 0 CS_KSTKN
KSTPZ Counter for original sales order BOM item NUMC 8 0 CS_KSTPZ
CLSZU Classification number NUMC 8 0 CS_CLSZU
KZCLB Indicator: classification as selection condition CHAR 1 0 CS_KZCLB
AEHLP Date Shift Hierarchy Indicator NUMC 2 0 CC_AEHLP
PRVBE Production Supply Area CHAR 10 0 PVBE PRVBE
NLFZV Lead-time offset for operation DEC 3 0 CS_NLFZV
NLFMV Unit for lead-time offset for operation UNIT 3 0 T006 CS_NLFMV
IDPOS Item group CHAR 20 0 CS_IDPOS
IDHIS History counter NUMC 5 0 CS_IDHIS
IDVAR Component Variant CHAR 5 0 CS_IDVAR
ALEKZ ALE indicator CHAR 1 0 CS_ALEKZ
ITMID External identification of an item CHAR 8 0 CS_ITMID
GUID Temporarily not used CHAR 22 0 CS_CHAR22
ITSOB Special Procurement Type for BOM Item CHAR 2 0 CS_SOBSL
RFPNT Reference point for BOM transfer CHAR 20 0 TCNRFP CN_RFPNT
GUIDX Global identification of an item's change status RAW 16 0 CS_GUID
SGT_CMKZ Segmentation Maintained for BOM Components CHAR 1 0 SGT_CMKZ
SGT_CATV Segmentation Value CHAR 40 0 SGT_CATV
VALID_TO Valid-to date DATS 8 0 DATUB
VALID_TO_RKEY Valid-to date DATS 8 0 DATUB
ECN_TO Change Number To CHAR 12 0 AENRA
ECN_TO_RKEY Change Number To CHAR 12 0 AENRA
ABLAD Unloading Point CHAR 25 0 ABLAD
WEMPF Goods Recipient CHAR 12 0 WEMPF
STVKN_VERSN Inherited node number of BOM item NUMC 8 0 STVKN
LASTCHANGEDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
SFWIND Indicator: Software component CHAR 1 0 CS_SFWIND
DUMMY_STPO_INCL_EEW_PS Data Element for Extensibility of Maintain BOM Item CHAR 1 0 STPO_INCL_EEW
CUFACTOR CU: Number of CU Instances NUMC 6 0 * /CUM/CUFACTOR
/SAPMP/MET_LRCH Length Calculation Method CHAR 2 0 /SAPMP/MET_LRCH
Pass On Lengths
1 Full Reels
2 Summarize Lengths
/SAPMP/MAX_FERTL Maximum Production Length QUAN 13 3 /SAPMP/MAX_FERTL
/SAPMP/FIX_AS_J Fixed Scrap - Any Length QUAN 13 3 /SAPMP/FIX_AS_J
/SAPMP/FIX_AS_E Fixed Scrap - First Length QUAN 13 3 /SAPMP/FIX_AS_E
/SAPMP/FIX_AS_L Fixed Scrap - Last Length QUAN 13 3 /SAPMP/FIX_AS_L
/SAPMP/ABL_ZAHL Number of Run-In Lengths NUMC 6 0 /SAPMP/ABL_ZAHL
/SAPMP/RUND_FAKT Rounding Value QUAN 13 3 /SAPMP/RUND_FAKT
FSH_VMKZ Deviation Values Maintained for Component at Variant Level CHAR 1 0 FSH_VMKZ
FSH_PGQR Quantity Distribution Profile CHAR 18 0 FSH_QD_PROFILE
FSH_PGQRRF Reference to Quantity Distribution Profile CHAR 1 0 FSH_PGQRRF
FSH_CRITICAL_COMP Critical Component Indicator CHAR 1 0 FSH_CRITICAL_COMP
Not Critical
A Critical and automatic selection of stock
M Critical and manual selection of stock
FSH_CRITICAL_LEVEL Crtical Level of a Component in BoM DEC 2 0 FSH_CRITICAL_LEVEL
FUNCID Function Identifier CHAR 40 0 CCC_FUNCID

STPO foreign key relationships

Table Field Check Table Check Field
0 STPO AENNR AENR Change Master AENNR
1 STPO BEIKZ T417 Material Provision Indicators MANDT
1 STPO BEIKZ T417 Material Provision Indicators BEIKZ
0 STPO DOKAR TDWA Document Types MANDT
0 STPO DOKAR TDWA Document Types DOKAR
1 STPO DSPST T414 Explosion Types MANDT
1 STPO DSPST T414 Explosion Types DISPO
0 STPO EKGRP T024 Purchasing Groups EKGRP
1 STPO EKORG T024E Purchasing Organizations EKORG
0 STPO ERSKZ T413 Spare Part Indicators MANDT
1 STPO KLART TCLA Class Types MANDT
0 STPO LGORT T001L Storage Locations MANDT
0 STPO LGORT T001L Storage Locations WERKS
1 STPO LIFNR LFA1 Supplier Master (General Section) MANDT
1 STPO LIFNR LFA1 Supplier Master (General Section) LIFNR
0 STPO LTXSP T002 Language Keys (Component BC-I18) SPRAS
1 STPO MATKL T023 Material Groups MATKL
0 STPO MEINS T006 Units of Measurement MANDT
0 STPO MEINS T006 Units of Measurement MSEHI
1 STPO NFMAT MARA General Material Data MANDT
1 STPO NFMAT MARA General Material Data MATNR
0 STPO NLFMV T006 Units of Measurement MANDT
1 STPO POSTP T418 Item Categories MANDT
1 STPO POSTP T418 Item Categories POSTP
0 STPO POTPR T418 Item Categories MANDT
0 STPO POTPR T418 Item Categories POSTP
1 STPO PRVBE PVBE Production Supply Area MANDT
1 STPO PRVBE PVBE Production Supply Area WERKS
1 STPO PRVBE PVBE Production Supply Area PRVBE
0 STPO PSWRK T001W Plants/Branches MANDT
0 STPO PSWRK T001W Plants/Branches WERKS
1 STPO RFORM T418F Variable-Size Item Formulas MANDT
0 STPO RFPNT TCNRFP Reference Point for BOM transfer MANDT
0 STPO RFPNT TCNRFP Reference Point for BOM transfer RFPNT
1 STPO ROMEI T006 Units of Measurement MANDT
0 STPO RVREL TVRL Relevance of Bill of Material Items for SD MANDT
0 STPO RVREL TVRL Relevance of Bill of Material Items for SD RVREL
1 STPO SANKA TCK08 Indicator for Relevancy to Costing MANDT
1 STPO SANKA TCK08 Indicator for Relevancy to Costing SELKZ
0 STPO VERTI T437V Distribution key in MRP MANDT
0 STPO VERTI T437V Distribution key in MRP WERKS
1 STPO WAERS TCURC Currency Codes MANDT
1 STPO WAERS TCURC Currency Codes WAERS