I_Scbo

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.
-- 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_V

CREATE VIEW I_Scbo AS
SELECT
  BusinessObject.business_object_id AS BusinessObjectID,
  BusinessObject.version_number AS VersionNumber,
  BusinessObject.namespace AS Namespace,
  BusinessObject.description AS Description,
  BusinessObject.description_plural AS DescriptionPlural,
  BusinessObject.scenario_id AS ScenarioID,
  BusinessObject.service_generation_indicator AS ServiceGenerationIndicator,
  BusinessObject.service_url AS ServiceUrl,
  BusinessObject.ui_generation_indicator AS UIGenerationIndicator,
  BusinessObject.ui_url AS UIUrl,
  BusinessObject.logic_generation_indicator AS LogicGenerationIndicator,
  BusinessObject.bsp_app_name AS BSPAppName,
  BusinessObject.iwsv_name AS IWSVName,
  BusinessObject.iwsg_name AS IWSGName,
  BusinessObject.system_admin_data_gen_ind AS SystemAdminDataGenInd,
  BusinessObject.change_document_object AS ChangeDocumentObject,
  BusinessObject.changedoc_generation_indicator AS ChangeDocGenInd,
  BusinessObject.authorization_object AS AuthorizationObject,
  BusinessObject.authorization_check_indicator AS AuthorizationCheckIndicator,
  BusinessObject.ilm_object AS ILMObject,
  BusinessObject.destruction_object AS DestructionObject,
  BusinessObject.destruction_program AS DestructionProgram,
  BusinessObject.active_business_object_id AS ActiveBusinessObjectID,
  BusinessObject.copied_business_object_id AS CopiedBusinessObjectID,
  case when BusinessObject.publish_state = 'S' and (System.release_number is null or System.is_current != 'X') then cast( 'SO' as scbo_publish_state ) else BusinessObject.publish_state end as PublishState AS publish_stateendasPublishState,
  BusinessObject.last_generate_tstmp AS LastGenerateTimestamp,
  BusinessObject.original_language AS OriginalLanguage,
  _LanguageText.sptxt AS OriginalLanguageText,
  BusinessObject.original_release AS OriginalRelease,
  BusinessObject.transported AS Transported,
  BusinessObject.created_at AS CreatedAt,
  BusinessObject.created_by AS CreatedBy,
  _CreateUser.description AS CreatedByName,
  BusinessObject.last_changed_at AS LastChangedAt,
  BusinessObject.last_changed_by AS LastChangedBy,
  _ChangeUser.description AS LastChangedByName,
  BusinessObject.translation_publish_state AS TranslationPublishState,
  BusinessObject.data_extraction_type AS DataExtractionType,
  BusinessObject.semantic_object AS SemanticObject,
  BusinessObject.sapui5_component_id AS SAPUI5ComponentID
FROM scbo_object 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 scbo_system AS System ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Scbo_Node AS _Node ON _Node.BusinessObjectID = BusinessObjectID AND _Node.VersionNumber = VersionNumber  -- association [0..*]
LEFT OUTER JOIN I_Scbo_Node AS _RootNode ON _RootNode.BusinessObjectID = BusinessObjectID AND _RootNode.VersionNumber = VersionNumber AND _RootNode.ParentNodeID = ''  -- association [0..*]
LEFT OUTER JOIN t002t AS _LanguageText ON _LanguageText.spras = $session.system_language AND _LanguageText.sprsl = OriginalLanguage  -- association [0..1]
;