C_BusinessPartnerCustomerRole

DDL: C_BUSINESSPARTNERCUSTOMERROLE SQL: CBUPACUSROLE Type: view CONSUMPTION

Consumption view for Customer BP Roles

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

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerRoleTP BusinessPartnerRole from

Associations (4)

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

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CBUPACUSROLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption view for Customer BP Roles 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
ValidityEndDate I_BusinessPartnerRoleTP ValidityEndDate
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartner _BusinessPartner
_BPRoleText _BPRoleText
_BPRoleValueHelp _BPRoleValueHelp
@AbapCatalog.sqlViewName: 'CBUPACUSROLE'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Consumption view for Customer BP Roles'

@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_BusinessPartnerCustomerRole
  as select from I_BusinessPartnerRoleTP as BusinessPartnerRole
  association [1..1] to C_BusinessPartner            as _BusinessPartner         on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [1..1] to C_BusinessPartnerCustomer    as _BusinessPartnerCustomer on  $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
  association [0..1] to I_BusinessPartnerCustRoleTxt as _BPRoleText              on  $projection.BusinessPartnerRoleForEdit = _BPRoleText.Role
                                                                                 and _BPRoleText.Language                   = $session.system_language
  association [0..1] to I_BusinessPartnerRole        as _BPRoleValueHelp         on  $projection.BusinessPartnerRoleForEdit = _BPRoleValueHelp.BusinessPartnerRole

{
  key BusinessPartnerRole.BusinessPartner,
  key BusinessPartnerRole.BusinessPartnerRole,
      BusinessPartnerRole.BusinessPartnerForEdit,
      @ObjectModel: {
                text.association: '_BPRoleText'
                 }
      BusinessPartnerRole.BusinessPartnerRoleForEdit,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerRole.ValidityStartDate,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerRole.ValidityEndDate,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartner,
      _BPRoleText,
      _BPRoleValueHelp // used for value help for multiple search on role selection field

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