SAP Table STPOV_ALV

BOM item (expanded for displaying where-used list), ALV

STPOV_ALV (BOM item (expanded for displaying where-used list), ALV) 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 STPOV_ALV to other SAP tables.

STPOV_ALV table fields

Field Data element Checktable Datatype Length Decimals
LEVEL Level (in multi-level BOM explosions) HISTU DEC 2 0
STLAN BOM Usage STLAN CHAR 1 0
WERKS Plant WERKS_D CHAR 4 0
OJTXB Object description (assembly) OJTXB CHAR 40 0
VWALT Alternative BOM STALT CHAR 2 0
POSNR BOM Item Number SPOSN CHAR 4 0
EMENG CS Float field (quantity help ...) CSFLT FLTP 16 16
MEINS Component unit of measure KMPME UNIT 3 0
MENGE Component quantity KMPMG QUAN 13 3
EMEIH Component unit of measure KMPME UNIT 3 0
BMENG Base quantity BASMN QUAN 13 3
STLST BOM status STLST NUMC 2 0
BMEIN Base unit of measure for BOM BASME UNIT 3 0
BMTYP 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
TTIDX Index in category table TTIDX INT4 10 0
CSLTY Indicator: configured material (material variant) CSLTY CHAR 1 0
X Yes
NULL No
LSTFG Checkbox XFELD CHAR 1 0
X Yes
NULL No
STKOZ Internal counter CIM_COUNT NUMC 8 0
LOEKZ Deletion flag for BOMs LOKNZ CHAR 1 0
X Yes
NULL No
FXMNG CS Float field (quantity help ...) CSFLT FLTP 16 16
MSIGN Checkbox XFELD CHAR 1 0
X Yes
NULL No
CRTFG Checkbox XFELD CHAR 1 0
X Yes
NULL No
SUMFG Totals record indicator SUMKZ CHAR 1 0
X Selection character
NULL Blank
EXCPT Exception EXCPT CHAR 4 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
AENNR Change Number AENNR CHAR 12 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 CHAR 4 0
POSTP Item Category (Bill of Material) POSTP CHAR 1 0
SORTF Sort String SORTP CHAR 10 0
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 CHAR 1 0
ERSKZ Indicator: spare part ERSKZ CHAR 1 0
RVREL Indicator: item relevant to sales RVREL 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 CK_SELKZ 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
NLFZT Lead-time offset NLFZT DEC 3 0
VERTI Distribution key for component consumption SA_VERTI 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 CHAR 3 0
LIFZT Delivery time in days LIFZT DEC 3 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
PREIS Price CPREI CURR 11 2
PEINH Price Unit PEINH DEC 5 0
WAERS Currency Key WAERS 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 UNIT 3 0
ROMEN Quantity of variable-size item ROMEN QUAN 13 3
RFORM Formula key RFORM CHAR 2 0
UPSKZ Indicator: sub-items exist UPSKZ CHAR 1 0
X Yes
NULL No
LTXSP Language: The long text was stored in this language LTXSP 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 CHAR 9 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
CSSTR Average material purity in % CSSTR DEC 5 2
POTPR Item Category (Bill of Material) POSTP CHAR 1 0
EKORG Purchasing Organization EKORG 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
KNOBJ Number of Object with Assigned Dependencies KNOBJ NUMC 18 0
LGORT Issue location for production order CSLGO CHAR 4 0
KZKUP Indicator: co-product KZKUP CHAR 1 0
X Yes
NULL No
INTRM Intra Material INTRM CHAR 18 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 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
DATUB Valid-to date DATUB DATS 8 0
AENRA Change Number To AENRA CHAR 12 0
AENKZ Change indicator SAENKZ CHAR 1 0
X Yes
NULL No
MTBME Base Unit of Measure MEINS UNIT 3 0
MTAME Unit of issue AUSME UNIT 3 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
INDEX Row Index of Internal Tables SYTABIX INT4 10 0
DOBJT Object ID SOBJID CHAR 40 0
OBJIC Object Type CS_OBJICON CHAR 132 0
OVFLS Indicator: value exceeds maximum length OVFLS CHAR 1 0
BOMFL Indicator: an assembly exists CSBFL CHAR 1 0
X Yes
NULL No
DSTUF Explosion level AFLST CHAR 2 0
DGLVL Explosion level (formatted) DGLVL CHAR 10 0
TLINE Text TEXTO CHAR 132 0
DUPMG Sub-item quantity UPMNG QUAN 13 3
CLOBJ Key of object to be classified OBJNUM CHAR 50 0
CLOTX Text, 40 Characters Long TEXT40 CHAR 40 0
DOKNR Document number DOKNR CHAR 25 0
DOKAR Document Type DOKAR CHAR 3 0
DOKTL Document Part DOKTL_D CHAR 3 0
DOKVR Document Version DOKVR CHAR 2 0
EQUNR Equipment Number EQUNR CHAR 18 0
IWERK Maintenance Planning Plant IWERK CHAR 4 0
VBELN Sales Order CS_VBELN CHAR 10 0
VBPOS Sales order item CS_VBPOS NUMC 6 0
MATNR Material Number MATNR CHAR 18 0
REVLV Revision Level REVST CHAR 2 0
STOBJ Standard object STOBJ CHAR 18 0
TPLNR Functional Location TPLNR CHAR 30 0
CLASS Class number KLASSE_D CHAR 18 0
KLART Class Type KLASSENART CHAR 3 0
DSTAL Alternative BOM STLAL CHAR 2 0
DPOSN BOM Item Number SPOSN CHAR 4 0
DIMNG Required quantity (displayed) DIMNG CHAR 15 0
DRMNG Resulting qty DRMNG CHAR 15 0
MEOPO Unit of measure (start object for where-used lists) MEOPO UNIT 3 0
DUNIT Unit of measure (unit to be displayed) DUNIT UNIT 3 0
IMOVF Indicator: required quantity amount exceeds maximum value IMOVF CHAR 1 0
RMOVF Indicator: resulting quantity amount exceeds maximum value RMOVF CHAR 1 0
COMFX Comment field: fixed quantity COMFX CHAR 4 0
CLAFG Indicator: indirect where-used list via class CLAFG CHAR 1 0
LOEFG Deletion Indicator LKENZ CHAR 1 0
X Yes
NULL No
TOKNZ Character: to (from - to) TOKNZ CHAR 1 0
KNOFL Indicator: object dependencies exist CS_KZBEZ CHAR 1 0
X Yes
NULL No
SELNM Description of selection parameter SELNM CHAR 32 0
SELVL Value entered for selection parameter SELVL CHAR 32 0
SLDTV Key date FDEPSTTA DATS 8 0
PSPNR WBS Element PS_POSNR NUMC 8 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