I_OpActyMainWrkCtrMfgUser

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_OpActyMainWrkCtrMfgUser.
-- 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: IMPEOAMWRKCTRUSR

CREATE VIEW I_OpActyMainWrkCtrMfgUser AS
SELECT
  OpActyMainWrkCtrMfgUser.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyMainWrkCtrMfgUser.OpActyNtwkElement AS OpActyNtwkElement,
  cast(OpActyMainWrkCtrMfgUser.UserID as mpe_exec_operator preserving type) AS UserID,
  cast(OpActyMainWrkCtrMfgUser._User.UserDescription as mpe_exec_operator_desc preserving type) AS UserDescription,
  OpActyMainWrkCtrMfgUser.BusinessPartnerUUID AS BusinessPartnerUUID,
  OpActyMainWrkCtrMfgUser.ManufacturingOrder AS ManufacturingOrder,
  OpActyMainWrkCtrMfgUser.OpActyNtwkSegmentType AS OpActyNtwkSegmentType,
  OpActyMainWrkCtrMfgUser.WorkCenter AS WorkCenter,
  _WorkCenterTextBySemanticKey[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  OpActyMainWrkCtrMfgUser.Plant AS Plant,
  cast('' as mpe_user_is_qualified preserving type) AS UserIsQualified,
  OpActyMainWrkCtrMfgUser._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyMainWrkCtrMfgUser._User AS _User,
  OpActyMainWrkCtrMfgUser._OANSegmentType AS _OANSegmentType,
  OpActyMainWrkCtrMfgUser._MfgOrder AS _MfgOrder,
  OpActyMainWrkCtrMfgUser._Plant AS _Plant,
  OpActyMainWrkCtrMfgUser._WorkCenterBySemanticKey AS _WorkCenterBySemanticKey
FROM P_OpActyMainWrkCtrMfgUser AS OpActyMainWrkCtrMfgUser
LEFT OUTER JOIN I_UserOpenOpActyAssignment AS _UserOpenOpActyAssignment ON UserID = _UserOpenOpActyAssignment.UserID  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterTextBySemanticKey AS _WorkCenterTextBySemanticKey ON WorkCenter = _WorkCenterTextBySemanticKey.WorkCenter AND Plant = _WorkCenterTextBySemanticKey.Plant  -- association [0..*]
;