C_MfgOperatorDetail

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_MfgOperatorDetail.
-- 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: CMFGOPTRDETS
-- Parameters: P_OpLtstSchedldExecFromDte : pph_fsavd, P_OpLtstSchedldExecToDte : pph_fsavd

CREATE VIEW C_MfgOperatorDetail AS
SELECT
  Partner.MfgBusinessPartner AS MfgBusinessPartner,
  $parameters.P_OpLtstSchedldExecFromDte AS OpLtstSchedldExecFromDte,
  $parameters.P_OpLtstSchedldExecToDte AS OpLtstSchedldExecToDte,
  BPUser.UserID AS UserID,
  cast(Partner.BusinessPartnerName as mpe_user_name preserving type) AS BusinessPartnerName,
  Partner.FirstName AS FirstName,
  Partner.LastName AS LastName,
  workplaceaddress.PhoneNumber AS PhoneNumber,
  lower(workplaceaddress.DefaultEmailAddress) AS DefaultEmailAddress,
  _WorkCenter.Plant AS DefaultPlant,
  _WorkCenter.Plant AS Plant,
  _WorkCenter.WorkCenter AS DefaultWorkCenter,
  _WorkCenter.WorkCenter AS WorkCenter,
  _WorkCenter._WorkCenterTextBySemanticKey AS _WorkCenterTextBySemanticKey,
  _WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  _WorkCenter._WorkCenterResponsible AS _WorkCenterResponsible,
  Partner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  Partner.AuthorizationGroup AS AuthorizationGroup,
  LabAct.OpActyNtwkInstance AS OpActyNtwkInstance,
  LabAct.OpActyNtwkElement AS OpActyNtwkElement,
  LabAct.ShopFloorItem AS ShopFloorItem,
  LabAct.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  OpActyInstanceStatusBasic.OpActyIsSeldForRtactvPostg AS OpActyIsSeldForRtactvPostg,
  cast(nr.NrOfUsrOpnOpActyAssignments as int4 preserving type ) AS NmbrOfOpActiesAssgdToOptr,
  cast(nr.OpActyExpdExecDurnInSeconds as mpe_expd_exec_duration preserving type ) AS AssgdLaborDurationInSecs,
  cast(' ' as char30 preserving type) AS AssignedLaborDuration,
  cast('00000000' as pph_fsavd) AS SelectedOpActyStartDate,
  Partner.BusinessPartner AS BusinessPartner,
  _WorkCenter._Plant AS _Plant,
  Partner._BusinessPartner AS _BusinessPartner
FROM I_MfgBusinessPartner AS Partner
INNER JOIN I_User AS BPUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_MfgBPResponsibility AS _Func ON _Func.RespyMgmtBusinessPartner = Partner.MfgBusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_MfgHumRsceQualifnBP AS _Qualification ON Partner.MfgBusinessPartner = _Qualification.MfgBusinessPartner  -- association [0..*]
LEFT OUTER JOIN C_MfgOpActyAssgdToOptr AS _AssignedOperationActivityList ON _AssignedOperationActivityList.UserID = UserID AND _AssignedOperationActivityList.OpLtstSchedldExecStrtDte >= OpLtstSchedldExecFromDte AND _AssignedOperationActivityList.OpLtstSchedldExecStrtDte <= OpLtstSchedldExecToDte  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON Partner.Plant = _WorkCenter.Plant AND Partner.WorkCenter = _WorkCenter.WorkCenter  -- association [0..1]
LEFT OUTER JOIN C_MfgBPWorkCenterAssgmt AS _WorkCenterAssignment ON MfgBusinessPartner = _WorkCenterAssignment.MfgBusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_MfgLaborStatusText AS _LaborStatus ON ManufacturingLaborStatus = _LaborStatus.ManufacturingLaborStatus AND _LaborStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MfgWorkCenterRespVH AS _MfgWrkCtrRespVH ON WorkCenterResponsible = _MfgWrkCtrRespVH.WorkCenterResponsible  -- association [1..*]
;