I_CostComponentHierNodeTxt

DDL: I_COSTCOMPONENTHIERNODETXT Type: view_entity BASIC Package: FINS_UCB_HIER

Cost Breakdown Hierarchy Node - Text

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

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_CostComponentHierarchy _Hierarchy $projection.CostComponentHierarchy = _Hierarchy.CostComponentHierarchy

Annotations (12)

NameValueLevelField
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey HierarchyNode view
EndUserText.label Cost Breakdown Hierarchy Node - Text view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name CostComponentHierarchyNodeText view

Fields (8)

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

define view entity I_CostComponentHierNodeTxt
  as select from hrrp_nodet_n

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

  association [1..*] to I_CostComponentHierarchy as _Hierarchy on $projection.CostComponentHierarchy = _Hierarchy.CostComponentHierarchy

{
        @ObjectModel.foreignKey.association: '_Hierarchy'
  key   cast ( hrrp_nodet_n.hryid as fucb_cost_comp_hierid preserving type ) as CostComponentHierarchy,
  key   hrrp_nodet_n.hrynode                                                 as HierarchyNode,
        @Semantics.businessDate.to: true
  key   cast (hrrp_nodet_n.hryvalto as fis_datbi preserving type )           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 preserving type )         as ValidityStartDate,
        _Language,
        _Hierarchy

}
where
  hrrp_nodet_n.hrytyp = 'CB01';