P_BusinessUser

DDL: P_BUSINESSUSER Type: view_entity BASIC Package: FS4_BPU

Business User

P_BusinessUser is a Basic CDS View that provides data about "Business User" in SAP S/4HANA. It reads from 3 data sources (adrp, I_BusinessPartner, P_BPUsrRoleUnique) and exposes 55 fields with key field BusinessPartner. It has 4 associations to related views. Part of development package FS4_BPU.

3 data source(s) 55 fields

Data Sources (3)

SourceAliasJoin Type
adrp _Address inner
I_BusinessPartner _BP from
P_BPUsrRoleUnique _UserRole inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] P_BPUsrReservation _UserReservation $projection.BusinessPartner = _UserReservation.BusinessPartner
[0..1] P_BPUsrDetail _UserDetail $projection.BusinessPartnerUUID = _UserDetail.BusinessPartnerUUID
[0..1] I_WorkplaceAddress _WorkplaceAddress $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID
[0..*] P_BPUsrRole _BusinessPartnerRole $projection.BusinessPartner = _BusinessPartnerRole.BusinessPartner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business User view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey BusinessPartner view
Metadata.allowExtensions true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID
BPIdentificationNumber _BPExternalID BPIdentificationNumber
PersonNumber I_BusinessPartner PersonNumber
LastName I_BusinessPartner LastName
FirstName I_BusinessPartner FirstName
PersonFullName adrp name_text
PersonFullNameMaintStatus adrp converted
FormOfAddress I_BusinessPartner FormOfAddress
AcademicTitle I_BusinessPartner AcademicTitle
AcademicSecondTitle I_BusinessPartner AcademicTitle2
CorrespondenceLanguage I_BusinessPartner CorrespondenceLanguage
MiddleName I_BusinessPartner MiddleName
AdditionalLastName I_BusinessPartner AdditionalLastName
BirthName I_BusinessPartner BusinessPartnerBirthName
BirthDate I_BusinessPartner BirthDate
BusinessPartnerBirthplaceName I_BusinessPartner BusinessPartnerBirthplaceName
NickName I_BusinessPartner BusinessPartnerNicknameLabel
Initials I_BusinessPartner Initials
LastNamePrefix I_BusinessPartner LastNamePrefix
LastNameSecondPrefix I_BusinessPartner LastNameSecondPrefix
NameSupplement I_BusinessPartner BusinessPartnerSupplementName
BusinessPartnerDeathDate I_BusinessPartner BusinessPartnerDeathDate
BusPartMaritalStatus I_BusinessPartner BusPartMaritalStatus
BusPartNationality I_BusinessPartner BusPartNationality
Language I_BusinessPartner Language
SearchTerm1 I_BusinessPartner SearchTerm1
SearchTerm2 I_BusinessPartner SearchTerm2
NameCountry I_BusinessPartner NameCountry
NameFormat I_BusinessPartner NameFormat
UserID _UserDetail UserID
IsMarkedForArchiving I_BusinessPartner IsMarkedForArchiving
CreatedByUser I_BusinessPartner CreatedByUser
CreationDateTime
LastChangedByUser I_BusinessPartner LastChangedByUser
LastChangeDateTime I_BusinessPartner ETag
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted
AuthorizationGroup I_BusinessPartner AuthorizationGroup
DataControllerSet I_BusinessPartner DataControllerSet
DataController1 I_BusinessPartner DataController1
DataController2 I_BusinessPartner DataController2
DataController3 I_BusinessPartner DataController3
DataController4 I_BusinessPartner DataController4
DataController5 I_BusinessPartner DataController5
DataController6 I_BusinessPartner DataController6
DataController7 I_BusinessPartner DataController7
DataController8 I_BusinessPartner DataController8
DataController9 I_BusinessPartner DataController9
DataController10 I_BusinessPartner DataController10
_UserDetail _UserDetail
_UserReservation _UserReservation
_WorkplaceAddress _WorkplaceAddress
_BusinessPartnerRole _BusinessPartnerRole
_AcademicTitleValueHelp I_BusinessPartner _AcademicTitleValueHelp
_AcademicTitleText I_BusinessPartner _AcademicTitleText 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business User'
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.representativeKey: 'BusinessPartner'
@ObjectModel.alternativeKey: [ { id : 'BusinessPartnerUUID', uniqueness: #UNIQUE, element: ['BusinessPartnerUUID'] } ]
@Metadata.allowExtensions: true
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity P_BusinessUser
  as select from           I_BusinessPartner       as _BP
    inner join             adrp                    as _Address      on  _BP.PersonNumber = _Address.persnumber
                                                                    and _Address.nation  = ''
    inner join             P_BPUsrRoleUnique       as _UserRole     on _BP.BusinessPartner = _UserRole.BusinessPartner
    left outer to one join P_BPUSRPERSONEXTERNALID as _BPExternalID on _BP.BusinessPartner = _BPExternalID.BusinessPartner
  association [0..1] to P_BPUsrReservation as _UserReservation     on $projection.BusinessPartner = _UserReservation.BusinessPartner
  association [0..1] to P_BPUsrDetail      as _UserDetail          on $projection.BusinessPartnerUUID = _UserDetail.BusinessPartnerUUID
  association [0..1] to I_WorkplaceAddress as _WorkplaceAddress    on $projection.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID
  association [0..*] to P_BPUsrRole        as _BusinessPartnerRole on $projection.BusinessPartner = _BusinessPartnerRole.BusinessPartner
{
  key _BP.BusinessPartner                          as BusinessPartner,
      _BP.BusinessPartnerUUID                      as BusinessPartnerUUID,
      _BPExternalID.BPIdentificationNumber         as BPIdentificationNumber,
      _BP.PersonNumber                             as PersonNumber,
      _BP.LastName                                 as LastName,
      _BP.FirstName                                as FirstName,
      _Address.name_text                           as PersonFullName,
      _Address.converted                           as PersonFullNameMaintStatus,
      _BP.FormOfAddress                            as FormOfAddress,
      _BP.AcademicTitle                            as AcademicTitle,
      _BP.AcademicTitle2                           as AcademicSecondTitle,
      _BP.CorrespondenceLanguage                   as CorrespondenceLanguage,
      _BP.MiddleName                               as MiddleName,
      _BP.AdditionalLastName                       as AdditionalLastName,
      _BP.BusinessPartnerBirthName                 as BirthName,
      _BP.BirthDate                                as BirthDate,
      _BP.BusinessPartnerBirthplaceName            as BusinessPartnerBirthplaceName,
      _BP.BusinessPartnerNicknameLabel             as NickName,
      _BP.Initials                                 as Initials,
      _BP.LastNamePrefix                           as LastNamePrefix,
      _BP.LastNameSecondPrefix                     as LastNameSecondPrefix,
      _BP.BusinessPartnerSupplementName            as NameSupplement,
      _BP.BusinessPartnerDeathDate                 as BusinessPartnerDeathDate,
      _BP.BusPartMaritalStatus                     as BusPartMaritalStatus,
      _BP.BusPartNationality                       as BusPartNationality,
      _BP.Language                                 as Language,
      _BP.SearchTerm1                              as SearchTerm1,
      _BP.SearchTerm2                              as SearchTerm2,
      _BP.NameCountry                              as NameCountry, 
      _BP.NameFormat                               as NameFormat, 
      _UserDetail.UserID                           as UserID,
      _BP.IsMarkedForArchiving                     as IsMarkedForArchiving,
      _BP.CreatedByUser                            as CreatedByUser,
      concat( _BP.CreationDate, _BP.CreationTime ) as CreationDateTime,
      _BP.LastChangedByUser                        as LastChangedByUser,
      _BP.ETag                                     as LastChangeDateTime,
      _BP.IsBusinessPurposeCompleted               as IsBusinessPurposeCompleted,
      _BP.AuthorizationGroup                       as AuthorizationGroup,

      @Consumption.hidden:true
      _BP.DataControllerSet,
      @Consumption.hidden:true
      _BP.DataController1,
      @Consumption.hidden:true
      _BP.DataController2,
      @Consumption.hidden:true
      _BP.DataController3,
      @Consumption.hidden:true
      _BP.DataController4,
      @Consumption.hidden:true
      _BP.DataController5,
      @Consumption.hidden:true
      _BP.DataController6,
      @Consumption.hidden:true
      _BP.DataController7,
      @Consumption.hidden:true
      _BP.DataController8,
      @Consumption.hidden:true
      _BP.DataController9,
      @Consumption.hidden:true
      _BP.DataController10,
      
      _UserDetail,
      _UserReservation,
      _WorkplaceAddress,
      _BusinessPartnerRole,
      _BP._AcademicTitleValueHelp                  as _AcademicTitleValueHelp,
      _BP._AcademicTitleText                       as _AcademicTitleText
} where _BP.BusinessPartnerCategory = '1' //Person

Learn More