I_ControlClass

DDL: I_CONTROLCLASS SQL: ICTRLCL Type: view COMPOSITE Package: VDM_SLL_CLS
15 Fields 1 Data Sources 2 Associations

Control Class

I_ControlClass is a Composite CDS View that provides data about "Control Class" in SAP S/4HANA. It reads from 1 data source (I_TrdClassfctnNmbr) and exposes 15 fields with key fields TrdClassfctnNmbrSchmCntnt, ControlClass, ValidityStartDate. It has 2 associations to related views. Part of development package VDM_SLL_CLS.

Data Sources (1)

SourceAliasJoin Type
I_TrdClassfctnNmbr _TrdClassfctnNmbr from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_TrdClassfctnNmbrOfficialDesc _OfficialDesc $projection.TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt and $projection.ControlClass = _OfficialDesc.TrdClassfctnNmbr and $projection.ValidityStartDate = _OfficialDesc.ValidityStartDate
[0..*] I_TrdClassfctnNmbrCnctntdDesc _CnctntdDesc $projection.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt and $projection.ControlClass = _CnctntdDesc.TrdClassfctnNmbr and $projection.ValidityStartDate = _CnctntdDesc.ValidityStartDate

Annotations (10)

NameValueLevelField
EndUserText.label Control Class view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICTRLCL view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ControlClass view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrSchmCntnt I_TrdClassfctnNmbr TrdClassfctnNmbrSchmCntnt No. Scheme Content
KEY ControlClass Number
KEY ValidityStartDate ValidityStartDate Validity Start Date
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbr Number
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbr Number
ValidityEndDate ValidityEndDate ValidTo
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_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 I_ControlClass.
-- 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: ICTRLCL

CREATE VIEW I_ControlClass AS
SELECT
  _TrdClassfctnNmbr.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  cast ( TrdClassfctnNmbr as /sapsll/concl) AS ControlClass,
  ValidityStartDate,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForCnctntdDesc,
  ValidityEndDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_TrdClassfctnNmbr AS _TrdClassfctnNmbr
LEFT OUTER JOIN I_TrdClassfctnNmbrOfficialDesc AS _OfficialDesc ON TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt AND ControlClass = _OfficialDesc.TrdClassfctnNmbr AND ValidityStartDate = _OfficialDesc.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN I_TrdClassfctnNmbrCnctntdDesc AS _CnctntdDesc ON TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt AND ControlClass = _CnctntdDesc.TrdClassfctnNmbr AND ValidityStartDate = _CnctntdDesc.ValidityStartDate  -- association [0..*]
;

Learn More