The fact table of production costs belongs to the Production costs datamart. It contains elements coming from the production costs table.
The WIPCOST, MFGHEAD and MFGITM tables must be parameterized to be audited for the BI if data synchronization should be incremental (update of the elements modified since the last synchronization only).
One of the objectives of the universe dedicated to production costs is to facilitate data handling by inexperienced users, it is in no way to duplicate data:
Field code | Normal title | Menu | Table | Object type |
MFGFCY | Production site | 0 | 0 | Dimension |
MFGSTA | Order status | 317 | 0 | Dimension |
MFGNUM | Work Order | 0 | 0 | Dimension |
ROUNUM | BOM | 0 | 0 | Dimension |
ROUALT | Route alternative | 0 | 0 | Dimension |
CPY | Company | 0 | 0 | Dimension |
PJT | Project | 0 | 0 | Dimension |
TXNTYP | Cost type | 2358 | 0 | Dimension |
MFGTRKNUM | Tracking button. | 0 | 0 | Information |
FIYNUM | Financial year | 0 | 0 | Technical |
PERNUM | Period | 0 | 0 | Dimension |
TXNDAT | Posting date: | 0 | 0 | Dimension |
ITMREF | Product | 0 | 0 | Dimension |
QTY | Quantity | 0 | 0 | Measurement |
REJQTY | Rejected quantity | 0 | 0 | Measurement |
CPLSETTIM | Achieved setup time | 0 | 0 | Measurement |
CPLOPETIM | Achieved op. time | 0 | 0 | Measurement |
WST | Load work center | 0 | 0 | Dimension |
AMOUNT | Amount | 0 | 0 | Measurement |
AMOUNTR | Report cur. amount | 0 | 0 | Measurement |
CSTELM | Cost element | 0 | 0 | Measurement |
CSTELMR | Cost elements report. cur. | 0 | 0 | Measurement |
OVENAT | Expenses nature | 0 | 0 | Dimension |
OVENATAMT | Expenses nature amount: | 0 | 0 | Measurement |
OVENATAMTR | Expenses nature amount report. cur. | 0 | 0 | Measurement |
MATGRP | Material cost group | 325 | 0 | Dimension |
OPEGRP | Operation cost group | 316 | 0 | Dimension |
GLPSTA | Posting status | 1 | 0 | Dimension |
GLPDAT | Posting date | 0 | 0 | Dimension |
PRINAT | Price nature | 705 | 0 | Dimension |
The fact table of material issue is loaded on the basis of a synchronization rule :
Only the Work Order trackings whose Production Cost Price is calculated are fed to the datamart.