P_Scbo_U

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 P_Scbo_U.
-- 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: P_SCBO_U_V

CREATE VIEW P_Scbo_U AS
SELECT
  cast( hextobin('00000000000000000000000000000000') as sdraft_key ) AS BusinessObjectDraftUUID,
  Active.BusinessObjectID AS ActiveBusinessObjectID,
  case when( Active.ActiveBusinessObjectID <> '' ) then Active.ActiveBusinessObjectID else Active.BusinessObjectID end as BusinessObjectID AS BusinessObjectIDendasBusinessObjectID,
  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.LogicGenerationIndicator AS LogicGenerationIndicator,
  Active.BSPAppName AS BSPAppName,
  Active.IWSVName AS IWSVName,
  Active.IWSGName AS IWSGName,
  Active.SystemAdminDataGenInd AS SystemAdminDataGenInd,
  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,
  cast( 'X' as boole_d ) AS IsActiveEntity,
  cast( ' ' as boole_d ) AS HasActiveEntity,
  Draft.businessobjectid AS BusinessObjectID,
  cast( ' ' as boole_d ) AS HasDraftEntity,
  Draft.businessobjectdraftuuid AS DraftAdministrativeDataUUID
FROM I_Scbo AS Active
LEFT OUTER JOIN scbo_object_d AS Draft ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): scbo_object_d
;