I_ChangeRecordPartnerVH

DDL: I_CHANGERECORDPARTNERVH SQL: ICHGRCDPARTNERVH Type: view COMPOSITE

Obsolete: Value help for Change Record Partner

I_ChangeRecordPartnerVH is a Composite CDS View that provides data about "Obsolete: Value help for Change Record Partner" in SAP S/4HANA. It reads from 2 data sources (I_Employee, I_BusinessPartner) and exposes 19 fields with key field Partner.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
I_Employee Employee from
I_BusinessPartner I_BusinessPartner inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGRCDPARTNERVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Obsolete: Value help for Change Record Partner view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Partner BusinessPartner
BusinessPartnerCategory BusinessPartnerCategory
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID
PartnerFirstName I_BusinessPartner FirstName
PartnerLastName I_BusinessPartner LastName
BusinessPartnerFullName I_BusinessPartner BusinessPartnerFullName
UserID I_Employee UserID
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 
@AbapCatalog.sqlViewName: 'ICHGRCDPARTNERVH'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Obsolete: Value help for Change Record Partner'

@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MASTER,
                         sizeCategory: #L}

define view I_ChangeRecordPartnerVH

  as select from I_Employee as Employee
    inner join   I_BusinessPartner on Employee.BusinessPartnerUUID = I_BusinessPartner.BusinessPartnerUUID

{

  key BusinessPartner                           as Partner,
      BusinessPartnerCategory,
      I_BusinessPartner.BusinessPartnerUUID,
      I_BusinessPartner.FirstName               as PartnerFirstName,
      I_BusinessPartner.LastName                as PartnerLastName,
      I_BusinessPartner.BusinessPartnerFullName as BusinessPartnerFullName,
      Employee.UserID                           as UserID,
      I_BusinessPartner.AuthorizationGroup      as AuthorizationGroup,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataControllerSet       as DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController1         as DataController1,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController2         as DataController2,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController3         as DataController3,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController4         as DataController4,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController5         as DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController6         as DataController6,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController7         as DataController7,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController8         as DataController8,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController9         as DataController9,
      //added only for DCL check

      @Consumption.hidden:true
      @UI.hidden:true
      I_BusinessPartner.DataController10        as DataController10


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_EMPLOYEE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More