C_TeamOpenOpActyAssignment

DDL: C_TEAMOPENOPACTYASSIGNMENT SQL: CMPETEAMOPNOA Type: view CONSUMPTION Package: MPE_EXEC_COMMON

Open operation activities assigned to a team

C_TeamOpenOpActyAssignment is a Consumption CDS View that provides data about "Open operation activities assigned to a team" in SAP S/4HANA. It reads from 4 data sources (I_OpActyInstanceStatusBasic, I_OpActyInstceOpActyNtwkElmnt, I_OpActyRespyMgmtTeamAssgmtBsc, I_OrderOperationDateTime) and exposes 18 fields with key fields RespyMgmtTeamID, OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_COMMON.

4 data source(s) 18 fields

Data Sources (4)

SourceAliasJoin Type
I_OpActyInstanceStatusBasic OpActyInstanceStatusBasic inner
I_OpActyInstceOpActyNtwkElmnt OpActyInstceOpActyNtwkElmnt inner
I_OpActyRespyMgmtTeamAssgmtBsc OpActyRespyMgmtTeamAssgmtBsc from
I_OrderOperationDateTime OrderOperationDateTime inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMPETEAMOPNOA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Open operation activities assigned to a team view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtTeamID I_OpActyRespyMgmtTeamAssgmtBsc RespyMgmtTeamID
KEY OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt OpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElement
OpActyNtwkElementExternalID
OperationActivityName
OpActyNtwkSegmentType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkSegmentType
ManufacturingOrder I_OpActyInstceOpActyNtwkElmnt ManufacturingOrder
ManufacturingOrderOperation
MfgOrderOperationText I_OrderOperationDateTime OperationText
WorkCenterInternalID I_OrderOperationDateTime WorkCenterInternalID
WorkCenterTypeCode I_OrderOperationDateTime WorkCenterTypeCode
ProductionPlant I_OrderOperationDateTime Plant
MfgOpActyExecutionPriority I_OpActyRespyMgmtTeamAssgmtBsc MfgOpActyExecutionPriority
_OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInstance
_OperationActivityInstance I_OpActyInstceOpActyNtwkElmnt _OperationActivityInstance
_OANSegmentType I_OpActyInstceOpActyNtwkElmnt _OANSegmentType
_MfgOrder I_OpActyInstceOpActyNtwkElmnt _MfgOrder
_WorkCenter I_OrderOperationDateTime _WorkCenter 
@AbapCatalog.sqlViewName: 'CMPETEAMOPNOA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@EndUserText.label: 'Open operation activities assigned to a team'
define view C_TeamOpenOpActyAssignment
  as select from I_OpActyRespyMgmtTeamAssgmtBsc as OpActyRespyMgmtTeamAssgmtBsc
    inner join   I_OpActyInstceOpActyNtwkElmnt  as OpActyInstceOpActyNtwkElmnt on  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance = OpActyRespyMgmtTeamAssgmtBsc.OpActyNtwkInstance
                                                                               and OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement  = OpActyRespyMgmtTeamAssgmtBsc.OpActyNtwkElement
    inner join   I_OpActyInstanceStatusBasic    as OpActyInstanceStatusBasic   on  OpActyInstanceStatusBasic.OpActyNtwkInstance = OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance
                                                                               and OpActyInstanceStatusBasic.OpActyNtwkElement  = OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement
    inner join   I_OrderOperationDateTime       as OrderOperationDateTime      on  OrderOperationDateTime.OrderInternalID          = OpActyInstceOpActyNtwkElmnt.OrderInternalID
                                                                               and OrderOperationDateTime.OrderOperationInternalID = OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID

{
  key OpActyRespyMgmtTeamAssgmtBsc.RespyMgmtTeamID,
  key OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance,
  key OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement,
      @ObjectModel.text.element: 'OperationActivityName'
      cast(OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID as mpe_oa_number_ext preserving type)             as OpActyNtwkElementExternalID,
      @UI.hidden: true
      @Semantics.text: true
      OpActyInstceOpActyNtwkElmnt._OperationActivityText[1: Language=$session.system_language].OperationActivityName as OperationActivityName,
      @UI.hidden: true
      OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType,
      OpActyInstceOpActyNtwkElmnt.ManufacturingOrder                                                                 as ManufacturingOrder,
      @ObjectModel.text.element: 'MfgOrderOperationText'
      cast(OrderOperationDateTime.Operation as mpe_vornr_char  preserving type )                                     as ManufacturingOrderOperation,
      @UI.hidden: true
      @Semantics.text: true
      OrderOperationDateTime.OperationText                                                                           as MfgOrderOperationText,
      @UI.hidden: true
      OrderOperationDateTime.WorkCenterInternalID,
      @UI.hidden: true
      OrderOperationDateTime.WorkCenterTypeCode,
      OrderOperationDateTime.Plant                                                                                   as ProductionPlant,
      //Scheduled Timestamps

      @Semantics.dateTime: true
      cast( case OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType
        when '1' then
          OrderOperationDateTime.OpLtstSchedldExecStrtDteTme
        when '2' then
          OrderOperationDateTime.OpLtstSchedldProcgStrtDteTme
        else
          OrderOperationDateTime.OpLtstSchedldTrdwnStrtDteTme
      end as mpe_oper_schedld_start_time preserving type )                                                           as OpLtstSchedldExecStrtDteTme,
      OpActyRespyMgmtTeamAssgmtBsc.MfgOpActyExecutionPriority,

      OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance,
      OpActyInstceOpActyNtwkElmnt._OperationActivityInstance,
      OpActyInstceOpActyNtwkElmnt._OANSegmentType,
      OpActyInstceOpActyNtwkElmnt._MfgOrder,
      OrderOperationDateTime._WorkCenter
}
where
  -- Only "open" Operation Activities
     OpActyInstanceStatusBasic._SASStatus.SASStatusCategory = 1 -- Initial
  or OpActyInstanceStatusBasic._SASStatus.SASStatusCategory = 2 -- In Process
  or OpActyInstanceStatusBasic._SASStatus.SASStatusCategory = 5 -- Paused

Learn More