I_BusinessPartnerCustRole

DDL: I_BUSINESSPARTNERCUSTROLE SQL: IBUPACUSTROLE Type: view BASIC

Value Help for Customer Roles

I_BusinessPartnerCustRole is a Basic CDS View that provides data about "Value Help for Customer Roles" in SAP S/4HANA. It reads from 2 data sources (tb003, tbd002) and exposes 3 fields with key field Role. It has 1 association to related views.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
tb003 tb003 inner
tbd002 tbd002 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BusinessPartnerCustRoleTxt _CustRoleText $projection.Role = _CustRoleText.Role

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBUPACUSTROLE view
ObjectModel.representativeKey Role view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value Help for Customer Roles view
Search.searchable true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY Role role Business Partner Roles
RoleCategory rolecategory
_CustRoleText _CustRoleText 
@AbapCatalog.sqlViewName: 'IBUPACUSTROLE'
@ObjectModel.representativeKey: 'Role'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Value Help for Customer Roles'
@Search.searchable: true

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
//@ObjectModel.dataCategory: #VALUE_HELP


define view I_BusinessPartnerCustRole
  as select from tbd002

    inner join   tb003 on tbd002.rltyp = tb003.rolecategory

  association [0..*] to I_BusinessPartnerCustRoleTxt as _CustRoleText on $projection.Role = _CustRoleText.Role
{
      @EndUserText.label: 'Business Partner Roles'
      @ObjectModel.text.association: '_CustRoleText'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key role as Role,
  @UI.hidden: true
  @Consumption.filter.hidden: true
  rolecategory as RoleCategory,

      _CustRoleText

} where tbd002.deb = 'X' and tb003.xsuppress != 'X'
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"TB003",
"TBD002"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERCUSTROLETXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More