P_SemTagNode

DDL: P_SEMTAGNODE SQL: PFISEMTAGND Type: view BASIC

P_SemTagNode is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (hrrp_node_n, P_SemTagLeaf, P_SemTagLeaf) and exposes 8 fields.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
hrrp_node_n node inner
P_SemTagLeaf P_SemTagLeaf from
P_SemTagLeaf P_SemTagLeaf inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PFISEMTAGND view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
hryid hryid
hrynode hrynode
hryvalto hryvalto
fins_sem_tag fins_sem_tag
hrynode hrrp_node_n parnode
hryvalto hrrp_node_n hryvalto
fins_sem_tag P_SemTagLeaf fins_sem_tag
nodetype hrrp_node_n nodetype 
@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