I_Scbo_Published_Bo_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_Published_Bo_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_PUB_V

CREATE VIEW I_Scbo_Published_Bo_C AS
SELECT
  Active.BusinessObjectID AS BusinessObjectID,
  Active.ActiveBusinessObjectID AS ActiveBusinessObjectID,
  Active.Namespace AS Namespace,
  Active.Description AS Description,
  Active.DescriptionPlural AS DescriptionPlural,
  Active.ServiceGenerationIndicator AS ServiceGenerationIndicator,
  Active.ServiceUrl AS ServiceUrl,
  Active.UIGenerationIndicator AS UIGenerationIndicator,
  Active.UIUrl AS UIUrl,
  Active.SemanticObject AS SemanticObject,
  Active.SAPUI5ComponentID AS SAPUI5ComponentID,
  Active.LogicGenerationIndicator AS LogicGenerationIndicator,
  Active.BSPAppName AS BSPAppName,
  Active.IWSVName AS IWSVName,
  Active.IWSGName AS IWSGName,
  Active.SystemAdminDataGenInd AS SystemAdminDataGenInd,
  Active.ChangeDocGenInd AS ChangeDocGenInd,
  Active.ChangeDocumentObject AS ChangeDocumentObject,
  Active.AuthorizationCheckIndicator AS AuthorizationCheckIndicator,
  Active.ScenarioID AS ScenarioID,
  Active.PublishState AS PublishState,
  Active.LastGenerateTimestamp AS LastGenerateTimestamp,
  Active.Transported AS Transported,
  Active.OriginalLanguage AS OriginalLanguage,
  Active.OriginalRelease AS OriginalRelease,
  Active.CreatedAt AS CreatedAt,
  Active.CreatedBy AS CreatedBy,
  Active.LastChangedAt AS LastChangedAt,
  Active.LastChangedBy AS LastChangedBy,
  Active.CopiedBusinessObjectID AS CopiedBusinessObjectID,
  Active.TranslationPublishState AS TranslationPublishState,
  Active.DataExtractionType AS DataExtractionType,
  _DataExtractionText.description AS DataExtractionTypeDesc,
  _TranslationPublishStateText.description AS TranslationPublishStateDesc,
  _RootNode.AssociabilityIndicator AS AssociabilityIndicator
FROM I_Scbo AS Active
LEFT OUTER JOIN I_Scbo_Node_A_C AS _Node ON _Node.BusinessObjectID = BusinessObjectID  -- association [1..*]
LEFT OUTER JOIN I_Scbo_Node_A_C AS _RootNode ON _RootNode.BusinessObjectID = BusinessObjectID AND _RootNode.ParentNodeID = ''  -- association [1..1]
LEFT OUTER JOIN I_SCBO_TRANSLATION_C AS _Translation ON _Translation.BusinessObjectID = BusinessObjectID  -- association [0..*]
LEFT OUTER JOIN I_SCBO_TRA_LANGU_EXISTING_V AS _ExistingTranslationLangu ON _ExistingTranslationLangu.BusinessObjectID = BusinessObjectID  -- association [0..*]
LEFT OUTER JOIN I_SCBO_TRA_LANGUAGE_NEW_V AS _NewTranslationLangu ON _NewTranslationLangu.BusinessObjectID = BusinessObjectID  -- association [0..*]
LEFT OUTER JOIN I_SCBO_I18N_PUBLISH_STATE AS _TranslationPublishStateText ON _TranslationPublishStateText.code = TranslationPublishState AND _TranslationPublishStateText.language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_Scbo_User AS _CreateUser ON _CreateUser.name = CreatedBy  -- association [0..1]
LEFT OUTER JOIN P_Scbo_User AS _ChangeUser ON _ChangeUser.name = LastChangedBy  -- association [0..1]
LEFT OUTER JOIN P_Scbo_Language AS _OriginalLanguageText ON _OriginalLanguageText.sprsl = OriginalLanguage  -- association [0..1]
LEFT OUTER JOIN I_SCBO_DATA_EXTRACTION_TYPE AS _DataExtractionText ON _DataExtractionText.Code = DataExtractionType AND _DataExtractionText.language = $session.system_language  -- association [0..1]
;