I_MSTRPROJBUSPARTNERBYROLE

CDS View

Master Project Business Partner By Role

I_MSTRPROJBUSPARTNERBYROLE is a CDS View in S/4HANA. Master Project Business Partner By Role. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MstrProjBusPartnerByRoleVH view from COMPOSITE Master Project Business Partner By Role Value Help 
@AbapCatalog.sqlViewName: 'IMPBUSPARTBYROLE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Project Business Partner By Role'
define view I_MstrProjBusPartnerByRole
  as select distinct from I_BusinessPartner as BusinessPartner
    inner join   I_BusinessPartner_to_BP_Role on BusinessPartner.BusinessPartner = I_BusinessPartner_to_BP_Role.BusinessPartner
  association [0..1] to I_BusinessPartnerRole      as _BusinessPartnerRole      on  $projection.BusinessPartnerRole = _BusinessPartnerRole.BusinessPartnerRole
  association [0..1] to I_User                     as _User                     on  $projection.BusinessPartnerUUID = _User.BusinessPartnerUUID



  association [0..1] to I_Addressindependentemail  as _AddressIndependentEmail  on  $projection.IndependentAddressID = _AddressIndependentEmail.AddressID
  association [0..1] to I_Addressindependentphone  as _AddressIndependentPhone  on  $projection.IndependentAddressID         = _AddressIndependentPhone.AddressID
                                                                                and _AddressIndependentPhone.PhoneNumberType = '1'
  association [0..1] to I_Addressindependentmobile as _AddressIndependentMobile on  $projection.IndependentAddressID          = _AddressIndependentMobile.AddressID
                                                                                and _AddressIndependentMobile.PhoneNumberType = '3'

{
          @ObjectModel.text.element: 'FullName'
  key     BusinessPartner.BusinessPartner,


          @EndUserText.label: 'Business Partner Role'
  key     I_BusinessPartner_to_BP_Role.BusinessPartnerRole                                            as BusinessPartnerRole,
          _BusinessPartnerRole._BusinessPartnerRoleText[1:Language = $session.system_language].BusinessPartnerRoleShortName,

          @EndUserText.label: 'Business Partner Name'
          BusinessPartner.BusinessPartnerFullName                                                     as FullName,

          _AddressIndependentEmail.EmailAddress                                                       as EmailAddress,

          @EndUserText.label: 'Business Partner Role Name'
          _BusinessPartnerRole._BusinessPartnerRoleText[1:Language = $session.system_language].BusinessPartnerRoleShortName
                                                                                                      as ProjectRoleName,

          _AddressIndependentMobile.MobilePhoneNumber                                                 as MobilePhoneNumber,


          _AddressIndependentPhone.AddressPhoneNumber                                                 as PhoneNumber,


          _User.UserID,
          BusinessPartner.IsBusinessPurposeCompleted,
          BusinessPartner.BusinessPartnerUUID,
          BusinessPartner.BusinessPartnerFullName,
          BusinessPartner.IndependentAddressID                                                        as IndependentAddressID,
 /////// Start of Datacontroller 10+1 fields -  Not to be consumed by any other views//////////      

        
        @Consumption.hidden:true
        @UI.hidden:true
        DataControllerSet,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController1,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController2,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController3,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController4,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController5,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController6,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController7,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController8,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController9,
        @Consumption.hidden:true
        @UI.hidden:true
        DataController10
        
 ////////////// End of Datacontroller 10+1 fields//////////          


}
where
     BusinessPartnerRole = 'BUP003'
  or BusinessPartnerRole = 'FLCU01'
  or BusinessPartnerRole = 'FLVN01'

Learn More