I_ConsolidationTaskLogMessage

DDL: I_CONSOLIDATIONTASKLOGMESSAGE Type: view_entity BASIC
13 Fields 1 Data Sources 1 Associations

Consolidation Task Log Message

I_ConsolidationTaskLogMessage (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

ConsolidationTaskLogMessage · Group Reporting

I_ConsolidationTaskLogMessage is a Basic CDS View that provides data about "Consolidation Task Log Message" in SAP S/4HANA. It reads from 1 data source (fincs_log_messag) and exposes 13 fields with key fields CnsldtnTaskLogUUID, CnsldtnTskLgMsgNmbr. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Purpose
This CDS view provides access to the message data of consolidation task logs. A consolidation task log message is an error, warning, or info message attached to the result of a consolidation task run. It provides additional information about consolidation task processing. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations To use this CDS view, assign the following business catalog to a user: SAP_A4C_BC_DEV_TST_FI_CCON_PC . The business role is SAP_BCR_A4C_DEV_TST_FI_CCON_PC .

Structure
Important Fields Important fields in this view include the following: Field Name Description CnsldtnTaskLogUUID Consolidation Log GUID CnsldtnTskLgMsgNmbr Consolidation Log Message Number CnsldtnTaskLogItemUUID Consolidation Log Item Number GUID SystemMessageType Message Type SystemMessageIdentification Message ID SystemMessageNumber Message SystemMessageVariable1 Message Variable SystemMessageVariable2 Message Variable SystemMessageVariable3 Message Variable SystemMessageVariable4 Message Variable SortField Sort Field CnsldtnTskLgMsgID Message ID SystemMessageTypeSortOrder Message Severity

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessGroup Reporting
Application ComponentFIN-CS-COR-IS
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageGroup Reporting for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
fincs_log_messag message from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ConsolidationTaskLog _ConsolidationTaskLog $projection.CnsldtnTaskLogUUID = _ConsolidationTaskLog.CnsldtnTaskLogUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consolidation Task Log Message view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name ConsolidationTaskLogMessage view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID fincs_log_messag cnsldtnlognumber Consolidation Log GUID
KEY CnsldtnTskLgMsgNmbr fincs_log_messag cnsldtnlogmessageno Consolidation Log Message Number
CnsldtnTaskLogItemUUID fincs_log_messag cnsldtnlogitemnumber Consolidation Log Item Number GUID
SystemMessageType fincs_log_messag msgty Msg.Type (E,I,W..)
SystemMessageIdentification fincs_log_messag msgid ABAP System Field: Message ID
SystemMessageNumber Message number
SystemMessageVariable1 fincs_log_messag msgv1 ABAP System Field: Message Variable
SystemMessageVariable2 fincs_log_messag msgv2 ABAP System Field: Message Variable
SystemMessageVariable3 fincs_log_messag msgv3 ABAP System Field: Message Variable
SystemMessageVariable4 fincs_log_messag msgv4 ABAP System Field: Message Variable
SortField Sort Field
CnsldtnTskLgMsgID Message ID
_ConsolidationTaskLog _ConsolidationTaskLog

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ConsolidationTaskLogMessage.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ConsolidationTaskLogMessage AS
SELECT
  message.cnsldtnlognumber AS CnsldtnTaskLogUUID,
  message.cnsldtnlogmessageno AS CnsldtnTskLgMsgNmbr,
  message.cnsldtnlogitemnumber AS CnsldtnTaskLogItemUUID,
  message.msgty AS SystemMessageType,
  message.msgid AS SystemMessageIdentification,
  cast(message.msgno as msgnr) AS SystemMessageNumber,
  message.msgv1 AS SystemMessageVariable1,
  message.msgv2 AS SystemMessageVariable2,
  message.msgv3 AS SystemMessageVariable3,
  message.msgv4 AS SystemMessageVariable4,
  cast(3 as eqfnr) AS SortField,
  cast(concat_with_space(message.msgid, message.msgno, 2) as fincs_msg_id preserving type) AS CnsldtnTskLgMsgID
FROM fincs_log_messag AS message
LEFT OUTER JOIN I_ConsolidationTaskLog AS _ConsolidationTaskLog ON CnsldtnTaskLogUUID = _ConsolidationTaskLog.CnsldtnTaskLogUUID  -- association [1..1]
;

Learn More