I_RespyMgmtTeamHeaderTP

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_RespyMgmtTeamHeaderTP.
-- 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: ITEAMHEADERTP

CREATE VIEW I_RespyMgmtTeamHeaderTP AS
SELECT
  Team.RespyMgmtTeamID AS RespyMgmtTeamID,
  Team.RespyMgmtTeamName AS RespyMgmtTeamName,
  Team.RespyMgmtGlobalTeamID AS RespyMgmtGlobalTeamID,
  Team.RespyMgmtTeamNameForSearch AS RespyMgmtTeamNameForSearch,
  Team.RespyMgmtTeamDescription AS RespyMgmtTeamDescription,
  Team.RespyMgmtTeamDescForSearch AS RespyMgmtTeamDescForSearch,
  Team.RespyMgmtTeamStatus AS RespyMgmtTeamStatus,
  Team.RespyMgmtTeamType AS RespyMgmtTeamType,
  Team.RespyMgmtTeamCategory AS RespyMgmtTeamCategory,
  Team.CreationDateTime AS CreationDateTime,
  Team.CreatedByUser AS CreatedByUser,
  _CreatedBy.UserDescription AS CreatedByUserFullName,
  _LastChangedBy.UserDescription AS LastChangedByUserFullName,
  Team.LastChangeDateTime AS LastChangeDateTime,
  Team.LastChangedByUser AS LastChangedByUser,
  Team.StartDate AS StartDate,
  Team.EndDate AS EndDate,
  Team.RespyMgmtAttributeNameValPair AS RespyMgmtAttributeNameValPair,
  Team.RespyMgmtTeamHasSubTeam AS RespyMgmtTeamHasSubTeam
FROM I_RespyMgmtTeamHeader AS Team
LEFT OUTER JOIN I_RespyMgmtTeamOrgUnitTP AS _TeamOrgUnit ON RespyMgmtTeamID = _TeamOrgUnit.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtTeamMemberTP AS _TeamMember ON RespyMgmtTeamID = _TeamMember.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtTeamAttributeTP AS _Attribute ON RespyMgmtTeamID = _Attribute.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtDirectSubTeamTP AS _SubTeam ON RespyMgmtTeamID = _SubTeam.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.UserID  -- association [1..1]
LEFT OUTER JOIN I_RespyMgmtDirectSuperTeamTP AS _SuperTeam ON RespyMgmtTeamID = _SuperTeam.RespyMgmtTeamID  -- association [1..*]
LEFT OUTER JOIN I_RespyMgmtTeamOwnerTP AS _TeamOwner ON RespyMgmtTeamID = _TeamOwner.RespyMgmtTeamID  -- association [1..*]
;