I_CCV_DATASOURCE_HELPER

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 I_CCV_DATASOURCE_HELPER.
-- 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.

CREATE VIEW I_CCV_DATASOURCE_HELPER AS
SELECT
  cast(stob.strucobjn_raw as abap.char(30)) AS DataSourceName,
  cast(stob.strucobjn as abap.char(30)) AS DataSourceNameUpper,
  src.source_origin AS SourceOrigin,
  cast (case when _dcl_for_entity.dclname <> '' and _access_control .value = '#PRIVILEGED_ONLY' then '2' when _dcl_for_entity.dclname <> '' then '1' else '0' end as abap.char(1) ) as AccessProtection AS char1asAccessProtection,
  case when _object_category.value = '#TEXT' then 'X' end as TextViewIndicator AS valueTEXTthenXendasTextViewIndicator,
  cast (case when _analytics_category.value = '#CUBE' then '1' when _analytics_category.value = '#DIMENSION' then '2' end as abap.char(1) ) as AnalyticsDataCategory AS char1asAnalyticsDataCategory
FROM dd02b AS stob
INNER JOIN ddldependency AS dep ON /* join condition not captured in parsed metadata */
INNER JOIN ddddlsrc AS src ON /* join condition not captured in parsed metadata */
INNER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS rel_c1_grp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS _odata ON _odata.strucobjn = stob.strucobjn AND _odata.name = 'ODATA.PUBLISH'  -- association [0..1]
LEFT OUTER JOIN ddheadanno AS _analytics_category ON _analytics_category.strucobjn = stob.strucobjn AND _analytics_category.name = 'ANALYTICS.DATACATEGORY'  -- association [0..1]
LEFT OUTER JOIN ddheadanno AS _analytics_query ON _analytics_query.strucobjn = stob.strucobjn AND _analytics_query.name = 'ANALYTICS.QUERY'  -- association [0..1]
LEFT OUTER JOIN ddheadanno AS _access_control ON _access_control.strucobjn = stob.strucobjn AND _access_control.name = 'ACCESSCONTROL.AUTHORIZATIONCHECK'  -- association [0..1]
LEFT OUTER JOIN Sacm_Public_Dcl_For_Entity AS _dcl_for_entity ON _dcl_for_entity.entity = stob.strucobjn  -- association [0..1]
LEFT OUTER JOIN ddheadanno AS _object_category ON _object_category.strucobjn = stob.strucobjn AND _object_category.name = 'OBJECTMODEL.DATACATEGORY'  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewSourceOrigin AS _SourceOrigin ON _SourceOrigin.SourceOrigin = src.source_origin  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewAccProtection AS _AccessProtection ON _AccessProtection.AccessProtection = AccessProtection  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewAnaDataCategory AS _AnaDataCategory ON _AnaDataCategory.AnalyticsDatacategory = AnalyticsDataCategory  -- association [0..1]
;