C_BusinessPartnerRole

DDL: C_BUSINESSPARTNERROLE SQL: CBUPAROLE Type: view CONSUMPTION

Consumption view for Business Partner Role

C_BusinessPartnerRole is a Consumption CDS View that provides data about "Consumption view for Business Partner Role" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerRoleTP) and exposes 10 fields with key fields BusinessPartner, BusinessPartnerRole. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRoleTP BusinessPartnerRole from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_BusinessPartnerRole _BPRoleValueHelp $projection.BusinessPartnerRoleForEdit = _BPRoleValueHelp.BusinessPartnerRole
[0..1] I_BusinessPartnerRoleText _BPRoleText $projection.BusinessPartnerRoleForEdit = _BPRoleText.BusinessPartnerRole and _BPRoleText.Language = $session.system_language

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CBUPAROLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption view for Business Partner Role view
Metadata.allowExtensions true view
ObjectModel.type #CONSUMPTION view
ObjectModel.writeEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
UI.headerInfo.typeName Role view
UI.headerInfo.typeNamePlural Roles view
UI.headerInfo.title.label Role Description view
UI.headerInfo.title.value _BPRoleText.RoleText view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartnerRoleTP BusinessPartner
KEY BusinessPartnerRole I_BusinessPartnerRoleTP BusinessPartnerRole
BusinessPartnerForEdit I_BusinessPartnerRoleTP BusinessPartnerForEdit
BusinessPartnerRoleForEdit I_BusinessPartnerRoleTP BusinessPartnerRoleForEdit
ValidityStartDate I_BusinessPartnerRoleTP ValidityStartDate Role Validity Start Date
ValidityEndDate I_BusinessPartnerRoleTP ValidityEndDate Role Validity End Date
RoleCategory I_BusinessPartnerRoleTP RoleCategory
_BusinessPartner _BusinessPartner
_BPRoleValueHelp _BPRoleValueHelp
_BPRoleText _BPRoleText
@AbapCatalog.sqlViewName: 'CBUPAROLE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Consumption view for Business Partner Role'

@Metadata.allowExtensions: true

@ObjectModel.type: #CONSUMPTION
@ObjectModel.writeEnabled: true
@ObjectModel: {
    semanticKey: ['BusinessPartner', 'BusinessPartnerRoleForEdit'],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

@Search.searchable: true

@UI.headerInfo:{
  typeName: 'Role',
  typeNamePlural: 'Roles',
  title:  { label:'Role Description', value: '_BPRoleText.RoleText' }
  }

@VDM.viewType: #CONSUMPTION

define view C_BusinessPartnerRole
  as select from I_BusinessPartnerRoleTP as BusinessPartnerRole
  association [1..1] to C_BusinessPartner         as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_BusinessPartnerRole     as _BPRoleValueHelp on  $projection.BusinessPartnerRoleForEdit = _BPRoleValueHelp.BusinessPartnerRole
  association [0..1] to I_BusinessPartnerRoleText as _BPRoleText      on  $projection.BusinessPartnerRoleForEdit = _BPRoleText.BusinessPartnerRole
                                                                      and _BPRoleText.Language                   = $session.system_language

{
  key BusinessPartnerRole.BusinessPartner,
  key BusinessPartnerRole.BusinessPartnerRole,
      BusinessPartnerRole.BusinessPartnerForEdit,
      @ObjectModel: {
                text.association: '_BPRoleText'
                 }
      BusinessPartnerRole.BusinessPartnerRoleForEdit,
      @EndUserText.label: 'Role Validity Start Date'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerRole.ValidityStartDate,
      @EndUserText.label: 'Role Validity End Date'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerRole.ValidityEndDate,
      
      BusinessPartnerRole.RoleCategory,

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,
      _BPRoleValueHelp, // used for value help for multiple search on role selection field 

      _BPRoleText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERROLETP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"I_BUSINESSPARTNERROLE",
"I_BUSINESSPARTNERROLETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/