Vb_Core_Cdsviews

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_Cdsviews.
-- 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: VBCORECDSVIEWS

CREATE VIEW Vb_Core_Cdsviews AS
SELECT
  Cds_Views_Info.DDLSourceName AS DDLSourceName,
  coalesce( dd02b.strucobjn_raw, Cds_Views_Info.DDLSourceName ) AS DDLSourceNameText,
  Cds_Views_Info.SQLViewName AS SQLViewName,
  Cds_Views_Info.CDSName AS CDSName,
  cast( Cds_Views_Info.CdsViewType as vdmviewtype ) AS CdsViewType,
  Cds_Views_Info.ApplicationComponent AS ApplicationComponent,
  Cds_Views_Info.ApplicationComponentName AS ApplicationComponentName,
  Cds_Views_Info.CDSViewPackage AS CDSViewPackage,
  Cds_Views_Info.CDSViewSourceSystem AS CDSViewSourceSystem,
  case when CDSAnalyticType.AnnotationValue = 'true' then 'QUERY' when CDSDataCategory.AnnotationValue = '#DIMENSION' then 'DIMENSION' when CDSDataCategory.AnnotationValue = '#CUBE' then 'CUBE' when CDSDataCategory.AnnotationValue = '#TEXT' then 'TEXT' when CDSDataCategory.AnnotationValue = '#FACT' then 'FACT' when CDSDataCategory.AnnotationValue = '#AGGREGATIONLEVEL' then 'AGGREGATIONLEVEL' when CDSDataCategory.AnnotationValue = '#HIERARCHY' then 'HIERARCHY' else CDSDataCategory.AnnotationValue end as CDSViewCategory AS AnnotationValueendasCDSViewCategory,
  cast(Cds_Views_Info.CDSOriginKey as abap.char( 10 )) AS CDSOriginKey,
  SupportCapabilities.SupportedCapability AS SupportedCapability,
  SupportCapabilities.NumberOfCapabilities AS NumberOfCapabilities,
  CDSModelingPattern.AnnotationValue AS ModelingPattern,
  Cds_Views_Info._CdsSupportedCapabilities AS _CdsSupportedCapabilities,
  Cds_Views_Info._CDSAppCompText AS _CDSAppCompText,
  Cds_Views_Info._CdsFavorite AS _CdsFavorite,
  Cds_Views_Info._CdsTagCount AS _CdsTagCount,
  Cds_Views_Info._Text AS _Text,
  Cds_Views_Info.SourceType AS SourceType
FROM Cds_Views_Info
LEFT OUTER JOIN Cds_View_Annotation_Position AS CDSAnalyticType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_View_Annotation_Position AS CDSDataCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_View_Annotation_Position AS CDSPrivate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS Cds_Release_Status ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02b ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN CDS_SUPPORTED_CAPABILITIES AS SupportCapabilities ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_View_Annotation_Position AS CDSModelingPattern ON /* join condition not captured in parsed metadata */
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..*]
;