# Stock Quantity and Value by Quality Grade (First and Second Quality) Report

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

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: S (4–5 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/stock-quantity-and-value-by-quality-grade-report/


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

### Closest standard alternatives

- MB52: Lists stock with batch and value; there is no grouping by quality grade and no write-down calculation.
- MC.9: Gives a stock analysis at material level; it does not split by batch characteristic.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MCHB | Batch stock: unrestricted, quality inspection and blocked quantity (driving table) | Read | - | ECC + S/4 |
| MCHA | Valuation type of the batch (split valuation by quality) | Read | MCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARG | ECC + S/4 |
| MBEW | Price control, standard and moving average price | Read | MBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKS AND MBEW-BWTAR = MCHA-BWTAR | ECC + S/4 |
| INOB | Link between batch and classification object | Read | INOB-OBJEK = parti nesne anahtarı AND INOB-KLART = '023' | ECC + S/4 |
| AUSP | Quality grade characteristic value | Read | AUSP-OBJEK = INOB-CUOBJ AND AUSP-ATINN = CABN-ATINN | ECC + S/4 |
| CABN | Translation of the characteristic name to its internal number | Read | CABN-ATNAM = P_ATNAM | ECC + S/4 |
| MARA | Material type and base unit of measure | Read | MARA-MATNR = MCHB-MATNR | ECC + S/4 |
| MAKT | Material description | Read | MAKT-MATNR = MCHB-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| I_StockQuantityCurrentValue_2 | In S/4HANA it can be read for stock quantity and value with a clean core approach | Read | Product = MCHB-MATNR AND Batch = MCHB-CHARG | S/4HANA only |

## Selection screen parameters

| Parameter | Description | Type | Reference field | Required |
|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | MCHB-WERKS | Yes |
| 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 |
| R_CHAR | Quality source: batch characteristic | Radio button | - | No |
| R_BWTAR | Quality source: valuation type | Radio button | - | No |
| P_ATNAM | Quality grade characteristic | Single value | CABN-ATNAM | No |
| P_PCT2 | Second quality realizable rate (%) | Single value | - | No |
| P_PCT3 | Third quality and below realizable rate (%) | Single value | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | MCHB-WERKS |
| Material | MCHB-MATNR |
| Material description | MAKT-MAKTX |
| Quality grade | Calculated: AUSP-ATWRT (characteristic) or MCHA-BWTAR (valuation type) |
| Number of batches | Calculated: Number of batches with stock in the grade |
| Unrestricted stock | Calculated: Σ MCHB-CLABS |
| Blocked and in inspection | Calculated: Σ MCHB-CSPEM + MCHB-CINSM |
| Unit | MARA-MEINS |
| Unit price | Calculated: MBEW-STPRS if VPRSV = S, otherwise MBEW-VERPR; / MBEW-PEINH |
| Book value | Calculated: Total quantity × unit price |
| Realizable rate % | Calculated: First quality 100; others the rate on the selection screen |
| Write-down needed | Calculated: max(0, book value − book value × realizable rate) |
| Lower quality share % | Calculated: Quantity other than first quality / total quantity × 100 for the material |

## How does the report work?

1. Batch stock in the selected plant, storage location and material type is read from MCHB.
2. 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.
3. 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.
4. 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%).
5. 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.
6. The ALV shows subtotals by material and quality grade; for each material the share of lower quality in total stock is shown.

## Authorization objects

- M_MATE_WRK: Material display authorization by plant
- M_MSEG_WMB: Stock 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.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=textile-quality-grade-stock-valuation
