Which tables does I_OperationActivityWorklistTP use?

I_OperationActivityWorklistTP reads from 1 data source(s): P_OperationActivityWorklist.

How many fields does I_OperationActivityWorklistTP have?

I_OperationActivityWorklistTP has 57 fields. Key fields: OpActyNtwkInstance, OpActyNtwkElement.

I_OperationActivityWorklistTP

DDL: I_OPERATIONACTIVITYWORKLISTTP Type: view TRANSACTIONAL

Personal Work Queue

I_OperationActivityWorklistTP is a Transactional CDS View that provides data about "Personal Work Queue" in SAP S/4HANA. It reads from 1 data source (P_OperationActivityWorklist) and exposes 57 fields with key fields OpActyNtwkInstance, OpActyNtwkElement. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_OperationActivityWorklist	OperationActivityWorklist	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_OpActyRespyMgmtTeamAssgmt	_OpActyRespyMgmtTeamAssgmt	`$projection.OpActyNtwkInstance = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkElement`
[0..1]	E_OperationActivity	_Extension	`$projection.OperationActivity = _Extension.OperationActivity and $projection.OperationActyVersionCounter = _Extension.OperationActyVersionCounter`

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	IMFGOPAWTP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.compositionRoot	true	view
ObjectModel.transactionalProcessingEnabled	true	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
ObjectModel.draftEnabled	false	view
ObjectModel.writeActivePersistence	IMFGOPAWTP	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#TRANSACTIONAL	view
EndUserText.label	Personal Work Queue	view

Fields (57)

Key	Field	Source Table	Source Field
KEY	OpActyNtwkInstance	P_OperationActivityWorklist	OpActyNtwkInstance
KEY	OpActyNtwkElement	P_OperationActivityWorklist	OpActyNtwkElement
	UserID	P_OperationActivityWorklist	UserID
	OpActyNtwkElementElement	P_OperationActivityWorklist	OpActyNtwkElementElement
	OpActyNtwkElementElmntVersCntr	P_OperationActivityWorklist	OpActyNtwkElementElmntVersCntr
	ManufacturingOrder	P_OperationActivityWorklist	ManufacturingOrder
	ManufacturingOrderOperation	P_OperationActivityWorklist	ManufacturingOrderOperation
	MfgOrderOperationText	P_OperationActivityWorklist	MfgOrderOperationText
	WorkCenter	P_OperationActivityWorklist	WorkCenter
	WorkCenterInternalID	P_OperationActivityWorklist	WorkCenterInternalID
	WorkCenterTypeCode	P_OperationActivityWorklist	WorkCenterTypeCode
	ProductionPlant	P_OperationActivityWorklist	ProductionPlant
	StatusAndActionSchema	P_OperationActivityWorklist	StatusAndActionSchema
	StatusAndActionSchemaStatus	P_OperationActivityWorklist	StatusAndActionSchemaStatus
	SASStatusCategory	P_OperationActivityWorklist	SASStatusCategory
	ProductionUnit	P_OperationActivityWorklist	ProductionUnit
	OpPlannedYieldQuantity	P_OperationActivityWorklist	OpPlannedYieldQuantity
	OpPlannedScrapQuantity	P_OperationActivityWorklist	OpPlannedScrapQuantity
	OperationExecutionAvailableQty
	OpActyExpdExecutionDuration
	OpActyExpdExecutionLaborDurn
	DurationUnit
	OpActyExpdExecDurnInSeconds	P_OperationActivityWorklist	OpActyExpdExecDurnInSeconds
	OpActyExpdExecLaborDurnInSecs	P_OperationActivityWorklist	OpActyExpdExecLaborDurnInSecs
	OpActyNtwkElementExternalID	P_OperationActivityWorklist	OpActyNtwkElementExternalID
	OperationActivityNetwork	P_OperationActivityWorklist	OperationActivityNetwork
	OpActyNtwkVersionCounter	P_OperationActivityWorklist	OpActyNtwkVersionCounter
	OpActyNtwkSegmentType	P_OperationActivityWorklist	OpActyNtwkSegmentType
	OpActyConfIsSFIBased	P_OperationActivityWorklist	OpActyConfIsSFIBased
	OpActyIsSeldForRtactvPostg	P_OperationActivityWorklist	OpActyIsSeldForRtactvPostg
	NrOfOpActyUserAssignments	P_OperationActivityWorklist	NrOfOpActyUserAssignments
	NrOfOpActyTeamAssignments	P_OperationActivityWorklist	NrOfOpActyTeamAssignments
	RespyMgmtTeamID	P_OperationActivityWorklist	RespyMgmtTeamID
	OrderInternalID	P_OperationActivityWorklist	OrderInternalID
	OrderOperationInternalID	P_OperationActivityWorklist	OrderOperationInternalID
	OperationActivity	P_OperationActivityWorklist	OperationActivity
	OperationActyVersionCounter	P_OperationActivityWorklist	OperationActyVersionCounter
	ProductionHold
	OpLtstSchedldExecStrtDteTme	P_OperationActivityWorklist	OpLtstSchedldExecStrtDteTme
	OpLtstSchedldExecEndDteTme	P_OperationActivityWorklist	OpLtstSchedldExecEndDteTme
	OpActualExecutionStartDateTime	P_OperationActivityWorklist	OpActualExecutionStartDateTime
	OpActualExecutionEndDateTime	P_OperationActivityWorklist	OpActualExecutionEndDateTime
	MfgOpActyExecutionPriority	P_OperationActivityWorklist	MfgOpActyExecutionPriority
	_OpActyNtwkInstance	P_OperationActivityWorklist	_OpActyNtwkInstance
	_User	P_OperationActivityWorklist	_User
	_MfgOrder	P_OperationActivityWorklist	_MfgOrder
	_OpActyNtwkInternalId	P_OperationActivityWorklist	_OpActyNtwkInternalId
	_OperationActivityNetwork	P_OperationActivityWorklist	_OperationActivityNetwork
	_SASSchema	P_OperationActivityWorklist	_SASSchema
	_UnitOfMeasure	P_OperationActivityWorklist	_UnitOfMeasure
	_SASStatus	P_OperationActivityWorklist	_SASStatus
	_ProductionPlant	P_OperationActivityWorklist	_ProductionPlant
	_WorkCenterBySemanticKey	P_OperationActivityWorklist	_WorkCenterBySemanticKey
	_WorkCenterType	P_OperationActivityWorklist	_WorkCenterType
	_OpActyUserAssgmt	P_OperationActivityWorklist	_OpActyUserAssgmt
	_OperationActivityText	P_OperationActivityWorklist	_OperationActivityText
	_OpActyRespyMgmtTeamAssgmt		_OpActyRespyMgmtTeamAssgmt

@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":""
}
}*/

Depth:

I_OperationActivityWorklistTP view

P_OperationActivityWorklist view

C_OpActyWorklistOfCurUsrTP view
C_OperationActivityWorklistTP view