P_ProdnModOperationWorkCenter

@EndUserText.label: 'Production Model WorkCenter'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #S,
  dataClass: #MASTER
}

define view entity P_ProdnModOperationWorkCenter
  as select from           I_WorkCenter                   as WorkCenter
    left outer to one join I_StandardWorkFmlaParamGroup   as StdWorkFmlaParamGrp on StdWorkFmlaParamGrp.StandardWorkFormulaParamGroup = WorkCenter.StandardWorkFormulaParamGroup
    left outer to one join I_StandardWorkFormulaParamText as StdWorkFmlaParam1   on  StdWorkFmlaParam1.StandardWorkFormulaParameter = StdWorkFmlaParamGrp.StandardWorkFormulaParam1
                                                                                 and StdWorkFmlaParam1.Language                     = $session.system_language
    left outer to one join I_StandardWorkFormulaParamText as StdWorkFmlaParam2   on  StdWorkFmlaParam2.StandardWorkFormulaParameter = StdWorkFmlaParamGrp.StandardWorkFormulaParam2
                                                                                 and StdWorkFmlaParam2.Language                     = $session.system_language
    left outer to one join I_StandardWorkFormulaParamText as StdWorkFmlaParam3   on  StdWorkFmlaParam3.StandardWorkFormulaParameter = StdWorkFmlaParamGrp.StandardWorkFormulaParam3
                                                                                 and StdWorkFmlaParam3.Language                     = $session.system_language
    left outer to one join I_StandardWorkFormulaParamText as StdWorkFmlaParam4   on  StdWorkFmlaParam4.StandardWorkFormulaParameter = StdWorkFmlaParamGrp.StandardWorkFormulaParam4
                                                                                 and StdWorkFmlaParam4.Language                     = $session.system_language
    left outer to one join I_StandardWorkFormulaParamText as StdWorkFmlaParam5   on  StdWorkFmlaParam5.StandardWorkFormulaParameter = StdWorkFmlaParamGrp.StandardWorkFormulaParam5
                                                                                 and StdWorkFmlaParam5.Language                     = $session.system_language
    left outer to one join I_StandardWorkFormulaParamText as StdWorkFmlaParam6   on  StdWorkFmlaParam6.StandardWorkFormulaParameter = StdWorkFmlaParamGrp.StandardWorkFormulaParam6
                                                                                 and StdWorkFmlaParam6.Language                     = $session.system_language
    left outer to one join I_WorkCenterCostCenter         as CostCtrActType1     on  CostCtrActType1.WorkCenterInternalID = WorkCenter.WorkCenterInternalID
                                                                                 and CostCtrActType1.WorkCenterTypeCode   = WorkCenter.WorkCenterTypeCode
                                                                                 and CostCtrActType1.ValidityEndDate      = WorkCenter.ValidityEndDate
                                                                                 and CostCtrActType1.CostCenterAllocation = '0001'
    left outer to one join I_WorkCenterCostCenter         as CostCtrActType2     on  CostCtrActType2.WorkCenterInternalID = WorkCenter.WorkCenterInternalID
                                                                                 and CostCtrActType2.WorkCenterTypeCode   = WorkCenter.WorkCenterTypeCode
                                                                                 and CostCtrActType2.ValidityEndDate      = WorkCenter.ValidityEndDate
                                                                                 and CostCtrActType2.CostCenterAllocation = '0002'
    left outer to one join I_WorkCenterCostCenter         as CostCtrActType3     on  CostCtrActType3.WorkCenterInternalID = WorkCenter.WorkCenterInternalID
                                                                                 and CostCtrActType3.WorkCenterTypeCode   = WorkCenter.WorkCenterTypeCode
                                                                                 and CostCtrActType3.ValidityEndDate      = WorkCenter.ValidityEndDate
                                                                                 and CostCtrActType3.CostCenterAllocation = '0003'
    left outer to one join I_WorkCenterCostCenter         as CostCtrActType4     on  CostCtrActType4.WorkCenterInternalID = WorkCenter.WorkCenterInternalID
                                                                                 and CostCtrActType4.WorkCenterTypeCode   = WorkCenter.WorkCenterTypeCode
                                                                                 and CostCtrActType4.ValidityEndDate      = WorkCenter.ValidityEndDate
                                                                                 and CostCtrActType4.CostCenterAllocation = '0004'
    left outer to one join I_WorkCenterCostCenter         as CostCtrActType5     on  CostCtrActType5.WorkCenterInternalID = WorkCenter.WorkCenterInternalID
                                                                                 and CostCtrActType5.WorkCenterTypeCode   = WorkCenter.WorkCenterTypeCode
                                                                                 and CostCtrActType5.ValidityEndDate      = WorkCenter.ValidityEndDate
                                                                                 and CostCtrActType5.CostCenterAllocation = '0005'
    left outer to one join I_WorkCenterCostCenter         as CostCtrActType6     on  CostCtrActType6.WorkCenterInternalID = WorkCenter.WorkCenterInternalID
                                                                                 and CostCtrActType6.WorkCenterTypeCode   = WorkCenter.WorkCenterTypeCode
                                                                                 and CostCtrActType6.ValidityEndDate      = WorkCenter.ValidityEndDate
                                                                                 and CostCtrActType6.CostCenterAllocation = '0006'
{
  key WorkCenter.WorkCenterInternalID,
  key WorkCenter.WorkCenterTypeCode,
      WorkCenter.WorkCenter,
      WorkCenter.Plant,
      WorkCenter.SupplyArea,
      WorkCenter.OperationControlProfile,
      WorkCenter.NumberOfTimeTickets,
      WorkCenter.NumberOfConfirmationSlips,
      WorkCenter.EmployeeWageGroup,
      WorkCenter.EmployeeWageType,
      WorkCenter.EmployeeSuitability,
      WorkCenter.WorkCenterSetupType,
      WorkCenter.ValidityStartDate,
      WorkCenter.ValidityEndDate,
      WorkCenter.NmbrOfTimeTicketsIsReferenced,
      WorkCenter.NumberOfConfSlipsIsReferenced,
      WorkCenter.EmployeeWageGroupIsReferenced,
      WorkCenter.EmployeeWageTypeIsReferenced,
      WorkCenter.WorkCenterSetpTypeIsReferenced,
      WorkCenter.OpControlProfileIsReferenced,
      WorkCenter.EmplSuitabilityIsReferenced,
      WorkCenter.WorkCenterStdQueueDurnUnit,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterStdQueueDurnUnit'
      WorkCenter.WorkCenterStandardQueueDurn,
      WorkCenter.WorkCenterMinimumQueueDurnUnit,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterMinimumQueueDurnUnit'
      WorkCenter.WorkCenterMinimumQueueDuration,
      CostCtrActType1.CostCenter,
      WorkCenter.WorkCenterFormulaParam1,
      WorkCenter.WorkCenterFormulaParam2,
      WorkCenter.WorkCenterFormulaParam3,
      WorkCenter.WorkCenterFormulaParam4,
      WorkCenter.WorkCenterFormulaParam5,
      WorkCenter.WorkCenterFormulaParam6,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterFmlaParamUnit1'
      WorkCenter.WorkCenterFmlaParamValue1,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterFmlaParamUnit2'
      WorkCenter.WorkCenterFmlaParamValue2,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterFmlaParamUnit3'
      WorkCenter.WorkCenterFmlaParamValue3,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterFmlaParamUnit4'
      WorkCenter.WorkCenterFmlaParamValue4,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterFmlaParamUnit5'
      WorkCenter.WorkCenterFmlaParamValue5,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterFmlaParamUnit6'
      WorkCenter.WorkCenterFmlaParamValue6,
      WorkCenter.WorkCenterFmlaParamUnit1,
      WorkCenter.WorkCenterFmlaParamUnit2,
      WorkCenter.WorkCenterFmlaParamUnit3,
      WorkCenter.WorkCenterFmlaParamUnit4,
      WorkCenter.WorkCenterFmlaParamUnit5,
      WorkCenter.WorkCenterFmlaParamUnit6,
      WorkCenter.WrkCtrStdValMaintRule1,
      WorkCenter.WrkCtrStdValMaintRule2,
      WorkCenter.WrkCtrStdValMaintRule3,
      WorkCenter.WrkCtrStdValMaintRule4,
      WorkCenter.WrkCtrStdValMaintRule5,
      WorkCenter.WrkCtrStdValMaintRule6,
      WorkCenter.WorkCenterStandardWorkQtyUnit1,
      WorkCenter.WorkCenterStandardWorkQtyUnit2,
      WorkCenter.WorkCenterStandardWorkQtyUnit3,
      WorkCenter.WorkCenterStandardWorkQtyUnit4,
      WorkCenter.WorkCenterStandardWorkQtyUnit5,
      WorkCenter.WorkCenterStandardWorkQtyUnit6,
      StdWorkFmlaParam1.StandardWorkFormulaParamName as StandardWorkFormulaParamName1,
      StdWorkFmlaParam2.StandardWorkFormulaParamName as StandardWorkFormulaParamName2,
      StdWorkFmlaParam3.StandardWorkFormulaParamName as StandardWorkFormulaParamName3,
      StdWorkFmlaParam4.StandardWorkFormulaParamName as StandardWorkFormulaParamName4,
      StdWorkFmlaParam5.StandardWorkFormulaParamName as StandardWorkFormulaParamName5,
      StdWorkFmlaParam6.StandardWorkFormulaParamName as StandardWorkFormulaParamName6,
      CostCtrActType1.CostCtrActivityType            as CostCtrActivityType1,
      CostCtrActType1.CostCtrActyTypeIsReferenced    as CostCtrActyType1IsReferenced,
      CostCtrActType2.CostCtrActivityType            as CostCtrActivityType2,
      CostCtrActType2.CostCtrActyTypeIsReferenced    as CostCtrActyType2IsReferenced,
      CostCtrActType3.CostCtrActivityType            as CostCtrActivityType3,
      CostCtrActType3.CostCtrActyTypeIsReferenced    as CostCtrActyType3IsReferenced,
      CostCtrActType4.CostCtrActivityType            as CostCtrActivityType4,
      CostCtrActType4.CostCtrActyTypeIsReferenced    as CostCtrActyType4IsReferenced,
      CostCtrActType5.CostCtrActivityType            as CostCtrActivityType5,
      CostCtrActType5.CostCtrActyTypeIsReferenced    as CostCtrActyType5IsReferenced,
      CostCtrActType6.CostCtrActivityType            as CostCtrActivityType6,
      CostCtrActType6.CostCtrActyTypeIsReferenced    as CostCtrActyType6IsReferenced
}