Which tables does I_ClosingTaskNotifLog use?

I_ClosingTaskNotifLog reads from 1 data source(s): fcco_notif_log.

I_ClosingTaskNotifLog

Q: How many fields does I_ClosingTaskNotifLog have?

I_ClosingTaskNotifLog has 27 fields. Key fields: ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingTask, NotificationUUID.

DDL: I_CLOSINGTASKNOTIFLOG Type: view BASIC Package: FCCO_VDM_MD

Closing Task Notification

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

Data Sources (1)

Source	Alias	Join Type
fcco_notif_log	fcco_notif_log	from

Associations (10)

Cardinality	Target	Alias	Condition
[1..1]	I_ClosingTaskList	_ClosingTaskList	`$projection.ClosingTemplate = _ClosingTaskList.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTaskList.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTaskList.FinancialTaskListContextType`
[1..1]	I_FinTaskListContextType	_FinTaskListContextType	`$projection.FinancialTaskListContextType = _FinTaskListContextType.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_ClosingTemplate	_ClosingTemplate	`$projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType`
[0..*]	I_ClosingFolderOrgUnit	_Plant	`$projection.ClosingTemplate = _Plant.ClosingTemplate and $projection.ClosingTaskListInstance = _Plant.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _Plant.FinancialTaskListContextType and $projection.PlantClosingFolder = _Plant.ClosingFolder`
[0..*]	I_ClosingFolderOrgUnit	_CompanyCode	`$projection.ClosingTemplate = _CompanyCode.ClosingTemplate and $projection.ClosingTaskListInstance = _CompanyCode.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _CompanyCode.FinancialTaskListContextType and $projection.CompanyCodeClosingFolder = _CompanyCode.ClosingFolder`
[0..*]	I_ClosingFolderOrgUnit	_ControllingArea	`$projection.ClosingTemplate = _ControllingArea.ClosingTemplate and $projection.ClosingTaskListInstance = _ControllingArea.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ControllingArea.FinancialTaskListContextType and $projection.ControllingAreaClosingFolder = _ControllingArea.ClosingFolder`
[0..1]	I_ClosingFolder	_CompanyCodeClosingFolder	`$projection.ClosingTemplate = _CompanyCodeClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _CompanyCodeClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _CompanyCodeClosingFolder.FinancialTaskListContextType and $projection.CompanyCodeClosingFolder = _CompanyCodeClosingFolder.ClosingFolder`
[0..1]	I_ClosingFolder	_ControllingAreaClosingFolder	`$projection.ClosingTemplate = _ControllingAreaClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _ControllingAreaClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ControllingAreaClosingFolder.FinancialTaskListContextType and $projection.ControllingAreaClosingFolder = _ControllingAreaClosingFolder.ClosingFolder`
[0..1]	I_ClosingFolder	_PlantClosingFolder	`$projection.ClosingTemplate = _PlantClosingFolder.ClosingTemplate and $projection.ClosingTaskListInstance = _PlantClosingFolder.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _PlantClosingFolder.FinancialTaskListContextType and $projection.PlantClosingFolder = _PlantClosingFolder.ClosingFolder`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	ICLSGTASKNOTILOG	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Closing Task Notification	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MASTER	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (27)

Key	Field	Source Table	Source Field
KEY	ClosingTemplate		profile
KEY	ClosingTaskListInstance		instance
KEY	FinancialTaskListContextType		flavor
KEY	ClosingTask		item
KEY	NotificationUUID		uuid
	ClosingNotifScenario		noti_sce
	ClosingTaskUser		task_user
	CreationDateTime		created_on
	NotificationSender		noti_sender
	EmailBodyText		dummy
	ClosingNotificationConfign	_ClosingTask	ClosingNotificationConfign
	ClosingAuthorizationGroup	_ClosingTask	ClosingAuthorizationGroup
	UserIsClsgTaskRespOrSubstit	_ClosingTask	UserIsClsgTaskRespOrSubstit
	UserIsClsgTaskProcsrOrSubstit	_ClosingTask	UserIsClsgTaskProcsrOrSubstit
	PlantClosingFolder	_ClosingTask	PlantClosingFolder
	CompanyCodeClosingFolder	_ClosingTask	CompanyCodeClosingFolder
	ControllingAreaClosingFolder	_ClosingTask	ControllingAreaClosingFolder
	_ClosingTaskList		_ClosingTaskList
	_ClosingTemplate		_ClosingTemplate
	_FinTaskListContextType		_FinTaskListContextType
	_ClosingTask		_ClosingTask
	_ControllingArea		_ControllingArea
	_CompanyCode		_CompanyCode
	_Plant		_Plant
	_CompanyCodeClosingFolder		_CompanyCodeClosingFolder
	_ControllingAreaClosingFolder		_ControllingAreaClosingFolder
	_PlantClosingFolder		_PlantClosingFolder

@AbapCatalog: {sqlViewName: 'ICLSGTASKNOTILOG', preserveKey: true}
@EndUserText.label: 'Closing Task Notification'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { usageType.serviceQuality: #C,
                usageType.sizeCategory: #XL,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view I_ClosingTaskNotifLog
  as select from fcco_notif_log

  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_FinTaskListContextType as _FinTaskListContextType       on  $projection.FinancialTaskListContextType = _FinTaskListContextType.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_ClosingTemplate        as _ClosingTemplate              on  $projection.ClosingTemplate              = _ClosingTemplate.ClosingTemplate
                                                                                  and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType

  association [0..*] to I_ClosingFolderOrgUnit   as _Plant                        on  $projection.ClosingTemplate              = _Plant.ClosingTemplate
                                                                                  and $projection.ClosingTaskListInstance      = _Plant.ClosingTaskListInstance
                                                                                  and $projection.FinancialTaskListContextType = _Plant.FinancialTaskListContextType
                                                                                  and $projection.PlantClosingFolder           = _Plant.ClosingFolder

  association [0..*] to I_ClosingFolderOrgUnit   as _CompanyCode                  on  $projection.ClosingTemplate              = _CompanyCode.ClosingTemplate
                                                                                  and $projection.ClosingTaskListInstance      = _CompanyCode.ClosingTaskListInstance
                                                                                  and $projection.FinancialTaskListContextType = _CompanyCode.FinancialTaskListContextType
                                                                                  and $projection.CompanyCodeClosingFolder     = _CompanyCode.ClosingFolder

  association [0..*] to I_ClosingFolderOrgUnit   as _ControllingArea              on  $projection.ClosingTemplate              = _ControllingArea.ClosingTemplate
                                                                                  and $projection.ClosingTaskListInstance      = _ControllingArea.ClosingTaskListInstance
                                                                                  and $projection.FinancialTaskListContextType = _ControllingArea.FinancialTaskListContextType
                                                                                  and $projection.ControllingAreaClosingFolder = _ControllingArea.ClosingFolder

  association [0..1] to I_ClosingFolder          as _CompanyCodeClosingFolder     on  $projection.ClosingTemplate              = _CompanyCodeClosingFolder.ClosingTemplate
                                                                                  and $projection.ClosingTaskListInstance      = _CompanyCodeClosingFolder.ClosingTaskListInstance
                                                                                  and $projection.FinancialTaskListContextType = _CompanyCodeClosingFolder.FinancialTaskListContextType
                                                                                  and $projection.CompanyCodeClosingFolder     = _CompanyCodeClosingFolder.ClosingFolder

  association [0..1] to I_ClosingFolder          as _ControllingAreaClosingFolder on  $projection.ClosingTemplate              = _ControllingAreaClosingFolder.ClosingTemplate
                                                                                  and $projection.ClosingTaskListInstance      = _ControllingAreaClosingFolder.ClosingTaskListInstance
                                                                                  and $projection.FinancialTaskListContextType = _ControllingAreaClosingFolder.FinancialTaskListContextType
                                                                                  and $projection.ControllingAreaClosingFolder = _ControllingAreaClosingFolder.ClosingFolder

  association [0..1] to I_ClosingFolder          as _PlantClosingFolder           on  $projection.ClosingTemplate              = _PlantClosingFolder.ClosingTemplate
                                                                                  and $projection.ClosingTaskListInstance      = _PlantClosingFolder.ClosingTaskListInstance
                                                                                  and $projection.FinancialTaskListContextType = _PlantClosingFolder.FinancialTaskListContextType
                                                                                  and $projection.PlantClosingFolder           = _PlantClosingFolder.ClosingFolder
{
         @ObjectModel.foreignKey.association: '_ClosingTemplate'
  key    profile                                    as       ClosingTemplate,
         @ObjectModel.foreignKey.association: '_ClosingTaskList'
  key    instance                                   as       ClosingTaskListInstance,
         @ObjectModel.foreignKey.association: '_FinTaskListContextType'
  key    flavor                                     as       FinancialTaskListContextType,
         @ObjectModel.foreignKey.association: '_ClosingTask'
  key    item                                       as       ClosingTask,
  key    uuid                                       as       NotificationUUID,

         noti_sce                                   as       ClosingNotifScenario,
         task_user                                  as       ClosingTaskUser,
         created_on                                 as       CreationDateTime,
         noti_sender                                as       NotificationSender,
         @Consumption.hidden: true
         dummy                                      as       EmailBodyText,

         _ClosingTask.ClosingNotificationConfign    as       ClosingNotificationConfign,
         _ClosingTask.ClosingAuthorizationGroup     as       ClosingAuthorizationGroup,
         _ClosingTask.UserIsClsgTaskRespOrSubstit   as       UserIsClsgTaskRespOrSubstit,
         _ClosingTask.UserIsClsgTaskProcsrOrSubstit as       UserIsClsgTaskProcsrOrSubstit,

         _ClosingTask.PlantClosingFolder            as       PlantClosingFolder,
         _ClosingTask.CompanyCodeClosingFolder      as       CompanyCodeClosingFolder,
         _ClosingTask.ControllingAreaClosingFolder  as       ControllingAreaClosingFolder,

         @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
         _ClosingTaskList,
         _ClosingTemplate,
         _FinTaskListContextType,
         @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
         _ClosingTask,
         @Consumption.hidden
         _ControllingArea,
         @Consumption.hidden
         _CompanyCode,
         @Consumption.hidden
         _Plant,
         @Consumption.hidden
         _CompanyCodeClosingFolder,
         @Consumption.hidden
         _ControllingAreaClosingFolder,
         @Consumption.hidden
         _PlantClosingFolder
}

Depth:

I_ClosingTaskNotifLog view

fcco_notif_log

C_ClosingTaskNotifLog view
P_ClosingTaskCorrespondence view