I_CustomerGroupHierNodeText

DDL: I_CUSTOMERGROUPHIERNODETEXT Type: view_entity BASIC Package: FINS_FIS_FICO

Customer Group Hierarchy Node - Text

I_CustomerGroupHierNodeText is a Basic CDS View that provides data about "Customer Group Hierarchy Node - Text" in SAP S/4HANA. It reads from 1 data source (hrrp_nodet_n) and exposes 8 fields with key fields CustomerGroupHierarchy, HierarchyNode, ValidityEndDate, Language. It has 2 associations to related views. Part of development package FINS_FIS_FICO.

Data Sources (1)

SourceAliasJoin Type
hrrp_nodet_n hrrp_nodet_n from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..*] I_CustomerGroupHierarchy _Hierarchy $projection.CustomerGroupHierarchy = _Hierarchy.CustomerGroupHierarchy

Annotations (13)

NameValueLevelField
ObjectModel.dataCategory #TEXT view
EndUserText.label Customer Group Hierarchy Node - Text view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name CustomerGroupHierarchyNodeText view
ObjectModel.representativeKey HierarchyNode view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustomerGroupHierarchy
KEY HierarchyNode hrrp_nodet_n hrynode
KEY ValidityEndDate
KEY Language hrrp_nodet_n spras
HierarchyNodeText hrrp_nodet_n nodetxt
ValidityStartDate
_Language _Language
_Hierarchy _Hierarchy
@AbapCatalog.viewEnhancementCategory: [#NONE]
@ObjectModel.dataCategory: #TEXT
@EndUserText.label: 'Customer Group Hierarchy Node - Text'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #LANGUAGE_DEPENDENT_TEXT, #EXTRACTION_DATA_SOURCE ]
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #L
}
@Search.searchable: true
@Analytics.dataExtraction.enabled: true
@ObjectModel.sapObjectNodeType.name:'CustomerGroupHierarchyNodeText'
@ObjectModel.representativeKey: 'HierarchyNode'

define view entity I_CustomerGroupHierNodeText
  as select from hrrp_nodet_n

  association [0..1] to I_Language               as _Language  on $projection.Language = _Language.Language

  association [1..*] to I_CustomerGroupHierarchy as _Hierarchy on $projection.CustomerGroupHierarchy = _Hierarchy.CustomerGroupHierarchy

{
      @ObjectModel.foreignKey.association: '_Hierarchy'
  key cast ( hrrp_nodet_n.hryid as fis_hryid_customergroup preserving type ) as CustomerGroupHierarchy,
  key hrrp_nodet_n.hrynode                                                   as HierarchyNode,
      @Semantics.businessDate.to: true
  key cast (hrrp_nodet_n.hryvalto as fis_datbi)                              as ValidityEndDate,
      @Semantics.language: true
  key hrrp_nodet_n.spras                                                     as Language,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      hrrp_nodet_n.nodetxt                                                   as HierarchyNodeText,
      @Semantics.businessDate.from: true
      cast (hrrp_nodet_n.hryvalfrom as fis_datab)                            as ValidityStartDate,
      _Language,
      _Hierarchy
}
where
  hrrp_nodet_n.hrytyp = 'U506'