PP Report Custom development ALV report Textile and Apparel

Weaving Loom Loading Plan Report by Width, Design and Warp Compatibility

Short answer: A custom ALV report that groups open weaving orders by loom width, fabric design and the warp they use, and proposes a sequence per loom that keeps warp changes to a minimum. Planners see on one screen which order can run on which loom, how many warp changes are needed and how many hours of work each loom is loaded with.

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

Why is the standard not enough?

The CM21 planning table dispatches orders to work centers by date and capacity, and CM01 shows the work center load; neither knows whether the fabric width fits the loom width or whether consecutive orders use the same warp. Setup-optimized sequencing can be done in PP/DS with setup matrices, but that needs its own implementation and maintenance. The custom report applies these compatibility rules from existing order, work center and classification data.

Who uses it? Weaving planners, production supervisors and loom setup teams.

Closest standard alternatives

  • CM21 Capacity Leveling: SFC Planning Table. Dispatches orders to work centers by date and capacity; it does not check loom width or warp compatibility.
  • CM01 Capacity Planning: Work Center Load. Shows the work center capacity load per period; it does not propose an order sequence or warp changes.

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 OrdersOrder header: basic dates, MRP controller, routing number (driving table)—ECC + S/4
AFPOOrder ItemOrder item: fabric, order quantity and unitAFPO-AUFNR = AFKO-AUFNRECC + S/4
JESTIndividual Object StatusOrder status: orders with TECO, DLV or deletion flag are excludedJEST-OBJNR = 'OR' + AFKO-AUFNR AND JEST-INACT = ' 'ECC + S/4
AFVCOperation within an OrderWeaving operations and work center linkAFVC-AUFPL = AFKO-AUFPLECC + S/4
CRHDWork Center HeaderLoom (work center) codeCRHD-OBJID = AFVC-ARBID AND CRHD-OBJTY = 'A'ECC + S/4
KBEDCapacity Requirements RecordsRemaining capacity requirement of the operationKBED-AUFPL = AFVC-AUFPL AND KBED-APLZL = AFVC-APLZLECC + S/4
RESBReservation/Dependent RequirementsOrder components: warp materialRESB-RSNUM = AFKO-RSNUMECC + S/4
KSSKAllocation Table: Object to ClassClass assignment of the loom (class type 019)KSSK-KLART = '019'ECC + S/4
AUSPCharacteristic Values of ObjectsFabric width, design and loom reed width characteristic valuesAUSP-OBJEK = AFPO-MATNR AND AUSP-KLART = '001'ECC + S/4
MAKTMaterial DescriptionsFabric descriptionMAKT-MATNR = AFPO-MATNR AND MAKT-SPRAS = SY-LANGUECC + S/4
I_ManufacturingOrderOperationManufacturing Order OperationIn S/4HANA it can replace AFVC with a clean core approachManufacturingOrder = AFKO-AUFNRS/4HANA only

Selection screen parameters

ParameterDescriptionTypeReference fieldRequiredExample
S_WERKSPlantRange / multipleAFPO-PWERKYes1000
S_ARBPLLooms (work center)Range / multipleCRHD-ARBPLYesDK001–DK048
S_DISPOMRP controllerRange / multipleAFKO-DISPONoD01
S_GSTRPBasic start date rangeRange / multipleAFKO-GSTRPNo17.11.2026 – 15.12.2026
P_ATWIDFabric greige width characteristicSingle valueCABN-ATNAMYesGREIGE_WIDTH
P_ATDESDesign characteristicSingle valueCABN-ATNAMNoDESIGN_NO
P_ATLOMLoom reed width characteristicSingle valueCABN-ATNAMYesREED_WIDTH
P_WARPWarp material groupSingle valueMARA-MATKLYesCZG01

Output columns

#ColumnSource
1LoomCRHD-ARBPL
2Reed width (cm)Calculated Reed width characteristic in work center classification (AUSP-ATFLV)
3Proposed sequenceCalculated Sequence number within the loom by warp, design and basic finish date
4Production orderAFKO-AUFNR
5FabricAFPO-MATNR
6Fabric descriptionMAKT-MAKTX
7Greige width (cm)AUSP-ATFLV
8DesignAUSP-ATWRT
9WarpRESB-MATNR
10Order quantityAFPO-PSMNG
11UnitAFPO-MEINS
12Basic startAFKO-GSTRP
13Remaining load (hours)Calculated Σ KBED remaining capacity requirement, converted to hours
14Warp changeCalculated X if the warp differs from the previous order in the proposed sequence
15Cumulative load %Calculated Σ remaining load / available hours in the planning horizon × 100
16FitCalculated Fits / Width mismatch (greige width > reed width)

Sample output

LoomReed width (cm)Proposed sequenceProduction orderFabricFabric descriptionGreige width (cm)DesignWarpOrder quantityUnitBasic startRemaining load (hours)Warp changeCumulative load %Fit
DK01222011004521HK-PNY-210-01Ham bez 210 cm desen 01210D-0410CZG-30-NE-48003,200M11/18/202641.5052Fits
DK01222021004533HK-PNY-210-07Ham bez 210 cm desen 07210D-0417CZG-30-NE-48002,400M11/20/20263191Fits
DK01222031004540HK-SAT-200-02Saten ham 200 cm200D-0522CZG-40-PE-52001,500M11/21/202622X118Fits
DK03119011004552HK-KTN-205-03Keten ham 205 cm205D-0611CZG-20-LN-44001,800M11/19/2026270Width mismatch
A view built with fictional sample data; not real system data.

How does the report work?

  1. Orders in the selected plant, MRP controller and basic start range are read from AFKO; via JEST only orders that are created or released and not technically completed remain.
  2. Weaving operations are taken from AFVC and the work center (ARBID) is translated to the loom via CRHD. The remaining capacity requirement of the operation is totalled in hours from KBED.
  3. The greige width and the design of the fabric are read via AUSP from characteristics in material classification (class type 001). The reed width of the loom comes from work center classification (class type 019) via KSSK and AUSP.
  4. The warp of the order is the component in RESB that falls into the warp material group given on the selection screen.
  5. Orders whose fabric width exceeds the loom width are flagged “Width mismatch”. The remaining orders are sorted per loom first by warp, then by design, then by basic finish date; when the warp differs from the previous order a “Warp change” flag is set.
  6. For each loom the cumulative load is compared with the available hours in the planning horizon; the summary line shows how many warp changes are saved against the current sequence. The report only proposes and does not change the orders.

Performance notes

Limit orders by plant, MRP controller and date range, and read JEST only for the object numbers of the selected orders. Read material and work center characteristics once with unique keys and keep them in memory.

Features

  • ALV list (sort, filter, subtotals)
  • User-specific layout variants
  • Double-click drill-down to the document Double-clicking the order opens CO03; double-clicking the loom opens the CM01 capacity load.
  • Export to Excel
  • Runs as a background job

Authorization objects

  • C_AFKO_AWKProduction order display authorization by order type and plant
  • C_ARPL_WRKWork center display authorization by plant

Frequently asked questions

Does the report assign orders to looms by itself?

No, it proposes. The planner applies the proposal in the planning table. If needed, the confirmed sequence can be transferred by an extra function that updates the work center and dates of the order operations; this adds 3–4 days to the estimate.

What if the warp is not in the bill of material?

If the warp is not kept as a component, the warp properties of the fabric (such as yarn count and end count) are read from a material characteristic, and orders with the same value are treated as sharing a warp.

Does it work on S/4HANA?

Yes. The tables are the same in S/4HANA; operations can be read via I_ManufacturingOrderOperation. In systems that use PP/DS, the report can also be used to try out compatibility rules before setup matrices are built.

Related reports

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: Weaving Loom Loading Plan Report by Width, Design and Warp Compatibility