I_OperationActivityWorklistTP

DDL: I_OPERATIONACTIVITYWORKLISTTP Type: view TRANSACTIONAL Package: MPE_EXEC_COMMON
57 Fields 1 Data Sources 2 Associations

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. Part of development package MPE_EXEC_COMMON.

Data Sources (1)

SourceAliasJoin Type
P_OperationActivityWorklist OperationActivityWorklist from

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OperationActivityWorklist OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OperationActivityWorklist OpActyNtwkElement Element Number
UserID P_OperationActivityWorklist UserID User Name
OpActyNtwkElementElement P_OperationActivityWorklist OpActyNtwkElementElement Operation Activity
OpActyNtwkElementElmntVersCntr P_OperationActivityWorklist OpActyNtwkElementElmntVersCntr OA Version
ManufacturingOrder P_OperationActivityWorklist ManufacturingOrder Order
ManufacturingOrderOperation P_OperationActivityWorklist ManufacturingOrderOperation Activity
MfgOrderOperationText P_OperationActivityWorklist MfgOrderOperationText Description
WorkCenter P_OperationActivityWorklist WorkCenter Work Center
WorkCenterInternalID P_OperationActivityWorklist WorkCenterInternalID Work Center
WorkCenterTypeCode P_OperationActivityWorklist WorkCenterTypeCode Object Type
ProductionPlant P_OperationActivityWorklist ProductionPlant Prod plnt
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 Op. Activity
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 Team ID
OrderInternalID P_OperationActivityWorklist OrderInternalID Plan No.f.Oper.
OrderOperationInternalID P_OperationActivityWorklist OrderOperationInternalID
OperationActivity P_OperationActivityWorklist OperationActivity Operation Activity
OperationActyVersionCounter P_OperationActivityWorklist OperationActyVersionCounter OA Version
ProductionHold
OpLtstSchedldExecStrtDteTme P_OperationActivityWorklist OpLtstSchedldExecStrtDteTme Time Stamp
OpLtstSchedldExecEndDteTme P_OperationActivityWorklist OpLtstSchedldExecEndDteTme Time Stamp
OpActualExecutionStartDateTime P_OperationActivityWorklist OpActualExecutionStartDateTime Time Stamp
OpActualExecutionEndDateTime P_OperationActivityWorklist OpActualExecutionEndDateTime Time Stamp
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_OperationActivityWorklistTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_OperationActivityWorklistTP AS
SELECT
  OperationActivityWorklist.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActivityWorklist.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActivityWorklist.UserID AS UserID,
  OperationActivityWorklist.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OperationActivityWorklist.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OperationActivityWorklist.ManufacturingOrder AS ManufacturingOrder,
  OperationActivityWorklist.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  OperationActivityWorklist.MfgOrderOperationText AS MfgOrderOperationText,
  OperationActivityWorklist.WorkCenter AS WorkCenter,
  OperationActivityWorklist.WorkCenterInternalID AS WorkCenterInternalID,
  OperationActivityWorklist.WorkCenterTypeCode AS WorkCenterTypeCode,
  OperationActivityWorklist.ProductionPlant AS ProductionPlant,
  OperationActivityWorklist.StatusAndActionSchema AS StatusAndActionSchema,
  OperationActivityWorklist.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  OperationActivityWorklist.SASStatusCategory AS SASStatusCategory,
  OperationActivityWorklist.ProductionUnit AS ProductionUnit,
  OperationActivityWorklist.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  OperationActivityWorklist.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  cast( 0 as mpe_ready_qty ) AS OperationExecutionAvailableQty,
  cast(0 as mpe_target_duration_quan) AS OpActyExpdExecutionDuration,
  cast(0 as mpe_target_labor_durn_quan) AS OpActyExpdExecutionLaborDurn,
  cast('' as durationunit) AS DurationUnit,
  OperationActivityWorklist.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OperationActivityWorklist.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  OperationActivityWorklist.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OperationActivityWorklist.OperationActivityNetwork AS OperationActivityNetwork,
  OperationActivityWorklist.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OperationActivityWorklist.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OperationActivityWorklist.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  OperationActivityWorklist.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  OperationActivityWorklist.NrOfOpActyUserAssignments AS NrOfOpActyUserAssignments,
  OperationActivityWorklist.NrOfOpActyTeamAssignments AS NrOfOpActyTeamAssignments,
  OperationActivityWorklist.RespyMgmtTeamID AS RespyMgmtTeamID,
  OperationActivityWorklist.OrderInternalID AS OrderInternalID,
  OperationActivityWorklist.OrderOperationInternalID AS OrderOperationInternalID,
  OperationActivityWorklist.OperationActivity AS OperationActivity,
  OperationActivityWorklist.OperationActyVersionCounter AS OperationActyVersionCounter,
  cast( 0 as mpe_hold_nmbr ) AS ProductionHold,
  OperationActivityWorklist.OpLtstSchedldExecStrtDteTme AS OpLtstSchedldExecStrtDteTme,
  OperationActivityWorklist.OpLtstSchedldExecEndDteTme AS OpLtstSchedldExecEndDteTme,
  OperationActivityWorklist.OpActualExecutionStartDateTime AS OpActualExecutionStartDateTime,
  OperationActivityWorklist.OpActualExecutionEndDateTime AS OpActualExecutionEndDateTime,
  OperationActivityWorklist.MfgOpActyExecutionPriority AS MfgOpActyExecutionPriority,
  OperationActivityWorklist._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OperationActivityWorklist._User AS _User,
  OperationActivityWorklist._MfgOrder AS _MfgOrder,
  OperationActivityWorklist._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OperationActivityWorklist._OperationActivityNetwork AS _OperationActivityNetwork,
  OperationActivityWorklist._SASSchema AS _SASSchema,
  OperationActivityWorklist._UnitOfMeasure AS _UnitOfMeasure,
  OperationActivityWorklist._SASStatus AS _SASStatus,
  OperationActivityWorklist._ProductionPlant AS _ProductionPlant,
  OperationActivityWorklist._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey,
  OperationActivityWorklist._WorkCenterType AS _WorkCenterType,
  OperationActivityWorklist._OpActyUserAssgmt AS _OpActyUserAssgmt,
  OperationActivityWorklist._OperationActivityText AS _OperationActivityText
FROM P_OperationActivityWorklist AS OperationActivityWorklist
LEFT OUTER JOIN I_OpActyRespyMgmtTeamAssgmt AS _OpActyRespyMgmtTeamAssgmt ON OpActyNtwkInstance = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN E_OperationActivity AS _Extension ON OperationActivity = _Extension.OperationActivity AND OperationActyVersionCounter = _Extension.OperationActyVersionCounter  -- association [0..1]
;

Learn More