P_SemTagNode

DDL: P_SEMTAGNODE SQL: PFISEMTAGND Type: view BASIC
8 Fields 3 Data Sources

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.

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 Hierarchy ID
hrynode hrynode Par. Node
hryvalto hryvalto Valid To
fins_sem_tag fins_sem_tag Semantic Tag
hrynode hrrp_node_n parnode Par. Node
hryvalto hrrp_node_n hryvalto Valid To
fins_sem_tag P_SemTagLeaf fins_sem_tag Semantic Tag
nodetype hrrp_node_n nodetype Object Type

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SemTagNode.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFISEMTAGND

CREATE VIEW P_SemTagNode AS
SELECT
  hryid,
  hrynode,
  hryvalto,
  fins_sem_tag,
  node.nodetype AS nodetype
FROM P_SemTagLeaf
INNER JOIN P_SemTagLeaf ON /* join condition not captured in parsed metadata */
INNER JOIN hrrp_node_n AS node ON /* join condition not captured in parsed metadata */
;

Learn More