PP Report Custom development ALV report Textile and Apparel

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

  • COOIS Production Order Information System. Lists operations and confirmations; no metre/m² conversion and no machine, process and quality totals.
  • CO14 Display Production Order Confirmation. Displays a single confirmation; no period totals and no efficiency calculation.

Tables used

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

TableRoleJoinSystem
AFRUOrder ConfirmationsConfirmations: good quantity, scrap, unit, machine time (driving table)—ECC + S/4
CRHDWork Center HeaderMachine (work center) and plantCRHD-OBJTY = 'A' AND CRHD-OBJID = AFRU-ARBIDECC + S/4
CRTXTexts for Work Centers and Production Resources/ToolsMachine descriptionCRTX-OBJTY = CRHD-OBJTY AND CRTX-OBJID = CRHD-OBJIDECC + S/4
AFVCOperation within an OrderStandard text key of the operation (process)AFVC-AUFPL = AFRU-AUFPL AND AFVC-APLZL = AFRU-APLZLECC + S/4
AFPOOrder ItemQuality (material) producedAFPO-AUFNR = AFRU-AUFNRECC + S/4
MAKTMaterial DescriptionsQuality descriptionMAKT-MATNR = AFPO-MATNRECC + S/4
MARAGeneral Material DataFabric width and its unitMARA-MATNR = AFPO-MATNRECC + S/4
MARMUnits of Measure for MaterialUnit conversion factors (M, M2, KG)MARM-MATNR = AFPO-MATNRECC + S/4

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleCRHD-WERKSYes1000
S_BUDATConfirmation posting dateRange / multipleAFRU-BUDATYes01.11.2026 – 16.11.2026
S_ARBPLMachine (work center)Range / multipleCRHD-ARBPLNoDK-*
S_KTSCHProcess (standard text key)Range / multipleAFVC-KTSCHNoDOKUMA
S_MATNRQuality (material)Range / multipleAFPO-MATNRNoKMS-*
P_GROUPGrouping: machine / process / qualityRadio button—YesMakine

Output columns

#ColumnSource
1PlantCRHD-WERKS
2MachineCRHD-ARBPL
3Machine descriptionCRTX-KTEXT
4ProcessAFVC-KTSCH
5QualityAFPO-MATNR
6Quality descriptionMAKT-MAKTX
7Good output (m)Calculated Σ AFRU-LMNGA converted to metres via MARM
8Good output (m²)Calculated Good metres × width (m)
9Scrap (m)Calculated Σ AFRU-XMNGA converted to metres
10Scrap %Calculated Scrap / (good + scrap) × 100
11Machine hoursCalculated Σ AFRU-ISM01 converted to hours
12Metres / hourCalculated Good metres / machine hours
13Number of ordersCalculated Count of distinct AFRU-AUFNR

Sample output

PlantMachineMachine descriptionProcessQualityQuality descriptionGood output (m)Good output (m²)Scrap (m)Scrap %Machine hoursMetres / hourNumber of orders
1000DK-014Jacquard loom 14WeavingKMS-24017Jacquard upholstery fabric 280 g/m²168235.203.401.9822.507.472
1000BY-03Jet dyeing machine 3DyeingKMS-24017Jacquard upholstery fabric 280 g/m²1,8502,590221.1818102.784
1000RM-01Stenter 1FinishingHLI-400-120Machine-made carpet 400 cm, design 1201,2404,960151.201677.503
1000KK-02Inspection table 2InspectionKMS-24017Jacquard upholstery fabric 280 g/m²1,7802,492412.2514.50122.764
A view built with fictional sample data; not real system data.

How does the report work?

  1. AFRU is read by plant and posting date (BUDAT); reversed confirmations (STOKZ = X) and reversal confirmations (STZHL filled) are excluded.
  2. 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).
  3. The quality is the material produced by the order (AFPO-MATNR); its description comes from MAKT.
  4. 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.
  5. Scrap (XMNGA) is converted the same way; scrap % = scrap / (good + scrap) × 100.
  6. 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

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

PP Report Custom ALV report

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 …

KBED · CRHD · CRCA · KAKO

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: Production Output by Machine, Process and Quality Report (Metres and m²)