What a SAP material master report shows
A SAP material master report lists your materials with their basic data (table MARA), descriptions (MAKT), plant and MRP data (MARC), valuation (MBEW) and sales data (MVKE), joined on the material number. PostNow.ai ships it as Material Master 360 in its Report Library: open it in Excel, set filters such as plant or material type, and run.
SAP shows a material one view at a time: basic data, MRP, purchasing, accounting and sales each sit on their own screens and in their own tables. A material master report puts them side by side, so you can check MRP types, price control and sales views across thousands of materials and every plant. This page covers reading and reporting material master data. To create materials from Excel, see mass create materials (MM01); to change them in bulk, see mass update material master (MM02).
SAP material master tables: MARA, MARC, MBEW and more
The PostNow.ai material master report reads the same SAP material master tables that MM03 displays. Each table holds one organisational level of the material, and its key tells you how many rows a material has there.
| Table | Level and key | What it holds | Typical fields |
|---|---|---|---|
MARA | General data, one row per material (MATNR) | Material type, material group, base unit, weights, old material number, client-level deletion flag, created on | MTART, MATKL, MEINS, BRGEW, BISMT, LVORM, ERSDA |
MAKT | Descriptions, one row per material and language (MATNR, SPRAS) | The material description | MAKTX |
MARC | Plant data, one row per material and plant (MATNR, WERKS) | MRP, purchasing and procurement settings, plant-level deletion flag | DISMM, DISPO, EKGRP, BESKZ, SOBSL, PLIFZ, LVORM |
MARD | Storage location data (MATNR, WERKS, LGORT) | Stock per storage location by stock type | LABST, INSME, SPEME |
MBEW | Valuation data (MATNR, BWKEY, plus BWTAR with split valuation) | Price control, prices, valuation class, total valuated stock and value | VPRSV, VERPR, STPRS, PEINH, BKLAS, SALK3 |
MVKE | Sales data (MATNR, VKORG, VTWEG) | Delivering plant, item category group, account assignment group, material groups 1 to 5 | DWERK, MTPOS, KTGRM, MVGR1 |
MARM, MLAN | Units of measure (MEINH); tax classification per country (ALAND) | Alternative units and conversion factors; tax indicators | UMREZ, UMREN, TAXM1 |
T023T, T134T, T001W | Texts and plants | Material group text, material type text, plant name | WGBEZ, MTBEZ, NAME1 |
- Rows multiply by level. A material in three plants has three
MARCrows; add two sales organisations fromMVKEand a report that joins both shows six rows for that material. That is correct data, not duplicates, so decide which level each row should represent before you count. - The material number is stored with leading zeros. A numeric material number such as 4711 is stored right-aligned with zeros in
MATNR(18 characters in ECC), so Excel lookups against an unpadded list miss. Alphanumeric numbers are stored as typed. - Stock is not in MARA. Quantities per storage location are in
MARD; total valuated stock and its value are inMBEW(LBKUM,SALK3). - The valuation area is usually the plant. When valuation is set at plant level,
MBEW-BWKEYequals the plant, soMBEWjoins toMARCon material and plant. With split valuation,MBEWalso has one row per valuation type (BWTAR). - There are two deletion flags.
MARA-LVORMflags the material for the whole client;MARC-LVORMflags it in one plant only.
Material master T-codes: MM03, MM60 and more
PostNow.ai gives you the list; SAP's material master T-codes give you one material, or one view, at a time. These are the transactions to display material master data in SAP, and what each one is good for.
| Transaction or report | What it shows | Use it for |
|---|---|---|
| PostNow.ai: Material Master 360 | Every material in your selection with basic, plant/MRP, valuation and sales data and the group, type and plant texts, in Excel | Lists, data reviews, audits, clean-up before a migration |
MM03 | Display material: one material, view by view, for the plant, storage location, valuation area or sales area you enter | Checking a single material in full |
MM60 | Materials List (program RMMVRZ00), selected by material, plant, material type and material group | A quick standard list of materials with their valuation data |
MM04 | Change documents for one material | Who changed which field, and when |
MMBE | Stock overview for one material across plants, storage locations and batches | Where a material's stock sits right now |
MB52 | Warehouse stocks: stock per material, plant and storage location as a list | Stock lists across many materials |
MM50 | List of extendable materials: materials not yet maintained for a view or organisational level | Finding missing plant, storage location or sales views |
SE16N / SQVI | One table, or a QuickViewer join you build yourself | Ad-hoc lists when you know the tables (see below) |
Is there one standard SAP material master report? Not one that covers every view. MM60 is the closest standard list, and it is built around plant and valuation data. A list that puts MRP, purchasing, valuation and sales views side by side is a join you build in SQVI or SAP Query, or a ready-made report.
Change history sits in the change document tables CDHDR and CDPOS under object class MATERIAL, with the material number as object ID. MM04 shows it for one material at a time. The PostNow.ai Change Documents / Audit Trail report in the Report Library reads those two tables, so you can filter on object class MATERIAL and list material changes, with old and new values, for many materials at once.
What a material master report should show
The PostNow.ai Material Master 360 report covers the columns most material reviews start with. The table lists the columns a complete material master report needs, the SAP field behind each, and where it comes from.
| Column | SAP field | Why it matters | In Material Master 360 |
|---|---|---|---|
| Material and description | MARA-MATNR, MAKT-MAKTX | Identifies the material | Yes |
| Material type and material group, with texts | MARA-MTART, MATKL, T134T-MTBEZ, T023T-WGBEZ | Which views and number range a material has; how it is grouped for purchasing and reporting | Yes |
| Base unit, weights, old material number | MARA-MEINS, BRGEW, NTGEW, GEWEI, BISMT | Units for every posting; the legacy number for matching after a migration | Yes |
| Deletion flag (client) | MARA-LVORM | Materials no longer to be used | Yes |
| Plant and plant name | MARC-WERKS, T001W-NAME1 | Where the material is maintained | Yes |
| MRP type and MRP controller | MARC-DISMM, DISPO | Whether and by whom the material is planned | Yes |
| Purchasing group, procurement type, special procurement, planned delivery time | MARC-EKGRP, BESKZ, SOBSL, PLIFZ | How the plant gets the material: made in-house or bought, and how long it takes | Yes |
| Valuation area, price control, moving average and standard price, price unit | MBEW-BWKEY, VPRSV, VERPR, STPRS, PEINH | How stock is valued in the plant | Yes |
| Sales organisation and material group 1 | MVKE-VKORG, MVGR1 | Where the material can be sold | Yes |
| Valuation class | MBEW-BKLAS | Which G/L accounts stock postings hit | Add in the SAP Query builder |
| Material status and plant deletion flag | MARA-MSTAE, MARC-MMSTA, MARC-LVORM | Materials blocked for some uses, or flagged in one plant | Add in the SAP Query builder |
| Stock per storage location | MARD-LABST, INSME, SPEME | Unrestricted, quality inspection and blocked stock | In the Stock Overview (Multi-Location) report |
To add the missing columns, a designer opens the report in the PostNow.ai SAP Query builder, adds the fields, and saves the result under My Reports, so the extended version is one click away next time.
Building it yourself: SE16N and SQVI
PostNow.ai replaces a routine most MM and master data teams know well: export several tables from SE16N, then match them in Excel. Here is what each SAP tool does and where it gets hard.
- SE16N shows one table at a time. Export
MARA,MARCandMBEWseparately, then match them in Excel on material, and on material and plant for the plant and valuation data. It needs table display authorization (S_TABU_DISorS_TABU_NAM), which many business users do not have. - SQVI QuickViewer joins tables in a small graphical editor and exports through the ALV list. A QuickViewer is stored for the user who built it; to share a query with a team, SAP Query (
SQ01) with a user group is the route. - Join MARC to MBEW on the plant.
MBEW-BWKEYholds the valuation area, which equals the plant when valuation is at plant level. JoiningMBEWon the material alone repeats every plant's price on every plant row. - Text tables need a language.
MAKT,T023TandT134Thold one row per language, so a self-built join should restrictSPRAS, or each material repeats once per language. - Join type decides who is missing. An inner join from
MARAtoMARCdrops materials that exist in no plant. Use a left outer join if they belong on the list.
For the general options to get SAP data into a spreadsheet (ALV export, SE16N, SQVI, SAP Query), see how to export SAP data to Excel.
The PostNow.ai Material Master 360 report
PostNow.ai ships the material master report ready-made in its Report Library, so nobody has to build the joins. Material Master 360 reads MARA, MAKT, MARC, MBEW, MVKE, T023T, T134T and T001W: plant data joined on the material, valuation data on the material and plant, and sales data on the material.
1. Open the report from the Report Library
In the PostNow.ai pane in Excel, open the Report Library and pick Material Master 360 from the MM reports. Designers and operators can both run library reports.
2. Set the filters
The report opens on the Filters step with ten range filters: material, material type, material group, plant, purchasing group, MRP controller, sales organisation, valuation area, deletion flag and created on. Leave a filter empty to include everything.
3. Run
PostNow.ai reads the eight tables through the SAP connection on your own computer and returns one grid with readable column headers such as Mat Type Desc, MRP Controller, Price Control and Plant Name. With the plant filter empty, materials without plant data stay on the list, because the joins are left outer joins.
The description and the material group and type texts come from MAKT, T023T and T134T, which keep one row per language (key SPRAS). If a material appears twice for the same plant and sales organisation, compare the description column: texts maintained in several languages show as one row each. A designer adds a filter on SPRAS with your logon language on the Filters step and saves the report under My Reports.
4. Read the analytics
Four figures sit above the data: Materials, Plants, Deletion-flagged and Material types, each counting distinct values. Three charts show materials by type, materials by plant and the top ten material groups.
5. Download to Excel
Choose Data only (formatted table with report header, filters and frozen header row), Data + Analytics (adds a dashboard sheet with KPI tiles and native Excel charts) or Data + Analytics + Pivot (adds a PivotTable and PivotChart with slicers), into a new workbook or a new sheet.
6. Re-run when you need fresh data
The Re-run this query button reads SAP again with the same filters. Save the report under My Reports to reopen it with your filters next month.
Related material reports. The same library has four more. Master Data Completeness Audit reads MARA, MAKT, MARC, MBEW and MVKE with created-by and changed-by stamps, and counts materials with No plant view, No valuation view and No sales view. Stock Overview (Multi-Location) lists MARD stock per storage location next to the MARC MRP data. Stock Valuation (Qty + Value) sums storage location stock per material and plant and joins the MBEW price and total value. Material Sales 360 lists the sales views with distribution channel, delivering plant, item category group and account assignment group. For stock movements, the goods movements report in Excel lists material documents with movement types.
The same approach for customers is in the SAP customer master report, built on KNA1, KNVV, KNVP and KNB1.
Worked example: finished goods with no MRP type in plant 1010
PostNow.ai answers this in one run. Before MRP goes live in plant 1010, the planning team wants every finished good there that has no MRP type, because MRP plans a material in a plant according to its MRP type.
- Open Material Master 360 and set Plant =
1010and Mat Type =FERT. A material sold through several sales organisations shows one row for each; the figures count each material once. - Run. The Materials figure shows how many finished goods plant 1010 has, and Plants shows 1.
- Sort the MRP Type column so the blanks come first. Material
FG-2040, for example, has a plant row and price controlS, but MRP Type and MRP Controller are blank: the plant was created through another view, and the MRP views were never maintained. - Check the Price Control column too. With valuation at plant level, a blank there means the material has no
MBEWrow for plant 1010, so its accounting view is missing as well. - Download with Data + Analytics and send the sheet to the team that owns material data. They set the MRP type in MM02, or for many materials in one pass with SAP mass change from Excel.
- Next week, open the saved report and re-run it. The blanks should be gone.
Filters: plant, material type, material group
In PostNow.ai, the ten filters of Material Master 360 decide how many rows you get, so set them for the question you are asking.
- Plant and valuation area. Plant picks the
MARCrows; valuation area picks theMBEWrows. Set Plant to one value to get one plant row per material. - Material type and material group. Narrow the list to raw materials (
ROH), finished goods (FERT), trading goods (HAWA) or one material group. - MRP controller and purchasing group. Give each planner or buyer the list of materials they are responsible for.
- Sales organisation. Sales data is joined on the material, so a material sold through several sales organisations repeats once for each on every plant row. Set one sales organisation to keep the list compact.
- Deletion flag and created on. Deletion Flag =
Xlists materials flagged at client level. A date range onMARA-ERSDAgives a monthly list of new materials for review.
Material master in S/4HANA
PostNow.ai runs the same material master report on ECC and S/4HANA, because S/4HANA keeps the material master tables and the MM01, MM02 and MM03 transactions. In SAP Fiori apps the material is called a product.
- The material number can be 40 characters. S/4HANA extends
MATNRto 40 characters (SAP Note 2267140, the material number field length extension). The longer number is switched on in Customizing (transactionOMSL); until then, material numbers keep 18 characters. - Stock quantities are calculated. In S/4HANA the inventory data model is based on the material document table
MATDOC(SAP Note 2206980). Reads onMARDgo through compatibility views that calculate the stock from material documents, so stock reports onMARDkeep working. - Moving from ECC? The ECC to S/4HANA migration guide compares system conversion, new implementation and selective data transition.