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
Tables used
The tables the report reads and their join fields. ECC and S/4HANA differences are marked separately.
| Table | Role | Join | System |
|---|---|---|---|
| AFKOOrder Header Data for PP Orders | Dyeing order header and reservation number (driving table) | — | ECC + S/4 |
| AFPOOrder Item | Color/product, planned and actual fabric quantity | AFPO-AUFNR = AFKO-AUFNR | ECC + S/4 |
| RESBReservation/Dependent Requirements | Dyestuff and chemical quantities in the recipe | RESB-RSNUM = AFKO-RSNUM | ECC + S/4 |
| MSEGMaterial Document Item | 261 issues and 262 returns to the order | MSEG-AUFNR = AFKO-AUFNR | ECC + S/4 |
| MARAGeneral Material Data | Dyestuff and chemical material group | MARA-MATNR = MSEG-MATNR | ECC + S/4 |
| MAKTMaterial Descriptions | Dyestuff / chemical description | MAKT-MATNR = MSEG-MATNR AND MAKT-SPRAS = SY-LANGU | ECC + S/4 |
| MBEWMaterial Valuation | Price for the variance value | MBEW-MATNR = MSEG-MATNR AND MBEW-BWKEY = MSEG-WERKS | ECC + S/4 |
| AFVCOperation within an Order | Dyeing operation and work center link | AFVC-AUFPL = AFKO-AUFPL | ECC + S/4 |
| CRHDWork Center Header | Dyeing machine (work center) code | CRHD-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 MSEG | MATDOC-AUFNR = AFKO-AUFNR | S/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
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | AFPO-PWERK | Yes | 3000 |
| S_DAUAT | Order type | Range / multiple | AFPO-DAUAT | No | BY01 |
| S_ARBPL | Dyeing machine | Range / multiple | CRHD-ARBPL | No | JET01–JET12 |
| S_AUFNR | Dyeing order | Range / multiple | AFKO-AUFNR | No | — |
| S_MATKL | Dyestuff and chemical material groups | Range / multiple | MARA-MATKL | Yes | BOYA01, KIM01 |
| S_BUDAT | Posting date range | Range / multiple | MSEG-BUDAT_MKPF | Yes | 01.11.2026 – 16.11.2026 |
| P_TOLER | Variance tolerance (%) | Single value | — | No | 5 |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Dye batch (order) | AFKO-AUFNR |
| 2 | Dyeing machine | CRHD-ARBPL |
| 3 | Color / product | AFPO-MATNR |
| 4 | Fabric (kg) | AFPO-WEMNG |
| 5 | Dyestuff / chemical | MSEG-MATNR |
| 6 | Description | MAKT-MAKTX |
| 7 | Recipe quantity | Calculated RESB-BDMNG × AFPO-WEMNG / AFPO-PSMNG |
| 8 | Actual issue | Calculated Σ MSEG-MENGE (261) − Σ MSEG-MENGE (262) |
| 9 | Addition (shade correction) | Calculated Issues of components not in the recipe + the part above the recipe quantity |
| 10 | Variance | Calculated Actual issue − recipe quantity |
| 11 | Variance % | Calculated Variance / recipe quantity × 100 |
| 12 | g/kg (actual) | Calculated Actual issue (g) / fabric (kg) |
| 13 | Unit | RESB-MEINS |
| 14 | Variance value | Calculated Variance × MBEW price / price unit |
Sample output
| Dye batch (order) | Dyeing machine | Color / product | Fabric (kg) | Dyestuff / chemical | Description | Recipe quantity | Actual issue | Addition (shade correction) | Variance | Variance % | g/kg (actual) | Unit | Variance value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1008840 | JET04 | KM-PNY-220-LAC | 620 | BY-REA-LAC-01 | Reaktif lacivert | 18.60 | 19.90 | 1.30 | 1.30 | 7 | 32.10 | KG | 1,716 |
| 1008840 | JET04 | KM-PNY-220-LAC | 620 | KM-TUZ-01 | Sodyum sülfat | 49.60 | 50.20 | 0 | 0.60 | 1.20 | 81 | KG | 30 |
| 1008852 | JET07 | KM-SAT-150-SYH | 480 | BY-DIS-SYH-02 | Dispers siyah | 14.40 | 14.10 | 0 | -0.30 | -2.10 | 29.40 | KG | -405 |
| 1008861 | JET02 | KM-KTN-180-BEJ | 350 | BY-REA-SAR-03 | Reaktif sarı | 0 | 0.70 | 0.70 | 0.70 | 0 | 2 | KG | 840 |
How does the report work?
- 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.
- 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.
- 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)”.
- Variance = actual issue − recipe quantity; variance % and grams per kilo of fabric (g/kg) are calculated. The value is found with the MBEW price.
- The share of orders without any addition is summarized per machine as the “right first time” rate.
- 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
Production Order Target vs Actual Cost Variance Report
A custom ALV report that compares the actual cost of production orders in a plant with the target cost from delivered quantity × standard price, and …
Production Order Component Consumption Variance Report (Planned vs Actual Issue)
A custom ALV report that compares, for completed production orders, the consumption each component should have for the delivered quantity with the …
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 …
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.