1. Home
  2. Resources
  3. SAP Tables
  4. STPO_OPR - Program structure: component allocation to operation

SAP Table STPO_OPR

Program structure: component allocation to operation

STPO_OPR (Program structure: component allocation to operation) 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_OPR to other SAP tables.

STPO_OPR table fields

Field Data element Checktable Datatype Length Decimals
FLG_SEL Version is valid on key date entered FLGSEL CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
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
LTXPS Long text working name LTXPS INT4 10 0
LTXVB Long text update indicator LVBKZ CHAR 1 0
VBKZ Update indicator VBKZ CHAR 1 0
I Insert
U Update
D Delete
MVBKZ Update indicator VBKZ CHAR 1 0
I Insert
U Update
D Delete
DATUB Valid-to date DATUB DATS 8 0
VWALT Alternative BOM STALT CHAR 2 0
AENRA Change Number To AENRA CHAR 12 0
AENKZ Change indicator SAENKZ CHAR 1 0
X Yes
NULL No
SELKZ Selection of valid records CSSEL CHAR 1 0
X Yes
NULL No
KZDMU Indicator: Maintaining DMU-transfer matrix in BOM completed CS_KZDMU CHAR 1 0
X Yes
NULL No
KZDOC Indicator: Maintain document assignment in BOM complete CS_KZDOC CHAR 1 0
X Yes
NULL No
KZVID Indicator: Maintain variable object ID in BOM complete CS_KZVID CHAR 1 0
X Yes
NULL No
KZWPF Indicator: dependencies maintained in BOM KZWPF CHAR 1 0
X Yes
NULL No
MASPN BOM Item Number SPOSN CHAR 4 0
MASKN BOM item node number STLKN NUMC 8 0
CLSPS Classification working name CS_CLSPS NUMC 8 0
CLSVB Classification update indicator CS_CVBKZ CHAR 1 0
DUMPS1 Phantom item indicator DUMPS CHAR 1 0
X Yes
NULL No
WEGXX1 Path (for multi-level BOM explosions) WEGXX DEC 4 0
STUFE1 Level (in multi-level BOM explosions) HISTU DEC 2 0
KANTE Edge in the exploded BOM tree STKAN NUMC 6 0
EFSRT Sort criterion for BOMs for effectivity CS_EFSRT CHAR 30 0
EFRNK ECM: level during explosion CC_EFRNK NUMC 20 0
CAALT Alternative BOM STALT CHAR 2 0
FAMAT Material Number MATNR CHAR 18 0
DSORT Field to sort items of Phantom assembly CS_DSORT INT4 10 0
INDEX_PLMZ Index referring to material staging INDEX_PLMZ INT4 10 0
PLNFL Sequence PLNFOLGE CHAR 6 0
VORNR Operation/Activity Number VORNR CHAR 4 0
FLG_REF Version is valid on key date entered FLGSEL CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
STRUCNR Row Index of Internal Tables SYTABIX INT4 10 0

STPO_OPR foreign key relationships

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