A_ConsolidationTaskLog

DDL: A_CONSOLIDATIONTASKLOG Type: view_entity COMPOSITE
22 Fields 1 Data Sources

Consolidation Task Log

A_ConsolidationTaskLog is a Composite CDS View that provides data about "Consolidation Task Log" in SAP S/4HANA. It reads from 1 data source (I_ConsolidationTaskLog) and exposes 22 fields with key field CnsldtnTaskLogUUID.

Data Sources (1)

SourceAliasJoin Type
I_ConsolidationTaskLog I_ConsolidationTaskLog projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Consolidation Task Log view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
OData.entityType.name ConsolidationTaskLog_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID Consolidation Log GUID
ConsolidationChartOfAccounts ConsolidationChartOfAccounts Cons. COA
ConsolidationGroup ConsolidationGroup Cons. Group
ConsolidationUnit ConsolidationUnit Consolidation Unit
ConsolidationVersion ConsolidationVersion Version
ConsolidationTaskCategory ConsolidationTaskCategory Task category
CnsldtnTaskLogExternalId CnsldtnTaskLogExternalId
CnsldtnTskRunBackgroundJobName CnsldtnTskRunBackgroundJobName
CnsldtnTaskRunBackgroundJob CnsldtnTaskRunBackgroundJob
FiscalPeriod FiscalPeriod Tax period
FiscalYear FiscalYear G/L Fiscal Year
CnsldtnTaskLogCreatedByUser CnsldtnTaskLogCreatedByUser
ConsolidationTask ConsolidationTask Task
ConsolidationDocumentType ConsolidationDocumentType Document Type
ConsolidationGroupCurrency ConsolidationGroupCurrency
ConsolidationTaskStatus ConsolidationTaskStatus
ConsolidationMethod ConsolidationMethod
CnsldtnIsCumulative CnsldtnIsCumulative
CnsldtnRptdDataUpdateMode CnsldtnRptdDataUpdateMode
CnsldtnTskLgCreatedDateTime CnsldtnTskLgCreatedDateTime
CnsldtnTaskLogHeaderDateTime CnsldtnTaskLogHeaderDateTime
ConsolidationTaskRunIsTest ConsolidationTaskRunIsTest

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 A_ConsolidationTaskLog.
-- 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 A_ConsolidationTaskLog AS
SELECT
  CnsldtnTaskLogUUID,
  ConsolidationChartOfAccounts,
  ConsolidationGroup,
  ConsolidationUnit,
  ConsolidationVersion,
  ConsolidationTaskCategory,
  CnsldtnTaskLogExternalId,
  CnsldtnTskRunBackgroundJobName,
  CnsldtnTaskRunBackgroundJob,
  FiscalPeriod,
  FiscalYear,
  CnsldtnTaskLogCreatedByUser,
  ConsolidationTask,
  ConsolidationDocumentType,
  ConsolidationGroupCurrency,
  ConsolidationTaskStatus,
  ConsolidationMethod,
  CnsldtnIsCumulative,
  CnsldtnRptdDataUpdateMode,
  CnsldtnTskLgCreatedDateTime,
  CnsldtnTaskLogHeaderDateTime,
  ConsolidationTaskRunIsTest
FROM I_ConsolidationTaskLog
;

Learn More