I_Scbo_reg

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_reg.
-- 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_REG_V

CREATE VIEW I_Scbo_reg AS
SELECT
  BusinessObject.BusinessObjectID AS BusinessObjectID,
  BusinessObject.DraftBusinessObjectID AS DraftBusinessObjectID,
  BusinessObject.VersionNumber AS VersionNumber,
  BusinessObject.Namespace AS Namespace,
  BusinessObject.Description AS Description,
  BusinessObject.DescriptionPlural AS DescriptionPlural,
  BusinessObject.CreatedAt AS CreatedAt,
  BusinessObject.CreatedBy AS CreatedBy,
  BusinessObject.LastChangedAt AS LastChangedAt,
  BusinessObject.LastChangedBy AS LastChangedBy,
  BusinessObject.PublishState AS PublishState,
  BusinessObject.OriginalRelease AS OriginalRelease,
  _CreateUser.description AS CreatedByName,
  _ChangeUser.description AS LastChangedByName,
  State_Texts.description AS PublishStateDescription,
  case when Draft.BusinessObjectID is not null then cast ('X' as abap.char(1)) else cast (' ' as abap.char(1)) end as HasDraft AS char1endasHasDraft,
  case when Active.BusinessObjectID is not null then cast ('X' as abap.char(1)) else cast (' ' as abap.char(1)) end as HasActive AS char1endasHasActive,
  ActiveRootNode.NodeID AS ActiveRootNodeID,
  DraftRootNode.NodeID AS DraftRootNodeID,
  case when DraftRootNode.NodeID is not null then DraftRootNode.NodeID else ActiveRootNode.NodeID end as RootNodeID AS NodeIDendasRootNodeID,
  Active,
  Draft,
  State_Texts,
  ActiveRootNode,
  DraftRootNode,
  ActiveRootNodeElements,
  DraftRootNodeElements
FROM P_Scbo_Reg_Union AS BusinessObject
LEFT OUTER JOIN P_Scbo_User AS _CreateUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Scbo_User AS _ChangeUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Scbo_Node AS ActiveRootNode ON ActiveRootNode.BusinessObjectID = BusinessObject.BusinessObjectID AND ActiveRootNode.VersionNumber = BusinessObject.VersionNumber AND ActiveRootNode.ParentNodeID = ''  -- association [0..1]
LEFT OUTER JOIN I_Scbo_Node AS DraftRootNode ON DraftRootNode.BusinessObjectID = BusinessObject.DraftBusinessObjectID AND DraftRootNode.VersionNumber = BusinessObject.VersionNumber AND DraftRootNode.ParentNodeID = ''  -- association [0..1]
LEFT OUTER JOIN I_Scbo_Element AS ActiveRootNodeElements ON ActiveRootNodeElements.BusinessObjectID = BusinessObject.BusinessObjectID AND ActiveRootNodeElements.NodeID = ActiveRootNodeID AND ActiveRootNodeElements.VersionNumber = BusinessObject.VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Element AS DraftRootNodeElements ON DraftRootNodeElements.BusinessObjectID = BusinessObject.DraftBusinessObjectID AND DraftRootNodeElements.NodeID = DraftRootNodeID AND DraftRootNodeElements.VersionNumber = BusinessObject.VersionNumber  -- association [0..*]
;