Fabric Roll Stock and Aging Report by Storage Location
Short answer: A custom ALV report that lists every fabric roll (batch) in stock with its storage location, quality grade, shade and roll length, and splits the days since the last goods receipt and the stock value into age buckets. Rolls that have been waiting for a long time become visible early by quality and storage location and can be steered to sales or cutting.
- Estimated effort
- M · 5–7 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 shows stock and value per batch, but it does not calculate how long a roll has been waiting and does not list batch characteristics such as quality, shade or roll length. MSC3N shows characteristics for one batch at a time. Aging reports at material level cannot separate old and new rolls of the same fabric. The custom report combines stock, age, value and characteristics per roll in one list.
Who uses it? Fabric warehouse leads, planning and sales teams, inventory management and cost accounting.
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 per storage location (driving table) | — | ECC + S/4 |
| MCHABatches (Plant Level) | Batch data: last goods receipt date, valuation type | MCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARG | 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 control, standard and moving average price | MBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKS | 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, shade and roll length characteristic values | AUSP-OBJEK = INOB-CUOBJ | ECC + S/4 |
| CABNCharacteristics | Translation of the characteristic name to its internal number | CABN-ATINN = AUSP-ATINN | ECC + S/4 |
| T001LStorage Locations | Storage location description | T001L-WERKS = MCHB-WERKS AND T001L-LGORT = MCHB-LGORT | ECC + S/4 |
| I_StockQuantityCurrentValue_2Current Stock Quantity and Value | In S/4HANA it can be read for the current 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 | KM01 |
| S_MATNR | Material (fabric) | Range / multiple | MCHB-MATNR | No | KM-* |
| S_MTART | Material type | Range / multiple | MARA-MTART | No | FERT, HALB |
| P_ATQUA | Quality grade characteristic | Single value | CABN-ATNAM | No | QUALITY_GRADE |
| P_ATSHD | Shade characteristic | Single value | CABN-ATNAM | No | DYE_LOT |
| P_ATLEN | Roll length characteristic | Single value | CABN-ATNAM | No | ROLL_LENGTH |
| P_KEYDT | Key date for the age calculation (default: today) | Single value | — | Yes | 17.11.2026 |
| P_MINAGE | Minimum age (days) | Single value | — | No | 90 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Storage location | MCHB-LGORT |
| 2 | Storage location name | T001L-LGOBE |
| 3 | Material | MCHB-MATNR |
| 4 | Material description | MAKT-MAKTX |
| 5 | Roll (batch) | MCHB-CHARG |
| 6 | Quality grade | AUSP-ATWRT |
| 7 | Shade | AUSP-ATWRT |
| 8 | Roll length (m) | AUSP-ATFLV |
| 9 | Unrestricted stock | MCHB-CLABS |
| 10 | In quality inspection | MCHB-CINSM |
| 11 | Blocked | MCHB-CSPEM |
| 12 | Unit | MARA-MEINS |
| 13 | Last goods receipt | MCHA-LWEDT |
| 14 | Age (days) | Calculated Key date − last goods receipt date (otherwise batch creation date) |
| 15 | Age bucket | Calculated 0–30 / 31–90 / 91–180 / 181–365 / 365+ days |
| 16 | Stock value (local currency) | Calculated (CLABS + CINSM + CSPEM) × price / MBEW-PEINH; price is STPRS if VPRSV = S, otherwise VERPR |
Sample output
| Storage location | Storage location name | Material | Material description | Roll (batch) | Quality grade | Shade | Roll length (m) | Unrestricted stock | In quality inspection | Blocked | Unit | Last goods receipt | Age (days) | Age bucket | Stock value (local currency) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KM01 | Ham kumaş deposu | KM-PNY-220-LAC | Penye süprem 220 cm lacivert | T26050118 | 1 | BP-2605-03 | 210 | 210 | 0 | 0 | M | 05/12/2026 | 189 | 181–365 days | 23,940 |
| KM01 | Ham kumaş deposu | KM-SAT-150-SYH | Saten 150 cm siyah | T26090744 | 1 | BP-2609-15 | 185.50 | 185.50 | 0 | 0 | M | 09/22/2026 | 56 | 31–90 days | 17,437 |
| KM02 | Mamul kumaş deposu | KM-KTN-180-BEJ | Keten karışım 180 cm bej | T26020231 | 2 | BP-2602-08 | 64 | 0 | 0 | 64 | M | 02/09/2026 | 281 | 181–365 days | 6,272 |
| KM02 | Mamul kumaş deposu | KM-DNM-160-IND | Denim 160 cm indigo | T25100915 | 1 | BP-2510-21 | 120 | 120 | 0 | 0 | M | 10/03/2025 | 410 | 365+ days | 15,600 |
How does the report work?
- MCHB is read by plant, storage location and material; the material type is filtered from MARA. Batches whose unrestricted (CLABS), quality inspection (CINSM) and blocked (CSPEM) quantities add up to zero are dropped.
- The age of a roll starts at the last goods receipt date in MCHA (LWEDT); if it is empty, the batch creation date is used.
- Quality grade, shade and roll length are read via INOB, CABN and AUSP from the batch characteristics named on the selection screen.
- Stock value = total quantity × price from MBEW according to the price control (S: standard price, V: moving average price) divided by the price unit. With batch-level valuation, MBEW is read with the valuation type of the batch.
- Age = key date − age start, grouped into 0–30, 31–90, 91–180, 181–365 and 365+ day buckets.
- The ALV shows subtotals per storage location and age bucket; optionally only rolls older than a given number of days are shown.
Performance notes
Limit MCHB by plant and storage location and drop zero-stock lines in the SELECT. Read characteristic values once for the selected batches. In warehouses with many rolls, run the report in the background and distribute the result as Excel.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants
- Double-click drill-down to the document Double-clicking the batch opens MSC3N; double-clicking the material opens MB52 with the same selection.
- Export to Excel
- Runs as a background job
Authorization objects
- M_MATE_WRKMaterial display authorization by plant
- M_MSEG_WMBStock and goods movement display authorization by plant
Frequently asked questions
Does it work if rolls are tracked as handling units instead of batches?
Yes, with an adaptation. If the roll number is kept as a handling unit, stock and age are read via VEKP/VEPO while the characteristics still come from the batch. This adds about 2 days to the estimate.
From which date does the age start?
It starts from the last goods receipt date of the batch. If that date is empty, the batch creation date is used. Another batch date, such as the production date, can be chosen instead.
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 are taken from I_StockQuantityCurrentValue_2.
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, …
Physical Inventory Count Differences and Recount Analysis Report by Material and Storage Location
A custom ALV report that reads all physical inventory documents of a period and shows, per material and storage location, the difference quantity, the …
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.