I_OPERATIONACTIVITYWORKLISTTP

CDS View

Personal Work Queue

I_OPERATIONACTIVITYWORKLISTTP is a CDS View in S/4HANA. Personal Work Queue. It contains 51 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 51 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_OpActyWorklistOfCurUsrTP view from CONSUMPTION
C_OperationActivityWorklistTP view from CONSUMPTION

Fields (51)

KeyField CDS FieldsUsed in Views
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
_MfgOrder _MfgOrder 2
_OpActyNtwkInstance _OpActyNtwkInstance 2
_OpActyNtwkInternalId _OpActyNtwkInternalId 2
_OpActyRespyMgmtTeamAssgmt _OpActyRespyMgmtTeamAssgmt 2
_OpActyUserAssgmt _OpActyUserAssgmt 2
_OperationActivityNetwork _OperationActivityNetwork 2
_ProductionPlant _ProductionPlant 2
_SASSchema _SASSchema 2
_SASStatus _SASStatus 2
_UnitOfMeasure _UnitOfMeasure 2
_WorkCenterBySemanticKey _WorkCenterBySemanticKey 2
_WorkCenterType _WorkCenterType 2
DurationUnit DurationUnit 2
ManufacturingOrder ManufacturingOrder 2
MfgOpActyExecutionPriority MfgOpActyExecutionPriority 2
MfgOrderOperationText MfgOrderOperationText 2
NrOfOpActyTeamAssignments NrOfOpActyTeamAssignments 2
NrOfOpActyUserAssignments NrOfOpActyUserAssignments 2
OpActualExecutionEndDateTime OpActualExecutionEndDateTime 2
OpActualExecutionStartDateTime OpActualExecutionStartDateTime 2
OpActyConfIsSFIBased OpActyConfIsSFIBased 2
OpActyExpdExecDurnInSeconds OpActyExpdExecDurnInSeconds 2
OpActyExpdExecLaborDurnInSecs OpActyExpdExecLaborDurnInSecs 2
OpActyExpdExecutionDuration OpActyExpdExecutionDuration 2
OpActyExpdExecutionLaborDurn OpActyExpdExecutionLaborDurn 2
OpActyIsSeldForRtactvPostg OpActyIsSeldForRtactvPostg 2
OpActyNtwkSegmentType OpActyNtwkSegmentType 2
OpActyNtwkVersionCounter OpActyNtwkVersionCounter 2
OperationActivity OperationActivity 2
OperationActivityNetwork OperationActivityNetwork 2
OperationActyVersionCounter OperationActyVersionCounter 2
OperationExecutionAvailableQty OperationExecutionAvailableQty 2
OpLtstSchedldExecEndDteTme OpLtstSchedldExecEndDteTme 2
OpLtstSchedldExecStrtDteTme OpLtstSchedldExecStrtDteTme 2
OpPlannedScrapQuantity OpPlannedScrapQuantity 2
OpPlannedYieldQuantity OpPlannedYieldQuantity 2
OrderInternalID OrderInternalID 2
OrderOperationInternalID OrderOperationInternalID 2
ProductionHold ProductionHold 2
ProductionPlant ProductionPlant 2
ProductionUnit ProductionUnit 2
RespyMgmtTeamID RespyMgmtTeamID 2
SASStatusCategory SASStatusCategory 2
StatusAndActionSchema StatusAndActionSchema 2
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 2
UserID UserID 2
WorkCenter WorkCenter 2
WorkCenterInternalID WorkCenterInternalID 2
WorkCenterTypeCode WorkCenterTypeCode 2 
@AbapCatalog: {
  sqlViewName: 'IMFGOPAWTP',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #REQUIRED
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  compositionRoot:  true,
  transactionalProcessingEnabled: true,
  createEnabled:    false,
  updateEnabled:    false,
  deleteEnabled:    false,
  draftEnabled:     false,
  writeActivePersistence: 'IMFGOPAWTP',
  usageType: {
    serviceQuality: #D,
    sizeCategory:   #XL,
    dataClass:      #MIXED
  }
}
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Personal Work Queue'
define view I_OperationActivityWorklistTP
  as select from P_OperationActivityWorklist as OperationActivityWorklist

  association [0..*] to I_OpActyRespyMgmtTeamAssgmt as _OpActyRespyMgmtTeamAssgmt on  $projection.OpActyNtwkInstance = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkElement

  association [0..1] to E_OperationActivity         as _Extension                 on  $projection.OperationActivity           = _Extension.OperationActivity
                                                                                  and $projection.OperationActyVersionCounter = _Extension.OperationActyVersionCounter

{
      //P_OpActyInstanceWithUserAssgmt

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
  key OperationActivityWorklist.OpActyNtwkInstance,
      @ObjectModel.readOnly: true
  key OperationActivityWorklist.OpActyNtwkElement,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.UserID,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyNtwkElementElement,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyNtwkElementElmntVersCntr,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.ManufacturingOrder,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.ManufacturingOrderOperation,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.MfgOrderOperationText,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.WorkCenter,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.WorkCenterInternalID,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.WorkCenterTypeCode,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.ProductionPlant,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.StatusAndActionSchema,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.StatusAndActionSchemaStatus,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.SASStatusCategory,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.ProductionUnit,
      @ObjectModel.readOnly: true
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      OperationActivityWorklist.OpPlannedYieldQuantity,
      @ObjectModel.readOnly: true
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      OperationActivityWorklist.OpPlannedScrapQuantity,
      @Semantics.quantity.unitOfMeasure: 'ProductionUnit'
      @ObjectModel: { virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_MPE_OA_READY_QTY' }
      cast( 0 as mpe_ready_qty )            as OperationExecutionAvailableQty,
      @Semantics.quantity.unitOfMeasure: 'DurationUnit'
      @ObjectModel: { virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_MPE_OA_EXPD_EXEC_DURN' }
      cast(0 as mpe_target_duration_quan)   as OpActyExpdExecutionDuration,
      @Semantics.quantity.unitOfMeasure: 'DurationUnit'
      @ObjectModel: { virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_MPE_OA_EXPD_EXEC_DURN' }
      cast(0 as mpe_target_labor_durn_quan) as OpActyExpdExecutionLaborDurn,
      @ObjectModel: { virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_MPE_OA_EXPD_EXEC_DURN' }
      @Semantics.unitOfMeasure: true
      cast('' as durationunit)              as DurationUnit,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyExpdExecDurnInSeconds,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyExpdExecLaborDurnInSecs,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyNtwkElementExternalID,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OperationActivityNetwork,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyNtwkVersionCounter,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyNtwkSegmentType,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyConfIsSFIBased,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActyIsSeldForRtactvPostg,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.NrOfOpActyUserAssignments,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.NrOfOpActyTeamAssignments,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.RespyMgmtTeamID,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OrderInternalID,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OrderOperationInternalID,
      OperationActivityWorklist.OperationActivity,
      OperationActivityWorklist.OperationActyVersionCounter,

      // Hold Information (as virtual elements for performance reasons)

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_MPE_OAI_HOLD_INFO'
      cast( 0 as mpe_hold_nmbr )            as ProductionHold,

      //_MfgOrderOpAdaptedDates

      //Scheduled Timestamps

      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpLtstSchedldExecStrtDteTme,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpLtstSchedldExecEndDteTme,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActualExecutionStartDateTime,
      @ObjectModel.readOnly: true
      OperationActivityWorklist.OpActualExecutionEndDateTime,

      OperationActivityWorklist.MfgOpActyExecutionPriority,

      /* Associations */
      OperationActivityWorklist._OpActyNtwkInstance,
      OperationActivityWorklist._User,
      OperationActivityWorklist._MfgOrder,
      OperationActivityWorklist._OpActyNtwkInternalId,
      OperationActivityWorklist._OperationActivityNetwork,
      OperationActivityWorklist._SASSchema,
      OperationActivityWorklist._UnitOfMeasure,
      OperationActivityWorklist._SASStatus,
      OperationActivityWorklist._ProductionPlant,
      OperationActivityWorklist._WorkCenterBySemanticKey,
      OperationActivityWorklist._WorkCenterType,
      OperationActivityWorklist._OpActyUserAssgmt,
      OperationActivityWorklist._OperationActivityText,
      _OpActyRespyMgmtTeamAssgmt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_OPERATIONACTIVITYWORKLIST"
],
"ASSOCIATED":
[
"E_OPERATIONACTIVITY",
"I_MFGORDER",
"I_OPACTYNTWKINSTANCE",
"I_OPACTYNTWKINTERNALID",
"I_OPACTYRESPYMGMTTEAMASSGMT",
"I_OPACTYUSERASSGMT",
"I_OPERATIONACTIVITYNETWORK",
"I_OPERATIONACTIVITYTEXT",
"I_PLANT",
"I_SASSCHEMA",
"I_SASSTATUS",
"I_UNITOFMEASURE",
"I_USER",
"I_WORKCENTERBYSEMANTICKEY",
"I_WORKCENTERTYPE"
],
"BASE":
[
"P_OPERATIONACTIVITYWORKLIST"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More