R_BPUSRCHANGEDOCUMENT

CDS View

Business User Change Document

R_BPUSRCHANGEDOCUMENT is a CDS View in S/4HANA. Business User Change Document. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPUsrChangeDocument view from CONSUMPTION Business User Change Document 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business User Change Document'

@VDM.viewType:#BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity R_BPUsrChangeDocument
  as select distinct from I_WorkplaceAddress as _Workplace
    inner join            I_BusinessPartner  as _BusinessPartner on _BusinessPartner.BusinessPartnerUUID = _Workplace.BusinessPartnerUUID
{
  key _Workplace.BusinessPartnerUUID,
      _BusinessPartner.BusinessPartner,
      _BusinessPartner.PersonNumber,

      _BusinessPartner.AuthorizationGroup                                                  as AuthorizationGroup,
      _BusinessPartner.IsBusinessPurposeCompleted                                          as IsBusinessPurposeCompleted,

      @Consumption.hidden:true
      _BusinessPartner.DataControllerSet,

      _Workplace.AddressID                                                                 as AddressID,

      concat_with_space('BP',concat(_BusinessPartner.PersonNumber,_Workplace.AddressID),2) as BPAddressChangeDocObject
}

Learn More