PP Report Custom development ALV report Textile and Apparel

Dyestuff and Chemical Consumption Variance vs Recipe Report

Short answer: A custom ALV report that scales the dyestuff and chemical quantities in the recipe of each dye batch (dyeing order) to the kilos of fabric dyed, compares them with the quantities actually issued and shows additions made for shade correction separately. Over-consumption becomes visible by batch, machine and chemical, and the right-first-time dyeing rate can be tracked.

Estimated effort
M · 6–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?

COOIS shows planned and withdrawn quantities per component and MB51 lists the movements. Neither normalizes consumption to fabric weight (g/kg), separates shade correction additions from recipe consumption or gives the share of dyeings that needed no addition. The custom report presents these measures together by dye batch, machine and chemical.

Who uses it? Dyehouse supervisors, laboratory and recipe owners, production planning and cost accounting.

Closest standard alternatives

  • COOIS Production Order Information System. Lists planned and withdrawn quantities of order components; there is no normalization to fabric weight and no separation of additions.
  • MB51 Material Document List. Shows issues to the order; it does not compare with the recipe or give a variance rate.

Tables used

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

TableRoleJoinSystem
AFKOOrder Header Data for PP OrdersDyeing order header and reservation number (driving table)—ECC + S/4
AFPOOrder ItemColor/product, planned and actual fabric quantityAFPO-AUFNR = AFKO-AUFNRECC + S/4
RESBReservation/Dependent RequirementsDyestuff and chemical quantities in the recipeRESB-RSNUM = AFKO-RSNUMECC + S/4
MSEGMaterial Document Item261 issues and 262 returns to the orderMSEG-AUFNR = AFKO-AUFNRECC + S/4
MARAGeneral Material DataDyestuff and chemical material groupMARA-MATNR = MSEG-MATNRECC + S/4
MAKTMaterial DescriptionsDyestuff / chemical descriptionMAKT-MATNR = MSEG-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
MBEWMaterial ValuationPrice for the variance valueMBEW-MATNR = MSEG-MATNR AND MBEW-BWKEY = MSEG-WERKSECC + S/4
AFVCOperation within an OrderDyeing operation and work center linkAFVC-AUFPL = AFKO-AUFPLECC + S/4
CRHDWork Center HeaderDyeing machine (work center) codeCRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A'ECC + S/4
MATDOCMaterial Documents (S/4HANA)In S/4HANA it is read for goods movements instead of MSEGMATDOC-AUFNR = AFKO-AUFNRS/4HANA only

S/4HANA notes

  • MSEG → MATDOC: In S/4HANA MATDOC replaces MSEG; reading MSEG works through a compatibility view but is slow at high volumes.
  • 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 / multipleAFPO-PWERKYes3000
S_DAUATOrder typeRange / multipleAFPO-DAUATNoBY01
S_ARBPLDyeing machineRange / multipleCRHD-ARBPLNoJET01–JET12
S_AUFNRDyeing orderRange / multipleAFKO-AUFNRNo—
S_MATKLDyestuff and chemical material groupsRange / multipleMARA-MATKLYesBOYA01, KIM01
S_BUDATPosting date rangeRange / multipleMSEG-BUDAT_MKPFYes01.11.2026 – 16.11.2026
P_TOLERVariance tolerance (%)Single value—No5

Output columns

#ColumnSource
1Dye batch (order)AFKO-AUFNR
2Dyeing machineCRHD-ARBPL
3Color / productAFPO-MATNR
4Fabric (kg)AFPO-WEMNG
5Dyestuff / chemicalMSEG-MATNR
6DescriptionMAKT-MAKTX
7Recipe quantityCalculated RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG
8Actual issueCalculated Σ MSEG-MENGE (261) − Σ MSEG-MENGE (262)
9Addition (shade correction)Calculated Issues of components not in the recipe + the part above the recipe quantity
10VarianceCalculated Actual issue − recipe quantity
11Variance %Calculated Variance / recipe quantity × 100
12g/kg (actual)Calculated Actual issue (g) / fabric (kg)
13UnitRESB-MEINS
14Variance valueCalculated Variance × MBEW price / price unit

Sample output

Dye batch (order)Dyeing machineColor / productFabric (kg)Dyestuff / chemicalDescriptionRecipe quantityActual issueAddition (shade correction)VarianceVariance %g/kg (actual)UnitVariance value
1008840JET04KM-PNY-220-LAC620BY-REA-LAC-01Reaktif lacivert18.6019.901.301.30732.10KG1,716
1008840JET04KM-PNY-220-LAC620KM-TUZ-01Sodyum sülfat49.6050.2000.601.2081KG30
1008852JET07KM-SAT-150-SYH480BY-DIS-SYH-02Dispers siyah14.4014.100-0.30-2.1029.40KG-405
1008861JET02KM-KTN-180-BEJ350BY-REA-SAR-03Reaktif sarı00.700.700.7002KG840
A view built with fictional sample data; not real system data.

How does the report work?

  1. Dyeing orders in the selected plant, order type and period are read from AFKO and AFPO; the dyeing machine comes from the work center of the first operation (AFVC, CRHD). Process orders are read from the same tables.
  2. Components that fall into the dyestuff and chemical material groups (MARA-MATKL) on the selection screen are taken from RESB. The recipe quantity is scaled to the actual fabric kilos of the order: RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG.
  3. 261 issues and 262 returns to the order are read from MSEG. Issues of components that are not in the recipe, and the part above the recipe quantity, are separated as “addition (shade correction)”.
  4. Variance = actual issue − recipe quantity; variance % and grams per kilo of fabric (g/kg) are calculated. The value is found with the MBEW price.
  5. The share of orders without any addition is summarized per machine as the “right first time” rate.
  6. The ALV lists by dye batch and chemical; lines outside tolerance are highlighted.

Performance notes

Select orders by plant, order type and date range, and read RESB and MSEG with the order numbers, filtered by material group. In S/4HANA, goods movements are taken from MATDOC in a single read.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the dye batch opens CO03; double-clicking the actual issue opens the related material documents.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • C_AFKO_AWKOrder display authorization by order type and plant
  • M_MSEG_WMBGoods movement display authorization by plant

Frequently asked questions

Does it work if recipes are kept in dye kitchen software?

The report treats the order components in SAP as the recipe. If recipes are kept in an external system, either the components must be transferred to the order or the external dispensing file is read separately for the comparison; the second option adds 2–3 days to the estimate.

How are additions (shade corrections) identified?

An issue of a dyestuff that is not in the order's recipe, and the part above the recipe quantity, count as additions. If additions are posted with a dedicated movement reason, the split is made directly by that reason.

Does it work on S/4HANA?

Yes. Order and reservation tables stay the same; goods movements are read via MATDOC or I_MaterialDocumentItem_2.

Related reports

PP Report Custom ALV report

Scrap and Yield Analysis by Work Center Report

A custom ALV report that totals yield, scrap and rework from production confirmations per work center and operation, and compares the actual scrap …

AFRU · AFVC · AFVV · CRHD

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: Dyestuff and Chemical Consumption Variance vs Recipe Report