I_ClosingTaskErrorHandling

DDL: I_CLOSINGTASKERRORHANDLING Type: view BASIC Package: FCCO_VDM_MD

Closing Task Error Handling

I_ClosingTaskErrorHandling is a Basic CDS View that provides data about "Closing Task Error Handling" in SAP S/4HANA. It reads from 3 data sources (fcco_errmsg_c, fcco_task, fcco_task_exec_r) and exposes 7 fields with key fields ClosingTaskExecutionResultUUID, SystemMessageIdentification, SystemMessageNumber. Part of development package FCCO_VDM_MD.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
fcco_errmsg_c fcco_errmsg_c inner
fcco_task fcco_task inner
fcco_task_exec_r fcco_task_exec_r from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICLSGTASKERRHDL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Closing Task Error Handling view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ClosingTaskExecutionResultUUID 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 (7)

KeyFieldSource TableSource FieldDescription
KEY ClosingTaskExecutionResultUUID fcco_task_exec_r resultuuid
KEY SystemMessageIdentification fcco_errmsg_c msgid
KEY SystemMessageNumber fcco_errmsg_c msgno
ClosingCommunicationProfile fcco_task communication_profile
ClosingBusinessTransactionType fcco_task bttype
SemanticObject fcco_errmsg_c semobj
SemanticObjectAction fcco_errmsg_c action 
@AbapCatalog: {sqlViewName: 'ICLSGTASKERRHDL', preserveKey: true}
@AbapCatalog.compiler.compareFilter:true
//@Analytics.dataCategory: #DIMENSION

@EndUserText.label: 'Closing Task Error Handling'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { representativeKey: 'ClosingTaskExecutionResultUUID',
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #XL,
                usageType.dataClass: #MASTER }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true

define view I_ClosingTaskErrorHandling

as select from fcco_task_exec_r
    inner join fcco_task     on  fcco_task_exec_r.task_uuid      = fcco_task.task_uuid
    inner join fcco_errmsg_c on  fcco_task.communication_profile = fcco_errmsg_c.communication_profile
                             and ( fcco_task.bttype                = fcco_errmsg_c.bttyp
                                   or fcco_errmsg_c.bttyp is initial
                                 )
                           
{
  key fcco_task_exec_r.resultuuid  as ClosingTaskExecutionResultUUID,
  key fcco_errmsg_c.msgid          as SystemMessageIdentification,
  key fcco_errmsg_c.msgno          as SystemMessageNumber,
  fcco_task.communication_profile  as ClosingCommunicationProfile,
  fcco_task.bttype                 as ClosingBusinessTransactionType,
  fcco_errmsg_c.semobj             as SemanticObject,
  fcco_errmsg_c.action             as SemanticObjectAction
  
}

Learn More