R_BPUsrChangeDocument

DDL: R_BPUSRCHANGEDOCUMENT Type: view_entity BASIC Package: FS4_BPU_ODATA

Business User Change Document

R_BPUsrChangeDocument is a Basic CDS View that provides data about "Business User Change Document" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 8 fields with key field BusinessPartnerUUID. Part of development package FS4_BPU_ODATA.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner _BusinessPartner inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business User Change Document view
VDM.viewType #BASIC view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID _Workplace BusinessPartnerUUID
BusinessPartner I_BusinessPartner BusinessPartner
PersonNumber I_BusinessPartner PersonNumber
AuthorizationGroup I_BusinessPartner AuthorizationGroup
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted
DataControllerSet I_BusinessPartner DataControllerSet
AddressID _Workplace AddressID
BPAddressChangeDocObject 
@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