A_ProcessOrderProdnRsceTools_2

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Process Order Production Resources Tools'
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

define view entity A_ProcessOrderProdnRsceTools_2
as select from I_MfgOrderOperationPRT
{
      // Key

  key MfgOrderInternalID as OrderInternalBillOfOperations,
  key MfgOrderOpProdnRsceToolIntID,
  
      // PRT data

      ProductionResourceTool,       
      ProdnRsceToolCategory_2 as ProdnRsceToolCategory,
      _ProdnRsceToolCategory_2._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName,
      ProdnRsceToolControlProfile,                                      // CE2105

      _ProdnRsceToolByInternalKey.Plant as ProdnRsceToolPlant,          // CE2105

       
      // Order and Operation data

      OrderOperationInternalID,                                         // CE2105      

      @ObjectModel.sapObjectNodeTypeReference: 'ProductionOrder'
      cast(ManufacturingOrder as co_bid preserving type)   as ManufacturingOrder,
      cast( ManufacturingOrderOperation as vdm_vornr preserving type ) as ManufacturingOrderOperation,                  // CE2105

      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderCategory'
      ManufacturingOrderCategory,
      @ObjectModel.sapObjectNodeTypeReference: 'ManufacturingOrderType'
      ManufacturingOrderType,
      ProductionPlant,       
      BillOfOperationsType,                                             // CE2105

      BillOfOperationsGroup,                                            // CE2105   

       
      // Dates and Times

      EarliestSchedldUsageStartDate,
      EarliestSchedldUsageStartTime,
      EarliestSchedldUsageEndDate,
      EarliestSchedldUsageEndTime,
      LatestSchedldUsageStartDate,
      LatestSchedldUsageStartTime,
      LatestSchedldUsageEndDate,
      LatestSchedldUsageEndTime,
      ActualUsageStartDate,                                             // CE2105

      ActualUsageStartTime,                                             // CE2105

      ActualUsageEndDate,                                               // CE2105

      ActualUsageEndTime,                                               // CE2105

      
      // Duration

      ProdnRsceToolUsageDurnUnit,                                       // CE2105   

      ProdnRsceToolUsageDuration,                                       // CE2105

      _ProdnRsceToolUsageDurnUnit.UnitOfMeasureISOCode as PRTUsageDurationUnitISOCode,  // CE2105

      _ProdnRsceToolUsageDurnUnit.UnitOfMeasureSAPCode as PRTUsageDurationUnitSAPCode,  // CE2105

      
      // Formulas

      ProdnRsceToolTotQtyCalcFormula,                                                   // CE2105

      ProdnRsceToolUsageQtyCalcFmla,                                                    // CE2105      

      
      // Quantities and UoM

      ProdnRsceToolStdWorkQtyUnit,                                                      // CE2105

      @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
      ProdnRsceToolStandardWorkQty,                                                     // CE2105

      _ProdnRsceToolStdWorkQtyUnit.UnitOfMeasureISOCode   as PRTStdWorkQtyUnitISOCode,  // CE2105

      _ProdnRsceToolStdWorkQtyUnit.UnitOfMeasureSAPCode   as PRTStdWorkQtyUnitSAPCode,  // CE2105

            
      PlannedProdnRsceToolQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
      PlannedTotalProdnRsceToolQty,
      _PlannedProdnRsceToolQtyUnit.UnitOfMeasureISOCode   as PlannedPRTQtyUnitISOCode,  // CE2105

      _PlannedProdnRsceToolQtyUnit.UnitOfMeasureSAPCode   as PlannedPRTQtyUnitSAPCode,  // CE2105

            
      ConfirmedProdnRsceToolQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'ConfirmedProdnRsceToolQtyUnit'
      ConfirmedProdnRsceToolQty,
      _ConfirmedProdnRsceToolQtyUnit.UnitOfMeasureISOCode as ConfirmedPRTQtyUnitISOCode, // CE2105

      _ConfirmedProdnRsceToolQtyUnit.UnitOfMeasureSAPCode as ConfirmedPRTQtyUnitSAPCode, // CE2105       

      
      // Usage Quantities an UoMs

      ProdnRsceToolUsageQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
      ProdnRsceToolUsageQuantity,
      _ProdnRsceToolUsageQtyUnit.UnitOfMeasureISOCode as PRTUsageQtyUnitISOCode,        // CE2105

      _ProdnRsceToolUsageQtyUnit.UnitOfMeasureSAPCode as PRTUsageQtyUnitSAPCode,        // CE2105

      
      PlndProdnRsceToolUsageQtyUnit,                                                    // CE2105

      @Semantics.quantity.unitOfMeasure: 'PlndProdnRsceToolUsageQtyUnit'
      PlannedProdnRsceToolUsageQty,                                                     // CE2105

      _PlndProdnRsceToolUsageQtyUnit.UnitOfMeasureISOCode as PlannedPRTUsageQtyUnitISOCode, // CE2105

      _PlndProdnRsceToolUsageQtyUnit.UnitOfMeasureSAPCode as PlannedPRTUsageQtyUnitSAPCode, // CE2105


      ConfdProdnRsceToolUsageQtyUnit,                                                       // CE2105

      @Semantics.quantity.unitOfMeasure: 'ConfdProdnRsceToolUsageQtyUnit'
      ConfirmedProdnRsceToolUsageQty,                                                       // CE2105

      _ConfdProdnRsceToolUsgeQtyUnit.UnitOfMeasureISOCode as ConfdPRTUsageQtyUnitISOCode,   // CE2105

      _ConfdProdnRsceToolUsgeQtyUnit.UnitOfMeasureSAPCode as ConfdPRTUsageQtyUnitSAPCode,   // CE2105


      _ProdnRsceToolMasterData.ProdnRsceToolBaseUnit,                                       // CE2105

      _ProdnRsceToolMasterData._ProdnRsceToolBaseUnit.UnitOfMeasureISOCode as  ProdnRsceToolBaseUnitISOCode, // CE2105

      _ProdnRsceToolMasterData._ProdnRsceToolBaseUnit.UnitOfMeasureSAPCode as  ProdnRsceToolBaseUnitSAPCode  // CE2105

}
where
  IsDeleted != 'X'
  and ManufacturingOrderCategory = '40';