I_Scbo_Nodes_C

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_Nodes_C.
-- 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_NODES_VC

CREATE VIEW I_Scbo_Nodes_C AS
SELECT
  I_Scbo_Node_TP.BusinessObjectID AS BusinessObjectID,
  I_Scbo_Node_TP.NodeID AS NodeID,
  I_Scbo_Node_TP.NodeIDForEdit AS NodeIDForEdit,
  I_Scbo_Node_TP.ParentNodeID AS ParentNodeID,
  I_Scbo_Node_TP.Description AS Description,
  I_Scbo_Node_TP.DescriptionPlural AS DescriptionPlural,
  I_Scbo_Node_TP.TableName AS TableName,
  I_Scbo_Node_TP.CDSViewName AS CDSViewName,
  I_Scbo_Node_TP.UIMetadataExtensionName AS UIMetadataExtensionName,
  I_Scbo_Node_TP.ABAPViewName AS ABAPViewName,
  I_Scbo_Node_TP.VhCDSViewName AS VhCDSViewName,
  I_Scbo_Node_TP.VhABAPViewName AS VhABAPViewName,
  I_Scbo_Node_TP.AlternativeKeyTableName AS AlternativeKeyTableName,
  I_Scbo_Node_TP.AlternativeKeyTypeName AS AlternativeKeyTypeName,
  I_Scbo_Node_TP.ReadServiceInterfaceName AS ReadServiceInterfaceName,
  I_Scbo_Node_TP.ReadServiceClassName AS ReadServiceClassName,
  I_Scbo_Node_TP.CopiedNodeID AS CopiedNodeID,
  I_Scbo_Node_TP.CreateDisabled AS CreateDisabled,
  I_Scbo_Node_TP.UpdateDisabled AS UpdateDisabled,
  I_Scbo_Node_TP.DeleteDisabled AS DeleteDisabled,
  cast( _LifecycleStatus.IsTransported as scbo_is_transported ) AS IsTransported,
  I_Scbo_Node_TP.DrilldownState AS DrilldownState,
  I_Scbo_Node_TP.HLevel AS HLevel
FROM I_Scbo_Node_TP
LEFT OUTER JOIN P_Scbo_Node_Transported AS _LifecycleStatus ON ( _LifecycleStatus.BusinessObjectID = I_Scbo_Node_TP.BusinessObjectID OR _LifecycleStatus.DraftBusinessObjectID = I_Scbo_Node_TP.BusinessObjectID ) AND _LifecycleStatus.NodeID = I_Scbo_Node_TP.NodeID  -- association [0..1]
LEFT OUTER JOIN I_Scbo_Registry_C AS _Registry ON _Registry.BusinessObjectID = BusinessObjectID  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Bo_c AS _BusinessObject ON _BusinessObject.BusinessObjectID = I_Scbo_Node_TP.BusinessObjectID  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Elements_C AS _Element ON _Element.NodeID = I_Scbo_Node_TP.NodeID AND _Element.BusinessObjectID = I_Scbo_Node_TP.BusinessObjectID  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Nodes_C AS _ChildNode ON _ChildNode.BusinessObjectID = BusinessObjectID AND _ChildNode.ParentNodeID = NodeID  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Node_Logic AS _Logic ON _Logic.BusinessObjectID = BusinessObjectID AND _Logic.NodeID = NodeID AND _Logic.VersionNumber = '0000000000'  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Actions_C AS _Action ON _Action.BusinessObjectID = BusinessObjectID AND _Action.NodeID = NodeID  -- association [0..*]
;