C_ControlGroupingByLanguage

DDL: C_CONTROLGROUPINGBYLANGUAGE SQL: CCTRLGRPGLANG Type: view CONSUMPTION
12 Fields 2 Data Sources 1 Associations

C_ControlGroupingByLanguage is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_Language, I_ControlGrouping) and exposes 12 fields with key fields LegalRegulation, ControlGrouping, Language. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_Language _LanguageJoin cross
I_ControlGrouping ControlGrouping from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ControlGroupingTextByLang _Text _Text.LegalRegulation = ControlGrouping.LegalRegulation and _Text.ControlGrouping = ControlGrouping.ControlGrouping and _Text.Language = _LanguageJoin.Language

Annotations (17)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CCTRLGRPGLANG view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.typeName Control Grouping view
UI.headerInfo.typeNamePlural Control Groupings view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value ControlGrouping view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value TEXT: LegalRegulation view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LegalRegulation I_ControlGrouping LegalRegulation Legal Regulation
KEY ControlGrouping I_ControlGrouping ControlGrouping Control Grouping
KEY Language I_Language Language Report Text Language
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_LegalRegulation I_ControlGrouping _LegalRegulation
_LegalRegulationText I_ControlGrouping _LegalRegulationText
_Text _Text
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_ControlGroupingByLanguage.
-- 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: CCTRLGRPGLANG

CREATE VIEW C_ControlGroupingByLanguage AS
SELECT
  ControlGrouping.LegalRegulation AS LegalRegulation,
  ControlGrouping.ControlGrouping AS ControlGrouping,
  _LanguageJoin.Language AS Language,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ControlGrouping._LegalRegulation AS _LegalRegulation,
  ControlGrouping._LegalRegulationText AS _LegalRegulationText
FROM I_ControlGrouping AS ControlGrouping
CROSS JOIN I_Language AS _LanguageJoin
LEFT OUTER JOIN I_ControlGroupingTextByLang AS _Text ON _Text.LegalRegulation = ControlGrouping.LegalRegulation AND _Text.ControlGrouping = ControlGrouping.ControlGrouping AND _Text.Language = _LanguageJoin.Language  -- association [0..1]
;

Learn More