I_MfgRespyMgmtTeam

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_MfgRespyMgmtTeam.
-- 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: IMFGRSPMGMTTEAM

CREATE VIEW I_MfgRespyMgmtTeam AS
SELECT
  MfgRespyMgmtTeamBasic.RespyMgmtTeamID AS RespyMgmtTeamID,
  MfgRespyMgmtTeamBasic.RespyMgmtTeamName AS RespyMgmtTeamName,
  MfgRespyMgmtTeamBasic.RespyMgmtTeamDescription AS RespyMgmtTeamDescription,
  MfgRespyMgmtTeamBasic.RespyMgmtTeamType AS RespyMgmtTeamType,
  MfgRespyMgmtTeamBasic.RespyMgmtTeamCategory AS RespyMgmtTeamCategory,
  MfgRespyMgmtTeamBasic.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  cast(TeamAttrPlant.RespyMgmtAttributeLowValue as werks_d) AS Plant,
  cast(TeamAttrWC.RespyMgmtAttributeLowValue as pph_arbpl) AS WorkCenter,
  MfgRespyMgmtTeamBasic.RespyMgmtTeamNameForSearch AS RespyMgmtTeamNameForSearch,
  MfgRespyMgmtTeamBasic.RespyMgmtTeamDescForSearch AS RespyMgmtTeamDescForSearch,
  MfgRespyMgmtTeamBasic._TeamMember AS _TeamMember,
  MfgRespyMgmtTeamBasic._AllLevelSuperTeam AS _AllLevelSuperTeam
FROM I_MfgRespyMgmtTeamBasic AS MfgRespyMgmtTeamBasic
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON WorkCenter = _WorkCenter.WorkCenter AND Plant = _WorkCenter.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;