MM Report Custom development ALV report Textile and Apparel

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

  • MB52 List of Warehouse Stocks on Hand. Lists stock per batch; does not show batch characteristics as columns.
  • CL30N Find Objects in Classes. Finds batches by classification values; shows no stock quantity or value.

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 (driving table)—ECC + S/4
MCHABatches (Plant Level)Batch master: creation dateMCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARGECC + S/4
INOBLink Between Internal Number and ObjectClassification object number of the batchINOB-OBTAB = 'MCH1' AND INOB-KLART = '023' AND INOB-OBJEK = MATNR + CHARGECC + S/4
AUSPCharacteristic Values of ObjectsBatch characteristic values: yarn count, quality, dye lot, brandAUSP-OBJEK = INOB-CUOBJ AND AUSP-KLART = '023'ECC + S/4
CABNCharacteristicsCharacteristic name, data type and unitCABN-ATINN = AUSP-ATINNECC + S/4
CAWNCharacteristic Value DefinitionsDescriptions of characteristic valuesCAWN-ATINN = AUSP-ATINN AND CAWN-ATWRT = AUSP-ATWRTECC + 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 for the stock valueMBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKSECC + S/4
I_BatchBatch InformationIn S/4HANA it can be read for batch master data with a clean core approachMaterial = 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-LGORTNo0002
S_MTARTMaterial typeRange / multipleMARA-MTARTNoROH, HALB
S_MATNRMaterialRange / multipleMCHB-MATNRNoIP-3020
S_ATNAMBatch characteristics to showRange / multipleCABN-ATNAMNoIPLIK_NUMARASI, KOMPOZISYON, KALITE, BOYA_LOTU, MARKA
S_ATWRTCharacteristic value filterRange / multipleAUSP-ATWRTNoNe 30/1
P_SUBTSubtotal characteristicSingle value—NoIPLIK_NUMARASI
P_NOZEROHide batches with zero stockCheckbox—NoX

Output columns

#ColumnSource
1PlantMCHB-WERKS
2Storage locationMCHB-LGORT
3MaterialMCHB-MATNR
4Material descriptionMAKT-MAKTX
5Batch (lot)MCHB-CHARG
6Yarn countCalculated AUSP-ATWRT, characteristic IPLIK_NUMARASI
7CompositionCalculated AUSP-ATWRT, characteristic KOMPOZISYON (with CAWN text)
8Quality gradeCalculated AUSP-ATWRT, characteristic KALITE
9Dye lot / shadeCalculated AUSP-ATWRT, characteristic BOYA_LOTU
10BrandCalculated AUSP-ATWRT, characteristic MARKA
11Unrestricted stockMCHB-CLABS
12Quality inspection stockMCHB-CINSM
13Blocked stockMCHB-CSPEM
14UnitMARA-MEINS
15Stock valueCalculated (CLABS + CINSM + CSPEM) × MBEW price / price unit
16Batch created onMCHA-ERSDA

Sample output

PlantStorage locationMaterialMaterial descriptionBatch (lot)Yarn countCompositionQuality gradeDye lot / shadeBrandUnrestricted stockQuality inspection stockBlocked stockUnitStock valueBatch created on
10000002IP-3020Ne 30/1 penye pamuk ipliğiL2611-07Ne 30/1100% cottonADemo İplik4,20000KG365,40011/04/2026
10000002IP-3020Ne 30/1 penye pamuk ipliğiL2610-19Ne 30/1100% cottonBDemo İplik8600120KG85,26010/21/2026
10000004KM-5005Süprem kumaş 30/1 boyalıF2611-02Ne 30/195% cotton 5% elastaneABL-0915 navyÖrnek Marka1,8503200KG412,65011/08/2026
10000002IP-4010Nm 2/48 yün karışım iplikL2609-30Nm 2/4870% wool 30% acrylicADemo İplik64000KG140,80009/30/2026
A view built with fictional sample data; not real system data.

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.

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

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 Standard ALV report

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 …

MARD · MARA · MAKT · MBEW

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: Yarn and Fabric Stock Report by Lot, Yarn Count, Quality and Brand