Multi-Level BOM Where-Used Report with Open Production Orders
Short answer: A custom ALV report that shows in which assemblies and, at the top, in which finished goods one or more components are used, as a flat list that includes intermediate levels and phantom assemblies. For every top-level material the number of open production orders and the remaining order quantity are on the same line, so the impact of a component change on open orders is visible in one run.
- Estimated effort
- M · 4–6 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
The CS15 where-used list evaluates components one at a time; running several components in one list and exporting the result to Excel as a flat table is tedious. In the multi-level view the path between the top-level material and the component is not written on one line, phantom assemblies look like a normal level and open production orders are not in the list. Before an engineering change, users move between CS15, CS12 and COOIS to answer 'which finished goods and which open orders does this part touch'. The custom report combines these three steps in one list.
Who uses it? Product engineering and R&D teams, production planners, master data owners and buyers who manage supplier or part changes.
Closest standard alternatives
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| STPOBOM Item | BOM items: component, quantity, validity (driving table) | — | ECC + S/4 |
| STKOBOM Header | BOM header: alternative, status, deletion indicator | STKO-STLTY = STPO-STLTY AND STKO-STLNR = STPO-STLNR | ECC + S/4 |
| MASTMaterial to BOM Link | Parent material, plant and usage of the BOM | MAST-STLNR = STKO-STLNR AND MAST-STLAL = STKO-STLAL | ECC + S/4 |
| MARCPlant Data for Material | Special procurement type for phantom detection | MARC-MATNR = MAST-MATNR AND MARC-WERKS = MAST-WERKS | ECC + S/4 |
| AFPOOrder Item | Open production order items of the top-level material | AFPO-MATNR = MAST-MATNR AND AFPO-DWERK = MAST-WERKS | ECC + S/4 |
| AUFKOrder Master Data | Order object number (for the status check) | AUFK-AUFNR = AFPO-AUFNR | ECC + S/4 |
| JESTIndividual Object Status | Excludes technically completed and deleted orders | JEST-OBJNR = AUFK-OBJNR | ECC + S/4 |
| MAKTMaterial Descriptions | Component and material descriptions | MAKT-MATNR = STPO-IDNRK / MAST-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_IDNRK | Component | Range / multiple | STPO-IDNRK | Yes | RM-2040 |
| S_WERKS | Plant | Range / multiple | MAST-WERKS | Yes | 1000 |
| S_STLAN | BOM usage | Range / multiple | MAST-STLAN | No | 1 |
| P_DATUV | Key date | Single value | STPO-DATUV | Yes | 17.11.2026 |
| P_LEVEL | Maximum levels | Single value | — | No | 6 |
| P_OPEN | Only top-level materials with open orders | Checkbox | — | No | X |
| P_PHANT | Show phantom assemblies as a separate level | Checkbox | — | No | — |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Component | STPO-IDNRK |
| 2 | Component description | MAKT-MAKTX |
| 3 | Plant | MAST-WERKS |
| 4 | Level | Calculated BOM levels counted from the component up to the top-level material |
| 5 | Direct parent | MAST-MATNR |
| 6 | Top-level material | Calculated Last link of the path: a material that is not a component of another BOM |
| 7 | Top-level description | Calculated MAKT-MAKTX of the top-level material |
| 8 | Path | Calculated Material numbers from the component to the top level, separated by ' > ' |
| 9 | Item quantity | STPO-MENGE |
| 10 | Unit | STPO-MEINS |
| 11 | Quantity per top-level unit | Calculated Product of STPO-MENGE ÷ STKO-BMENG along the path |
| 12 | Phantom on path | Calculated X when an assembly on the path has MARC-SOBSL = '50' |
| 13 | Valid from | STPO-DATUV |
| 14 | BOM usage | MAST-STLAN |
| 15 | Open orders | Calculated Number of AFPO items of the top-level material with ELIKZ blank and no TECO |
| 16 | Open order quantity | Calculated Σ (AFPO-PSMNG − AFPO-WEMNG) |
Sample output
| Component | Component description | Plant | Level | Direct parent | Top-level material | Top-level description | Path | Item quantity | Unit | Quantity per top-level unit | Phantom on path | Valid from | BOM usage | Open orders | Open order quantity |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RM-2040 | Steel sheet 2 mm | 1000 | 2 | SA-3100 | FG-5003 | Packed product C | RM-2040 > SA-3100 > FG-5003 | 1.80 | KG | 3.60 | 03/01/2026 | 1 | 4 | 1,250 | |
| RM-2040 | Steel sheet 2 mm | 1000 | 3 | PH-3150 | FG-6100 | Panel cabinet 80 cm | RM-2040 > PH-3150 > SA-3200 > FG-6100 | 2.40 | KG | 4.80 | X | 05/15/2026 | 1 | 2 | 300 |
| RM-3220 | Gasket set 12 pcs | 1000 | 1 | FG-6100 | FG-6100 | Panel cabinet 80 cm | RM-3220 > FG-6100 | 1 | PC | 1 | 11/01/2025 | 1 | 2 | 300 | |
| RM-3220 | Gasket set 12 pcs | 2000 | 2 | SA-4010 | FG-7200 | Compressor unit K2 | RM-3220 > SA-4010 > FG-7200 | 2 | PC | 4 | 01/10/2026 | 1 | 0 | 0 |
How does the report work?
- Material BOM items (STLTY = ‘M’) are read from STPO for the components on the selection screen; deleted items (LKENZ) and items not valid on the key date (DATUV after the key date, or superseded by a newer change record) are skipped.
- Through STPO-STLNR the STKO header (alternative, status STLST, deletion indicator LOEKZ) is read, and MAST gives the parent material, plant and usage (STLAN) the BOM belongs to.
- The parent material is searched as a component in the next pass, until the selected level limit is reached or a material without further where-used is found. For recursive BOMs the visited materials are kept and a repeating path is cut.
- At each level, assemblies with MARC-SOBSL = ‘50’ are flagged as phantom assemblies; quantities are multiplied along the path to get the component quantity needed for one unit of the top-level material.
- For the top-level materials, open production order items are read from AFPO (ELIKZ blank, TECO I0045 or the deletion flag I0076 not active on AUFK-OBJNR); the number of orders and the remaining quantity (PSMNG − WEMNG) are summed.
- The result is listed as one line per component – top-level path; when ‘only with open orders’ is selected, paths without open orders are hidden.
Performance notes
Read STPO by IDNRK; a standard secondary index exists for STPO-IDNRK. Process each level with one FOR ALL ENTRIES read instead of one SELECT per material. For mass runs with thousands of components keep the level limit at 5–6 and run the report in the background.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document The component and parent open CS03; the open order count opens the COOIS list of those orders.
- Export to Excel
- Runs as a background job
Authorization objects
- C_STUE_WRKDisplay BOMs by plant
- C_STUE_BERDisplay BOMs by BOM authorization group
- C_AFKO_AWKDisplay open production orders by plant and order type
Frequently asked questions
How are phantom assemblies shown?
Because a phantom assembly is not produced on its own, it is kept as a link in the path and flagged in the 'Phantom on path' column. The quantity calculation ties the components below the phantom directly to the parent; if preferred, the phantom level can be hidden from the list completely.
What happens if there are several alternative BOMs?
Each alternative (MAST-STLAL) is evaluated as a separate path and the alternative number is shown on the line. Showing only the alternatives used in a production version can be added as an optional filter.
Does the report work on S/4HANA?
Yes. STPO, STKO, MAST and AFPO keep the same structure in S/4HANA. For a clean core approach it can also be built on released CDS views for BOMs and production orders.
Related reports
Mass BOM Component Replacement Upload Program
A custom program that replaces, adds or deletes components or updates quantities in many material BOMs from Excel or CSV rows. Validity is set with a …
Production Order Missing Parts with Covering Purchase Order Report
A custom ALV report that shows the missing components of production orders, the shortage quantity and the open purchase order that will cover it, with …
Let us build this report for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.