A_RespyMTeamMemberFunction_2

DDL: A_RESPYMTEAMMEMBERFUNCTION_2 SQL: ARSMTEAMMBRFUNC2 Type: view CONSUMPTION

Team Member Functions

A_RespyMTeamMemberFunction_2 is a Consumption CDS View that provides data about "Team Member Functions" in SAP S/4HANA. It reads from 1 data source (I_RespyMgmtTeamMbrFunc) and exposes 5 fields with key fields RespyMgmtGlobalTeamID, RespyMgmtTeamMemberType, ResponsibilityTeamMember, RespyMgmtFunction. It is exposed through 1 OData service (API_RESPYM_TEAM_SRV_2).

1 data source(s) Exposed by 1 service(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_RespyMgmtTeamMbrFunc I_RespyMgmtTeamMbrFunc from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ARSMTEAMMBRFUNC2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name RespyMTeamMemberFunction_Type view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Team Member Functions view

OData Services (1)

ServiceBindingVersionContractRelease
API_RESPYM_TEAM_SRV_2

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY RespyMgmtGlobalTeamID _Team RespyMgmtGlobalTeamID
KEY RespyMgmtTeamMemberType RespyMgmtTeamMemberType
KEY ResponsibilityTeamMember RespyMgmtBusinessPartner
KEY RespyMgmtFunction RespyMgmtFunction
_TeamMember _TeamMember 
@AbapCatalog.sqlViewName: 'ARSMTEAMMBRFUNC2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@AccessControl.personalData.blocking: #REQUIRED

@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true
@OData.entityType.name:'RespyMTeamMemberFunction_Type'
@ObjectModel.semanticKey:  [ 'RespyMgmtFunction' ]
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@EndUserText.label: 'Team Member Functions'
define view A_RespyMTeamMemberFunction_2
  as select from I_RespyMgmtTeamMbrFunc
  association to parent A_RespyMgmtTeamMember_2 as _TeamMember on  $projection.RespyMgmtGlobalTeamID    = _TeamMember.RespyMgmtGlobalTeamID
                                                               and $projection.RespyMgmtTeamMemberType  = _TeamMember.RespyMgmtTeamMemberType
                                                               and $projection.ResponsibilityTeamMember = _TeamMember.ResponsibilityTeamMember
{
  key _Team.RespyMgmtGlobalTeamID as RespyMgmtGlobalTeamID,
  key RespyMgmtTeamMemberType,
  key RespyMgmtBusinessPartner    as ResponsibilityTeamMember,
  key RespyMgmtFunction,

      // Association to parent

      _TeamMember
}
where
  _Team.RespyMgmtGlobalTeamID <> ''
  and _Team.RespyMgmtTeamStatus <> '99';

Learn More