I_RoutingActivity

@AbapCatalog.sqlViewName: 'IRTGACT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'BOOOpInternalVersionCounter'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Routing Activity (Opr, Sub-opr) Details'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #XXL, dataClass: #MASTER }
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
define view I_RoutingActivity
  as select from    I_RoutingSequence             as _Sequence
    inner join      I_BOOSqncOperationAssgmtChgSt as _Activity   on  _Sequence.BillOfOperationsType     =  _Activity.BillOfOperationsType
                                                                 and _Sequence.BillOfOperationsGroup    =  _Activity.BillOfOperationsGroup
                                                                 and _Sequence.BillOfOperationsVariant  =  _Activity.BillOfOperationsVariant
                                                                 and _Sequence.BillOfOperationsSequence =  _Activity.BillOfOperationsSequence
                                                                 and _Activity.IsDeleted                <> 'X'
    inner join      I_BillOfOperationsOpBasic     as _Operation  on  _Activity.BillOfOperationsType     = _Operation.BillOfOperationsType
                                                                 and _Activity.BillOfOperationsGroup    = _Operation.BillOfOperationsGroup
                                                                 and (
                                                                    _Activity.BOOOperationInternalID    = _Operation.BOOOperationInternalID
                                                                    or _Activity.BOOOperationInternalID = _Operation.SuperiorOperationInternalID
                                                                  )
    left outer join I_BillOfOperationsOpBasic     as _SuperiorOp on  _Activity.BillOfOperationsType         = _SuperiorOp.BillOfOperationsType
                                                                 and _Activity.BillOfOperationsGroup        = _SuperiorOp.BillOfOperationsGroup
                                                                 and _Operation.SuperiorOperationInternalID = _SuperiorOp.BOOOperationInternalID
    //                                                                 and _SuperiorOp.ValidityStartDate          <= $session.system_date

                                                                 and _SuperiorOp.ValidityEndDate            >= $session.system_date
  association [0..1] to I_TaskListOperationLongText as _LongText on  $projection.BillOfOperationsType        = _LongText.TaskListType
                                                                 and $projection.BillOfOperationsGroup       = _LongText.TaskListGroup
                                                                 and $projection.BOOOperationInternalID      = _LongText.BOOOperationInternalID
                                                                 and $projection.BOOOpInternalVersionCounter = _LongText.BOOInternalVersionCounter
                                                                 and $projection.LongTextLanguageCode        is not null
{
  key _Sequence.BillOfOperationsType,
  key _Sequence.BillOfOperationsGroup,
  key _Sequence.BillOfOperationsVariant,
  key _Sequence.BOOInternalVersionCounter,
  key _Sequence.BillOfOperationsSequence,
  key _Sequence.BOOSqncInternalVersionCounter,
  key _Operation.BOOOperationInternalID,
  key _Operation.BOOOpInternalVersionCounter,
      case
        when _Sequence.ValidityStartDate > _Operation.ValidityStartDate
        then _Sequence.ValidityStartDate
        else _Operation.ValidityStartDate
        end                                                                                                                                                        as ValidityStartDate,
      case
        when _Sequence.ValidityEndDate < _Activity.ValidityEndDate
        then _Sequence.ValidityEndDate
        when _Activity.ValidityEndDate < _Operation.ValidityEndDate
        then _Activity.ValidityEndDate
        else _Operation.ValidityEndDate
      end                                                                                                                                                          as ValidityEndDate,
      _Operation.ChangeNumber,
      case
        when _Operation.SuperiorOperationInternalID <> '00000000'
        then _Operation.IsDeleted
        else _Activity.IsDeleted
      end                                                                                                                                                          as IsDeleted,
      case
        when _Operation.SuperiorOperationInternalID <> '00000000'
        then _Operation.IsImplicitlyDeleted
        else _Activity.IsImplicitlyDeleted
      end                                                                                                                                                          as IsImplicitlyDeleted,
      _Operation.Operation,
      _Operation.SuperiorOperationInternalID,
      _SuperiorOp.Operation                                                                                                                                        as SuperiorOperation,
      _Operation.WorkCenterInternalID                                                                                                                              as WorkCenterInternalID,
      _Operation._WorkCenter.WorkCenter                                                                                                                            as WorkCenter,
      _Operation.Plant,
      _Operation.OperationText,
      _Operation.LongTextLanguageCode,
      _Operation.OperationReferenceQuantity,
      _Operation.OperationUnit,
      _Operation.FactoryCalendar,
      case
        when _Operation._WorkCenter.OpControlProfileIsReferenced = 'X'
        then _Operation._WorkCenter.OperationControlProfile
        else _Operation.OperationControlProfile
      end                                                                                                                                                          as OperationControlProfile,
      _Operation.OpQtyToBaseQtyNmrtr,
      _Operation.OpQtyToBaseQtyDnmntr,
      _Operation.OperationStandardTextCode,
      _Operation.OperationSetupType,
      _Operation.OperationSetupGroup,
      _Operation.OperationSetupGroupCategory,

      // Alternative Sequence Information

      _Sequence.MinimumLotSizeQuantity,
      _Sequence.MaximumLotSizeQuantity,
      _Sequence.BillOfOperationsUnit,

      //      Standard Values

      _Operation._WorkCenter.StandardWorkFormulaParamGroup,
      _Operation.CostCtrActivityType1,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1.StandardWorkFormulaParameter                                               as StandardWorkFormulaParam1,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter1._Text[1:Language = $session.system_language].StandardWorkFormulaParamName  as StandardWorkFormulaParamName1,
      _Operation.StandardWorkQuantity1,
      _Operation.StandardWorkQuantityUnit1,
      _Operation._StandardWorkQuantityUnit1.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit1ISOCode,
      _Operation.CostCtrActivityType2,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2.StandardWorkFormulaParameter                                               as StandardWorkFormulaParam2,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter2._Text[1:Language = $session.system_language].StandardWorkFormulaParamName  as StandardWorkFormulaParamName2,
      _Operation.StandardWorkQuantity2,
      _Operation.StandardWorkQuantityUnit2,
      _Operation._StandardWorkQuantityUnit2.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit2ISOCode,
      _Operation.CostCtrActivityType3,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3.StandardWorkFormulaParameter                                               as StandardWorkFormulaParam3,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter3._Text[1:Language = $session.system_language].StandardWorkFormulaParamName  as StandardWorkFormulaParamName3,
      _Operation.StandardWorkQuantity3,
      _Operation.StandardWorkQuantityUnit3,
      _Operation._StandardWorkQuantityUnit3.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit3ISOCode,
      _Operation.CostCtrActivityType4,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4.StandardWorkFormulaParameter                                               as StandardWorkFormulaParam4,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter4._Text[1:Language = $session.system_language].StandardWorkFormulaParamName  as StandardWorkFormulaParamName4,
      _Operation.StandardWorkQuantity4,
      _Operation.StandardWorkQuantityUnit4,
      _Operation._StandardWorkQuantityUnit4.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit4ISOCode,
      _Operation.CostCtrActivityType5,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5.StandardWorkFormulaParameter                                               as StandardWorkFormulaParam5,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter5._Text[1:Language = $session.system_language].StandardWorkFormulaParamName  as StandardWorkFormulaParamName5,
      _Operation.StandardWorkQuantity5,
      _Operation.StandardWorkQuantityUnit5,
      _Operation._StandardWorkQuantityUnit5.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit5ISOCode,
      _Operation.CostCtrActivityType6,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6.StandardWorkFormulaParameter                                               as StandardWorkFormulaParam6,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup._StandardWorkFormulaParameter6._Text[1:Language = $session.system_language].StandardWorkFormulaParamName  as StandardWorkFormulaParamName6,
      _Operation.StandardWorkQuantity6,
      _Operation.StandardWorkQuantityUnit6,
      _Operation._StandardWorkQuantityUnit6.UnitOfMeasureISOCode                                                                                                   as StdWrkQtyUnit6ISOCode,
      _LongText.PlainLongText,

      _SuperiorOp.BOOOpInternalVersionCounter                                                                                                                      as SuperiorOperationInternalVers,

      /* Administrative Data */
      _Operation.CreationDate,
      _Operation.CreatedByUser,
      _Operation.LastChangeDate,
      _Operation.LastChangedByUser,

      //Associations

      _Sequence._BillOfOperationsType,
      _Sequence._BillOfOperations,
      _Sequence._BillOfOperationsGroup,
      _Sequence._BillOfOperationsSequence,
      _Operation._ChangeMaster,
      _Operation._Plant,
      _Operation._FactoryCalendar,
      _Operation._OperationUnit,
      _Operation._OperationStandardText,
      _Operation._OperationSetupType,
      _Operation._OperationSetupGroup,
      _Operation._OperationSetupGroupCategory,
      _Operation._WorkCenter._StandardWorkFmlaParamGroup,
      _Operation._StandardWorkQuantityUnit1,
      _Operation._StandardWorkQuantityUnit2,
      _Operation._StandardWorkQuantityUnit3,
      _Operation._StandardWorkQuantityUnit4,
      _Operation._StandardWorkQuantityUnit5,
      _Operation._StandardWorkQuantityUnit6
}
where
      _Activity.BillOfOperationsType =  'N'
  and _Operation.ValidityEndDate     >  _Operation.ValidityStartDate
  //  and _Operation.ValidityEndDate     >= $session.system_date

  //  and _Activity.ValidityEndDate      >= $session.system_date

  and _Sequence.IsDeleted            <> 'X'