I_ClosingTaskTemplateSet

DDL: I_CLOSINGTASKTEMPLATESET SQL: ICLSGTSKTMPLSET Type: view BASIC Package: FCCO_VDM_MD

Closing Task Template Set

I_ClosingTaskTemplateSet is a Basic CDS View (Dimension) that provides data about "Closing Task Template Set" in SAP S/4HANA. It reads from 1 data source (fccoc_task_set) and exposes 7 fields with key fields ClosingCommunicationProfile, ClosingTaskTemplateSet. It has 3 associations to related views. Part of development package FCCO_VDM_MD.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
fccoc_task_set fccoc_task_set from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ClosingCommProfile _ClosingCommunicationProfile $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile
[0..1] I_ClosingTaskListHierarchyType _ClosingTaskListHierarchyType $projection.ClosingTaskListHierarchyType = _ClosingTaskListHierarchyType.ClosingTaskListHierarchyType
[0..*] I_ClosingTaskTemplateSetText _Text $projection.ClosingCommunicationProfile = _Text.ClosingCommunicationProfile and $projection.ClosingTaskTemplateSet = _Text.ClosingTaskTemplateSet

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGTSKTMPLSET view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
EndUserText.label Closing Task Template Set view
VDM.viewType #BASIC view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 0 view
ObjectModel.representativeKey ClosingTaskTemplateSet view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ClosingCommunicationProfile communication_profile
KEY ClosingTaskTemplateSet taskset
ClosingTaskListHierarchyType hierarchy_type
IsMarkedForDeletion orphaned
_ClosingCommunicationProfile _ClosingCommunicationProfile
_ClosingTaskListHierarchyType _ClosingTaskListHierarchyType
_Text _Text 
@AbapCatalog.sqlViewName: 'ICLSGTSKTMPLSET'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@EndUserText.label: 'Closing Task Template Set'
@VDM.viewType: #BASIC
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.numberOfKeyFields: 0

@ObjectModel: { representativeKey: 'ClosingTaskTemplateSet',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_ClosingTaskTemplateSet
  as select from fccoc_task_set

  association [0..1] to I_ClosingCommProfile           as _ClosingCommunicationProfile  on  $projection.ClosingCommunicationProfile = _ClosingCommunicationProfile.ClosingCommunicationProfile
  association [0..1] to I_ClosingTaskListHierarchyType as _ClosingTaskListHierarchyType on  $projection.ClosingTaskListHierarchyType = _ClosingTaskListHierarchyType.ClosingTaskListHierarchyType
  association [0..*] to I_ClosingTaskTemplateSetText   as _Text                         on  $projection.ClosingCommunicationProfile = _Text.ClosingCommunicationProfile
                                                                                        and $projection.ClosingTaskTemplateSet      = _Text.ClosingTaskTemplateSet
{
      @ObjectModel.foreignKey.association: '_ClosingCommunicationProfile'
  key communication_profile                       as ClosingCommunicationProfile,
      @ObjectModel.text.association: '_Text'
  key taskset                                     as ClosingTaskTemplateSet,

      @ObjectModel.foreignKey.association: '_ClosingTaskListHierarchyType'
      hierarchy_type                              as ClosingTaskListHierarchyType,
      orphaned                                    as IsMarkedForDeletion,

      _ClosingCommunicationProfile,
      _ClosingTaskListHierarchyType,
      _Text
}

Learn More