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
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
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
X Yes
NULL No
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
X Yes
NULL No
AUSCH Component scrap in percent KAUSF DEC 5 2
AVOAU Operation scrap AVOAU DEC 5 2
NETAU Indicator: Net scrap NETAU CHAR 1 0
X Yes
NULL No
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
SANIN Indicator: item relevant to plant maintenance SANIN CHAR 1 0
X Yes
NULL No
SANKA Indicator for relevancy to costing CS_SANKA TCK08 CHAR 1 0
SANKO Indicator: item relevant to engineering SANKO CHAR 1 0
X Yes
NULL No
SANVS Indicator: high-level configuration SANVS CHAR 1 0
X Yes
NULL No
STKKZ PM assembly indicator STKKZ CHAR 1 0
X Yes
NULL No
REKRI Indicator: BOM is recursive REKRI CHAR 1 0
X Yes
NULL No
REKRS Indicator: recursiveness allowed REKRS CHAR 1 0
X Yes
NULL No
CADPO CAD Indicator CADPO CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
VALKZ Indicator: item in more than one alternative VALKZ CHAR 1 0
X Yes
NULL No
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
NULL Optional component
1 Required component
2 Object dependencies determine whether comp. used
INSKZ Instance indicator INSKZ CHAR 1 0
X Yes
NULL No
VCEKZ Indicator: not displayed in configuration editor VCEKZ CHAR 1 0
X Yes
NULL No
VSTKZ Indicator: not displayed in single-level configuration VSTKZ CHAR 1 0
X Yes
NULL No
VACKZ Indicator: not displayed in automatic configuration VACKZ CHAR 1 0
X Yes
NULL No
EKORG Purchasing Organization EKORG T024E CHAR 4 0
CLOBK Required Component CLOBK CHAR 1 0
X Yes
NULL No
CLMUL Multiple Selection Allowed CLMULT CHAR 1 0
X Yes
NULL No
CLALT Alternative Display Format CLALT CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
INTRM Intra Material INTRM CHAR 18 0
TPEKZ Indicator: restrictions exist TPEKZ CHAR 1 0
X Yes
NULL No
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
1 Manual maintenance/by usage probability
2 100% check
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
X Yes
NULL No
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
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
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
X Yes
NULL No
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
X Yes
NULL No
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