A_CnsldtnFuncnlAreaHierNode

DDL: A_CNSLDTNFUNCNLAREAHIERNODE Type: view_entity BASIC Package: FIN_CS_MD_FUNCTIONALAREA

Cnsldtn Functional Area Hierarchy Node

A_CnsldtnFuncnlAreaHierNode is a Basic CDS View that provides data about "Cnsldtn Functional Area Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnFuncnlAreaHierNode) and exposes 12 fields with key fields CnsldtnFunctionalAreaHierarchy, HierarchyNode, ValidityEndDate. It has 2 associations to related views. It is exposed through 1 OData service (API_CNSLDTNFUNCNLAREAHIER). Part of development package FIN_CS_MD_FUNCTIONALAREA.

1 data source(s) Exposed by 1 service(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnFuncnlAreaHierNode _Source from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_CnsldtnFunctionalAreaHier_2 _Hierarchy $projection.CnsldtnFunctionalAreaHierarchy = _Hierarchy.CnsldtnFunctionalAreaHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate
[0..*] A_CnsldtnFuncnlAreaHierNodeT _Text $projection.CnsldtnFunctionalAreaHierarchy = _Text.CnsldtnFunctionalAreaHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.ValidityEndDate = _Text.ValidityEndDate and $projection.FunctionalArea = ''

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
OData.entityType.name CnsldtnFuncnlAreaHierarchyNode_Type view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Cnsldtn Functional Area Hierarchy Node view

OData Services (1)

ServiceBindingVersionContractRelease
API_CNSLDTNFUNCNLAREAHIER API_CNSLDTNFUNCNLAREAHIER V4 C2 C1

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnFunctionalAreaHierarchy I_CnsldtnFuncnlAreaHierNode CnsldtnFunctionalAreaHierarchy
KEY HierarchyNode I_CnsldtnFuncnlAreaHierNode HierarchyNode
KEY ValidityEndDate I_CnsldtnFuncnlAreaHierNode ValidityEndDate
ValidityStartDate I_CnsldtnFuncnlAreaHierNode ValidityStartDate
ParentNode I_CnsldtnFuncnlAreaHierNode ParentNode
HierarchyVersion I_CnsldtnFuncnlAreaHierNode HierarchyVersion
FunctionalArea I_CnsldtnFuncnlAreaHierNode FunctionalArea
HierarchyNodeSequence I_CnsldtnFuncnlAreaHierNode HierarchyNodeSequence
HierarchyNodeLevel I_CnsldtnFuncnlAreaHierNode HierarchyNodeLevel
NodeType I_CnsldtnFuncnlAreaHierNode NodeType
_Hierarchy _Hierarchy
_Text _Text 
@AccessControl.authorizationCheck: #MANDATORY
@Metadata:{
  ignorePropagatedAnnotations:true
}
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #M
  }
}
@OData.entityType.name: 'CnsldtnFuncnlAreaHierarchyNode_Type'
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@EndUserText.label: 'Cnsldtn Functional Area Hierarchy Node'
define view entity A_CnsldtnFuncnlAreaHierNode
  as select from I_CnsldtnFuncnlAreaHierNode as _Source


  association [1..1] to A_CnsldtnFunctionalAreaHier_2 as _Hierarchy on  $projection.CnsldtnFunctionalAreaHierarchy = _Hierarchy.CnsldtnFunctionalAreaHierarchy
                                                                    and $projection.ValidityEndDate                = _Hierarchy.ValidityEndDate

  association [0..*] to A_CnsldtnFuncnlAreaHierNodeT  as _Text      on  $projection.CnsldtnFunctionalAreaHierarchy = _Text.CnsldtnFunctionalAreaHierarchy
                                                                    and $projection.HierarchyNode                  = _Text.HierarchyNode
                                                                    and $projection.ValidityEndDate                = _Text.ValidityEndDate
                                                                    and $projection.FunctionalArea                 = ''
{


  key _Source.CnsldtnFunctionalAreaHierarchy,

  key _Source.HierarchyNode,

      @Semantics.businessDate.to: true
  key _Source.ValidityEndDate,

      @Semantics.businessDate.from: true
      _Source.ValidityStartDate,

      _Source.ParentNode,

      _Source.HierarchyVersion,

      _Source.FunctionalArea,

      _Source.HierarchyNodeSequence,

      _Source.HierarchyNodeLevel,

      _Source.NodeType,


      _Hierarchy,
      _Text
};

Learn More