P_CnsldtnUnitElimNodeText

DDL: P_CNSLDTNUNITELIMNODETEXT Type: view_entity BASIC Package: FIN_CS_MD_UNIT

Cnsldtn Unit Mgmt Elim Node - Text

P_CnsldtnUnitElimNodeText is a Basic CDS View that provides data about "Cnsldtn Unit Mgmt Elim Node - Text" in SAP S/4HANA. It reads from 2 data sources (hrrp_node, hrrp_nodet) and exposes 4 fields with key fields spras, nodevalue. Part of development package FIN_CS_MD_UNIT.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
hrrp_node _node inner
hrrp_nodet _nodet from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY spras hrrp_nodet spras
KEY nodevalue hrrp_node nodevalue
nodecls hrrp_nodet nodecls
nodetxt 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #B,
    sizeCategory: #M}
}
@VDM:{
  viewType: #BASIC,
  private:true
  }

define view entity P_CnsldtnUnitElimNodeText
  as select from hrrp_nodet as _nodet

    inner join   hrrp_node  as _node on  _nodet.hryid    = _node.hryid
                                     and _nodet.hryvalto = _node.hryvalto
                                     and _nodet.hrynode  = _node.hrynode
                                     and _node.nodetype  = '$'
                                     and _node.hrytype   = 'CS17'
                                     and _node.nodecls   = 'Y1'

{
       @Semantics.language
  key  _nodet.spras,

  key  _node.nodevalue,

       _nodet.nodecls,

       @Semantics.text
       max(_nodet.nodetxt) as nodetxt

}
where
      _nodet.hrytyp       = 'CS17'
//and _nodet.node_timedep = ''

  and _nodet.nodecls      = 'Y1'
group by
  _nodet.hrynode,
  _nodet.spras,
  _nodet.nodecls,
  _node.nodevalue;

Learn More