P_OpActyInstanceWithUserAssgmt

DDL: P_OPACTYINSTANCEWITHUSERASSGMT SQL: POAIWUA Type: view TRANSACTIONAL
49 Fields 4 Data Sources 4 Associations

P_OpActyInstanceWithUserAssgmt is a Transactional CDS View in SAP S/4HANA. It reads from 4 data sources (I_OpActyUserAssgmtBasic, I_OpActyInstanceStatusBasic, I_OpActyInstceOpActyNtwkElmnt, I_OrderOperationDateTime) and exposes 49 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, UserID. It has 4 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_OpActyUserAssgmtBasic assgmt left_outer
I_OpActyInstanceStatusBasic OpActyInstanceStatusBasic inner
I_OpActyInstceOpActyNtwkElmnt OpActyInstceOpActyNtwkElmnt from
I_OrderOperationDateTime OrderOperationDateTime inner

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_User _User $projection.UserID = _User.UserID
[1..1] I_Plant _ProductionPlant $projection.ProductionPlant = _ProductionPlant.Plant
[0..1] I_WorkCenterBySemanticKey _WorkCenterBySemanticKey $projection.WorkCenter = _WorkCenterBySemanticKey.WorkCenter and $projection.ProductionPlant = _WorkCenterBySemanticKey.Plant
[0..1] I_WorkCenterType _WorkCenterType $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName POAIWUA view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #TRANSACTIONAL view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElement Element Number
KEY UserID
ManufacturingOrder I_OpActyInstceOpActyNtwkElmnt ManufacturingOrder Order
OrderInternalID I_OpActyInstceOpActyNtwkElmnt OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_OpActyInstceOpActyNtwkElmnt OrderOperationInternalID
StatusAndActionSchema I_OpActyInstceOpActyNtwkElmnt StatusAndActionSchema
StatusAndActionSchemaStatus I_OpActyInstanceStatusBasic StatusAndActionSchemaStatus Status
SASStatusCategory
ProductionUnit I_OpActyInstceOpActyNtwkElmnt ProductionUnit
OpPlannedYieldQuantity I_OpActyInstceOpActyNtwkElmnt OpPlannedYieldQuantity
OpPlannedScrapQuantity I_OpActyInstceOpActyNtwkElmnt OpPlannedScrapQuantity
OpActyExpdExecDurnInSeconds I_OpActyInstceOpActyNtwkElmnt OpActyExpdExecDurnInSeconds
OperationActivityNetwork I_OpActyInstceOpActyNtwkElmnt OperationActivityNetwork
OpActyNtwkVersionCounter I_OpActyInstceOpActyNtwkElmnt OpActyNtwkVersionCounter
OpActyNtwkSegmentType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkSegmentType
OpActyConfIsSFIBased I_OpActyInstceOpActyNtwkElmnt OpActyConfIsSFIBased
OpActyConfirmationIsAllowed I_OpActyInstceOpActyNtwkElmnt OpActyConfirmationIsAllowed
OpActyConfNotAllowedReason I_OpActyInstceOpActyNtwkElmnt OpActyConfNotAllowedReason
OpActyNtwkElementExternalID I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementExternalID Op. Activity
OpActyNtwkElementElement I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementElement Operation Activity
OpActyNtwkElementElmntVersCntr I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementElmntVersCntr OA Version
OperationActivity I_OpActyInstceOpActyNtwkElmnt OperationActivity Operation Activity
OperationActyVersionCounter I_OpActyInstceOpActyNtwkElmnt OperationActyVersionCounter OA Version
OpActyNtwkElementType I_OpActyInstceOpActyNtwkElmnt OpActyNtwkElementType
ManufacturingOrderOperation I_OrderOperationDateTime Operation Transaction
MfgOrderOperationText I_OrderOperationDateTime OperationText Description
WorkCenter WorkCenter WorkCenter Work Center
WorkCenterInternalID I_OrderOperationDateTime WorkCenterInternalID Work Center
WorkCenterTypeCode I_OrderOperationDateTime WorkCenterTypeCode Object Type
LaborTrackingIsRequired WorkCenter LaborTrackingIsRequired
ProductionPlant I_OrderOperationDateTime Plant Valuation Area
CreatedByUser I_OpActyUserAssgmtBasic CreatedByUser User Name
CreationDateTime I_OpActyUserAssgmtBasic CreationDateTime Timestamp
MfgOpActyExecutionPriority I_OpActyUserAssgmtBasic MfgOpActyExecutionPriority Execution Priority
_MfgOrder I_OpActyInstceOpActyNtwkElmnt _MfgOrder
_OrderInternalID I_OpActyInstceOpActyNtwkElmnt _OrderInternalID
_OpActyNtwkInstance I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInstance
_SASSchema I_OpActyInstceOpActyNtwkElmnt _SASSchema
_UnitOfMeasure I_OpActyInstceOpActyNtwkElmnt _UnitOfMeasure
_OpActyNtwkInternalId I_OpActyInstceOpActyNtwkElmnt _OpActyNtwkInternalId
_OperationActivityNetwork I_OpActyInstceOpActyNtwkElmnt _OperationActivityNetwork
_OperationActivity I_OpActyInstceOpActyNtwkElmnt _OperationActivity
_OperationActivityText I_OpActyInstceOpActyNtwkElmnt _OperationActivityText
_ProductionPlant _ProductionPlant
_WorkCenterType _WorkCenterType
_User _User
_WorkCenterBySemanticKey _WorkCenterBySemanticKey
_SASStatus I_OpActyInstanceStatusBasic _SASStatus

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 P_OpActyInstanceWithUserAssgmt.
-- 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: POAIWUA

CREATE VIEW P_OpActyInstanceWithUserAssgmt AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  coalesce( assgmt.UserID, '' ) AS UserID,
  OpActyInstceOpActyNtwkElmnt.ManufacturingOrder AS ManufacturingOrder,
  OpActyInstceOpActyNtwkElmnt.OrderInternalID AS OrderInternalID,
  OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID AS OrderOperationInternalID,
  OpActyInstceOpActyNtwkElmnt.StatusAndActionSchema AS StatusAndActionSchema,
  OpActyInstanceStatusBasic.StatusAndActionSchemaStatus AS StatusAndActionSchemaStatus,
  OpActyInstanceStatusBasic._SASStatus.SASStatusCategory AS SASStatusCategory,
  OpActyInstceOpActyNtwkElmnt.ProductionUnit AS ProductionUnit,
  OpActyInstceOpActyNtwkElmnt.OpPlannedYieldQuantity AS OpPlannedYieldQuantity,
  OpActyInstceOpActyNtwkElmnt.OpPlannedScrapQuantity AS OpPlannedScrapQuantity,
  OpActyInstceOpActyNtwkElmnt.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OpActyInstceOpActyNtwkElmnt.OperationActivityNetwork AS OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkVersionCounter AS OpActyNtwkVersionCounter,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyInstceOpActyNtwkElmnt.OpActyConfIsSFIBased AS OpActyConfIsSFIBased,
  OpActyInstceOpActyNtwkElmnt.OpActyConfirmationIsAllowed AS OpActyConfirmationIsAllowed,
  OpActyInstceOpActyNtwkElmnt.OpActyConfNotAllowedReason AS OpActyConfNotAllowedReason,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElement AS OpActyNtwkElementElement,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementElmntVersCntr AS OpActyNtwkElementElmntVersCntr,
  OpActyInstceOpActyNtwkElmnt.OperationActivity AS OperationActivity,
  OpActyInstceOpActyNtwkElmnt.OperationActyVersionCounter AS OperationActyVersionCounter,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElementType AS OpActyNtwkElementType,
  OrderOperationDateTime.Operation AS ManufacturingOrderOperation,
  OrderOperationDateTime.OperationText AS MfgOrderOperationText,
  WorkCenter.WorkCenter AS WorkCenter,
  OrderOperationDateTime.WorkCenterInternalID AS WorkCenterInternalID,
  OrderOperationDateTime.WorkCenterTypeCode AS WorkCenterTypeCode,
  WorkCenter.LaborTrackingIsRequired AS LaborTrackingIsRequired,
  OrderOperationDateTime.Plant AS ProductionPlant,
  assgmt.CreatedByUser AS CreatedByUser,
  assgmt.CreationDateTime AS CreationDateTime,
  assgmt.MfgOpActyExecutionPriority AS MfgOpActyExecutionPriority,
  OpActyInstceOpActyNtwkElmnt._MfgOrder AS _MfgOrder,
  OpActyInstceOpActyNtwkElmnt._OrderInternalID AS _OrderInternalID,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt._SASSchema AS _SASSchema,
  OpActyInstceOpActyNtwkElmnt._UnitOfMeasure AS _UnitOfMeasure,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInternalId AS _OpActyNtwkInternalId,
  OpActyInstceOpActyNtwkElmnt._OperationActivityNetwork AS _OperationActivityNetwork,
  OpActyInstceOpActyNtwkElmnt._OperationActivity AS _OperationActivity,
  OpActyInstceOpActyNtwkElmnt._OperationActivityText AS _OperationActivityText,
  OpActyInstanceStatusBasic._SASStatus AS _SASStatus
FROM I_OpActyInstceOpActyNtwkElmnt AS OpActyInstceOpActyNtwkElmnt
INNER JOIN I_OpActyInstanceStatusBasic AS OpActyInstanceStatusBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperationDateTime AS OrderOperationDateTime ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyUserAssgmtBasic AS assgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _User ON UserID = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON WorkCenter = _WorkCenterBySemanticKey.WorkCenter AND ProductionPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
;

Learn More