I_ClosingTaskExecutionLog
Closing Task Execution Log
I_ClosingTaskExecutionLog is a Basic CDS View (Dimension) that provides data about "Closing Task Execution Log" in SAP S/4HANA. It reads from 2 data sources (fcco_task_exec_m, fcco_task_exec_r) and exposes 33 fields with key fields ClosingTemplate, ClosingTaskListInstance, FinancialTaskListContextType, ClosingTask, ClosingTaskExecutionGroupUUID. It has 7 associations to related views. Part of development package FCCO_VDM_MD.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| fcco_task_exec_m | fcco_task_exec_m | inner |
| fcco_task_exec_r | fcco_task_exec_r | from |
Associations (7)
| 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_ClosingTaskExecutionGroup | _ClosingTaskExecutionGroup | $projection.ClosingTemplate = _ClosingTaskExecutionGroup.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTaskExecutionGroup.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTaskExecutionGroup.FinancialTaskListContextType and $projection.ClosingTask = _ClosingTaskExecutionGroup.ClosingTask and $projection.ClosingTaskExecutionGroupUUID = _ClosingTaskExecutionGroup.ClosingTaskExecutionGroupUUID |
| [1..1] | I_ClosingTaskExecution | _ClosingTaskExecution | $projection.ClosingTemplate = _ClosingTaskExecution.ClosingTemplate and $projection.ClosingTaskListInstance = _ClosingTaskExecution.ClosingTaskListInstance and $projection.FinancialTaskListContextType = _ClosingTaskExecution.FinancialTaskListContextType and $projection.ClosingTask = _ClosingTaskExecution.ClosingTask and $projection.ClosingTaskExecutionGroupUUID = _ClosingTaskExecution.ClosingTaskExecutionGroupUUID and $projection.ClosingTaskExecutionUUID = _ClosingTaskExecution.ClosingTaskExecutionUUID |
| [1..1] | I_ClosingTaskExecutionResult | _ClosingTaskExecutionResult | _ClosingTaskExecutionResult.ClosingTemplate = $projection.ClosingTemplate and _ClosingTaskExecutionResult.ClosingTaskListInstance = $projection.ClosingTaskListInstance and _ClosingTaskExecutionResult.FinancialTaskListContextType = $projection.FinancialTaskListContextType and _ClosingTaskExecutionResult.ClosingTask = $projection.ClosingTask and _ClosingTaskExecutionResult.ClosingTaskExecutionGroupUUID = $projection.ClosingTaskExecutionGroupUUID and _ClosingTaskExecutionResult.ClosingTaskExecutionUUID = $projection.ClosingTaskExecutionUUID and _ClosingTaskExecutionResult.ClosingTaskExecutionResultUUID = $projection.ClosingTaskExecutionResultUUID |
| [1..1] | I_ClosingTemplate | _ClosingTemplate | $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICLSGTASKEXECL | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| EndUserText.label | Closing Task Execution Log | view | |
| VDM.viewType | #BASIC | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | ClosingTaskExecutionMsgUUID | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Metadata.allowExtensions | true | view |
Fields (33)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ClosingTemplate | profile | ||
| KEY | ClosingTaskListInstance | instance | ||
| KEY | FinancialTaskListContextType | flavor | ||
| KEY | ClosingTask | item | ||
| KEY | ClosingTaskExecutionGroupUUID | exec_grp_uuid | ||
| KEY | ClosingTaskExecutionUUID | execuuid | ||
| KEY | ClosingTaskExecutionResultUUID | fcco_task_exec_r | resultuuid | |
| KEY | ClosingTaskExecutionMsgUUID | msguuid | ||
| CreationDateTime | time_stmp | |||
| SystemMessageIdentification | msgid | |||
| SystemMessageNumber | msgno | |||
| SystemMessageType | msgty | |||
| SystemMessageText | text | |||
| SystemMessageVariable1 | msgv1 | |||
| SystemMessageVariable2 | msgv2 | |||
| SystemMessageVariable3 | msgv3 | |||
| SystemMessageVariable4 | msgv4 | |||
| ApplicationLogObject | object | |||
| ApplicationLogSubobject | subobject | |||
| ApplicationLog | lognumber | |||
| ApplicationLogHandle | loghandle | |||
| ClosingTaskExecutionLogType | resulttype | |||
| CompanyCode | bukrs | |||
| ControllingArea | kokrs | |||
| Plant | werks | |||
| Country | country | |||
| _ClosingTaskList | _ClosingTaskList | |||
| _FinTaskListContextType | _FinTaskListContextType | |||
| _ClosingTask | _ClosingTask | |||
| _ClosingTaskExecutionGroup | _ClosingTaskExecutionGroup | |||
| _ClosingTaskExecution | _ClosingTaskExecution | |||
| _ClosingTaskExecutionResult | _ClosingTaskExecutionResult | |||
| _ClosingTemplate | _ClosingTemplate |
@AbapCatalog: {sqlViewName: 'ICLSGTASKEXECL', preserveKey: true}
@AbapCatalog.compiler.compareFilter:true
@Analytics.dataCategory: #DIMENSION
@EndUserText.label: 'Closing Task Execution Log'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'ClosingTaskExecutionMsgUUID',
usageType.serviceQuality: #C,
usageType.sizeCategory: #XL,
usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
define view I_ClosingTaskExecutionLog
as select from fcco_task_exec_r
inner join fcco_task_exec_m on fcco_task_exec_r.resultuuid = fcco_task_exec_m.resultuuid
and fcco_task_exec_r.mandt = fcco_task_exec_m.mandt
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_ClosingTaskExecutionGroup as _ClosingTaskExecutionGroup on $projection.ClosingTemplate = _ClosingTaskExecutionGroup.ClosingTemplate
and $projection.ClosingTaskListInstance = _ClosingTaskExecutionGroup.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _ClosingTaskExecutionGroup.FinancialTaskListContextType
and $projection.ClosingTask = _ClosingTaskExecutionGroup.ClosingTask
and $projection.ClosingTaskExecutionGroupUUID = _ClosingTaskExecutionGroup.ClosingTaskExecutionGroupUUID
association [1..1] to I_ClosingTaskExecution as _ClosingTaskExecution on $projection.ClosingTemplate = _ClosingTaskExecution.ClosingTemplate
and $projection.ClosingTaskListInstance = _ClosingTaskExecution.ClosingTaskListInstance
and $projection.FinancialTaskListContextType = _ClosingTaskExecution.FinancialTaskListContextType
and $projection.ClosingTask = _ClosingTaskExecution.ClosingTask
and $projection.ClosingTaskExecutionGroupUUID = _ClosingTaskExecution.ClosingTaskExecutionGroupUUID
and $projection.ClosingTaskExecutionUUID = _ClosingTaskExecution.ClosingTaskExecutionUUID
association [1..1] to I_ClosingTaskExecutionResult as _ClosingTaskExecutionResult on _ClosingTaskExecutionResult.ClosingTemplate = $projection.ClosingTemplate
and _ClosingTaskExecutionResult.ClosingTaskListInstance = $projection.ClosingTaskListInstance
and _ClosingTaskExecutionResult.FinancialTaskListContextType = $projection.FinancialTaskListContextType
and _ClosingTaskExecutionResult.ClosingTask = $projection.ClosingTask
and _ClosingTaskExecutionResult.ClosingTaskExecutionGroupUUID = $projection.ClosingTaskExecutionGroupUUID
and _ClosingTaskExecutionResult.ClosingTaskExecutionUUID = $projection.ClosingTaskExecutionUUID
and _ClosingTaskExecutionResult.ClosingTaskExecutionResultUUID = $projection.ClosingTaskExecutionResultUUID
association [1..1] to I_ClosingTemplate as _ClosingTemplate on $projection.ClosingTemplate = _ClosingTemplate.ClosingTemplate
and $projection.FinancialTaskListContextType = _ClosingTemplate.FinancialTaskListContextType
{
@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,
@ObjectModel.foreignKey.association: '_ClosingTaskExecutionGroup'
key exec_grp_uuid as ClosingTaskExecutionGroupUUID,
@ObjectModel.foreignKey.association: '_ClosingTaskExecution'
key execuuid as ClosingTaskExecutionUUID,
@ObjectModel.foreignKey.association: '_ClosingTaskExecutionResult'
key fcco_task_exec_r.resultuuid as ClosingTaskExecutionResultUUID,
key msguuid as ClosingTaskExecutionMsgUUID,
time_stmp as CreationDateTime,
msgid as SystemMessageIdentification,
msgno as SystemMessageNumber,
msgty as SystemMessageType,
text as SystemMessageText,
msgv1 as SystemMessageVariable1,
msgv2 as SystemMessageVariable2,
msgv3 as SystemMessageVariable3,
msgv4 as SystemMessageVariable4,
object as ApplicationLogObject,
subobject as ApplicationLogSubobject,
lognumber as ApplicationLog,
loghandle as ApplicationLogHandle,
resulttype as ClosingTaskExecutionLogType,
bukrs as CompanyCode,
kokrs as ControllingArea,
werks as Plant,
country as Country,
@ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
_ClosingTaskList,
_FinTaskListContextType,
_ClosingTask,
_ClosingTaskExecutionGroup,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
_ClosingTaskExecution,
_ClosingTaskExecutionResult,
_ClosingTemplate
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA