I_Scbo_Actions_C

DDL: I_SCBO_ACTIONS_C SQL: I_SCBO_ACTS_VC Type: view

Custom Business Objects: Action BO

I_Scbo_Actions_C is a CDS View that provides data about "Custom Business Objects: Action BO" in SAP S/4HANA. It reads from 1 data source (I_Scbo_Action_Tp) and exposes 8 fields with key fields BusinessObjectID, NodeID, ActionID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Scbo_Action_Tp I_Scbo_Action_Tp from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Scbo_Registry_C _Registry _Registry.BusinessObjectID = $projection.BusinessObjectID
[1..1] I_Scbo_Nodes_C _Node _Node.NodeID = $projection.NodeID and _Node.BusinessObjectID = $projection.BusinessObjectID

Annotations (8)

NameValueLevelField
EndUserText.label Custom Business Objects: Action BO view
AbapCatalog.sqlViewName I_SCBO_ACTS_VC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_INDEPENDENT view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectID I_Scbo_Action_Tp BusinessObjectID Business Object ID
KEY NodeID I_Scbo_Action_Tp NodeID Workflow Step
KEY ActionID I_Scbo_Action_Tp ActionID Action ID
ActionIDForEdit I_Scbo_Action_Tp ActionIDForEdit Action ID
Description I_Scbo_Action_Tp Description Well Code Des.
OrdinalNumber I_Scbo_Action_Tp OrdinalNumber Sequence Number
_Registry _Registry
_Node _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_Actions_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_ACTS_VC

CREATE VIEW I_Scbo_Actions_C AS
SELECT
  I_Scbo_Action_Tp.BusinessObjectID AS BusinessObjectID,
  I_Scbo_Action_Tp.NodeID AS NodeID,
  I_Scbo_Action_Tp.ActionID AS ActionID,
  I_Scbo_Action_Tp.ActionIDForEdit AS ActionIDForEdit,
  I_Scbo_Action_Tp.Description AS Description,
  I_Scbo_Action_Tp.OrdinalNumber AS OrdinalNumber
FROM I_Scbo_Action_Tp
LEFT OUTER JOIN I_Scbo_Registry_C AS _Registry ON _Registry.BusinessObjectID = BusinessObjectID  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Nodes_C AS _Node ON _Node.NodeID = NodeID AND _Node.BusinessObjectID = BusinessObjectID  -- association [1..1]
;