I_ClosingFolderNote

DDL: I_CLOSINGFOLDERNOTE SQL: ICLSGFLDNOTE Type: view BASIC Package: FCCO_VDM_MD

Closing Folder Note

I_ClosingFolderNote is a Basic CDS View that provides data about "Closing Folder Note" in SAP S/4HANA. It reads from 1 data source (sgbt_nte_cont) and exposes 13 fields with key fields NoteID, ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingFolder. 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_ClosingFolder _ClosingFolder $projection.ClosingTemplate = _ClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingFolder.FinancialTaskListContextType and $projection.ClosingFolder = _ClosingFolder.ClosingFolder
[1..1] I_FinTaskListContextType _FinTaskListContextType $projection.FinancialTaskListContextType = _FinTaskListContextType.FinancialTaskListContextType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGFLDNOTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Closing Folder Note 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 ClosingFolder
NoteText content
NoteDescription title
CreationDateTime created
CreatedByUser creator
_ClosingFolder _ClosingFolder
_ClosingTaskList _ClosingTaskList
_ClosingTemplate _ClosingTemplate
_FinTaskListContextType _FinTaskListContextType 
@AbapCatalog.sqlViewName: 'ICLSGFLDNOTE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Closing Folder Note'
@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_ClosingFolderNote
  //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_ClosingFolder          as _ClosingFolder          on  $projection.ClosingTemplate              = _ClosingFolder.ClosingTemplate
                                                                            and $projection.ClosingTaskListInstance      = _ClosingFolder.ClosingTaskListInstance
                                                                            and $projection.FinancialTaskListContextType = _ClosingFolder.FinancialTaskListContextType
                                                                            and $projection.ClosingFolder                = _ClosingFolder.ClosingFolder
  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: '_ClosingFolder'
  key cast( substring(objectid, 41, 12) as fcco_folder_id)                           as ClosingFolder,

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

      _ClosingFolder,
      _ClosingTaskList,
      _ClosingTemplate,
      _FinTaskListContextType
}

where
  objectnodetype = 'ClosingFolder'

Learn More