I_Scbo_Node_TP

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_TP.
-- 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_TP_V

CREATE VIEW I_Scbo_Node_TP AS
SELECT
  P_Scbo_Node_A.BusinessObjectID AS BusinessObjectID,
  P_Scbo_Node_A.NodeID AS NodeID,
  P_Scbo_Node_A.NodeID AS NodeIDForEdit,
  P_Scbo_Node_A.ParentNodeID AS ParentNodeID,
  P_Scbo_Node_A.Description AS Description,
  P_Scbo_Node_A.DescriptionPlural AS DescriptionPlural,
  P_Scbo_Node_A.TableName AS TableName,
  P_Scbo_Node_A.CDSViewName AS CDSViewName,
  P_Scbo_Node_A.UIMetadataExtensionName AS UIMetadataExtensionName,
  P_Scbo_Node_A.ABAPViewName AS ABAPViewName,
  P_Scbo_Node_A.VhCDSViewName AS VhCDSViewName,
  P_Scbo_Node_A.VhABAPViewName AS VhABAPViewName,
  P_Scbo_Node_A.AlternativeKeyTableName AS AlternativeKeyTableName,
  P_Scbo_Node_A.AlternativeKeyTypeName AS AlternativeKeyTypeName,
  P_Scbo_Node_A.UpsertParameterTypeName AS UpsertParameterTypeName,
  P_Scbo_Node_A.DclName AS DclName,
  P_Scbo_Node_A.VhDclName AS VhDclName,
  P_Scbo_Node_A.ReadServiceInterfaceName AS ReadServiceInterfaceName,
  P_Scbo_Node_A.ReadServiceClassName AS ReadServiceClassName,
  P_Scbo_Node_A.CopiedNodeID AS CopiedNodeID,
  P_Scbo_Node_A.CreateDisabled AS CreateDisabled,
  P_Scbo_Node_A.UpdateDisabled AS UpdateDisabled,
  P_Scbo_Node_A.DeleteDisabled AS DeleteDisabled,
  case when _HasChildren.HasChildren is null then cast ( 'leaf' as abap.char(10)) else cast ( '' as abap.char(10)) end as DrilldownState AS char10endasDrilldownState
FROM P_Scbo_Node_A
LEFT OUTER JOIN I_Scbo_Registry_Tp AS _Registry ON _Registry.BusinessObjectID = BusinessObjectID  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Bo_TP AS _BusinessObject ON _BusinessObject.BusinessObjectID = P_Scbo_Node_A.BusinessObjectID  -- association [1]
LEFT OUTER JOIN I_Scbo_Elem_TP AS _Element ON _Element.BusinessObjectID = P_Scbo_Node_A.BusinessObjectID AND _Element.NodeID = P_Scbo_Node_A.NodeID  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Action_Tp AS _Action ON _Action.BusinessObjectID = P_Scbo_Node_A.BusinessObjectID AND _Action.NodeID = P_Scbo_Node_A.NodeID  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Eval_Tp AS _Evaluation ON _Evaluation.BusinessObjectID = P_Scbo_Node_A.BusinessObjectID AND _Evaluation.NodeID = P_Scbo_Node_A.NodeID  -- association [0..*]
LEFT OUTER JOIN P_Scbo_Node_Has_Children AS _HasChildren ON _HasChildren.ParentNodeID = NodeID AND _HasChildren.BusinessObjectID = BusinessObjectID  -- association [0..1]
;