I_UserOpenOpActyAssignment

DDL: I_USEROPENOPACTYASSIGNMENT SQL: IMPEUSROPNOA Type: view COMPOSITE
46 Fields 1 Data Sources

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.

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 User Name
KEY OpActyNtwkInstance OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement OpActyNtwkElement Element Number
ManufacturingOrder ManufacturingOrder Order
OrderInternalID OrderInternalID Plan No.f.Oper.
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 Op. Activity
OperationActivity OperationActivity Operation Activity
OperationActyVersionCounter OperationActyVersionCounter OA Version
OperationActivityName
OpActyNtwkElementType OpActyNtwkElementType
ManufacturingOrderOperation ManufacturingOrderOperation Activity
MfgOrderOperationText MfgOrderOperationText Description
WorkCenter WorkCenter Work Center
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
ProductionPlant ProductionPlant Prod plnt
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
MfgOpActyExecutionPriority MfgOpActyExecutionPriority
OpLtstSchedldExecStrtDteTme OpLtstSchedldExecStrtDteTme Time Stamp
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

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_UserOpenOpActyAssignment.
-- 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.
-- SQL view name: IMPEUSROPNOA

CREATE VIEW I_UserOpenOpActyAssignment AS
SELECT
  UserID,
  OpActyNtwkInstance,
  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
FROM P_OpActyInstanceWithUserAssgmt
;

Learn More