I_MSTRPROJMEMBER

CDS View

Master Project Member

I_MSTRPROJMEMBER is a CDS View in S/4HANA. Master Project Member. It contains 10 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 10 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_MasterProjectRole view left_outer COMPOSITE Master Project Role
I_MstrProjBusinessPartner view from BASIC Master Project Business Partner
I_MstrProjManager view left_outer COMPOSITE Get Project managers
I_MstrProjTeamMember view left_outer COMPOSITE Master Project Team Member
I_MstrProjUser view from COMPOSITE Master Project User

Fields (10)

KeyField CDS FieldsUsed in Views
BusinessPartner BusinessPartner,EmploymentInternalID 3
BusinessPartnerType BusinessPartnerType 3
ChangedBy ChangedBy 1
ChangedDateTime ChangedDateTime 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
EmployeePersonnelNumber EmployeePersonnelNumber 1
EmploymentInternalID EmploymentInternalID 2
MasterProject MasterProject 2
MasterProjectUUID MasterProjectUUID 1 
@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