Source information

The order costing model retrieves data from these order costing files:

• Order costing material components (CPOCOA)

  This is where costs for costing component A are retrieved.

• Order costing operation components (CPOCOM)

  This is where costs for costing components B, C, and D are retrieved.

• Order costing semi-finished material (CPOCOS)

  This is where all costs for semi-finished materials are retrieved.

• Order costing product cost (CPOPRO)

  This is where costs for costing component E are retrieved.

Only the costs from manufacturing orders are retrieved in the above source files.

This model has two fact tables, one captures the costs at the material level, and the other one at the finished product level

The time dimension is based on the MO finish date.