I_CostComponentHierarchy

DDL: I_COSTCOMPONENTHIERARCHY Type: view_entity BASIC Package: FINS_UCB_HIER

Cost Breakdown Hierarchy

I_CostComponentHierarchy is a Basic CDS View (Dimension) that provides data about "Cost Breakdown Hierarchy" in SAP S/4HANA. It reads from 1 data source (hrrp_dir_n) and exposes 9 fields with key fields CostComponentHierarchy, ValidityEndDate. It has 2 associations to related views. Part of development package FINS_UCB_HIER.

Data Sources (1)

SourceAliasJoin Type
hrrp_dir_n hrrp_dir_n from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_CostComponentHierarchyText _Text $projection.CostComponentHierarchy = _Text.CostComponentHierarchy and $projection.ValidityEndDate = _Text.ValidityEndDate
[0..1] I_CostBreakdownStructure _CostBreakdownStructure $projection.CostBreakdownStructure = _CostBreakdownStructure.CostBreakdownStructure

Annotations (14)

NameValueLevelField
EndUserText.label Cost Breakdown Hierarchy view
ObjectModel.representativeKey CostComponentHierarchy view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
Analytics.dataExtraction.enabled true view
ObjectModel.sapObjectNodeType.name CostComponentHierarchy view
Analytics.internalName #LOCAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CostComponentHierarchy
KEY ValidityEndDate
ValidityStartDate
LastChangedByUser hrrp_dir_n upduser
LastChangeDateTime hrrp_dir_n updtime
HierarchyShortID hrrp_dir_n hrysid
CostBreakdownStructure hrrp_dir_n cost_comp_struc
_Text _Text
_CostBreakdownStructure _CostBreakdownStructure
@EndUserText.label: 'Cost Breakdown Hierarchy'
@ObjectModel.representativeKey: 'CostComponentHierarchy'
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@Metadata.allowExtensions:true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ]
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #S
}
@Analytics.dataExtraction.enabled: true
@ObjectModel.sapObjectNodeType.name: 'CostComponentHierarchy'
@Analytics.internalName:#LOCAL

define view entity I_CostComponentHierarchy
  as select from hrrp_dir_n
  association [1..*] to I_CostComponentHierarchyText as _Text                   on  $projection.CostComponentHierarchy = _Text.CostComponentHierarchy
                                                                                and $projection.ValidityEndDate        = _Text.ValidityEndDate
  association [0..1] to I_CostBreakdownStructure     as _CostBreakdownStructure on  $projection.CostBreakdownStructure = _CostBreakdownStructure.CostBreakdownStructure

{
      @ObjectModel.text.association: '_Text'
  key cast ( hrrp_dir_n.hryid as fucb_cost_comp_hierid preserving type ) as CostComponentHierarchy,
      @Semantics.businessDate.to: true
  key cast(hrrp_dir_n.hryvalto as fis_datbi preserving type )            as ValidityEndDate,
      @Semantics.businessDate.from: true
      cast(hrrp_dir_n.hryvalfrom as fis_datab preserving type )          as ValidityStartDate,
      @Semantics.user.lastChangedBy: true
      hrrp_dir_n.upduser                                                 as LastChangedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      hrrp_dir_n.updtime                                                 as LastChangeDateTime,
      hrrp_dir_n.hrysid                                                  as HierarchyShortID,
      @ObjectModel.foreignKey.association: '_CostBreakdownStructure'
      @Hierarchy.notAssignedNode.filter: true
      hrrp_dir_n.cost_comp_struc                                         as CostBreakdownStructure,
      _Text,

      _CostBreakdownStructure

}
where
  hrrp_dir_n.hrytyp = 'CB01';