Production Output by Machine, Process and Quality Report (Metres and m²)
Short answer: A custom ALV report that totals good output and scrap from production confirmations by machine, process (weaving, dyeing, finishing, inspection) and quality in metres and m². Output confirmed in different units is converted into one unit; metres per machine hour and the scrap rate appear on the same line.
- Estimated effort
- M · 4–7 working days
- System
- ECC and S/4HANA
- Tables
- 8
- Scope
- Global · 1 industries
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
COOIS lists operations and confirmations, but it does not convert the confirmation unit into metres and m², does not total by machine, process and quality, and does not calculate output per machine hour. In textile companies this data is usually combined by hand in Excel for the daily production meeting. The custom report produces the same table in one run.
Who uses it? Textile production managers, plant managers, production planning and costing teams.
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 |
|---|---|---|---|
| AFRUOrder Confirmations | Confirmations: good quantity, scrap, unit, machine time (driving table) | — | ECC + S/4 |
| CRHDWork Center Header | Machine (work center) and plant | CRHD-OBJTY = 'A' AND CRHD-OBJID = AFRU-ARBID | ECC + S/4 |
| CRTXTexts for Work Centers and Production Resources/Tools | Machine description | CRTX-OBJTY = CRHD-OBJTY AND CRTX-OBJID = CRHD-OBJID | ECC + S/4 |
| AFVCOperation within an Order | Standard text key of the operation (process) | AFVC-AUFPL = AFRU-AUFPL AND AFVC-APLZL = AFRU-APLZL | ECC + S/4 |
| AFPOOrder Item | Quality (material) produced | AFPO-AUFNR = AFRU-AUFNR | ECC + S/4 |
| MAKTMaterial Descriptions | Quality description | MAKT-MATNR = AFPO-MATNR | ECC + S/4 |
| MARAGeneral Material Data | Fabric width and its unit | MARA-MATNR = AFPO-MATNR | ECC + S/4 |
| MARMUnits of Measure for Material | Unit conversion factors (M, M2, KG) | MARM-MATNR = AFPO-MATNR | ECC + S/4 |
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| S_WERKS | Plant | Range / multiple | CRHD-WERKS | Yes | 1000 |
| S_BUDAT | Confirmation posting date | Range / multiple | AFRU-BUDAT | Yes | 01.11.2026 – 16.11.2026 |
| S_ARBPL | Machine (work center) | Range / multiple | CRHD-ARBPL | No | DK-* |
| S_KTSCH | Process (standard text key) | Range / multiple | AFVC-KTSCH | No | DOKUMA |
| S_MATNR | Quality (material) | Range / multiple | AFPO-MATNR | No | KMS-* |
| P_GROUP | Grouping: machine / process / quality | Radio button | — | Yes | Makine |
Output columns
| # | Column | Source |
|---|---|---|
| 1 | Plant | CRHD-WERKS |
| 2 | Machine | CRHD-ARBPL |
| 3 | Machine description | CRTX-KTEXT |
| 4 | Process | AFVC-KTSCH |
| 5 | Quality | AFPO-MATNR |
| 6 | Quality description | MAKT-MAKTX |
| 7 | Good output (m) | Calculated Σ AFRU-LMNGA converted to metres via MARM |
| 8 | Good output (m²) | Calculated Good metres × width (m) |
| 9 | Scrap (m) | Calculated Σ AFRU-XMNGA converted to metres |
| 10 | Scrap % | Calculated Scrap / (good + scrap) × 100 |
| 11 | Machine hours | Calculated Σ AFRU-ISM01 converted to hours |
| 12 | Metres / hour | Calculated Good metres / machine hours |
| 13 | Number of orders | Calculated Count of distinct AFRU-AUFNR |
Sample output
| Plant | Machine | Machine description | Process | Quality | Quality description | Good output (m) | Good output (m²) | Scrap (m) | Scrap % | Machine hours | Metres / hour | Number of orders |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1000 | DK-014 | Jacquard loom 14 | Weaving | KMS-24017 | Jacquard upholstery fabric 280 g/m² | 168 | 235.20 | 3.40 | 1.98 | 22.50 | 7.47 | 2 |
| 1000 | BY-03 | Jet dyeing machine 3 | Dyeing | KMS-24017 | Jacquard upholstery fabric 280 g/m² | 1,850 | 2,590 | 22 | 1.18 | 18 | 102.78 | 4 |
| 1000 | RM-01 | Stenter 1 | Finishing | HLI-400-120 | Machine-made carpet 400 cm, design 120 | 1,240 | 4,960 | 15 | 1.20 | 16 | 77.50 | 3 |
| 1000 | KK-02 | Inspection table 2 | Inspection | KMS-24017 | Jacquard upholstery fabric 280 g/m² | 1,780 | 2,492 | 41 | 2.25 | 14.50 | 122.76 | 4 |
How does the report work?
- AFRU is read by plant and posting date (BUDAT); reversed confirmations (STOKZ = X) and reversal confirmations (STZHL filled) are excluded.
- The confirmation’s work center (AFRU-ARBID → CRHD-OBJID, OBJTY = ‘A’) gives the machine; the machine description comes from CRTX. The process is the operation’s standard text key (AFVC-KTSCH; e.g. weaving, dyeing, finishing, inspection).
- The quality is the material produced by the order (AFPO-MATNR); its description comes from MAKT.
- If the confirmation unit (AFRU-MEINH) is not metres, it is converted with the MARM factors (UMREZ/UMREN). m² = metres × width; the width is converted to metres from MARA-BREIT and its unit MEABM. If the material has an M2 alternative unit, the MARM factor is used directly.
- Scrap (XMNGA) is converted the same way; scrap % = scrap / (good + scrap) × 100.
- Machine hours come from the machine time activity of the confirmation (ISM01, converted to hours by unit ILE01); metres/hour = good metres / machine hours. The ALV shows subtotals by the selected grouping (machine, process or quality).
Performance notes
Limit AFRU by plant and posting date; exclude reversals in the database. Read CRHD, CRTX, MARA and MARM once with the distinct keys found in the confirmations and buffer them. Run selections covering a full year in the background.
Features
- ALV list (sort, filter, subtotals)
- User-specific layout variants The machine, process and quality groupings can be saved as separate layouts.
- Double-click drill-down to the document Double-clicking a line shows the confirmations of that group, and from there CO14 opens a single confirmation.
- Export to Excel
- Runs as a background job The previous day's output can be emailed every morning.
Authorization objects
- C_AFRU_AWKConfirmation display authorization by plant and order type
- C_AFKO_AWKProduction order display authorization
Frequently asked questions
How are metres found if confirmations are posted in kilograms?
If the conversion between kg and metres is defined in MARM as an alternative unit, that factor is used. If not, the line is flagged with a warning and the metre column stays empty, which also makes the missing master data visible.
Can I see the figures per shift?
AFRU has no shift field. A shift column can be added by matching the confirmation start time (ISDZ) with the work center's shift calendar; this adds about 1 day to the estimate.
Does it work on S/4HANA?
Yes. AFRU, CRHD, AFVC and MARM keep the same structure on S/4HANA; the report runs without changes.
Related reports
Production Order Schedule Adherence Report (Planned vs Actual Start and Finish)
A custom ALV report that compares the planned and actual start and finish dates of completed production orders and calculates the days of delay and …
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 …
Weekly Capacity Load by Work Center Report
A custom ALV report that shows, for every work center of the selected plant, the available capacity, the production order and planned order load and …
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.