I_UserOpenOpActyAssignment

DDL: I_USEROPENOPACTYASSIGNMENT SQL: IMPEUSROPNOA Type: view COMPOSITE

Open operation activities assigned to an user

I_UserOpenOpActyAssignment is a Composite CDS View that provides data about "Open operation activities assigned to an user" in SAP S/4HANA. It reads from 1 data source (P_OpActyInstanceWithUserAssgmt) and exposes 46 fields with key fields UserID, OpActyNtwkInstance, OpActyNtwkElement.

1 data source(s) 46 fields

Data Sources (1)

SourceAliasJoin Type
P_OpActyInstanceWithUserAssgmt P_OpActyInstanceWithUserAssgmt from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPEUSROPNOA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
EndUserText.label Open operation activities assigned to an user view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY UserID UserID
KEY OpActyNtwkInstance OpActyNtwkInstance
KEY OpActyNtwkElement OpActyNtwkElement
ManufacturingOrder ManufacturingOrder
OrderInternalID OrderInternalID
OrderOperationInternalID OrderOperationInternalID
StatusAndActionSchema StatusAndActionSchema
StatusAndActionSchemaStatus StatusAndActionSchemaStatus
ProductionUnit ProductionUnit
OpPlannedYieldQuantity OpPlannedYieldQuantity
OpPlannedScrapQuantity OpPlannedScrapQuantity
OpActyExpdExecDurnInSeconds OpActyExpdExecDurnInSeconds
OperationActivityNetwork OperationActivityNetwork
OpActyNtwkVersionCounter OpActyNtwkVersionCounter
OpActyNtwkSegmentType OpActyNtwkSegmentType
OpActyConfIsSFIBased OpActyConfIsSFIBased
OpActyConfirmationIsAllowed OpActyConfirmationIsAllowed
OpActyConfNotAllowedReason OpActyConfNotAllowedReason
OpActyNtwkElementExternalID OpActyNtwkElementExternalID
OperationActivity OperationActivity
OperationActyVersionCounter OperationActyVersionCounter
OperationActivityName
OpActyNtwkElementType OpActyNtwkElementType
ManufacturingOrderOperation ManufacturingOrderOperation
MfgOrderOperationText MfgOrderOperationText
WorkCenter WorkCenter
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
ProductionPlant ProductionPlant
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
MfgOpActyExecutionPriority MfgOpActyExecutionPriority
OpLtstSchedldExecStrtDteTme OpLtstSchedldExecStrtDteTme
DateIsActualDate DateIsActualDate
_MfgOrder _MfgOrder
_OpActyNtwkInstance _OpActyNtwkInstance
_OpActyNtwkInternalId _OpActyNtwkInternalId
_OperationActivityNetwork _OperationActivityNetwork
_OrderInternalID _OrderInternalID
_ProductionPlant _ProductionPlant
_SASSchema _SASSchema
_SASStatus _SASStatus
_UnitOfMeasure _UnitOfMeasure
_User _User
_WorkCenterBySemanticKey _WorkCenterBySemanticKey
_WorkCenterType _WorkCenterType 
@AbapCatalog.sqlViewName: 'IMPEUSROPNOA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Open operation activities assigned to an user'
define view I_UserOpenOpActyAssignment
  as select from P_OpActyInstanceWithUserAssgmt
 
{
  key UserID,
  key OpActyNtwkInstance,
  key OpActyNtwkElement,
      ManufacturingOrder,
      OrderInternalID,
      OrderOperationInternalID,
      StatusAndActionSchema,
      StatusAndActionSchemaStatus,
      ProductionUnit,
      OpPlannedYieldQuantity,
      OpPlannedScrapQuantity,
      OpActyExpdExecDurnInSeconds,
      OperationActivityNetwork,
      OpActyNtwkVersionCounter,
      OpActyNtwkSegmentType,
      OpActyConfIsSFIBased,
      OpActyConfirmationIsAllowed,
      OpActyConfNotAllowedReason,
      OpActyNtwkElementExternalID,
      OperationActivity,
      OperationActyVersionCounter,
      _OperationActivityText[1: Language=$session.system_language].OperationActivityName as  OperationActivityName,
      OpActyNtwkElementType,
      ManufacturingOrderOperation,
      MfgOrderOperationText,
      WorkCenter,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      ProductionPlant,
      CreatedByUser,
      CreationDateTime,
      MfgOpActyExecutionPriority,
      OpLtstSchedldExecStrtDteTme,
      DateIsActualDate,
      /* Associations */
      _MfgOrder,
      _OpActyNtwkInstance,
      _OpActyNtwkInternalId,
      _OperationActivityNetwork,
      _OrderInternalID,
      _ProductionPlant,
      _SASSchema,
      _SASStatus,
      _UnitOfMeasure,
      _User,
      _WorkCenterBySemanticKey,
      _WorkCenterType
}
where
  -- Only "open" Operation Activities
     _SASStatus.SASStatusCategory = 1 -- Initial
  or _SASStatus.SASStatusCategory = 2 -- In Process
  or _SASStatus.SASStatusCategory = 5 -- Paused
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONACTIVITYTEXT",
"I_SASSTATUS",
"P_OPACTYINSTANCEWITHUSERASSGMT"
],
"ASSOCIATED":
[
"I_MFGORDER",
"I_OPACTYNTWKINSTANCE",
"I_OPACTYNTWKINTERNALID",
"I_OPERATIONACTIVITYNETWORK",
"I_ORDINTERNALBILLOFOPERATIONS",
"I_PLANT",
"I_SASSCHEMA",
"I_SASSTATUS",
"I_UNITOFMEASURE",
"I_USER",
"I_WORKCENTERBYSEMANTICKEY",
"I_WORKCENTERTYPE"
],
"BASE":
[
"P_OPACTYINSTANCEWITHUSERASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More