STPOV_ALV SAP (BOM item (expanded for displaying where-used list), ALV) Structure details
Description: BOM item (expanded for displaying where-used list), ALV
Structure field list including key, data, relationships and ABAP select examples
STPOV_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "BOM item (expanded for displaying where-used list), ALV" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_STPOV_ALV TYPE STPOV_ALV.
The STPOV_ALV table consists of various fields, each holding specific information or linking keys about BOM item (expanded for displaying where-used list), ALV data available in SAP. These include STLAN (BOM Usage), WERKS (Plant), OJTXB (Object description (assembly)), VWALT (Alternative BOM).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP STPOV_ALV structure 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 |
LEVEL | Level (in multi-level BOM explosions) | HISTU | DEC | 2 | DEC2 | ||||
STLAN | BOM Usage | STLAN | CHAR | 1 | Assigned to domain | STLAN | CSV | ||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
OJTXB | Object description (assembly) | OJTXB | CHAR | 40 | TEXT40 | ||||
VWALT | Alternative BOM | STALT | CHAR | 2 | ALPHA | ALTNR | |||
POSNR | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
EMENG | CS Float field (quantity help ...) | CSFLT | FLTP | 16(16) | FLOAT1 | ||||
MEINS | Component unit of measure | KMPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MENGE | Component quantity | KMPMG | QUAN | 13(3) | MENGV13 | ||||
EMEIH | Component unit of measure | KMPME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BMENG | Base quantity | BASMN | QUAN | 13(3) | MENG13 | ||||
STLST | BOM status | STLST | NUMC | 2 | Assigned to domain | STLST | |||
BMEIN | Base unit of measure for BOM | BASME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BMTYP | BOM category | STLTY | CHAR | 1 | STLTY | ||||
TTIDX | Index in category table | TTIDX | INT4 | 10 | TABIX | ||||
CSLTY | Indicator: configured material (material variant) | CSLTY | CHAR | 1 | XFELD | ||||
LSTFG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
STKOZ | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
LOEKZ | Deletion flag for BOMs | LOKNZ | CHAR | 1 | XFELD | ||||
FXMNG | CS Float field (quantity help ...) | CSFLT | FLTP | 16(16) | FLOAT1 | ||||
MSIGN | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
CRTFG | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
SUMFG | Totals record indicator | SUMKZ | CHAR | 1 | KENZX | ||||
EXCPT | Exception | EXCPT | CHAR | 4 | CHAR4 | ||||
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 | ||||
AENNR | Change Number | AENNR | CHAR | 12 | Assigned to domain | AENNR | AENNR | AEN | |
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 | Assigned to domain | WERKS | |||
POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | Assigned to domain | POSTP | |||
SORTF | Sort String | SORTP | CHAR | 10 | CHAR10 | ||||
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 | Assigned to domain | BEIKZ | |||
ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | Assigned to domain | ERSKZ | |||
RVREL | Indicator: item relevant to sales | RVREL | CHAR | 1 | Assigned to domain | 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 | CK_SELKZ | CHAR | 1 | Assigned to domain | 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 | ||||
NLFZT | Lead-time offset | NLFZT | DEC | 3 | NLFZT | ||||
VERTI | Distribution key for component consumption | SA_VERTI | CHAR | 4 | Assigned to domain | 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 | Assigned to domain | EKGRP | EKG | ||
LIFZT | Delivery time in days | LIFZT | DEC | 3 | DEC3 | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | 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 | Assigned to domain | 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 | Assigned to domain | CUNIT | MEINS | ||
ROMEN | Quantity of variable-size item | ROMEN | QUAN | 13(3) | MENG13 | ||||
RFORM | Formula key | RFORM | CHAR | 2 | Assigned to domain | RFORM | |||
UPSKZ | Indicator: sub-items exist | UPSKZ | CHAR | 1 | XFELD | ||||
LTXSP | Language: The long text was stored in this language | LTXSP | LANG | 1 | Assigned to domain | 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 | Assigned to domain | MATKL | MKL | S_WBWG | |
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
CSSTR | Average material purity in % | CSSTR | DEC | 5(2) | DEC3_2 | ||||
POTPR | Item Category (Bill of Material) | POSTP | CHAR | 1 | Assigned to domain | POSTP | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
CLOBK | Required Component | CLOBK | CHAR | 1 | XFELD | ||||
CLMUL | Multiple Selection Allowed | CLMULT | CHAR | 1 | XFELD | ||||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
LGORT | Issue location for production order | CSLGO | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
KZKUP | Indicator: co-product | KZKUP | CHAR | 1 | XFELD | ||||
INTRM | Intra Material | INTRM | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
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 | Assigned to domain | 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 | ||||
DATUB | Valid-to date | DATUB | DATS | 8 | DATUM | ||||
AENRA | Change Number To | AENRA | CHAR | 12 | Assigned to domain | AENNR | AENNR | ||
AENKZ | Change indicator | SAENKZ | CHAR | 1 | XFELD | ||||
MTBME | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MTAME | Unit of issue | AUSME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UMREZ | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
INDEX | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
DOBJT | Object ID | SOBJID | CHAR | 40 | CHAR40 | ||||
OBJIC | Object Type | CS_OBJICON | CHAR | 132 | SYCHAR132 | ||||
OVFLS | Indicator: value exceeds maximum length | OVFLS | CHAR | 1 | CHAR01 | ||||
BOMFL | Indicator: an assembly exists | CSBFL | CHAR | 1 | XFELD | ||||
DSTUF | Explosion level | AFLST | CHAR | 2 | CHAR2 | ||||
DGLVL | Explosion level (formatted) | DGLVL | CHAR | 10 | CHAR10 | ||||
TLINE | Text | TEXTO | CHAR | 132 | TEXT132 | ||||
DUPMG | Sub-item quantity | UPMNG | QUAN | 13(3) | MENGV13 | ||||
CLOBJ | Key of object to be classified | OBJNUM | CHAR | 50 | OBJEKT | OJK | |||
CLOTX | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
DOKNR | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
DOKAR | Document Type | DOKAR | CHAR | 3 | Assigned to domain | DOKAR | CV2 | ||
DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
IWERK | Maintenance Planning Plant | IWERK | CHAR | 4 | Assigned to domain | WERKS | IWK | ||
VBELN | Sales Order | CS_VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
VBPOS | Sales order item | CS_VBPOS | NUMC | 6 | Assigned to domain | POSNR | APO | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVST | CHAR | 2 | NUMCV | REVLV | |||
STOBJ | Standard object | STOBJ | CHAR | 18 | CHAR18 | ||||
TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
CLASS | Class number | KLASSE_D | CHAR | 18 | KLASSE | KLA | |||
KLART | Class Type | KLASSENART | CHAR | 3 | Assigned to domain | KLASSENART | KAR | ||
DSTAL | Alternative BOM | STLAL | CHAR | 2 | ALPHA | ALTNR | |||
DPOSN | BOM Item Number | SPOSN | CHAR | 4 | NUMCV | SPOSN | |||
DIMNG | Required quantity (displayed) | DIMNG | CHAR | 15 | CHAR15 | ||||
DRMNG | Resulting qty | DRMNG | CHAR | 15 | CHAR15 | ||||
MEOPO | Unit of measure (start object for where-used lists) | MEOPO | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DUNIT | Unit of measure (unit to be displayed) | DUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
IMOVF | Indicator: required quantity amount exceeds maximum value | IMOVF | CHAR | 1 | CHAR01 | ||||
RMOVF | Indicator: resulting quantity amount exceeds maximum value | RMOVF | CHAR | 1 | CHAR01 | ||||
COMFX | Comment field: fixed quantity | COMFX | CHAR | 4 | CHAR4 | ||||
CLAFG | Indicator: indirect where-used list via class | CLAFG | CHAR | 1 | CHAR01 | ||||
LOEFG | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
TOKNZ | Character: to (from - to) | TOKNZ | CHAR | 1 | CHAR01 | ||||
KNOFL | Indicator: object dependencies exist | CS_KZBEZ | CHAR | 1 | XFELD | ||||
SELNM | Description of selection parameter | SELNM | CHAR | 32 | CHAR32 | ||||
SELVL | Value entered for selection parameter | SELVL | CHAR | 32 | CHAR32 | ||||
SLDTV | Key date | FDEPSTTA | DATS | 8 | DATUM | ||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
.INCLU--AP | 0 | ||||||||
CUFACTOR | CU: Number of CU Instances | /CUM/CUFACTOR | NUMC | 6 | Assigned to domain | /CUM/CUFACTOR |
Key field | Non-key field |
How do I retrieve data from SAP structure STPOV_ALV using ABAP code?
As STPOV_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on STPOV_ALV as there is no data to select.How to access SAP table STPOV_ALV
Within an ECC or HANA version of SAP you can also view further information about STPOV_ALV 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