I_Scbo_Bo_TP

DDL: I_SCBO_BO_TP SQL: I_SCBO_BO_TP_V Type: view Package: S_CBO_MODEL_DRAFT2
40 Fields 1 Data Sources 3 Associations

Custom Business Objects: Business Object

I_Scbo_Bo_TP is a CDS View that provides data about "Custom Business Objects: Business Object" in SAP S/4HANA. It reads from 1 data source (P_Scbo_A) and exposes 40 fields with key field BusinessObjectID. It has 3 associations to related views. Part of development package S_CBO_MODEL_DRAFT2.

Data Sources (1)

SourceAliasJoin Type
P_Scbo_A P_Scbo_A from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Scbo_Registry_Tp _Registry _Registry.BusinessObjectID = $projection.BusinessObjectID
[0..*] I_Scbo_Node_TP _Node _Node.BusinessObjectID = $projection.BusinessObjectID
[0..1] P_Scbo_Node_A _RootNode _RootNode.BusinessObjectID = $projection.BusinessObjectID and _RootNode.ParentNodeID = ''

Annotations (9)

NameValueLevelField
EndUserText.label Custom Business Objects: Business Object view
AbapCatalog.sqlViewName I_SCBO_BO_TP_V view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #CLIENT_INDEPENDENT view
ObjectModel.writeDraftPersistence SCBO_OBJECT_D2 view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.entityChangeStateId LastChangedAt view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectID P_Scbo_A BusinessObjectID Business Object ID
ActiveBusinessObjectID P_Scbo_A ActiveBusinessObjectID Business Object ID
Namespace P_Scbo_A Namespace Parameter Namespace
Description P_Scbo_A Description Well Code Des.
DescriptionPlural P_Scbo_A DescriptionPlural Description Plural
ServiceGenerationIndicator P_Scbo_A ServiceGenerationIndicator Service Generation
ServiceUrl P_Scbo_A ServiceUrl Service URL
UIGenerationIndicator P_Scbo_A UIGenerationIndicator UI Generation
UIUrl P_Scbo_A UIUrl UI URL
LogicGenerationIndicator P_Scbo_A LogicGenerationIndicator Logic Generation
BSPAppName P_Scbo_A BSPAppName BSP App Name
IWSVName P_Scbo_A IWSVName Service Implement.
IWSGName P_Scbo_A IWSGName Service
ChangeDocumentObject P_Scbo_A ChangeDocumentObject
AuthorizationObject P_Scbo_A AuthorizationObject
ILMObject P_Scbo_A ILMObject
DestructionObject P_Scbo_A DestructionObject
DestructionProgram P_Scbo_A DestructionProgram
CopiedBusinessObjectID P_Scbo_A CopiedBusinessObjectID
SystemAdminDataGenInd P_Scbo_A SystemAdminDataGenInd SAD Generation
ChangeDocGenInd P_Scbo_A ChangeDocGenInd
AuthorizationCheckIndicator P_Scbo_A AuthorizationCheckIndicator
AssociabilityIndicator _RootNode AssociabilityIndicator Is Associable
PublishState P_Scbo_A PublishState Publish State
TranslationPublishState P_Scbo_A TranslationPublishState
LastGenerateTimestamp P_Scbo_A LastGenerateTimestamp Time Stamp
Transported P_Scbo_A Transported Truth Value
OriginalLanguage P_Scbo_A OriginalLanguage Original Language
OriginalRelease P_Scbo_A OriginalRelease Release
CreatedAt P_Scbo_A CreatedAt Created at
CreatedBy P_Scbo_A CreatedBy Created by
LastChangedAt P_Scbo_A LastChangedAt Time Stamp
LastChangedBy P_Scbo_A LastChangedBy User Name
DataExtractionType P_Scbo_A DataExtractionType
ScenarioID P_Scbo_A ScenarioID
ScenarioIDForEdit P_Scbo_A ScenarioID
SemanticObject P_Scbo_A SemanticObject Semantic Object
SAPUI5ComponentID P_Scbo_A SAPUI5ComponentID
_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_Bo_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_BO_TP_V

CREATE VIEW I_Scbo_Bo_TP AS
SELECT
  P_Scbo_A.BusinessObjectID AS BusinessObjectID,
  P_Scbo_A.ActiveBusinessObjectID AS ActiveBusinessObjectID,
  P_Scbo_A.Namespace AS Namespace,
  P_Scbo_A.Description AS Description,
  P_Scbo_A.DescriptionPlural AS DescriptionPlural,
  P_Scbo_A.ServiceGenerationIndicator AS ServiceGenerationIndicator,
  P_Scbo_A.ServiceUrl AS ServiceUrl,
  P_Scbo_A.UIGenerationIndicator AS UIGenerationIndicator,
  P_Scbo_A.UIUrl AS UIUrl,
  P_Scbo_A.LogicGenerationIndicator AS LogicGenerationIndicator,
  P_Scbo_A.BSPAppName AS BSPAppName,
  P_Scbo_A.IWSVName AS IWSVName,
  P_Scbo_A.IWSGName AS IWSGName,
  P_Scbo_A.ChangeDocumentObject AS ChangeDocumentObject,
  P_Scbo_A.AuthorizationObject AS AuthorizationObject,
  P_Scbo_A.ILMObject AS ILMObject,
  P_Scbo_A.DestructionObject AS DestructionObject,
  P_Scbo_A.DestructionProgram AS DestructionProgram,
  P_Scbo_A.CopiedBusinessObjectID AS CopiedBusinessObjectID,
  P_Scbo_A.SystemAdminDataGenInd AS SystemAdminDataGenInd,
  P_Scbo_A.ChangeDocGenInd AS ChangeDocGenInd,
  P_Scbo_A.AuthorizationCheckIndicator AS AuthorizationCheckIndicator,
  _RootNode.AssociabilityIndicator AS AssociabilityIndicator,
  P_Scbo_A.PublishState AS PublishState,
  P_Scbo_A.TranslationPublishState AS TranslationPublishState,
  P_Scbo_A.LastGenerateTimestamp AS LastGenerateTimestamp,
  P_Scbo_A.Transported AS Transported,
  P_Scbo_A.OriginalLanguage AS OriginalLanguage,
  P_Scbo_A.OriginalRelease AS OriginalRelease,
  P_Scbo_A.CreatedAt AS CreatedAt,
  P_Scbo_A.CreatedBy AS CreatedBy,
  P_Scbo_A.LastChangedAt AS LastChangedAt,
  P_Scbo_A.LastChangedBy AS LastChangedBy,
  P_Scbo_A.DataExtractionType AS DataExtractionType,
  P_Scbo_A.ScenarioID AS ScenarioID,
  P_Scbo_A.ScenarioID AS ScenarioIDForEdit,
  P_Scbo_A.SemanticObject AS SemanticObject,
  P_Scbo_A.SAPUI5ComponentID AS SAPUI5ComponentID
FROM P_Scbo_A
LEFT OUTER JOIN I_Scbo_Registry_Tp AS _Registry ON _Registry.BusinessObjectID = BusinessObjectID  -- association [1..1]
LEFT OUTER JOIN I_Scbo_Node_TP AS _Node ON _Node.BusinessObjectID = BusinessObjectID  -- association [0..*]
LEFT OUTER JOIN P_Scbo_Node_A AS _RootNode ON _RootNode.BusinessObjectID = BusinessObjectID AND _RootNode.ParentNodeID = ''  -- association [0..1]
;

Learn More