I_CnsldtnSalesOrgHierNodeEnhcd

DDL: I_CNSLDTNSALESORGHIERNODEENHCD Type: view BASIC

Cnsldtn Sales Organization - Hier Node

I_CnsldtnSalesOrgHierNodeEnhcd is a Basic CDS View that provides data about "Cnsldtn Sales Organization - Hier Node" in SAP S/4HANA. It reads from 1 data source (hrrp_node) and exposes 9 fields with key fields AdditionalMasterDataHierarchy, HierarchyNode, ValidityEndDate.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
hrrp_node hrrp_node from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICCSGHNENH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
EndUserText.label Cnsldtn Sales Organization - Hier Node view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMasterDataHierarchy
KEY HierarchyNode hrrp_node hrynode
KEY ValidityEndDate
ParentNode hrrp_node parnode
ValidityStartDate
HierarchyNodeSequence hrrp_node hryseqnbr
HierarchyNodeLevel hrrp_node hrylevel
NodeType hrrp_node nodetype
HierarchyType 
@AbapCatalog: {
  sqlViewName: 'ICCSGHNENH',
  compiler.compareFilter: true
  }
/*@Hierarchy.parentChild: {
  recurse:          { parent:    'ParentNode',
                      child:     'HierarchyNode'   },
  siblingsOrder:    [{ by:       'SequenceNumber',
                      direction: #ASC   },
                    { by:        'HierarchyNode',
                      direction: #ASC   }]
//  orphanedNode:     { handling:  #IGNORE  },

  //directory:        '_Hierarchy'

}*/
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {usageType: {
  dataClass: #MASTER,
  serviceQuality: #A,
  sizeCategory: #XL}
  //dataCategory: #HIERARCHY

  }
@VDM.viewType: #BASIC
@EndUserText.label: 'Cnsldtn Sales Organization - Hier Node'

// OBSOLETE


define view I_CnsldtnSalesOrgHierNodeEnhcd
  as select from hrrp_node

{
      @Consumption.filter: {mandatory : true, selectionType : #SINGLE, multipleSelections : false }
      //      @ObjectModel.foreignKey.association: '_Hierarchy'

  key cast( hrrp_node.hryid as fincs_hryid)              as AdditionalMasterDataHierarchy,

      //      @ObjectModel.text.association: '_Text'

  key hrrp_node.hrynode                                  as HierarchyNode,

      @Consumption.filter: {mandatory : true, selectionType : #SINGLE, multipleSelections : false }
  key cast(hrrp_node.hryvalto as fis_datbi)              as ValidityEndDate,

      hrrp_node.parnode                                  as ParentNode,
      //      hrrp_node.hryver                                                               as HierarchyVersion,


      @Semantics.businessDate.from: true
      cast(hrrp_node.hryvalfrom as fis_datab)            as ValidityStartDate,

      //      @ObjectModel.foreignKey.association: '_SalesOrg'

      cast ( case hrrp_node.nodetype
        when 'L' then  substring( hrrp_node.nodevalue, 1, 4 )
        else  ''
        end as  vkorg )                                  as SalesOrganization,

      hrrp_node.hryseqnbr                                as HierarchyNodeSequence,

      hrrp_node.hrylevel                                 as HierarchyNodeLevel,

      hrrp_node.nodetype                                 as NodeType,

      @Consumption.hidden: true
      cast(substring( hrrp_node.hryid, 1, 4) as hrytype) as HierarchyType

}
where
      hrytype  =  'CS11'
  and nodetype <> 'D'
  and nodetype <> 'B'
  and nodetype <> 'J'
  and nodetype <> 'V';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"HRRP_NODE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More