MM Report Custom development ALV report

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

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

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
MARAGeneral Material DataGeneral material data: type, group, overall maintenance status (driving table)—ECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MARA-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MARCPlant Data for MaterialPlant data: maintenance status, MRP typeMARC-MATNR = MARA-MATNRECC + S/4
T001WPlants/BranchesTarget plant name and valuation areaT001W-WERKS = MARC-WERKSECC + S/4
MBEWMaterial ValuationAccounting view: valuation class and price controlMBEW-MATNR = MARA-MATNR AND MBEW-BWKEY = T001W-BWKEYECC + S/4
MARDStorage Location Data for MaterialStorage location viewMARD-MATNR = MARA-MATNR AND MARD-WERKS = T001W-WERKSECC + S/4
MVKESales Data for MaterialSales organization viewMVKE-MATNR = MARA-MATNRECC + S/4
I_ProductPlantBasicProduct PlantCDS view that can replace MARC in S/4HANAProduct = MARA-MATNR AND Plant = MARC-WERKSS/4HANA only
I_ProductValuationBasicProduct ValuationCan replace MBEW in S/4HANAProduct = MARA-MATNR AND ValuationArea = T001W-BWKEYS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_MTARTMaterial typeRange / multipleMARA-MTARTYesROH, FERT
S_MATNRMaterialRange / multipleMARA-MATNRNoRM-*
S_MATKLMaterial groupRange / multipleMARA-MATKLNo01
S_WERKSTarget plantsRange / multipleMARC-WERKSYes1000, 2000, 3000
P_LGORTStorage location to checkSingle valueMARD-LGORTNo0001
P_VKORGSales organization to checkSingle valueMVKE-VKORGNo1000
P_VTWEGDistribution channelSingle valueMVKE-VTWEGNo10
P_NOLVMExclude materials flagged for deletionCheckbox—NoX
P_ONLYMOnly rows with a missing viewCheckbox—NoX

Output columns

#ColumnSource
1MaterialMARA-MATNR
2Material descriptionMAKT-MAKTX
3Material typeMARA-MTART
4Material groupMARA-MATKL
5PlantT001W-WERKS
6Plant nameT001W-NAME1
7Overall maint. statusMARA-PSTAT
8Plant maint. statusMARC-PSTAT
9PurchasingCalculated ✓ if MARC-PSTAT contains 'E', otherwise missing
10MRPCalculated ✓ if MARC-PSTAT contains 'D' and MARC-DISMM is filled
11AccountingCalculated ✓ if an MBEW record exists and MBEW-BKLAS is filled
12StorageCalculated ✓ if an MARD record exists for the target storage location
13SalesCalculated ✓ if an MVKE record exists for the target sales organization/channel
14Valuation classMBEW-BKLAS
15Missing viewsCalculated Number of views marked missing

Sample output

MaterialMaterial descriptionMaterial typeMaterial groupPlantPlant nameOverall maint. statusPlant maint. statusPurchasingMRPAccountingStorageSalesValuation classMissing views
RM-1001Carton box 40x30ROH013000Konya PlantKEDBLKE✓MissingMissing✓—2
RM-2040Steel sheet 2 mmROH032000Bursa PlantKEDBLKEDBL✓✓✓Missing—30001
FG-5003Packed product CFERT103000Konya PlantKVEDBLGMissingMissingMissingMissing✓4
FG-5010Packed product DFERT102000Bursa PlantKVEDBLGVEDBLG✓✓✓✓Missing79201
A view built with fictional sample data; not real system data.

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.

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

CA Package Custom

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 …

5 components · v1.0

Related reports

MM Report Custom ALV report

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 …

CDHDR · CDPOS · MARA · MAKT

MM Program Custom Mass upload

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 …

MARA · MAKT · MARC · MBEW

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.

Related report: Materials Missing Required Views by Plant Report (S/4HANA Migration Check)