I_ControlClassForKeyDate

DDL: I_CONTROLCLASSFORKEYDATE SQL: ICTRLCLFORKDATE Type: view COMPOSITE

Control Class for Key Date

I_ControlClassForKeyDate is a Composite CDS View that provides data about "Control Class for Key Date" in SAP S/4HANA. It reads from 2 data sources (I_TrdClassfctnNmbrSchmCntntAct, I_ControlClass) and exposes 12 fields with key fields LegalRegulation, ControlClass. It has 1 association to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchmCntntAct inner
I_ControlClass ControlClass from

Parameters (1)

NameTypeDefault
P_KeyDate sll_validon

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TrdClassfctnLglRgln _LegalRegulation _LegalRegulation.LegalRegulation = $projection.legalregulation and _LegalRegulation.CtrlClNmbrSchm = _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm

Annotations (10)

NameValueLevelField
EndUserText.label Control Class for Key Date view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICTRLCLFORKDATE 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 (12)

KeyFieldSource TableSource FieldDescription
KEY LegalRegulation _LegalRegulation LegalRegulation
KEY ControlClass ControlClass
TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct TrdClassfctnNmbrSchm
TrdClassfctnNmbrSchmCntnt I_ControlClass TrdClassfctnNmbrSchmCntnt
ValidityStartDate I_ControlClass ValidityStartDate
ValidityEndDate I_ControlClass ValidityEndDate
TrdClassfctnNmbrForOfclDesc TrdClassfctnNmbrForOfclDesc
TrdClassfctnNmbrForCnctntdDesc TrdClassfctnNmbrForCnctntdDesc
_OfficialDesc _OfficialDesc
_CnctntdDesc _CnctntdDesc
_TrdClassfctnNmbrSchmCntnt _TrdClassfctnNmbrSchmCntnt
_TrdClassfctnNmbrSchm I_TrdClassfctnNmbrSchmCntntAct _TrdClassfctnNmbrSchm 
@EndUserText.label: 'Control Class for Key Date'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'ICTRLCLFORKDATE'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations:  [ '_CreatedByUser' , '_LastChangedByUser' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ControlClass'

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

define view I_ControlClassForKeyDate
  with parameters
    P_KeyDate : sll_validon
  as select from I_ControlClass                 as ControlClass
    inner join   I_TrdClassfctnNmbrSchmCntntAct as _TrdClassfctnNmbrSchmCntntAct on  _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchmCntnt = ControlClass.TrdClassfctnNmbrSchmCntnt
                                                                                 and _TrdClassfctnNmbrSchmCntntAct.ValidityStartDate         <= $parameters.P_KeyDate
                                                                                 and _TrdClassfctnNmbrSchmCntntAct.ValidityEndDate           >= $parameters.P_KeyDate
  association [0..1] to I_TrdClassfctnLglRgln   as _LegalRegulation       on  _LegalRegulation.LegalRegulation = $projection.legalregulation
                                                                          and _LegalRegulation.CtrlClNmbrSchm  = _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm
{
  key _LegalRegulation.LegalRegulation,
  key ControlClass,
      _TrdClassfctnNmbrSchmCntntAct.TrdClassfctnNmbrSchm,
      ControlClass.TrdClassfctnNmbrSchmCntnt,
      ControlClass.ValidityStartDate,
      ControlClass.ValidityEndDate,
      TrdClassfctnNmbrForOfclDesc,
      TrdClassfctnNmbrForCnctntdDesc,

      _OfficialDesc,
      _CnctntdDesc,
      _TrdClassfctnNmbrSchmCntnt,
      _TrdClassfctnNmbrSchmCntntAct._TrdClassfctnNmbrSchm
}
where
      ControlClass.ValidityStartDate <= $parameters.P_KeyDate
  and ControlClass.ValidityEndDate   >= $parameters.P_KeyDate

Learn More