Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the production total cost fact:
Dimension | Type | Note |
---|---|---|
Calculation Office | Conformed | From Production Order |
Company | Conformed | ticst010.compnr |
Cost Component | Conformed | ticst010.cpcp |
Financial Company | Conformed | If Financial Transactions by Work Center (tisfc001_rswc) =
Yes, the Financial Company of the Work Center. Else, the Financial Company of the Production Order. |
Item | Conformed | From Production Order (1) |
PCS Project | Conformed | From Production Order |
Planner | Conformed | From Production Order |
Production Order | Domain specific | ticst010.pdno |
Production Order Detail | Domain specific | Junk dimension |
Production Total Cost Detail | Domain specific | Junk dimension |
Shop Floor Planner | Conformed | From Production Order |
Site | Conformed | From Production Order |
Time | Birst | (2) Start Date + End Date |
Work Center | Conformed | ticst010.cwoc |
- (1) The Product Variant dimension is not targeted for production orders. In LN, a unique item exists for each product variant used in Job Shop. In Job Shop BI, the product variant becomes an attribute in the Item dimension.
- (2) You can analyze by two dates on the production order: Start Date
and End Date.
Start Date = Actual Start Date. Planned Start Date if there is no Actual Start Date.
End Date = Completion Date. Planned Delivery Date if there is no Completion Date.