I_Scbo_Node

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 I_Scbo_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.
-- SQL view name: I_SCBO_NODE_V

CREATE VIEW I_Scbo_Node AS
SELECT
  Node.business_object_id AS BusinessObjectID,
  Node.node_id AS NodeID,
  Node.version_number AS VersionNumber,
  Node.parent_node_id AS ParentNodeID,
  Node.description AS Description,
  Node.description_plural AS DescriptionPlural,
  Node.table_name AS TableName,
  Node.cds_view_name AS CDSViewName,
  Node.ui_metadata_extension_name AS UIMetadataExtensionName,
  Node.abap_view_name AS ABAPViewName,
  Node.vh_cds_view_name AS VhCDSViewName,
  Node.vh_abap_view_name AS VhABAPViewName,
  Node.alternativekey_type_name AS AlternativeKeyTypeName,
  Node.alternativekey_table_name AS AlternativeKeyTableName,
  Node.bl_eval_rs_intf_name AS ReadServiceInterfaceName,
  Node.bl_eval_rs_class_name AS ReadServiceClassName,
  Node.associability_indicator AS AssociabilityIndicator,
  Node.copied_node_id AS CopiedNodeID,
  Node.upsert_parameter_type_name AS UpsertParameterTypeName,
  Node.dcl_name AS DclName,
  Node.create_disabled AS CreateDisabled,
  Node.update_disabled AS UpdateDisabled,
  Node.delete_disabled AS DeleteDisabled,
  _BusinessObject.LastChangedAt AS BOLastChangedAt
FROM scbo_node AS Node
LEFT OUTER JOIN I_Scbo AS _BusinessObject ON BusinessObjectID = _BusinessObject.BusinessObjectID AND VersionNumber = _BusinessObject.VersionNumber  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Node AS _ParentNode ON BusinessObjectID = _ParentNode.BusinessObjectID AND ParentNodeID = _ParentNode.NodeID AND VersionNumber = _ParentNode.VersionNumber  -- association [0..1]
LEFT OUTER JOIN I_Scbo_Node AS _ChildNode ON BusinessObjectID = _ChildNode.BusinessObjectID AND NodeID = _ChildNode.ParentNodeID AND VersionNumber = _ChildNode.VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Element AS _Element ON BusinessObjectID = _Element.BusinessObjectID AND NodeID = _Element.NodeID AND VersionNumber = _Element.VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Node_Logic AS _Logic ON BusinessObjectID = _Logic.BusinessObjectID AND NodeID = _Logic.NodeID AND VersionNumber = _Logic.VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Action AS _Action ON BusinessObjectID = _Action.BusinessObjectID AND NodeID = _Action.NodeID AND VersionNumber = _Action.VersionNumber  -- association [0..*]
;