A_CnsldtnFSItemHierNode

DDL: A_CNSLDTNFSITEMHIERNODE Type: view_entity BASIC Package: FIN_CS_MD_FSITEM

Consolidation FS Item - Hierarchy Node

A_CnsldtnFSItemHierNode is a Basic CDS View that provides data about "Consolidation FS Item - Hierarchy Node" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnFSItemHierNode_2) and exposes 14 fields with key fields ConsolidationChartOfAccounts, CnsldtnFSItemHierarchy, HierarchyNode, ValidityEndDate. It has 2 associations to related views. It is exposed through 1 OData service (API_CNSLDTNFSITEMHIERARCHY). Part of development package FIN_CS_MD_FSITEM.

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

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnFSItemHierNode_2 _HierarchyNode from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_CnsldtnFSItemHierarchy_3 _Hierarchy $projection.ConsolidationChartOfAccounts = _Hierarchy.ConsolidationChartOfAccounts and $projection.CnsldtnFSItemHierarchy = _Hierarchy.CnsldtnFSItemHierarchy and $projection.ValidityEndDate = _Hierarchy.ValidityEndDate
[0..*] A_CnsldtnFSItemHierNodeText _Text $projection.ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts and $projection.CnsldtnFSItemHierarchy = _Text.CnsldtnFSItemHierarchy and $projection.HierarchyNode = _Text.HierarchyNode and $projection.ValidityEndDate = _Text.ValidityEndDate and $projection.CnsldtnFinancialStatementItem = ''

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name CnsldtnFSItemHierarchyNode view
OData.entitySet.name CnsldtnFSItemHierarchyNode view
OData.entityType.name CnsldtnFSItemHierarchyNode_Type view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Consolidation FS Item - Hierarchy Node view

OData Services (1)

ServiceBindingVersionContractRelease
API_CNSLDTNFSITEMHIERARCHY API_CNSLDTNFSITEMHIERARCHY V4 C2 C1

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts I_CnsldtnFSItemHierNode_2 ConsolidationChartOfAccounts
KEY CnsldtnFSItemHierarchy I_CnsldtnFSItemHierNode_2 CnsldtnFSItemHierarchy
KEY HierarchyNode I_CnsldtnFSItemHierNode_2 HierarchyNode
KEY ValidityEndDate I_CnsldtnFSItemHierNode_2 ValidityEndDate
ValidityStartDate I_CnsldtnFSItemHierNode_2 ValidityStartDate
ParentNode I_CnsldtnFSItemHierNode_2 ParentNode
HierarchyVersion I_CnsldtnFSItemHierNode_2 HierarchyVersion
CnsldtnFinancialStatementItem I_CnsldtnFSItemHierNode_2 CnsldtnFinancialStatementItem
HierarchyNodeSequence I_CnsldtnFSItemHierNode_2 HierarchyNodeSequence
HierarchyNodeLevel I_CnsldtnFSItemHierNode_2 HierarchyNodeLevel
NodeType I_CnsldtnFSItemHierNode_2 NodeType
SignIsInverted I_CnsldtnFSItemHierNode_2 SignIsInverted
_Hierarchy _Hierarchy
_Text _Text 
@AccessControl.authorizationCheck: #MANDATORY
@Metadata:{
  ignorePropagatedAnnotations:true
  }
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #XL},
    sapObjectNodeType.name: 'CnsldtnFSItemHierarchyNode'
}
@OData: {
  entitySet.name: 'CnsldtnFSItemHierarchyNode',
  entityType.name: 'CnsldtnFSItemHierarchyNode_Type'
  }
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
  }
@EndUserText.label: 'Consolidation FS Item - Hierarchy Node'

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view entity A_CnsldtnFSItemHierNode
  as select from I_CnsldtnFSItemHierNode_2 as _HierarchyNode

  association [1..1] to A_CnsldtnFSItemHierarchy_3  as _Hierarchy on  $projection.ConsolidationChartOfAccounts = _Hierarchy.ConsolidationChartOfAccounts
                                                                  and $projection.CnsldtnFSItemHierarchy       = _Hierarchy.CnsldtnFSItemHierarchy
                                                                  and $projection.ValidityEndDate              = _Hierarchy.ValidityEndDate

  association [0..*] to A_CnsldtnFSItemHierNodeText as _Text      on  $projection.ConsolidationChartOfAccounts  = _Text.ConsolidationChartOfAccounts
                                                                  and $projection.CnsldtnFSItemHierarchy        = _Text.CnsldtnFSItemHierarchy
                                                                  and $projection.HierarchyNode                 = _Text.HierarchyNode
                                                                  and $projection.ValidityEndDate               = _Text.ValidityEndDate
                                                                  and $projection.CnsldtnFinancialStatementItem = ''
{

      @ObjectModel.sapObjectNodeTypeReference: 'ConsolidationChartOfAccounts'
  key _HierarchyNode.ConsolidationChartOfAccounts,

      @ObjectModel.sapObjectNodeTypeReference: 'ConsolidationFSItemHierarchy'
  key _HierarchyNode.CnsldtnFSItemHierarchy,

  key _HierarchyNode.HierarchyNode,

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

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

      _HierarchyNode.ParentNode,

      _HierarchyNode.HierarchyVersion,

      @ObjectModel.sapObjectNodeTypeReference: 'CnsldtnFinancialStatementItem'
      _HierarchyNode.CnsldtnFinancialStatementItem,

      _HierarchyNode.HierarchyNodeSequence,

      _HierarchyNode.HierarchyNodeLevel,

      _HierarchyNode.NodeType,

      _HierarchyNode.SignIsInverted,


      _Hierarchy,
      _Text
};

Learn More