I_MfgOrderOperationDataList

@AbapCatalog.sqlViewName: 'IPPMOROPDATALIST'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Mfg Order Sub-/Operation (Data List)'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE

define view I_MfgOrderOperationDataList
  as select from I_ManufacturingOrderOperation as MfgOrderOperation
    inner join   I_OrderOperationStatus        as OperationStatus on  MfgOrderOperation.MfgOrderInternalID       = OperationStatus.OrderInternalID
                                                                  and MfgOrderOperation.OrderOperationInternalID = OperationStatus.OrderOperationInternalID

  association [1..1] to I_ManufacturingOrderOperation as _ManufacturingOrderOperation on  $projection.OrderInternalBillOfOperations = _ManufacturingOrderOperation.MfgOrderInternalID
                                                                                      and $projection.OrderIntBillOfOperationsItem  = _ManufacturingOrderOperation.OrderOperationInternalID
  association [1..1] to E_OrderOperation              as _Extension                   on  $projection.OrderInternalBillOfOperations = _Extension.OrderInternalID // Extensibility

                                                                                      and $projection.OrderIntBillOfOperationsItem  = _Extension.OrderOperationInternalID


{

      // internal key

  key MfgOrderOperation.MfgOrderInternalID             as OrderInternalBillOfOperations,
  key MfgOrderOperation.OrderOperationInternalID       as OrderIntBillOfOperationsItem,

      // external key

      @ObjectModel.foreignKey.association: null
      MfgOrderOperation.ManufacturingOrder             as ManufacturingOrder,
      @ObjectModel.foreignKey.association: null
      MfgOrderOperation.ManufacturingOrderSequence     as ManufacturingOrderSequence,
      MfgOrderOperation.ManufacturingOrderOperation    as ManufacturingOrderOperation,
      MfgOrderOperation.ManufacturingOrderSubOperation as ManufacturingOrderSubOperation,
      MfgOrderOperation.SuperiorOperationInternalID    as SuperiorOperationInternalID,

      // Category 10 = Production Order 40 = Process Order

      MfgOrderOperation.ManufacturingOrderCategory     as ManufacturingOrderCategory,
      MfgOrderOperation.MfgOrderOperationIsPhase       as MfgOrderOperationIsPhase,

      // text

      MfgOrderOperation.MfgOrderOperationText          as MfgOrderOperationText,
      MfgOrderOperation.Language                       as LongTextLanguageCode,

      MfgOrderOperation._WorkCenter.WorkCenter         as WorkCenter,
      MfgOrderOperation.Plant                          as ProductionPlant,

      MfgOrderOperation.OpLtstSchedldExecStrtDte       as OpLtstSchedldExecStrtDte,
      MfgOrderOperation.OpLtstSchedldExecEndDte        as OpLtstSchedldExecEndDte,

      MfgOrderOperation.OperationConfirmation          as OperationConfirmation,


      //WorkCenterStandard

      MfgOrderOperation.WorkCenterStandardWorkQty1     as WorkCenterStandardWorkQty1,
      MfgOrderOperation.WorkCenterStandardWorkQty2     as WorkCenterStandardWorkQty2,
      MfgOrderOperation.WorkCenterStandardWorkQty3     as WorkCenterStandardWorkQty3,
      MfgOrderOperation.WorkCenterStandardWorkQty4     as WorkCenterStandardWorkQty4,
      MfgOrderOperation.WorkCenterStandardWorkQty5     as WorkCenterStandardWorkQty5,
      MfgOrderOperation.WorkCenterStandardWorkQty6     as WorkCenterStandardWorkQty6,

      //WorkCenterStandardUnit

      MfgOrderOperation.WorkCenterStandardWorkQtyUnit1,
      MfgOrderOperation.WorkCenterStandardWorkQtyUnit2,
      MfgOrderOperation.WorkCenterStandardWorkQtyUnit3,
      MfgOrderOperation.WorkCenterStandardWorkQtyUnit4,
      MfgOrderOperation.WorkCenterStandardWorkQtyUnit5,
      MfgOrderOperation.WorkCenterStandardWorkQtyUnit6,

      _ManufacturingOrderOperation
}

where
  OperationStatus.OperationIsDeleted = ' '