VB_ALL_VIEWS_CE

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 VB_ALL_VIEWS_CE.
-- 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: VBALLVIEWSCE

CREATE VIEW VB_ALL_VIEWS_CE AS
SELECT
  _draft.ItemId AS DDLSourceName,
  Cds_View_Info.CDSOriginKey AS CDSOriginKey,
  Cds_View_Info.SQLViewName AS SQLViewName,
  Cds_View_Info.CDSName AS CDSName,
  Cds_View_Info.SourceType AS SourceType,
  cast (_draft.CDSViewStatus as ars_release_state) AS CDSViewStatus,
  cast (' ' as ars_release_state ) AS CDSViewStatusCloud,
  _draft.is_draft AS IsDraft,
  case when Cds_Release_Status.use_in_key_user_apps = 'X' then Cds_Release_Status.state end as CDSViewStatus AS stateendasCDSViewStatus,
  case when Cds_Release_Status.use_in_cloud_development = 'X' then Cds_Release_Status.state end as CDSViewStatusCloud AS stateendasCDSViewStatusCloud,
  _status.Ddlname AS DraftDDLSourceName
FROM VB_DRAFT_OR_PUBLISH_VIEWS AS _draft
INNER JOIN VB_PUBLIC_CDS_VIEWS_CE AS Cds_View_Info ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VB_ATOV_U_ITEM_BOM_BASE AS _atov_status ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): VB_PUBLIC_CDS_VIEWS_CE, VB_DRAFT_PUBLISH_STATUS_VIEWS
;