11. Load production and capacity data¶

Supply Planning can propose production only when it knows where to produce, which resources to consume, how much time to use, and which components to transform. These relationships are master data; they are not production orders.

How the objects connect¶

flowchart LR
    ML[Output material + location] --> PV[Production version]
    PV --> RT[Production routing]
    RT --> OP1[Operation 10: machine]
    RT --> OP2[Operation 20: labor]
    OP1 --> RM[Machine resource]
    OP2 --> RL[Labor resource]
    RM --> AM[Daily availability]
    RL --> AL[Daily availability]
    PV --> BOM[Bill of materials / recipe]
    BOM --> CP[Components]
    CP --> MI[Input materials]

Transportation is intentionally absent from this diagram; the next chapter covers the supply network separately.

Load sequence¶

Production Resources;
Production Resource Availability;
Production Routing;
Production Routing Operations;
Bill of Materials;
Bill of Materials Components;
Single-routing Production Version.

Routing and bill of materials form independent branches. Load the production version only after both branches exist.

Tutorial files¶

Download one workbook per topic; each file keeps the exact header returned by the official Community endpoint.

01-production-resources.xlsx 02-production-resource-availability.xlsx 03-production-routing.xlsx 04-production-routing-operations.xlsx 05-bill-of-materials.xlsx 06-bill-of-materials-components.xlsx 07-production-version.xlsx

1. Open the production topics¶

Hover over Data and open Operations > Data Operations.

In the catalog, follow Master Data > Production Master Data and select each topic in the sequence above.

Production Master Data topic path

2. Register resources and availability¶

Use separate resources for machine and labor:

Production Resource Id	Description	Location Id	Efficiency	Active
`RES_MACHINE_EAST`	East converting machine	`MILL_EAST`	1	true
`RES_LABOR_EAST`	East converting labor	`MILL_EAST`	1	true

Availability uses one row per resource per day. A missing date means zero available hours, so load every working day in the horizon rather than one monthly row.

The reconciled tutorial dataset contains 261 weekdays for each resource: 522 availability rows from January through December 2027.

Production Resource Id	Reference Date	Available Hours
`RES_MACHINE_EAST`	`2027-01-04`	16
`RES_LABOR_EAST`	`2027-01-04`	16

Action to perform

In each topic, click Download to obtain the template, fill the published columns, and use Import. Confirm the success message before moving to a dependent topic.

3. Create the routing and two operations¶

The routing identifies the output material and plant. Each operation points to one resource, so machine and labor are separate operations.

Routing Id	Location Id	Output Material Id	Priority	Active
`ROUTE_TISSUE_DOUBLE_EAST`	`MILL_EAST`	`FG_TISSUE_DOUBLE_12`	0	true

Routing Id	Operation Sequence	Production Resource Id	Base Quantity	Base Quantity UOM	Hours by Base Quantity
`ROUTE_TISSUE_DOUBLE_EAST`	10	`RES_MACHINE_EAST`	1	`TON`	1.25
`ROUTE_TISSUE_DOUBLE_EAST`	20	`RES_LABOR_EAST`	1	`TON`	0.80

The engine constrains capacity by resource. Production duration uses the largest operation time; do not describe this as detailed scheduling or shift synchronization.

4. Create the bill of materials and components¶

Bill of Materials Id	Location Id	Output Material Id	Output Quantity	Output Unit of Measure Id	Priority	Active
`BOM_TISSUE_DOUBLE_EAST`	`MILL_EAST`	`FG_TISSUE_DOUBLE_12`	1	`TON`	0	true

Bill of Materials Id	Component Material Id	Component Material Quantity Unit of Measure Id	Component Material Quantity
`BOM_TISSUE_DOUBLE_EAST`	`ROLL_TISSUE`	`TON`	1.03

The 1.03 quantity represents technical consumption and physical loss in the example; it is neither a cost nor an economic rate.

5. Link the routing and bill of materials¶

Id	Location Id	Priority	Output Material Id	Routing Id	Bill of Materials Id	Active
`PV_TISSUE_DOUBLE_EAST`	`MILL_EAST`	0	`FG_TISSUE_DOUBLE_12`	`ROUTE_TISSUE_DOUBLE_EAST`	`BOM_TISSUE_DOUBLE_EAST`	true

Action to perform

Import the version last. If it fails, reconcile the material, location, routing, and bill-of-materials IDs; do not create a silent fallback.

Completion criterion¶

Every resource, availability day, routing, operation, bill of materials, component, and version must import without errors and use a consistent location and unit.

Return to Demand Plan review, or continue with the supply network.