I_MstrProjEmplWthAddr

DDL: I_MSTRPROJEMPLWTHADDR SQL: IMPEMPLWTHADDR Type: view COMPOSITE Package: VDM_CPM_WS

Master Project Employee With Address

I_MstrProjEmplWthAddr is a Composite CDS View that provides data about "Master Project Employee With Address" in SAP S/4HANA. It reads from 1 data source (I_WorkforcePerson) and exposes 10 fields with key field BusinessPartner. Part of development package VDM_CPM_WS.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkforcePerson Employee from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPEMPLWTHADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Master Project Employee With Address view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner Person
Employee PersonExternalID
BusinessPartnerFullName PersonFullName
MasterProjectTeamRole _BusinessPartnerToBPRole BusinessPartnerRole
UserID _BusinessUser UserID
ProjectRoleName
BusinessPartnerUUID BusinessPartnerUUID
PhoneNumber _WorkplaceAddress NormalizedPhoneNumber
MobilePhoneNumber _WorkplaceAddress MblNormalizedPhoneNumber
EmailAddress _WorkplaceAddress DefaultEmailAddress 
@AbapCatalog.sqlViewName: 'IMPEMPLWTHADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER 
@ObjectModel.usageType.serviceQuality: #C 
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'Master Project Employee With Address'
define view I_MstrProjEmplWthAddr as select from /*//->NOTE:2921621 

I_Employee as Employee
{
@ObjectModel.text.element: 'BusinessPartnerFullName'
key Employee.PersonnelNumber as PersonnelNumber, //not to be used in UI              

    EmployeeInternalID as BusinessPartner, 
    Employee,   
    @Semantics.text  
    EmployeeFullName as BusinessPartnerFullName,
    BusinessPartnerRole as MasterProjectTeamRole,
    UserID,
    Employee._BPRoleText[1:Language = $session.system_language].BusinessPartnerRoleName as ProjectRoleName,
 */
I_WorkforcePerson as Employee 
{
@ObjectModel.text.element: 'BusinessPartnerFullName'
 //removing PersonnelNumber without replacement          

key Person as BusinessPartner, 
    PersonExternalID as Employee,   
    @Semantics.text  
    PersonFullName as BusinessPartnerFullName,
    _BusinessPartnerToBPRole.BusinessPartnerRole  as MasterProjectTeamRole,
    _BusinessUser.UserID,   
    _BusinessPartnerToBPRole._BusinessPartnerRole._BusinessPartnerRoleText[1:Language = $session.system_language].BusinessPartnerRoleShortName
     as ProjectRoleName, 
   //<-NOTE:2921621

    BusinessPartnerUUID,
    _WorkplaceAddress.NormalizedPhoneNumber as PhoneNumber,
    _WorkplaceAddress.MblNormalizedPhoneNumber as MobilePhoneNumber,
    _WorkplaceAddress.DefaultEmailAddress as EmailAddress
}

Learn More