Production Operation (Job Shop)

The Production Operation fact includes measures based on Production Order Operations (tisfc010) and Estimated and Actual Hours (ticst010) from Job Shop. Both provide details at the production operation level.

Transformation of extracted data:

Deleted lines

Deleted production operations are stored in the Production Operation fact table. These facts are hidden if the production operation status is not Completed. Production operations that are deleted with status Completed (when archiving orders) will not be hidden and remain available for analysis

These production order related dimensions are available, but not drawn in the star schema due to limited space:

• Site, Calculation Office
• Item, PCS Project
• Planner, Shop Floor Planner
• Production Order Detail, Production Order

The production order related dimensions allow you to, for example, analyze how much labor was used for rework orders.

This diagram shows the star schema: