# Materials Missing Required Views by Plant Report (S/4HANA Migration Check)

> 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.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (3–5 working days)
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/materials-missing-views-by-plant-report/


## 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.

### Closest standard alternatives

- MM50: Lists extendable materials; no mandatory-view rule per material type and no multi-target check.
- MM60: Lists the materials in a plant; does not show which view is missing.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MARA | General material data: type, group, overall maintenance status (driving table) | Read | - | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MARA-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MARC | Plant data: maintenance status, MRP type | Read | MARC-MATNR = MARA-MATNR | ECC + S/4 |
| T001W | Target plant name and valuation area | Read | T001W-WERKS = MARC-WERKS | ECC + S/4 |
| MBEW | Accounting view: valuation class and price control | Read | MBEW-MATNR = MARA-MATNR AND MBEW-BWKEY = T001W-BWKEY | ECC + S/4 |
| MARD | Storage location view | Read | MARD-MATNR = MARA-MATNR AND MARD-WERKS = T001W-WERKS | ECC + S/4 |
| MVKE | Sales organization view | Read | MVKE-MATNR = MARA-MATNR | ECC + S/4 |
| I_ProductPlantBasic | CDS view that can replace MARC in S/4HANA | Read | Product = MARA-MATNR AND Plant = MARC-WERKS | S/4HANA only |
| I_ProductValuationBasic | Can replace MBEW in S/4HANA | Read | Product = MARA-MATNR AND ValuationArea = T001W-BWKEY | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_MTART | Material type | Range / multiple | MARA-MTART | Yes |
| S_MATNR | Material | Range / multiple | MARA-MATNR | No |
| S_MATKL | Material group | Range / multiple | MARA-MATKL | No |
| S_WERKS | Target plants | Range / multiple | MARC-WERKS | Yes |
| P_LGORT | Storage location to check | Single value | MARD-LGORT | No |
| P_VKORG | Sales organization to check | Single value | MVKE-VKORG | No |
| P_VTWEG | Distribution channel | Single value | MVKE-VTWEG | No |
| P_NOLVM | Exclude materials flagged for deletion | Checkbox | - | No |
| P_ONLYM | Only rows with a missing view | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Material | MARA-MATNR |
| Material description | MAKT-MAKTX |
| Material type | MARA-MTART |
| Material group | MARA-MATKL |
| Plant | T001W-WERKS |
| Plant name | T001W-NAME1 |
| Overall maint. status | MARA-PSTAT |
| Plant maint. status | MARC-PSTAT |
| Purchasing | Calculated: ✓ if MARC-PSTAT contains 'E', otherwise missing |
| MRP | Calculated: ✓ if MARC-PSTAT contains 'D' and MARC-DISMM is filled |
| Accounting | Calculated: ✓ if an MBEW record exists and MBEW-BKLAS is filled |
| Storage | Calculated: ✓ if an MARD record exists for the target storage location |
| Sales | Calculated: ✓ if an MVKE record exists for the target sales organization/channel |
| Valuation class | MBEW-BKLAS |
| Missing views | Calculated: Number of views marked missing |

## How does the report work?

1. MARA is read by material type, material and material group; depending on the selection, materials flagged for deletion (LVORM) are skipped.
2. Each material is paired with each target plant. If no MARC record exists, "plant data missing" is shown.
3. 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.
4. 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.
5. The number of missing views is calculated; with "missing only" selected, rows with zero are skipped. The ALV totals the missing count per plant.

## Authorization objects

- M_MATE_MAR: Display authorization by material type
- M_MATE_WRK: Material authorization by plant
- M_MATE_STA: Authorization 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-materials-missing-views-by-plant
