Yarn and Fabric Stock Report by Lot, Yarn Count, Quality and Brand
Short answer: 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.
- Estimated effort
- M · 5–8 working days
- System
- ECC and S/4HANA
- Tables
- 10
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
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.
Who uses it? Textile production planning, yarn and fabric purchasing, sales and warehouse 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) | Batch master: creation date | MCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARG | ECC + S/4 |
| INOBLink Between Internal Number and Object | Classification object number of the batch | INOB-OBTAB = 'MCH1' AND INOB-KLART = '023' AND INOB-OBJEK = MATNR + CHARG | ECC + S/4 |
| AUSPCharacteristic Values of Objects | Batch characteristic values: yarn count, quality, dye lot, brand | AUSP-OBJEK = INOB-CUOBJ AND AUSP-KLART = '023' | ECC + S/4 |
| CABNCharacteristics | Characteristic name, data type and unit | CABN-ATINN = AUSP-ATINN | ECC + S/4 |
| CAWNCharacteristic Value Definitions | Descriptions of characteristic values | CAWN-ATINN = AUSP-ATINN AND CAWN-ATWRT = AUSP-ATWRT | 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 |
| MBEWMaterial Valuation | Price for the stock value | MBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKS | ECC + S/4 |
| I_BatchBatch Information | In S/4HANA it can be read for batch master data with a clean core approach | Material = 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 | 0002 |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | ROH, HALB |
| S_MATNR | Material | Range / multiple | MCHB-MATNR | No | IP-3020 |
| S_ATNAM | Batch characteristics to show | Range / multiple | CABN-ATNAM | No | IPLIK_NUMARASI, KOMPOZISYON, KALITE, BOYA_LOTU, MARKA |
| S_ATWRT | Characteristic value filter | Range / multiple | AUSP-ATWRT | No | Ne 30/1 |
| P_SUBT | Subtotal characteristic | Single value | — | No | IPLIK_NUMARASI |
| P_NOZERO | Hide batches with zero stock | Checkbox | — | No | X |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | MCHB-WERKS |
| 2 | Storage location | MCHB-LGORT |
| 3 | Material | MCHB-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Batch (lot) | MCHB-CHARG |
| 6 | Yarn count | Calculated AUSP-ATWRT, characteristic IPLIK_NUMARASI |
| 7 | Composition | Calculated AUSP-ATWRT, characteristic KOMPOZISYON (with CAWN text) |
| 8 | Quality grade | Calculated AUSP-ATWRT, characteristic KALITE |
| 9 | Dye lot / shade | Calculated AUSP-ATWRT, characteristic BOYA_LOTU |
| 10 | Brand | Calculated AUSP-ATWRT, characteristic MARKA |
| 11 | Unrestricted stock | MCHB-CLABS |
| 12 | Quality inspection stock | MCHB-CINSM |
| 13 | Blocked stock | MCHB-CSPEM |
| 14 | Unit | MARA-MEINS |
| 15 | Stock value | Calculated (CLABS + CINSM + CSPEM) × MBEW price / price unit |
| 16 | Batch created on | MCHA-ERSDA |
Sample output
| Plant | Storage location | Material | Material description | Batch (lot) | Yarn count | Composition | Quality grade | Dye lot / shade | Brand | Unrestricted stock | Quality inspection stock | Blocked stock | Unit | Stock value | Batch created on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | 0002 | IP-3020 | Ne 30/1 penye pamuk ipliği | L2611-07 | Ne 30/1 | 100% cotton | A | Demo İplik | 4,200 | 0 | 0 | KG | 365,400 | 11/04/2026 | |
| 1000 | 0002 | IP-3020 | Ne 30/1 penye pamuk ipliği | L2610-19 | Ne 30/1 | 100% cotton | B | Demo İplik | 860 | 0 | 120 | KG | 85,260 | 10/21/2026 | |
| 1000 | 0004 | KM-5005 | Süprem kumaş 30/1 boyalı | F2611-02 | Ne 30/1 | 95% cotton 5% elastane | A | BL-0915 navy | Örnek Marka | 1,850 | 320 | 0 | KG | 412,650 | 11/08/2026 |
| 1000 | 0002 | IP-4010 | Nm 2/48 yün karışım iplik | L2609-30 | Nm 2/48 | 70% wool 30% acrylic | A | Demo İplik | 640 | 0 | 0 | KG | 140,800 | 09/30/2026 |
How does the report work?
- 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.
- 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).
- 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.
- 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.
- 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.
Performance notes
Read AUSP in bulk with the object numbers of the selected batches and only the internal numbers (ATINN) of the selected characteristics. With many batches, use one bulk SELECT instead of reading classification per batch with a function; this cuts the runtime considerably.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants Characteristic columns and subtotals are saved as a layout.
- Double-click drill-down to the document Double-clicking the batch opens the batch master in MSC3N.
- Export to Excel
- Runs as a background job
Authorization objects
- M_MATE_WRKMaterial and stock display authorization by plant
- C_TCLA_BKAClassification 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.
Related reports
Batch Shelf Life Tracking Report (Batches Close to Expiry)
A custom ALV report that lists batches close to or past their expiry date with remaining days, remaining shelf life percentage and stock value. Food, …
MB52 – List of Warehouse Stocks on Hand
MB52 is the standard SAP report (program RM07MLBS) that lists current material stocks per plant and storage location by stock type, together with …
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, …
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.