C_ControlClassByLanguage

DDL: C_CONTROLCLASSBYLANGUAGE SQL: CCTRLCLBYLANG Type: view CONSUMPTION
17 Fields 2 Data Sources 2 Associations

Control Class by Given Language

C_ControlClassByLanguage is a Consumption CDS View that provides data about "Control Class by Given Language" in SAP S/4HANA. It reads from 2 data sources (I_Language, I_ControlClass) and exposes 17 fields with key fields Language, TrdClassfctnNmbrSchmCntnt, ControlClass, ValidityStartDate. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Language _Language cross
I_ControlClass ControlClass from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TrdClassfctnNmbrOfclDescByLa _OfficialDescOnLanguage _OfficialDescOnLanguage.TrdClassfctnNmbrSchmCntnt = $projection.TrdClassfctnNmbrSchmCntnt and _OfficialDescOnLanguage.TrdClassfctnNmbr = $projection.ControlClass and _OfficialDescOnLanguage.ValidityStartDate = $projection.ValidityStartDate and _OfficialDescOnLanguage.Language = _Language.Language
[0..1] I_TrdClassfctnNmbrCoDescByLa _CnctntdDescOnLanguage _CnctntdDescOnLanguage.TrdClassfctnNmbrSchmCntnt = $projection.TrdClassfctnNmbrSchmCntnt and _CnctntdDescOnLanguage.TrdClassfctnNmbr = $projection.ControlClass and _CnctntdDescOnLanguage.ValidityStartDate = $projection.ValidityStartDate and _CnctntdDescOnLanguage.Language = _Language.Language

Annotations (14)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CCTRLCLBYLANG view
AbapCatalog.preserveKey true view
EndUserText.label Control Class by Given Language 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
Search.searchable true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Language I_Language Language Report Text Language
KEY TrdClassfctnNmbrSchmCntnt I_ControlClass TrdClassfctnNmbrSchmCntnt
KEY ControlClass ControlClass
KEY ValidityStartDate I_ControlClass ValidityStartDate Validity Start Date
ValidityEndDate I_ControlClass ValidityEndDate ValidTo
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_OfficialDescOnLanguage _OfficialDescOnLanguage
_CnctntdDescOnLanguage _CnctntdDescOnLanguage
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_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_ControlClassByLanguage.
-- 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: CCTRLCLBYLANG

CREATE VIEW C_ControlClassByLanguage AS
SELECT
  _Language.Language AS Language,
  ControlClass.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  ControlClass,
  ControlClass.ValidityStartDate AS ValidityStartDate,
  ControlClass.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_ControlClass AS ControlClass
CROSS JOIN I_Language AS _Language
LEFT OUTER JOIN I_TrdClassfctnNmbrOfclDescByLa AS _OfficialDescOnLanguage ON _OfficialDescOnLanguage.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _OfficialDescOnLanguage.TrdClassfctnNmbr = ControlClass AND _OfficialDescOnLanguage.ValidityStartDate = ValidityStartDate AND _OfficialDescOnLanguage.Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrCoDescByLa AS _CnctntdDescOnLanguage ON _CnctntdDescOnLanguage.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _CnctntdDescOnLanguage.TrdClassfctnNmbr = ControlClass AND _CnctntdDescOnLanguage.ValidityStartDate = ValidityStartDate AND _CnctntdDescOnLanguage.Language = _Language.Language  -- association [0..1]
;

Learn More