I_MstrProjMember

DDL: I_MSTRPROJMEMBER SQL: IMPMEMBER Type: view BASIC Package: VDM_CPM_WS

Master Project Member

I_MstrProjMember is a Basic CDS View that provides data about "Master Project Member" in SAP S/4HANA. It reads from 2 data sources (I_MasterProject, /cpd/d_mp_member) and exposes 14 fields. Part of development package VDM_CPM_WS.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_MasterProject MasterProject from
/cpd/d_mp_member Member inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPMEMBER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Master Project Member view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
MasterProjectUUID I_MasterProject MasterProjectUUID
MasterProject I_MasterProject MasterProject
MasterProjectType I_MasterProject MasterProjectType
MasterProjectIsConfidential I_MasterProject MasterProjectIsConfidential
MasterProjectOrganization I_MasterProject MasterProjectOrganization
BusinessPartnerType /cpd/d_mp_member mem_object_type
MstrProjMemberUUID /cpd/d_mp_member db_key
BusinessPartner /cpd/d_mp_member bupa_id
EmploymentInternalID
EmployeePersonnelNumber
CreationDate
ChangedBy /cpd/d_mp_member changed_by
ChangedDateTime
CreatedByUser /cpd/d_mp_member created_by 
@AbapCatalog.sqlViewName: 'IMPMEMBER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Master Project Member'

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #A
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MstrProjMember
  as select from I_MasterProject  as MasterProject
    inner join   /cpd/d_mp_member as Member on MasterProject.MasterProjectUUID = Member.parent_key

{
  MasterProject.MasterProjectUUID,
  MasterProject.MasterProject,
  MasterProject.MasterProjectType,
  MasterProject.MasterProjectIsConfidential,
  MasterProject.MasterProjectOrganization,
  Member.mem_object_type                           as                                    BusinessPartnerType,
  Member.db_key                                    as                                    MstrProjMemberUUID,
  Member.bupa_id                                   as                                    BusinessPartner,
  cast(lpad(Member.mem_id, 10, '0') as bu_partner) as                                    EmploymentInternalID,
  cast(lpad(Member.mem_id, 8, '0') as /cpd/proj_manager)         as                      EmployeePersonnelNumber,
  cast(Member.created_on as /cpd/cpm_createdon)                  as                                    CreationDate,
  Member.changed_by                                as                                    ChangedBy,
  cast (Member.changed_on as /cpd/cpm_changedon)   as                                    ChangedDateTime,
  Member.created_by                                as                                    CreatedByUser

}

Learn More