C_CnsldtnTaskRunLastLog

DDL: C_CNSLDTNTASKRUNLASTLOG Type: view_entity CONSUMPTION
14 Fields 2 Data Sources 1 Associations

Consolidation Task Run Last Log

C_CnsldtnTaskRunLastLog is a Consumption CDS View that provides data about "Consolidation Task Run Last Log" in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnTaskRunLastLog_2, I_ConsolidationTaskLog) and exposes 14 fields with key fields ConsolidationChartOfAccounts, ConsolidationVersion, FiscalYear, FiscalPeriod, ConsolidationTask. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnTaskRunLastLog_2 CnsldtnTaskRunLastLog from
I_ConsolidationTaskLog ConsolidationTaskLog inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedByUserContactCard $projection.CnsldtnTaskLogCreatedByUser = _CreatedByUserContactCard.ContactCardID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
UI.textArrangement #TEXT_LAST view
EndUserText.label Consolidation Task Run Last Log view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts I_CnsldtnTaskRunLastLog_2 ConsolidationChartOfAccounts Cons. COA
KEY ConsolidationVersion I_CnsldtnTaskRunLastLog_2 ConsolidationVersion Version
KEY FiscalYear I_CnsldtnTaskRunLastLog_2 FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_CnsldtnTaskRunLastLog_2 FiscalPeriod Tax period
KEY ConsolidationTask I_CnsldtnTaskRunLastLog_2 ConsolidationTask Task
KEY ConsolidationGroup I_CnsldtnTaskRunLastLog_2 ConsolidationGroup Cons. Group
KEY ConsolidationTaskRunIsTest I_CnsldtnTaskRunLastLog_2 ConsolidationTaskRunIsTest
CnsldtnTaskLogCreatedByUser I_CnsldtnTaskRunLastLog_2 CnsldtnTaskLogCreatedByUser Created By
CnsldtnTaskLogUUID I_CnsldtnTaskRunLastLog_2 CnsldtnTaskLogUUID Consolidation Log GUID
ConsolidationTaskStatus I_ConsolidationTaskLog ConsolidationTaskStatus Status
ConsolidationTaskStatusText ConsolidationStatus ConsolidationTaskStatusText
CnsldtnParentMessageText
_CreatedByUserContactCard _CreatedByUserContactCard
_CnsldtnTask I_CnsldtnTaskRunLastLog_2 _CnsldtnTask

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 C_CnsldtnTaskRunLastLog.
-- 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 C_CnsldtnTaskRunLastLog AS
SELECT
  CnsldtnTaskRunLastLog.ConsolidationChartOfAccounts AS ConsolidationChartOfAccounts,
  CnsldtnTaskRunLastLog.ConsolidationVersion AS ConsolidationVersion,
  CnsldtnTaskRunLastLog.FiscalYear AS FiscalYear,
  CnsldtnTaskRunLastLog.FiscalPeriod AS FiscalPeriod,
  CnsldtnTaskRunLastLog.ConsolidationTask AS ConsolidationTask,
  CnsldtnTaskRunLastLog.ConsolidationGroup AS ConsolidationGroup,
  CnsldtnTaskRunLastLog.ConsolidationTaskRunIsTest AS ConsolidationTaskRunIsTest,
  CnsldtnTaskRunLastLog.CnsldtnTaskLogCreatedByUser AS CnsldtnTaskLogCreatedByUser,
  CnsldtnTaskRunLastLog.CnsldtnTaskLogUUID AS CnsldtnTaskLogUUID,
  ConsolidationTaskLog.ConsolidationTaskStatus AS ConsolidationTaskStatus,
  ConsolidationStatus.ConsolidationTaskStatusText AS ConsolidationTaskStatusText,
  cast( '' as msgtxt_long) AS CnsldtnParentMessageText,
  CnsldtnTaskRunLastLog._CnsldtnTask AS _CnsldtnTask
FROM I_CnsldtnTaskRunLastLog_2 AS CnsldtnTaskRunLastLog
INNER JOIN I_ConsolidationTaskLog AS ConsolidationTaskLog ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CnsldtnTaskLogCreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
;

Learn More