I_ClosingTaskNote

DDL: I_CLOSINGTASKNOTE SQL: ICLSGTASKNOTE Type: view BASIC Package: FCCO_VDM_MD

Notes of a Closing Task

I_ClosingTaskNote is a Basic CDS View that provides data about "Notes of a Closing Task" in SAP S/4HANA. It reads from 1 data source (sgbt_nte_cont) and exposes 13 fields with key fields NoteID, ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingTask. It has 4 associations to related views. Part of development package FCCO_VDM_MD.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
sgbt_nte_cont sgbt_nte_cont from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ClosingTaskList _ClosingTaskList $projection.ClosingTemplate = _ClosingTaskList.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTaskList.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType
[1..1] I_ClosingTemplate _ClosingTemplate $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType
[1..1] I_ClosingTask _ClosingTask $projection.ClosingTemplate = _ClosingTask.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTask.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTask.FinancialTaskListContextType and $projection.ClosingTask = _ClosingTask.ClosingTask
[1..1] I_FinTaskListContextType _FinTaskListContextType $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGTASKNOTE view
EndUserText.label Notes of a Closing Task view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey NoteID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY NoteID noteid
KEY ClosingTemplate
KEY ClosingTaskListInstance
KEY FinancialTaskListContextType
KEY ClosingTask
NoteText content
NoteDescription title
CreationDateTime created
CreatedByUser creator
_ClosingTask _ClosingTask
_ClosingTaskList _ClosingTaskList
_ClosingTemplate _ClosingTemplate
_FinTaskListContextType _FinTaskListContextType 
@AbapCatalog.sqlViewName: 'ICLSGTASKNOTE'
@EndUserText.label: 'Notes of a Closing Task'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'NoteID',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #L,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_ClosingTaskNote
  //as select from srgbtbrel

  as select from sgbt_nte_cont

  association [1..1] to I_ClosingTaskList        as _ClosingTaskList        on  $projection.ClosingTemplate              = _ClosingTaskList.ClosingTemplate
                                                                            and $projection.ClosingTaskListInstance      = _ClosingTaskList.ClosingTaskListInstance
                                                                            and $projection.FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType

  association [1..1] to I_ClosingTemplate        as _ClosingTemplate        on  $projection.ClosingTemplate              = _ClosingTemplate.ClosingTemplate
                                                                            and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType

  association [1..1] to I_ClosingTask            as _ClosingTask            on  $projection.ClosingTemplate              = _ClosingTask.ClosingTemplate
                                                                            and $projection.ClosingTaskListInstance      = _ClosingTask.ClosingTaskListInstance
                                                                            and $projection.FinancialTaskListContextType = _ClosingTask.FinancialTaskListContextType
                                                                            and $projection.ClosingTask                  = _ClosingTask.ClosingTask
  association [1..1] to I_FinTaskListContextType as _FinTaskListContextType on  $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType
{
  key noteid                                                                         as NoteID,
      @ObjectModel.foreignKey.association: '_ClosingTemplate'
  key cast( substring(objectid, 1, 20) as fcco_profile)                              as ClosingTemplate,
      @ObjectModel.foreignKey.association: '_ClosingTaskList'
  key cast( cast( substring(objectid, 21, 10) as numc10) as fcco_instance)           as ClosingTaskListInstance,
      @ObjectModel.foreignKey.association: '_FinTaskListContextType'
  key cast( substring(objectid, 31, 10) as fcco_flavor)                              as FinancialTaskListContextType,
      @ObjectModel.foreignKey.association: '_ClosingTask'
  key cast( substring(objectid, 41, 12) as fcco_task_id)                             as ClosingTask,

      content                                                                        as NoteText,
      title                                                                          as NoteDescription,
      created                                                                        as CreationDateTime,
      creator                                                                        as CreatedByUser,

      _ClosingTask,
      _ClosingTaskList,
      _ClosingTemplate,
      _FinTaskListContextType
}

where
  objectnodetype = 'ClosingTask'

Learn More