I_DC_DATA_CTRL

DDL: I_DC_DATA_CTRL Type: view BASIC
6 Fields 1 Data Sources 2 Associations

Data Controller View

I_DC_DATA_CTRL is a Basic CDS View that provides data about "Data Controller View" in SAP S/4HANA. It reads from 1 data source (dcc_dc) and exposes 6 fields with key field DataCtrlName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
dcc_dc dcc_dc from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_DC_DATA_CTRL_DSCR _DSCR $projection.DataCtrlName = _DSCR.DataCtrlName
[0..*] I_DC_DATA_CTRL_TYPE_T _TYPE_TEXT $projection.DataCtrlType = _TYPE_TEXT.value

Annotations (9)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IDATACTRL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Data Controller View view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DataCtrlName data_ctrl_name Data Controller Name
DataCtrlDescription
DataCtrlType data_ctrl_type
DataCtrlTypeText
_DSCR _DSCR
_TYPE_TEXT _TYPE_TEXT

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_DC_DATA_CTRL.
-- 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_DC_DATA_CTRL AS
SELECT
  data_ctrl_name AS DataCtrlName,
  _DSCR[1: Language=$session.system_language].DataCtrlDescription AS DataCtrlDescription,
  data_ctrl_type AS DataCtrlType,
  _TYPE_TEXT[1: language=$session.system_language].text AS DataCtrlTypeText
FROM dcc_dc
LEFT OUTER JOIN I_DC_DATA_CTRL_DSCR AS _DSCR ON DataCtrlName = _DSCR.DataCtrlName  -- association [0..*]
LEFT OUTER JOIN I_DC_DATA_CTRL_TYPE_T AS _TYPE_TEXT ON DataCtrlType = _TYPE_TEXT.value  -- association [0..*]
;

Learn More