I_ControlClassCntntVersDetail

DDL: I_CONTROLCLASSCNTNTVERSDETAIL SQL: ICTRLCLVERD Type: view COMPOSITE Package: VDM_SLL_CLS
13 Fields 2 Data Sources 2 Associations

Control Class Content Version Detail

I_ControlClassCntntVersDetail is a Composite CDS View that provides data about "Control Class Content Version Detail" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnCntntNmbr, I_TrdClassfctnCntntVersionLang) and exposes 13 fields with key fields TrdClassfctnNmbrUUID, Language. It has 2 associations to related views. Part of development package VDM_SLL_CLS.

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnCntntNmbr _ControlClass from
I_TrdClassfctnCntntVersionLang _Language cross

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_TrdClsfctnCntntNmbrOfclDesc _OfficialDesc _ControlClass.TrdClassfctnNmbr = _OfficialDesc.TrdClassfctnNmbr and _ControlClass.TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt and _ControlClass.TrdClassfctnCntntVersion = _OfficialDesc.TrdClassfctnCntntVersion and _ControlClass.ValidityStartDate = _OfficialDesc.ValidityStartDate and _Language.Language = _OfficialDesc.Language
[0..1] I_TrdClsfctnCntntNmbrCoDesc _CnctntdDesc _ControlClass.TrdClassfctnNmbr = _CnctntdDesc.TrdClassfctnNmbr and _ControlClass.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt and _ControlClass.TrdClassfctnCntntVersion = _CnctntdDesc.TrdClassfctnCntntVersion and _ControlClass.ValidityStartDate = _CnctntdDesc.ValidityStartDate and _Language.Language = _CnctntdDesc.Language

Annotations (9)

NameValueLevelField
EndUserText.label Control Class Content Version Detail view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICTRLCLVERD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TrdClassfctnNmbrUUID I_TrdClassfctnCntntNmbr TrdClassfctnNmbrUUID UUID
KEY Language I_TrdClassfctnCntntVersionLang Language Report Text Language
TrdClassfctnCntntUUID I_TrdClassfctnCntntNmbr TrdClassfctnCntntUUID UUID
ControlClass
TrdClassfctnCntntVersUUID I_TrdClassfctnCntntNmbr TrdClassfctnCntntVersUUID UUID
TrdClassfctnNmbrSchmCntnt I_TrdClassfctnCntntNmbr TrdClassfctnNmbrSchmCntnt No. Scheme Content
TrdClassfctnCntntVersion I_TrdClassfctnCntntNmbr TrdClassfctnCntntVersion Version
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbr Number
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbr Number
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc

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_ControlClassCntntVersDetail.
-- 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: ICTRLCLVERD

CREATE VIEW I_ControlClassCntntVersDetail AS
SELECT
  _ControlClass.TrdClassfctnNmbrUUID AS TrdClassfctnNmbrUUID,
  _Language.Language AS Language,
  _ControlClass.TrdClassfctnCntntUUID AS TrdClassfctnCntntUUID,
  cast ( _ControlClass.TrdClassfctnNmbr as /sapsll/concl) AS ControlClass,
  _ControlClass.TrdClassfctnCntntVersUUID AS TrdClassfctnCntntVersUUID,
  _ControlClass.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  _ControlClass.TrdClassfctnCntntVersion AS TrdClassfctnCntntVersion,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbr AS TrdClassfctnNmbrForCnctntdDesc,
  ValidityStartDate,
  ValidityEndDate
FROM I_TrdClassfctnCntntNmbr AS _ControlClass
CROSS JOIN I_TrdClassfctnCntntVersionLang AS _Language
LEFT OUTER JOIN I_TrdClsfctnCntntNmbrOfclDesc AS _OfficialDesc ON _ControlClass.TrdClassfctnNmbr = _OfficialDesc.TrdClassfctnNmbr AND _ControlClass.TrdClassfctnNmbrSchmCntnt = _OfficialDesc.TrdClassfctnNmbrSchmCntnt AND _ControlClass.TrdClassfctnCntntVersion = _OfficialDesc.TrdClassfctnCntntVersion AND _ControlClass.ValidityStartDate = _OfficialDesc.ValidityStartDate AND _Language.Language = _OfficialDesc.Language  -- association [0..1]
LEFT OUTER JOIN I_TrdClsfctnCntntNmbrCoDesc AS _CnctntdDesc ON _ControlClass.TrdClassfctnNmbr = _CnctntdDesc.TrdClassfctnNmbr AND _ControlClass.TrdClassfctnNmbrSchmCntnt = _CnctntdDesc.TrdClassfctnNmbrSchmCntnt AND _ControlClass.TrdClassfctnCntntVersion = _CnctntdDesc.TrdClassfctnCntntVersion AND _ControlClass.ValidityStartDate = _CnctntdDesc.ValidityStartDate AND _Language.Language = _CnctntdDesc.Language  -- association [0..1]
;

Learn More