I_CCV_DataSource_VH_2

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_2.
-- 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_2 AS
SELECT
  header.entity_name AS entity_name,
  header.state AS state,
  header.entity_name_raw AS view_name,
  header.ddl_name AS ddl_name,
  header.label_text AS view_text,
  _Rework.HighestPriorityText AS TaskPriority,
  _Rework.HighestPrioritySortOrder AS TaskPrioritySortOrder,
  _Rework.ReworkIndicator AS ReworkIndicator,
  _Rework.Category AS Category,
  _Rework.CategoryText AS TaskCategory,
  _Rework._TaskPriority AS _TaskPriority,
  _Rework._TaskCategory AS _TaskCategory
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 ddheadanno AS transactionalProviderAnno ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomCDSViewSourceOrigin AS _SourceOrigin ON _SourceOrigin.SourceOrigin = header.source_origin  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewObjectStatus AS _ObjectStatus ON _ObjectStatus.ObjectStatus = ObjectStatus  -- association [0..1]
LEFT OUTER JOIN Sacm_Public_Dcl_For_Entity AS _dcl_for_entity ON _dcl_for_entity.entity = header.entity_name  -- 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 = header.ddl_name  -- association [0..1]
LEFT OUTER JOIN ddheadanno AS _objectmodel_datacategory ON _objectmodel_datacategory.strucobjn = header.entity_name AND _objectmodel_datacategory.name = 'OBJECTMODEL.DATACATEGORY'  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _label_text_active ON _label_text_active.ddlname = header.ddl_name AND _label_text_active.strucobjn = header.entity_name AND _label_text_active.as4local = header.state AND _label_text_active.ddlanguage = $session.system_language  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _label_text_english ON _label_text_english.ddlname = header.ddl_name AND _label_text_english.strucobjn = header.entity_name AND _label_text_english.as4local = header.state AND _label_text_english.ddlanguage = 'E'  -- association [0..1]
LEFT OUTER JOIN ddddlsrc02bt AS _label_text_original ON _label_text_original.ddlname = header.ddl_name AND _label_text_original.strucobjn = header.entity_name AND _label_text_original.as4local = header.state AND _label_text_original.ddlanguage = header.original_language  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewAnaDataCategory AS _AnaDataCategory ON _AnaDataCategory.AnalyticsDatacategory = analytics_datacategory  -- association [0..1]
;