Materials Missing Required Views by Plant Report (S/4HANA Migration Check)
Short answer: A custom ALV report that shows, on one row per material and plant, which of the purchasing, MRP, accounting, storage and sales views are missing for the selected material types and target plants. Master data teams close missing views from a single list when a new plant goes live or before an S/4HANA migration.
- Estimated effort
- M · 3–5 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MM60 lists the materials that exist in a plant but does not show missing views. MM50 finds extendable materials, but it does not check a mandatory-view rule per material type, several target plants and sales organizations, and gaps in critical fields such as the valuation class in the same list. The custom report gives the view gaps as a material × plant matrix and makes data quality measurable before a migration.
Who uses it? Material master data teams, S/4HANA migration teams, purchasing and cost accounting.
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 |
|---|---|---|---|
| MARAGeneral Material Data | General material data: type, group, overall maintenance status (driving table) | — | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MARA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MARCPlant Data for Material | Plant data: maintenance status, MRP type | MARC-MATNR = MARA-MATNR | ECC + S/4 |
| T001WPlants/Branches | Target plant name and valuation area | T001W-WERKS = MARC-WERKS | ECC + S/4 |
| MBEWMaterial Valuation | Accounting view: valuation class and price control | MBEW-MATNR = MARA-MATNR AND MBEW-BWKEY = T001W-BWKEY | ECC + S/4 |
| MARDStorage Location Data for Material | Storage location view | MARD-MATNR = MARA-MATNR AND MARD-WERKS = T001W-WERKS | ECC + S/4 |
| MVKESales Data for Material | Sales organization view | MVKE-MATNR = MARA-MATNR | ECC + S/4 |
| I_ProductPlantBasicProduct Plant | CDS view that can replace MARC in S/4HANA | Product = MARA-MATNR AND Plant = MARC-WERKS | S/4HANA only |
| I_ProductValuationBasicProduct Valuation | Can replace MBEW in S/4HANA | Product = MARA-MATNR AND ValuationArea = T001W-BWKEY | S/4HANA only |
S/4HANA notes
- MBEW: In S/4HANA the Material Ledger is mandatory and valuation data is read through a compatibility view. Prices remain readable; validate value calculations against the currency and valuation view in use.
- MARD → MATDOC: In S/4HANA stock quantities are no longer stored physically; reading MARD returns values calculated on the fly from MATDOC through a compatibility view. Reads still work, but test performance on very large selections.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_MTART | Material type | Range / multiple | MARA-MTART | Yes | ROH, FERT |
| S_MATNR | Material | Range / multiple | MARA-MATNR | No | RM-* |
| S_MATKL | Material group | Range / multiple | MARA-MATKL | No | 01 |
| S_WERKS | Target plants | Range / multiple | MARC-WERKS | Yes | 1000, 2000, 3000 |
| P_LGORT | Storage location to check | Single value | MARD-LGORT | No | 0001 |
| P_VKORG | Sales organization to check | Single value | MVKE-VKORG | No | 1000 |
| P_VTWEG | Distribution channel | Single value | MVKE-VTWEG | No | 10 |
| P_NOLVM | Exclude materials flagged for deletion | Checkbox | — | No | X |
| P_ONLYM | Only rows with a missing view | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Material | MARA-MATNR |
| 2 | Material description | MAKT-MAKTX |
| 3 | Material type | MARA-MTART |
| 4 | Material group | MARA-MATKL |
| 5 | Plant | T001W-WERKS |
| 6 | Plant name | T001W-NAME1 |
| 7 | Overall maint. status | MARA-PSTAT |
| 8 | Plant maint. status | MARC-PSTAT |
| 9 | Purchasing | Calculated ✓ if MARC-PSTAT contains 'E', otherwise missing |
| 10 | MRP | Calculated ✓ if MARC-PSTAT contains 'D' and MARC-DISMM is filled |
| 11 | Accounting | Calculated ✓ if an MBEW record exists and MBEW-BKLAS is filled |
| 12 | Storage | Calculated ✓ if an MARD record exists for the target storage location |
| 13 | Sales | Calculated ✓ if an MVKE record exists for the target sales organization/channel |
| 14 | Valuation class | MBEW-BKLAS |
| 15 | Missing views | Calculated Number of views marked missing |
Sample output
| Material | Material description | Material type | Material group | Plant | Plant name | Overall maint. status | Plant maint. status | Purchasing | MRP | Accounting | Storage | Sales | Valuation class | Missing views |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RM-1001 | Carton box 40x30 | ROH | 01 | 3000 | Konya Plant | KEDBL | KE | ✓ | Missing | Missing | ✓ | — | 2 | |
| RM-2040 | Steel sheet 2 mm | ROH | 03 | 2000 | Bursa Plant | KEDBL | KEDBL | ✓ | ✓ | ✓ | Missing | — | 3000 | 1 |
| FG-5003 | Packed product C | FERT | 10 | 3000 | Konya Plant | KVEDBLG | Missing | Missing | Missing | Missing | ✓ | 4 | ||
| FG-5010 | Packed product D | FERT | 10 | 2000 | Bursa Plant | KVEDBLG | VEDBLG | ✓ | ✓ | ✓ | ✓ | Missing | 7920 | 1 |
How does the report work?
- MARA is read by material type, material and material group; depending on the selection, materials flagged for deletion (LVORM) are skipped.
- Each material is paired with each target plant. If no MARC record exists, “plant data missing” is shown.
- The maintenance status letters in MARC-PSTAT are checked: without E the purchasing view is missing, without D the MRP view; if D exists but MARC-DISMM is blank, the MRP type is flagged as missing.
- MBEW is looked up via T001W-BWKEY; without a record the accounting view is missing, and an empty BKLAS is flagged separately. MARD is checked for the target storage location and MVKE for the target sales organization/distribution channel.
- The number of missing views is calculated; with “missing only” selected, rows with zero are skipped. The ALV totals the missing count per plant.
Performance notes
Restrict MARA by material type. Read MARC, MBEW, MARD and MVKE once each via FOR ALL ENTRIES for the selected materials and match them in sorted internal tables with BINARY SEARCH. With hundreds of thousands of materials, run it in the background.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the material opens the MM01 extension screen for that plant.
- Export to Excel The missing list can be downloaded as Excel in the layout of the mass material upload template.
- Runs as a background job
Authorization objects
- M_MATE_MARDisplay authorization by material type
- M_MATE_WRKMaterial authorization by plant
- M_MATE_STAAuthorization by maintenance status (view); checked when jumping to MM01
Frequently asked questions
How is it decided which view is mandatory?
By default the rule comes from the targets on the selection screen: if a plant, storage location and sales organization are given, the related view is checked. If needed, mandatory views per material type are kept in a maintenance table; for example, no sales view is expected for raw materials.
Why is this check important for an S/4HANA migration?
During migrations and new plant go-lives, a missing accounting or MRP view causes errors at the first goods movement and MRP run. The report shows the gaps as numbers before the migration rehearsal and lets the team track cleansing progress.
Can missing views be completed directly from the report?
The report only reads. The missing list can be exported to Excel and completed with the mass material upload program via BAPI_MATERIAL_SAVEDATA; for single fixes there is a jump to MM01.
Packages that include this solution
S/4HANA Conversion Readiness Pack
A five-component pack that finds the master data and finance inconsistencies to clean up before a system conversion from ECC to S/4HANA: business …
Related reports
Material Master Change Log Report by Field and User
A custom ALV report that lists material master changes for many materials by date, user, transaction, table and field, with old and new values. In an …
Mass Material Master Upload Program
A custom program that creates or updates material master data in bulk from Excel or CSV rows, including the basic data, plant and valuation views. It …
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.