C_CustomCDSViewDataSource

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 C_CustomCDSViewDataSource.
-- 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: APS_CCV_C_DSRC_V

CREATE VIEW C_CustomCDSViewDataSource AS
SELECT
  entity_name AS EntityName,
  data_source_uuid AS DataSourceUUID,
  data_source_alias AS DataSourceAlias,
  Counter,
  data_source_name AS DataSourceName,
  Type,
  Cardinality,
  join_cond_comparison_operator AS JoinCondComparisonOperator,
  _Root.Scenario AS Scenario,
  _Root._Scenario AS _Scenario,
  _DataSource.SourceOrigin AS SourceOrigin,
  _DataSource._SourceOrigin AS _SourceOrigin,
  _DataSource.AccessProtection AS AccessProtection,
  _DataSource._AccessProtection AS _AccessProtection,
  _DataSource.AnalyticsDataCategory AS AnalyticsDataCategory,
  _DataSource._AnaDataCategory AS _AnaDataCategory,
  _DataSource.TextViewIndicator AS TextViewIndicator,
  _DataSource.MasterdataViewIndicator AS MasterdataViewIndicator,
  _Rework.HighestPriority AS TaskPriorityId,
  _Rework.HighestPriorityText AS TaskPriority,
  _Rework.HighestPrioritySortOrder AS TaskPrioritySortOrder,
  cast( _Rework.ReworkIndicator as aps_ccv_rework_ind preserving type ) AS ReworkIndicator,
  _Rework.CategoryText AS ReworkCategoryText,
  _Rework.ItemId AS ReworkItemId,
  _Rework.ItemType AS ReworkItemType,
  _Rework._TaskPriority AS _TaskPriority,
  _AtoBomDataSource.ItemId AS AtoItemId,
  _AtoBomDataSource.ItemType AS AtoItemType,
  cast( ' ' as abap.sstring( 100 ) ) AS ObjectStatusText,
  cast( ' ' as abap.sstring( 10 ) ) AS ObjectStatus,
  ' ' AS CDBStatusCode,
  cast( ' ' as boolean preserving type ) AS JoinCondition_fc,
  cast( ' ' as boolean preserving type ) AS ParameterValue_fc
FROM I_CustomCDSViewDataSource
LEFT OUTER JOIN C_CustomCDSViewRoot AS _Root ON _Root.EntityName = I_CustomCDSViewDataSource.entity_name  -- association [1..1]
LEFT OUTER JOIN C_CustomCDSViewDSJoinCondition AS _JoinCondition ON _JoinCondition.EntityName = I_CustomCDSViewDataSource.entity_name AND _JoinCondition.DataSourceUUID = I_CustomCDSViewDataSource.data_source_uuid  -- association [0..*]
LEFT OUTER JOIN C_CustomCDSViewParameterValue AS _ParameterValue ON _ParameterValue.EntityName = I_CustomCDSViewDataSource.entity_name AND _ParameterValue.DataSourceUUID = I_CustomCDSViewDataSource.data_source_uuid  -- association [0..*]
LEFT OUTER JOIN I_CustomCDSViewDatasourceType AS _DatasourceType ON _DatasourceType.DataSourceType = I_CustomCDSViewDataSource.type  -- association [0..1]
LEFT OUTER JOIN I_CCV_DATASOURCE_HELPER AS _DataSource ON _DataSource.DataSourceName = I_CustomCDSViewDataSource.data_source_name  -- association [0..1]
LEFT OUTER JOIN I_CustomCDSViewRework AS _Rework ON _Rework.EntityName = I_CustomCDSViewDataSource.data_source_name  -- association [0..1]
LEFT OUTER JOIN I_CCV_ATO_BOM_DS AS _AtoBomDataSource ON _AtoBomDataSource.EntityName = I_CustomCDSViewDataSource.data_source_name  -- association [0..1]
;