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_FinSGLErrCrrtnTeamMbrFunc view_entity from COMPOSITE Error Processing Member Function
I_JITTeamMemberFunction view_entity from COMPOSITE Details of defined Functions
I_MfgBuyOffProcessorTeamFunc view from 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 Sales Plan My Teams

Fields (5)

KeyField CDS FieldsUsed in Views
KEY RespyMgmtBusinessPartner RespyMgmtBusinessPartner 2
KEY RespyMgmtFunction RespyMgmtFunction,RespyMgmtFunctionForEdit 5
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

}