I_RESPYMGMTTEAMMBRFUNC

CDS View

Basic View for Team Member Function

I_RESPYMGMTTEAMMBRFUNC is a CDS View in S/4HANA. Basic View for Team Member Function. It contains 5 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_RespyMTeamMemberFunction_2 view from CONSUMPTION Team Member Functions
C_MfgBPResponsibility view from CONSUMPTION Manufacturing User Responsibilities
C_MfgBPResponsibility view union CONSUMPTION Manufacturing User Responsibilities
C_SalesPlanTeamVH view left_outer CONSUMPTION Value Help for Sales Plan Teams
I_JITTeamMemberFunction view_entity from COMPOSITE Details of defined Functions
I_MfgBuyOffProcessorTeamFunc view from COMPOSITE Buy Off Processor Team Function
I_MfgBuyOffProcessorTeamFunc view union COMPOSITE Buy Off Processor Team Function
I_MfgBuyOffTeamVH view left_outer COMPOSITE Team Value Help
I_RespyMgmtTeamMbrFuncTP view from TRANSACTIONAL View for Team Member and Function
P_SalesPlanMyTeams view from COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
KEY RespyMgmtBusinessPartner RespyMgmtBusinessPartner 2
KEY RespyMgmtFunction RespyMgmtFunction,RespyMgmtFunctionForEdit 4
KEY RespyMgmtTeamID RespyMgmtTeamID 3
RespyMgmtFuncIsForOrgUnitMbr RespyMgmtFuncIsForOrgUnitMbr 1
RespyMgmtTeamFuncnlAssgmtID RespyMgmtTeamFuncnlAssgmtID 1
@AbapCatalog.sqlViewName: 'ITEAMMBRFUNCTION'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Basic View for Team Member Function'
define view I_RespyMgmtTeamMbrFunc
  as select from P_RespyMgmtTeamMbrFunc as TeamMemberFunction
  association [1..1] to I_RespyMgmtTeamHeader          as _Team              on  $projection.RespyMgmtTeamID = _Team.RespyMgmtTeamID
  association [1..1] to I_RespyMgmtTeamMemberBasic     as _TeamMember        on  $projection.RespyMgmtTeamID          = _TeamMember.RespyMgmtTeamID
                                                                             and $projection.RespyMgmtBusinessPartner = _TeamMember.BusinessPartner
  association [0..*] to I_RespyMgmtSuperTeamOfAllLevel as _AllLevelSuperTeam on  $projection.RespyMgmtTeamID = _AllLevelSuperTeam.RespyMgmtTeamID
{
  key TeamMemberFunction.Function                     as RespyMgmtFunction,
  key TeamMemberFunction.RespyMgmtTeamID              as RespyMgmtTeamID,
  key TeamMemberFunction.RespyMgmtBusinessPartner     as RespyMgmtBusinessPartner,

      _TeamMember.RespyMgmtTeamMemberType             as RespyMgmtTeamMemberType,
      TeamMemberFunction.RespyMgmtTeamFuncnlAssgmtID  as RespyMgmtTeamFuncnlAssgmtID,
      TeamMemberFunction.RespyMgmtFuncIsForOrgUnitMbr as RespyMgmtFuncIsForOrgUnitMbr,

      _Team,
      _AllLevelSuperTeam
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESPYMGMTTEAMMEMBERBASIC",
"P_RESPYMGMTTEAMMBRFUNC"
],
"ASSOCIATED":
[
"I_RESPYMGMTSUPERTEAMOFALLLEVEL",
"I_RESPYMGMTTEAMHEADER",
"I_RESPYMGMTTEAMMEMBERBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/