C_BPUsrChangeDocument

DDL: C_BPUSRCHANGEDOCUMENT SQL: CBPUSRCHGDOC Type: view CONSUMPTION

Business User Change Document

C_BPUsrChangeDocument is a Consumption CDS View that provides data about "Business User Change Document" in SAP S/4HANA. It has 1 association to related views.

18 fields

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_WorkplaceAddress _WorkPlace $projection.BusinessPartnerUUID = _WorkPlace.BusinessPartnerUUID

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CBPUSRCHGDOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business User Change Document view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID
BusinessPartner BusinessPartner
PersonNumber PersonNumber
AuthorizationGroup I_BusinessUserTP AuthorizationGroup
IsBusinessPurposeCompleted I_BusinessUserTP IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
AddressID _WorkPlace AddressID
BPAddressChangeDocObject 
@AbapCatalog.sqlViewName: 'CBPUSRCHGDOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business User Change Document'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm : #SESSION_VARIABLE

@VDM.viewType:#CONSUMPTION

define view C_BPUsrChangeDocument
  as select distinct from I_BusinessUserTP
  association [1..1] to I_WorkplaceAddress as _WorkPlace on $projection.BusinessPartnerUUID = _WorkPlace.BusinessPartnerUUID
{
  key BusinessPartnerUUID,
      BusinessPartner,
      PersonNumber,

      I_BusinessUserTP.AuthorizationGroup                                 as AuthorizationGroup,
      I_BusinessUserTP.IsBusinessPurposeCompleted                         as IsBusinessPurposeCompleted,

      @Consumption.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      DataController1,
      @Consumption.hidden:true
      DataController2,
      @Consumption.hidden:true
      DataController3,
      @Consumption.hidden:true
      DataController4,
      @Consumption.hidden:true
      DataController5,
      @Consumption.hidden:true
      DataController6,
      @Consumption.hidden:true
      DataController7,
      @Consumption.hidden:true
      DataController8,
      @Consumption.hidden:true
      DataController9,
      @Consumption.hidden:true
      DataController10,
      
      _WorkPlace.AddressID                                                as AddressID,

      concat_with_space('BP',concat(PersonNumber,_WorkPlace.AddressID),2) as BPAddressChangeDocObject
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSUSERTP",
"I_WORKPLACEADDRESS"
],
"ASSOCIATED":
[
"I_WORKPLACEADDRESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More