MM Report Custom development ALV report Textile and Apparel

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

  • MB52 List of Warehouse Stocks on Hand. Lists stock and value per batch; it does not calculate age or show quality, shade and roll length characteristics.
  • MSC3N Display Batch. Shows the characteristics of one batch; there is no warehouse-wide list or age bucket.

Tables used

The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.

TableRoleJoinSystem
MCHBBatch StocksBatch 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 typeMCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARGECC + S/4
MARAGeneral Material DataMaterial type and base unit of measureMARA-MATNR = MCHB-MATNRECC + S/4
MAKTMaterial DescriptionsMaterial descriptionMAKT-MATNR = MCHB-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MBEWMaterial ValuationPrice control, standard and moving average priceMBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKSECC + S/4
INOBLink Between Internal Number and ObjectLink between batch and classification objectINOB-OBJEK = parti nesne anahtarı AND INOB-KLART = '023'ECC + S/4
AUSPCharacteristic Values of ObjectsQuality grade, shade and roll length characteristic valuesAUSP-OBJEK = INOB-CUOBJECC + S/4
CABNCharacteristicsTranslation of the characteristic name to its internal numberCABN-ATINN = AUSP-ATINNECC + S/4
T001LStorage LocationsStorage location descriptionT001L-WERKS = MCHB-WERKS AND T001L-LGORT = MCHB-LGORTECC + S/4
I_StockQuantityCurrentValue_2Current Stock Quantity and ValueIn S/4HANA it can be read for the current stock quantity and value with a clean core approachProduct = MCHB-MATNR AND Batch = MCHB-CHARGS/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

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleMCHB-WERKSYes1000
S_LGORTStorage locationRange / multipleMCHB-LGORTNoKM01
S_MATNRMaterial (fabric)Range / multipleMCHB-MATNRNoKM-*
S_MTARTMaterial typeRange / multipleMARA-MTARTNoFERT, HALB
P_ATQUAQuality grade characteristicSingle valueCABN-ATNAMNoQUALITY_GRADE
P_ATSHDShade characteristicSingle valueCABN-ATNAMNoDYE_LOT
P_ATLENRoll length characteristicSingle valueCABN-ATNAMNoROLL_LENGTH
P_KEYDTKey date for the age calculation (default: today)Single value—Yes17.11.2026
P_MINAGEMinimum age (days)Single value—No90

Output columns

#ColumnSource
1Storage locationMCHB-LGORT
2Storage location nameT001L-LGOBE
3MaterialMCHB-MATNR
4Material descriptionMAKT-MAKTX
5Roll (batch)MCHB-CHARG
6Quality gradeAUSP-ATWRT
7ShadeAUSP-ATWRT
8Roll length (m)AUSP-ATFLV
9Unrestricted stockMCHB-CLABS
10In quality inspectionMCHB-CINSM
11BlockedMCHB-CSPEM
12UnitMARA-MEINS
13Last goods receiptMCHA-LWEDT
14Age (days)Calculated Key date − last goods receipt date (otherwise batch creation date)
15Age bucketCalculated 0–30 / 31–90 / 91–180 / 181–365 / 365+ days
16Stock value (local currency)Calculated (CLABS + CINSM + CSPEM) × price / MBEW-PEINH; price is STPRS if VPRSV = S, otherwise VERPR

Sample output

Storage locationStorage location nameMaterialMaterial descriptionRoll (batch)Quality gradeShadeRoll length (m)Unrestricted stockIn quality inspectionBlockedUnitLast goods receiptAge (days)Age bucketStock value (local currency)
KM01Ham kumaş deposuKM-PNY-220-LACPenye süprem 220 cm lacivertT260501181BP-2605-0321021000M05/12/2026189181–365 days23,940
KM01Ham kumaş deposuKM-SAT-150-SYHSaten 150 cm siyahT260907441BP-2609-15185.50185.5000M09/22/20265631–90 days17,437
KM02Mamul kumaş deposuKM-KTN-180-BEJKeten karışım 180 cm bejT260202312BP-2602-08640064M02/09/2026281181–365 days6,272
KM02Mamul kumaş deposuKM-DNM-160-INDDenim 160 cm indigoT251009151BP-2510-2112012000M10/03/2025410365+ days15,600
A view built with fictional sample data; not real system data.

How does the report work?

  1. 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.
  2. 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.
  3. Quality grade, shade and roll length are read via INOB, CABN and AUSP from the batch characteristics named on the selection screen.
  4. 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.
  5. Age = key date − age start, grouped into 0–30, 31–90, 91–180, 181–365 and 365+ day buckets.
  6. 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

MM Report Custom ALV report ChemicalsFood and Beverage

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, …

MCHB · MCHA · MARA · MAKT

MM Report Custom ALV report

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, …

MARD · MARA · MAKT · MBEW

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.

Related report: Fabric Roll Stock and Aging Report by Storage Location