Production cost table
The fact table of production costs belongs to the Production costs datamart. It contains elements coming from the production costs table.
Prerequisites
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).
Description
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:
- Some information deemed secondary is not transmitted.
- Conversely, other information is calculated.
- Finally, information is restructured if needed.
Data detail
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 |
Description
Synchronization rules
The fact table of material issue is loaded on the basis of a synchronization rule :
- WIPCOST1: for production costs
Only the Work Order trackings whose Production Cost Price is calculated are fed to the datamart.
Specific loading functions
- TRTX3BI.GETCPY([F:MFG]MFGFCY): This function returns the company of the production site
- TRTX3BI.GETEXE([F:MFG]MFGFCY,[F:MFG]ENDAT): this function is used to return the fiscal year of the WO end date.
- TRTX3BI.GETPER([F:MFG]MFGFCY,[F:MFG]ENDAT): This function is used to return the period of the WO end date.
- TRTX3BI.CNVCPYRPT([F:MWI]MFGFCY,[F:MWI]TXNDAT,*): this function is used to convert the amount in reporting currency