VB_CDS_QUERY_VIEWS

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_CDS_QUERY_VIEWS.
-- 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: VBQUERYCDS

CREATE VIEW VB_CDS_QUERY_VIEWS AS
SELECT
  Core_CDSViews.DDLSourceName AS DDLSourceName,
  Core_CDSViews.CDSName AS CDSName,
  Core_CDSViews.SQLViewName AS SQLViewName,
  Core_CDSViews.DDLSourceNameText AS DDLSourceNameText,
  Core_CDSViews.DefaultText AS DefaultText,
  Core_CDSViews.DDLSourceText AS DDLSourceText,
  Core_CDSViews.CDSViewPackage AS CDSViewPackage,
  case when SourceType = 'P' then 'true' else Core_CDSViews.CDSViewCategory end as CDSViewCategory AS CDSViewCategoryendasCDSViewCategory,
  Core_CDSViews.CdsViewType AS CdsViewType,
  Core_CDSViews.ApplicationComponentName AS ApplicationComponentName,
  Core_CDSViews.CDSOriginKey AS CDSOriginKey,
  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,
  Core_CDSViews._EditorText[Language = $session.system_language].ddtext AS CDSOrigin,
  Core_CDSViews._CdsFavorite.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  Core_CDSViews._CdsViewUserTag AS _CdsViewUserTag,
  Core_CDSViews._CdsDefinition AS _CdsDefinition,
  Core_CDSViews._CdsViewCrossreference AS _CdsViewCrossreference,
  Core_CDSViews._CdsViewAnnotation AS _CdsViewAnnotation,
  Core_CDSViews.CDSViewSourceSystem AS CDSViewSourceSystem,
  Core_CDSViews._CdsSupportedCapabilities AS _CdsSupportedCapabilities,
  Core_CDSViews.SourceType AS SourceType
FROM VB_CORE_CDS_VIEWS AS Core_CDSViews
;