VB_CORE_CDS_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_CORE_CDS_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: VBCORECDSVIEWCE

CREATE VIEW VB_CORE_CDS_VIEWS_CE AS
SELECT
  Core_CDSViews.DDLSourceName AS DDLSourceName,
  dd02b.strucobjn_raw AS DDLSourceNameText,
  CDSDescription.ddtext AS DefaultText,
  CDSViewText.ddtext AS DDLSourceText,
  Core_CDSViews.SQLViewName AS SQLViewName,
  Core_CDSViews.CDSName AS CDSName,
  cast( Core_CDSViews.CDSOriginKey as abap.char( 10 )) AS CDSOriginKey,
  Core_CDSViews.SourceType AS SourceType,
  CDSPkgAppComp.ApplicationComponent AS ApplicationComponent,
  CDSPkgAppComp.ApplicationComponentName AS ApplicationComponentName,
  CDSPkgAppComp.CDSViewPackage AS CDSViewPackage,
  CDSPkgAppComp.CDSViewSourceSystem AS CDSViewSourceSystem,
  VdmType.CdsViewType AS CdsViewType,
  Core_CDSViews.CDSViewStatus AS CDSViewStatus,
  Core_CDSViews.CDSViewStatusCloud AS CDSViewStatusCloud,
  CDSAnalyticType.CDSViewCategory AS CDSViewCategory,
  Core_CDSViews.IsDraft AS IsDraft,
  Core_CDSViews.DraftDDLSourceName AS DraftDDLSourceName,
  _CdsFavorite.DDLSourceIsFavorite AS DDLSourceIsFavorite,
  _AnalyticalQueryPublished[app_type = 0].app_id AS AppID,
  _AnalyticalQueryPublished[app_type = 1].app_id AS WDAppID
FROM VB_ALL_VIEWS_CE AS Core_CDSViews
LEFT OUTER JOIN vdm_browsertag AS _CdsViewUserTag ON DDLSourceName = _CdsViewUserTag.ddlsourcename AND _CdsViewUserTag.username = $session.user  -- association [0..*]
LEFT OUTER JOIN Cds_View_Parameter AS _CdsViewParameter ON CDSName = _CdsViewParameter.CDSName  -- association [0..*]
LEFT OUTER JOIN Vb_Core_Cds_Definition AS _CdsDefinition ON CDSName = _CdsDefinition.SQLViewName  -- association [1..*]
LEFT OUTER JOIN Vb_Core_Cds_Annotation AS _CdsViewAnnotation ON CDSName = _CdsViewAnnotation.CDSName  -- association [0..*]
LEFT OUTER JOIN VB_CDS_CROSSREFERENCE AS _CdsViewCrossreference ON CDSName = _CdsViewCrossreference.ObjectDDLSourceName  -- association [1..*]
LEFT OUTER JOIN Cds_Editors_Text AS _EditorText ON CDSOriginKey = _EditorText.CDSOrigin AND _EditorText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN report_chips AS _AnalyticalQueryPublished ON DDLSourceName = _AnalyticalQueryPublished.ddlsourcename  -- association [0..*]
LEFT OUTER JOIN CDS_ALL_SUPPORTED_CAPABILITIES AS _CdsSupportedCapabilities ON DDLSourceName = _CdsSupportedCapabilities.Ddlsourcename  -- association [0..*]
LEFT OUTER JOIN Cds_Views_Favorite AS _CdsFavorite ON DDLSourceName = _CdsFavorite.DDLSourceName  -- association [0..1]
;