FAC_CDS_HRRP_NODET_SDM_VER_B

DDL: FAC_CDS_HRRP_NODET_SDM_VER_B SQL: HRRPNODETSDMVERB Type: view
12 Fields 1 Data Sources 1 Associations

hrrp_nodet with sdm version field

FAC_CDS_HRRP_NODET_SDM_VER_B is a CDS View that provides data about "hrrp_nodet with sdm version field" in SAP S/4HANA. It reads from 1 data source (hrrp_nodet) and exposes 12 fields with key fields mandt, spras, hryid, hryver, nodecls. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hrrp_nodet hrrp_nodet from

Associations (1)

CardinalityTargetAliasCondition
[1..1] hrrp_directory _dir _dir.hryid = $projection.hryid and _dir.hryver = $projection.hryver and _dir.hryvalto = $projection.hryvalto

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName HRRPNODETSDMVERB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label hrrp_nodet with sdm version field view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY spras spras Off. Language
KEY hryid hryid Hierarchy ID
KEY hryver hryver Version: Structures
KEY nodecls nodecls Node Class
KEY hrynode hrynode Node
KEY parnode parnode Par. Node
KEY hryvalto hryvalto Valid To
hryvalfrom hryvalfrom Valid From
nodetxt nodetxt Description
hrytyp _dir hrytyp Hierarchy Type
nodetxt0

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 FAC_CDS_HRRP_NODET_SDM_VER_B.
-- 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: HRRPNODETSDMVERB

CREATE VIEW FAC_CDS_HRRP_NODET_SDM_VER_B AS
SELECT
  mandt,
  spras,
  hryid,
  hryver,
  nodecls,
  hrynode,
  parnode,
  hryvalto,
  hryvalfrom,
  nodetxt,
  _dir.hrytyp AS hrytyp,
  concat('0',nodetxt) AS nodetxt0
FROM hrrp_nodet
LEFT OUTER JOIN hrrp_directory AS _dir ON _dir.hryid = hryid AND _dir.hryver = hryver AND _dir.hryvalto = hryvalto  -- association [1..1]
;

Learn More