C_RespyMgmtTeamMbrFuncTP

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_RespyMgmtTeamMbrFuncTP.
-- 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: CTMMBRFUNCTIONTP

CREATE VIEW C_RespyMgmtTeamMbrFuncTP AS
SELECT
  RespyMgmtFunction,
  RespyMgmtBusinessPartner,
  RespyMgmtTeamID,
  RespyMgmtFunctionForEdit,
  RespyMgmtFuncIsForOrgUnitMbr,
  TeamMemberFunction.RespyMgmtTeamFuncnlAssgmtID AS RespyMgmtTeamFuncnlAssgmtID,
  _Function.RespyMgmtFunctionDescription AS RespyMgmtFunctionDescription,
  _Team.RespyMgmtTeamType AS RespyMgmtTeamType
FROM I_RespyMgmtTeamMbrFuncTP AS TeamMemberFunction
LEFT OUTER JOIN C_RespyMgmtTeamMemberTP AS _TeamMember ON _TeamMember.RespyMgmtBusinessPartner = RespyMgmtBusinessPartner AND _TeamMember.RespyMgmtTeamID = RespyMgmtTeamID  -- association [1..1]
LEFT OUTER JOIN C_RespyMgmtTeamHeaderTP AS _Team ON _Team.RespyMgmtTeamID = RespyMgmtTeamID  -- association [1..1]
LEFT OUTER JOIN C_RespyMgmtTeamTypeFinalFuncVH AS _FunctionValueHelp ON RespyMgmtFunctionForEdit = _FunctionValueHelp.RespyMgmtFunction AND _FunctionValueHelp.RespyMgmtTeamType = RespyMgmtTeamType  -- association [1..1]
LEFT OUTER JOIN I_RespyMgmtFunction AS _Function ON _Function.RespyMgmtFunction = RespyMgmtFunctionForEdit  -- association [1..1]
;