C_BPCatHelpTextVhTemp

DDL: C_BPCATHELPTEXTVHTEMP SQL: CBPCATHELPT Type: view CONSUMPTION

C_BPCatHelpTextVhTemp is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_BR_Domain) and exposes 5 fields with key fields BusinessPartnerCategory, Language. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_BR_Domain I_BR_Domain from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_BusinessPartnerCatHelpVhTemp _CategoryValueHelp $projection.BusinessPartnerCategory = _CategoryValueHelp.BusinessPartnerCategory

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CBPCATHELPT view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
Search.searchable true view
ObjectModel.representativeKey BusinessPartnerCategory view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerCategory
KEY Language Language
BusinessPartnerCategoryText DomainText Business Partner Category Description
DomainValue DomainValue
_CategoryValueHelp _CategoryValueHelp 
@AbapCatalog.sqlViewName: 'CBPCATHELPT'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@ObjectModel.dataCategory: #TEXT
@Search.searchable: true
@ObjectModel.representativeKey: 'BusinessPartnerCategory'

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

//@EndUserText.label: 'BP category text value help'

define view C_BPCatHelpTextVhTemp
  as select from I_BR_Domain

  association [0..1] to C_BusinessPartnerCatHelpVhTemp as _CategoryValueHelp on $projection.BusinessPartnerCategory = _CategoryValueHelp.BusinessPartnerCategory

{
      @ObjectModel.foreignKey.association: '_CategoryValueHelp'
  key cast ( cast ( substring( DomainValue, 1, 1 ) as abap.char( 1 ) ) as bu_type )    as BusinessPartnerCategory,

      @Semantics.language:true
  key Language                                                                         as Language,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Consumption.filter.hidden: true
      // cast ( substring( ddtext, 1, 20 ) as abap.char( 20 ) )                       as BusinessPartnerCategoryText,

      @EndUserText.label: 'Business Partner Category Description'
      DomainText                                                                       as BusinessPartnerCategoryText,
      
      @Search.defaultSearchElement: true
      @Consumption.hidden: true
      DomainValue as DomainValue,
      
      _CategoryValueHelp
}
where
      Name        =  'BU_TYPE'
  and DomainValue <> '3'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_DOMAIN"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNERCATHELPVHTEMP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More