I_CCV_DataSource_VH_1

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_VH_1.
-- 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_VH_1 AS
SELECT
  stob.strucobjn AS entity_name,
  stob.as4local AS state,
  stob.strucobjn_raw AS view_name,
  src.ddlname AS ddl_name,
  _Rework.HighestPriorityText AS TaskPriority,
  _Rework.HighestPrioritySortOrder AS TaskPrioritySortOrder,
  _Rework.ReworkIndicator AS ReworkIndicator,
  _Rework.CategoryText AS TaskCategory,
  _Rework.Category AS Category,
  _Rework._TaskPriority AS _TaskPriority,
  _Rework._TaskCategory AS _TaskCategory
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 dd02bnd AS node_info ON /* join condition not captured in parsed metadata */
INNER JOIN tadir 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 modelingDataSourceAnno ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddheadanno AS modelingAssocTargetAnno ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ddddlsrc02bt AS _label_text_active ON _label_text_active.ddlname = src.ddlname AND _label_text_active.strucobjn = stob.strucobjn AND _label_text_active.ddlanguage = $session.system_language AND _label_text_active.as4local = stob.as4local  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _label_text_english ON _label_text_english.ddlname = src.ddlname AND _label_text_english.strucobjn = stob.strucobjn AND _label_text_english.ddlanguage = 'E' AND _label_text_english.as4local = stob.as4local  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _label_text_original ON _label_text_original.ddlname = src.ddlname AND _label_text_original.strucobjn = stob.strucobjn AND _label_text_original.ddlanguage = tadir.masterlang AND _label_text_original.as4local = stob.as4local  -- association [0..1]
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_datacategory ON _analytics_datacategory.strucobjn = stob.strucobjn AND _analytics_datacategory.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 _objectmodel_datacategory ON _objectmodel_datacategory.strucobjn = stob.strucobjn AND _objectmodel_datacategory.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_CustomCDSViewObjectStatus AS _ObjectStatus ON _ObjectStatus.ObjectStatus = ObjectStatus  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewAccProtection AS _AccessProtection ON _AccessProtection.AccessProtection = access_protection  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewRework_KeyUpper AS _Rework ON _Rework.EntityName = src.ddlname  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewAnaDataCategory AS _AnaDataCategory ON _AnaDataCategory.AnalyticsDatacategory = analytics_datacategory  -- association [0..1]
;