# Yarn and Fabric Stock Report by Lot, Yarn Count, Quality and Brand

> A custom ALV report that lists yarn and fabric stock at batch (lot) level together with batch classification values such as yarn count, composition, quality grade, dye lot and brand. Planning and sales teams add up stock of the same count and quality across lots, avoid mixing different lots and see which fabric is on hand in which quality in one list.

- Type: Report, Custom development, ALV report
- Module: MM
- Estimated effort: M (5–8 working days)
- Industry: Textile and Apparel
- Last updated: 2026-11-17
- URL: https://nekuhub.com/en/reports/yarn-and-fabric-stock-report-by-lot-count-and-quality/


## Why is the standard not enough?

MB52 and MMBE show stock at batch level but do not give batch classification values as columns, so stock cannot be filtered or totalled by yarn count or quality grade. MSC3N shows the characteristics of one batch and CL30N finds batches by classification; neither lists the stock quantity together with storage location and stock type. The custom report combines stock and batch characteristics on the same line and gives subtotals by the selected characteristic.

### Closest standard alternatives

- MB52: Lists stock per batch; does not show batch characteristics as columns.
- CL30N: Finds batches by classification values; shows no stock quantity or value.

## Tables used

| Table | Role | Access | Join | System |
|---|---|---|---|---|
| MCHB | Batch stock: unrestricted, quality inspection and blocked quantity (driving table) | Read | - | ECC + S/4 |
| MCHA | Batch master: creation date | Read | MCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARG | ECC + S/4 |
| INOB | Classification object number of the batch | Read | INOB-OBTAB = 'MCH1' AND INOB-KLART = '023' AND INOB-OBJEK = MATNR + CHARG | ECC + S/4 |
| AUSP | Batch characteristic values: yarn count, quality, dye lot, brand | Read | AUSP-OBJEK = INOB-CUOBJ AND AUSP-KLART = '023' | ECC + S/4 |
| CABN | Characteristic name, data type and unit | Read | CABN-ATINN = AUSP-ATINN | ECC + S/4 |
| CAWN | Descriptions of characteristic values | Read | CAWN-ATINN = AUSP-ATINN AND CAWN-ATWRT = AUSP-ATWRT | 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 |
| MBEW | Price for the stock value | Read | MBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKS | ECC + S/4 |
| I_Batch | In S/4HANA it can be read for batch master data with a clean core approach | Read | Material = 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_MTART | Material type | Range / multiple | MARA-MTART | No |
| S_MATNR | Material | Range / multiple | MCHB-MATNR | No |
| S_ATNAM | Batch characteristics to show | Range / multiple | CABN-ATNAM | No |
| S_ATWRT | Characteristic value filter | Range / multiple | AUSP-ATWRT | No |
| P_SUBT | Subtotal characteristic | Single value | - | No |
| P_NOZERO | Hide batches with zero stock | Checkbox | - | No |

## Output columns

| Column | Source |
|---|---|
| Plant | MCHB-WERKS |
| Storage location | MCHB-LGORT |
| Material | MCHB-MATNR |
| Material description | MAKT-MAKTX |
| Batch (lot) | MCHB-CHARG |
| Yarn count | Calculated: AUSP-ATWRT, characteristic IPLIK_NUMARASI |
| Composition | Calculated: AUSP-ATWRT, characteristic KOMPOZISYON (with CAWN text) |
| Quality grade | Calculated: AUSP-ATWRT, characteristic KALITE |
| Dye lot / shade | Calculated: AUSP-ATWRT, characteristic BOYA_LOTU |
| Brand | Calculated: AUSP-ATWRT, characteristic MARKA |
| Unrestricted stock | MCHB-CLABS |
| Quality inspection stock | MCHB-CINSM |
| Blocked stock | MCHB-CSPEM |
| Unit | MARA-MEINS |
| Stock value | Calculated: (CLABS + CINSM + CSPEM) × MBEW price / price unit |
| Batch created on | MCHA-ERSDA |

## How does the report work?

1. MCHB is read by plant, storage location, material and material type (yarn, greige fabric, finished fabric). Unrestricted, quality inspection and blocked stock are kept in separate columns; batches with zero stock can be left out.
2. The classification object of the batch is found in INOB (class type 023; OBTAB = MCH1 if batches are unique at material level, MCHA if at plant level).
3. The values of the selected characteristics are read from AUSP; CABN gives the characteristic name, data type and unit. Character values come from ATWRT, numeric values from ATFLV; the value text is added from CAWN.
4. The characteristics to show (yarn count, composition, quality grade, dye lot, brand) are entered on the selection screen by characteristic name; the report turns them into dynamic ALV columns and filters by characteristic value.
5. The stock value is calculated with the price from MBEW, and the batch creation date comes from MCHA. The ALV gives subtotals by the selected characteristic.

## Authorization objects

- M_MATE_WRK: Material and stock display authorization by plant
- C_TCLA_BKA: Classification display authorization by class type

## Frequently asked questions

### Which batch characteristics can be shown?

Any characteristic defined in the batch class (class type 023) can be shown. Characteristics are picked by name on the selection screen; frequently used combinations are stored as variants and ALV layouts.

### Can different lots of the same yarn count be totalled?

Yes. When yarn count is chosen as the subtotal characteristic, the ALV gives the total stock per count while the lots remain separate lines below. Planning sees the total quantity and the warehouse does not mix lots.

### Does it work on S/4HANA?

Yes. MCHB is still read as a compatibility view in S/4HANA and batch classification stays in AUSP. For clean core, stock can be read from I_MaterialStock_2 and batch data from I_Batch.

---
Let us build this report for your system: https://nekuhub.com/en/request-a-quote/?report=mm-yarn-fabric-stock-by-lot
