P_CNSLDTNUNITELIMNODETEXT

CDS View

Cnsldtn Unit Mgmt Elim Node - Text

P_CNSLDTNUNITELIMNODETEXT is a CDS View in S/4HANA. Cnsldtn Unit Mgmt Elim Node - Text. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CnsldtnUnitElimNodeText view from BASIC Cnsldtn Unit Mgmt Elim Node - Text
I_CnsldtnUnitOfEliminationT view from BASIC Consolidation Unit for Elimination Text

Fields (1)

KeyField CDS FieldsUsed in Views
KEY spras Language 2 
@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