N_SCBO2_NODE

DDL: N_SCBO2_NODE Type: view_entity
11 Fields 1 Data Sources

CBO Version 2: Node

N_SCBO2_NODE is a CDS View that provides data about "CBO Version 2: Node" in SAP S/4HANA. It reads from 1 data source (scbo2_node) and exposes 11 fields with key fields BusinessObjectId, NodeId.

Data Sources (1)

SourceAliasJoin Type
scbo2_node Node from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CBO Version 2: Node view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectId scbo2_node business_object_id Business Object ID
KEY NodeId scbo2_node node_id Workflow Step
ParentNodeId scbo2_node parent_node_id Node Id
Description scbo2_node description Well Code Des.
DescriptionPlural scbo2_node description_plural Description Plural
NodeAlias scbo2_node node_alias Alias
TitleElement scbo2_node title_element
DescriptionElement scbo2_node description_element
OrdinalNumber scbo2_node ordinal_number Ordinal Number
LocalLastChangedAt scbo2_node local_last_changed_at Time Stamp
Transported scbo2_node transported Truth Value

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 N_SCBO2_NODE.
-- 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.

CREATE VIEW N_SCBO2_NODE AS
SELECT
  Node.business_object_id AS BusinessObjectId,
  Node.node_id AS NodeId,
  Node.parent_node_id AS ParentNodeId,
  Node.description AS Description,
  Node.description_plural AS DescriptionPlural,
  Node.node_alias AS NodeAlias,
  Node.title_element AS TitleElement,
  Node.description_element AS DescriptionElement,
  Node.ordinal_number AS OrdinalNumber,
  Node.local_last_changed_at AS LocalLastChangedAt,
  Node.transported AS Transported
FROM scbo2_node AS Node
;

Learn More