P_SEMTAGNODE

CDS View

P_SEMTAGNODE is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GLAcctHierNodeSemanticTag view from BASIC GL Account Hierarchy Node with Semantic Tag 
@AbapCatalog.sqlViewName: 'PFISEMTAGND'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@ObjectModel.representativeKey: 'SemanticTag'

@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_SemTagNode

  as select from P_SemTagLeaf
{
  hryid,
  hrynode,
  hryvalto,
  fins_sem_tag,
  nodetype
}

union all select distinct from hrrp_node_n
  inner join                   P_SemTagLeaf        on  hrrp_node_n.hryid_42 = P_SemTagLeaf.hryid
                                                   and hrrp_node_n.hrynode  = P_SemTagLeaf.hrynode
                                                   and hrrp_node_n.hryvalto = P_SemTagLeaf.hryvalto
  inner join                   hrrp_node_n as node on  node.hryid_42 = hrrp_node_n.hryid_42
                                                   and node.hrynode  = hrrp_node_n.parnode
                                                   and node.hryvalto = hrrp_node_n.hryvalto
{
  hrrp_node_n.hryid_42 as hryid,
  hrrp_node_n.parnode  as hrynode,
  hrrp_node_n.hryvalto,
  P_SemTagLeaf.fins_sem_tag,
  node.nodetype

}
where
  node.nodetype = 'N'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SEMTAGLEAF",
"HRRP_NODE_N"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More