I_RespyMgmtTeamHeader

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_RespyMgmtTeamHeader.
-- 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: ITEAMHEADER

CREATE VIEW I_RespyMgmtTeamHeader AS
SELECT
  Team.RespyMgmtTeamID AS RespyMgmtTeamID,
  cast(Team.TeamName as rsm_de_team_name) AS RespyMgmtTeamName,
  Team.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  Team.TeamName AS RespyMgmtTeamNameForSearch,
  cast(Team.TeamDescription as rsm_de_team_descr) AS RespyMgmtTeamDescription,
  Team.TeamDescription AS RespyMgmtTeamDescForSearch,
  Team.TeamStatus AS RespyMgmtTeamStatus,
  Team.TeamType AS RespyMgmtTeamType,
  Team.TeamCategory AS RespyMgmtTeamCategory,
  Team.CreationDateTime AS CreationDateTime,
  Team.CreatedByUser AS CreatedByUser,
  Team.LastChangeDateTime AS LastChangeDateTime,
  Team.LastChangedByUser AS LastChangedByUser,
  Team.StartDate AS StartDate,
  Team.EndDate AS EndDate,
  cast('' as char255 ) AS RespyMgmtAttributeNameValPair,
  cast('' as char1 preserving type ) AS RespyMgmtTeamHasSubTeam
FROM P_RespyMgmtTeamHeader AS Team
LEFT OUTER JOIN I_RespyMgmtSuperTeamOfAllLevel AS _AllLevelSuperTeam ON Team.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID  -- association [0..*]
;