Stock Quantity and Value by Quality Grade (First and Second Quality) Report
Short answer: A custom ALV report that splits fabric and finished goods stock by quality grade (first, second, third quality) read from a batch characteristic or the valuation type, shows the quantity and book value of each grade and estimates the write-down needed for second and lower quality stock. Second quality stock is tracked separately and period-end valuation is prepared with figures.
- Estimated effort
- S · 4–5 working days
- System
- ECC and S/4HANA
- Tables
- 9
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
MB52 lists stock with batch and value and MC.9 gives a stock analysis at material level, but neither uses the quality grade as a grouping criterion or calculates realizable value and write-down for second quality stock that is valued at the same price. The custom report gives quantity, value and estimated write-down by quality grade in one list.
Who uses it? Cost and general accounting, inventory management, sales (stock clearance) and quality teams.
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 |
|---|---|---|---|
| MCHBBatch Stocks | Batch stock: unrestricted, quality inspection and blocked quantity (driving table) | — | ECC + S/4 |
| MCHABatches (Plant Level) | Valuation type of the batch (split valuation by quality) | MCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARG | ECC + S/4 |
| MBEWMaterial Valuation | Price control, standard and moving average price | MBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKS AND MBEW-BWTAR = MCHA-BWTAR | ECC + S/4 |
| INOBLink Between Internal Number and Object | Link between batch and classification object | INOB-OBJEK = parti nesne anahtarı AND INOB-KLART = '023' | ECC + S/4 |
| AUSPCharacteristic Values of Objects | Quality grade characteristic value | AUSP-OBJEK = INOB-CUOBJ AND AUSP-ATINN = CABN-ATINN | ECC + S/4 |
| CABNCharacteristics | Translation of the characteristic name to its internal number | CABN-ATNAM = P_ATNAM | ECC + S/4 |
| MARAGeneral Material Data | Material type and base unit of measure | MARA-MATNR = MCHB-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Material description | MAKT-MATNR = MCHB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_StockQuantityCurrentValue_2Current Stock Quantity and Value | In S/4HANA it can be read for stock quantity and value with a clean core approach | Product = MCHB-MATNR AND Batch = MCHB-CHARG | S/4HANA only |
S/4HANA notes
- MCHB → MATDOC: In S/4HANA batch stock quantities are calculated from MATDOC through a compatibility view; reads work, but test performance on large selections.
- 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.
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MCHB-WERKS | Yes | 1000 |
| S_LGORT | Storage location | Range / multiple | MCHB-LGORT | No | — |
| S_MATNR | Material | Range / multiple | MCHB-MATNR | No | — |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | FERT, HALB |
| R_CHAR | Quality source: batch characteristic | Radio button | — | No | X |
| R_BWTAR | Quality source: valuation type | Radio button | — | No | — |
| P_ATNAM | Quality grade characteristic | Single value | CABN-ATNAM | No | QUALITY_GRADE |
| P_PCT2 | Second quality realizable rate (%) | Single value | — | No | 70 |
| P_PCT3 | Third quality and below realizable rate (%) | Single value | — | No | 40 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | MCHB-WERKS |
| 2 | Material | MCHB-MATNR |
| 3 | Material description | MAKT-MAKTX |
| 4 | Quality grade | Calculated AUSP-ATWRT (characteristic) or MCHA-BWTAR (valuation type) |
| 5 | Number of batches | Calculated Number of batches with stock in the grade |
| 6 | Unrestricted stock | Calculated Σ MCHB-CLABS |
| 7 | Blocked and in inspection | Calculated Σ MCHB-CSPEM + MCHB-CINSM |
| 8 | Unit | MARA-MEINS |
| 9 | Unit price | Calculated MBEW-STPRS if VPRSV = S, otherwise MBEW-VERPR; / MBEW-PEINH |
| 10 | Book value | Calculated Total quantity × unit price |
| 11 | Realizable rate % | Calculated First quality 100; others the rate on the selection screen |
| 12 | Write-down needed | Calculated max(0, book value − book value × realizable rate) |
| 13 | Lower quality share % | Calculated Quantity other than first quality / total quantity × 100 for the material |
Sample output
| Plant | Material | Material description | Quality grade | Number of batches | Unrestricted stock | Blocked and in inspection | Unit | Unit price | Book value | Realizable rate % | Write-down needed | Lower quality share % |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | KM-PNY-220-LAC | Penye süprem 220 cm lacivert | 1 | 42 | 8,640 | 0 | M | 114 | 984,960 | 100 | 0 | 9.40 |
| 1000 | KM-PNY-220-LAC | Penye süprem 220 cm lacivert | 2 | 7 | 742 | 156 | M | 114 | 102,372 | 70 | 30,712 | 9.40 |
| 1000 | GM-TSH-BSC-M | Basic tişört M beyaz | 1 | 18 | 12,400 | 0 | ST | 96 | 1,190,400 | 100 | 0 | 5.30 |
| 1000 | GM-TSH-BSC-M | Basic tişört M beyaz | 3 | 4 | 0 | 690 | ST | 96 | 66,240 | 40 | 39,744 | 5.30 |
How does the report work?
- Batch stock in the selected plant, storage location and material type is read from MCHB.
- Depending on the selection, the quality grade comes from one of two sources: (a) the quality characteristic in batch classification (INOB, CABN, AUSP); (b) the valuation type of the batch (MCHA-BWTAR) when split valuation by quality is used.
- The unit price is read from MBEW by material, valuation area and, if any, valuation type; with price control S the standard price, with V the moving average price, divided by the price unit.
- Book value = quantity × unit price. For each lower quality grade a realizable rate is given on the selection screen (for example second quality 70%, third quality 40%).
- Write-down needed = book value − book value × realizable rate; if negative it is set to zero. With split valuation, if the lower grade is already valued at a lower price, this column is for information only.
- The ALV shows subtotals by material and quality grade; for each material the share of lower quality in total stock is shown.
Performance notes
Limit MCHB by plant and material type and drop zero-stock lines. Read the quality characteristic once for the selected batches. Read MBEW with the material, valuation area and valuation type key via FOR ALL ENTRIES.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking a line shows the related batches; double-clicking a batch opens MSC3N.
- Export to Excel
- Runs as a background job
Authorization objects
- M_MATE_WRKMaterial display authorization by plant
- M_MSEG_WMBStock display authorization by plant
Frequently asked questions
Does the report post the write-down to accounting?
No. The report only estimates the need. Posting is done according to the company's method, either with a price change (MR21) or with a manual journal entry; the amounts in the report can serve as the basis for that posting.
What if second quality is kept under a separate material number?
In that case the quality grade is read from a suffix in the material number or from material classification and matched with the first quality material. This adds 1–2 days to the estimate.
Does it work on S/4HANA?
Yes. MCHB and MBEW can be read as compatibility views in S/4HANA; if clean core is preferred, stock and value come from I_StockQuantityCurrentValue_2.
Related reports
Material Ledger Price Differences by Plant Report
A custom ALV report that shows the standard price, periodic unit price and price differences from the material ledger for all materials and plants in …
Stock Aging Report
A custom ALV report that shows how many days each material has been in stock since its last goods receipt and which age bucket (0–30, 31–90, 91–180, …
Blocked Stock Left from Rejected Usage Decisions Report
A custom ALV report that lists the quantities rejected at the usage decision and posted to blocked stock that are still sitting in blocked stock, 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.