C_MfgOpActyAssgdToOptr

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 C_MfgOpActyAssgdToOptr.
-- 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: CMFGOAASSGDTOOP

CREATE VIEW C_MfgOpActyAssgdToOptr AS
SELECT
  OAAssgmt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OAAssgmt.OpActyNtwkElement AS OpActyNtwkElement,
  OAAssgmt.UserID AS UserID,
  OAAssgmt.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  OAAssgmt._OperationActivityText.OperationActivityName AS OperationActivityName,
  OAAssgmt.OpActyExpdExecDurnInSeconds AS OpActyExpdExecDurnInSeconds,
  OAAssgmt.OpActyExpdExecLaborDurnInSecs AS OpActyExpdExecLaborDurnInSecs,
  OpActyInstanceStatusBasic._SASStatus._Text[1:Language = $session.system_language].SASStatusName AS SASStatusName,
  cast(' ' as char30 preserving type) AS MfgQualifnSufficiencyName,
  cast(3 as int1 preserving type ) AS MfgHumRsceQualifnCritlty,
  cast(' ' as char30 preserving type) AS OpActyExpdExecutionDuration,
  WorkCenter.WorkCenter AS WorkCenter,
  OAAssgmt.ManufacturingOrder AS ManufacturingOrder,
  OAAssgmt.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  OAAssgmt.MfgOpActyExecutionPriority AS MfgOpActyExecutionPriority,
  OAAssgmt.MfgOpActyIsAssgdDirectlyToOptr AS MfgOpActyIsAssgdDirectlyToOptr,
  OAAssgmt._OpActyNtwkInstance AS _OpActyNtwkInstance
FROM I_MfgOpActyAssgdToOptr AS OAAssgmt
LEFT OUTER JOIN I_OpActyRespyMgmtTeamAssgmt AS _OpActyRespyMgmtTeamAssgmt ON OAAssgmt.OpActyNtwkInstance = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkInstance AND OAAssgmt.OpActyNtwkElement = _OpActyRespyMgmtTeamAssgmt.OpActyNtwkElement  -- association [0..*]
LEFT OUTER JOIN C_MfgOperatorDetail AS _Detail ON OAAssgmt.UserID = _Detail.UserID  -- association [1..1]
;