MM Report Custom development ALV report Textile and Apparel

Stock Quantity and Value by Quality Grade (First and Second Quality) Report

Short answer: A custom ALV report that splits fabric and finished goods stock by quality grade (first, second, third quality) read from a batch characteristic or the valuation type, shows the quantity and book value of each grade and estimates the write-down needed for second and lower quality stock. Second quality stock is tracked separately and period-end valuation is prepared with figures.

Estimated effort
S · 4–5 working days
System
ECC and S/4HANA
Tables
9
Scope
Global · 1 industries
Built by
NeKuDos Teknoloji
Last updated

Why is the standard not enough?

MB52 lists stock with batch and value and MC.9 gives a stock analysis at material level, but neither uses the quality grade as a grouping criterion or calculates realizable value and write-down for second quality stock that is valued at the same price. The custom report gives quantity, value and estimated write-down by quality grade in one list.

Who uses it? Cost and general accounting, inventory management, sales (stock clearance) and quality teams.

Closest standard alternatives

  • MB52 List of Warehouse Stocks on Hand. Lists stock with batch and value; there is no grouping by quality grade and no write-down calculation.
  • MC.9 Material Analysis: Stock. Gives a stock analysis at material level; it does not split by batch characteristic.

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)Valuation type of the batch (split valuation by quality)MCHA-MATNR = MCHB-MATNR AND MCHA-WERKS = MCHB-WERKS AND MCHA-CHARG = MCHB-CHARGECC + S/4
MBEWMaterial ValuationPrice control, standard and moving average priceMBEW-MATNR = MCHB-MATNR AND MBEW-BWKEY = MCHB-WERKS AND MBEW-BWTAR = MCHA-BWTARECC + 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 characteristic valueAUSP-OBJEK = INOB-CUOBJ AND AUSP-ATINN = CABN-ATINNECC + S/4
CABNCharacteristicsTranslation of the characteristic name to its internal numberCABN-ATNAM = P_ATNAMECC + 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
I_StockQuantityCurrentValue_2Current Stock Quantity and ValueIn S/4HANA it can be read for 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-LGORTNo—
S_MATNRMaterialRange / multipleMCHB-MATNRNo—
S_MTARTMaterial typeRange / multipleMARA-MTARTNoFERT, HALB
R_CHARQuality source: batch characteristicRadio button—NoX
R_BWTARQuality source: valuation typeRadio button—No—
P_ATNAMQuality grade characteristicSingle valueCABN-ATNAMNoQUALITY_GRADE
P_PCT2Second quality realizable rate (%)Single value—No70
P_PCT3Third quality and below realizable rate (%)Single value—No40

Output columns

#ColumnSource
1PlantMCHB-WERKS
2MaterialMCHB-MATNR
3Material descriptionMAKT-MAKTX
4Quality gradeCalculated AUSP-ATWRT (characteristic) or MCHA-BWTAR (valuation type)
5Number of batchesCalculated Number of batches with stock in the grade
6Unrestricted stockCalculated Σ MCHB-CLABS
7Blocked and in inspectionCalculated Σ MCHB-CSPEM + MCHB-CINSM
8UnitMARA-MEINS
9Unit priceCalculated MBEW-STPRS if VPRSV = S, otherwise MBEW-VERPR; / MBEW-PEINH
10Book valueCalculated Total quantity × unit price
11Realizable rate %Calculated First quality 100; others the rate on the selection screen
12Write-down neededCalculated max(0, book value − book value × realizable rate)
13Lower quality share %Calculated Quantity other than first quality / total quantity × 100 for the material

Sample output

PlantMaterialMaterial descriptionQuality gradeNumber of batchesUnrestricted stockBlocked and in inspectionUnitUnit priceBook valueRealizable rate %Write-down neededLower quality share %
1000KM-PNY-220-LACPenye süprem 220 cm lacivert1428,6400M114984,96010009.40
1000KM-PNY-220-LACPenye süprem 220 cm lacivert27742156M114102,3727030,7129.40
1000GM-TSH-BSC-MBasic tişört M beyaz11812,4000ST961,190,40010005.30
1000GM-TSH-BSC-MBasic tişört M beyaz340690ST9666,2404039,7445.30
A view built with fictional sample data; not real system data.

How does the report work?

  1. Batch stock in the selected plant, storage location and material type is read from MCHB.
  2. Depending on the selection, the quality grade comes from one of two sources: (a) the quality characteristic in batch classification (INOB, CABN, AUSP); (b) the valuation type of the batch (MCHA-BWTAR) when split valuation by quality is used.
  3. The unit price is read from MBEW by material, valuation area and, if any, valuation type; with price control S the standard price, with V the moving average price, divided by the price unit.
  4. Book value = quantity × unit price. For each lower quality grade a realizable rate is given on the selection screen (for example second quality 70%, third quality 40%).
  5. Write-down needed = book value − book value × realizable rate; if negative it is set to zero. With split valuation, if the lower grade is already valued at a lower price, this column is for information only.
  6. The ALV shows subtotals by material and quality grade; for each material the share of lower quality in total stock is shown.

Performance notes

Limit MCHB by plant and material type and drop zero-stock lines. Read the quality characteristic once for the selected batches. Read MBEW with the material, valuation area and valuation type key via FOR ALL ENTRIES.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking a line shows the related batches; double-clicking a batch opens MSC3N.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • M_MATE_WRKMaterial display authorization by plant
  • M_MSEG_WMBStock display authorization by plant

Frequently asked questions

Does the report post the write-down to accounting?

No. The report only estimates the need. Posting is done according to the company's method, either with a price change (MR21) or with a manual journal entry; the amounts in the report can serve as the basis for that posting.

What if second quality is kept under a separate material number?

In that case the quality grade is read from a suffix in the material number or from material classification and matched with the first quality material. This adds 1–2 days to the estimate.

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 come from I_StockQuantityCurrentValue_2.

Related reports

CO Report Custom ALV report

Material Ledger Price Differences by Plant Report

A custom ALV report that shows the standard price, periodic unit price and price differences from the material ledger for all materials and plants in …

CKMLHD · CKMLPP · CKMLCR · 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: Stock Quantity and Value by Quality Grade (First and Second Quality) Report