P_CnsldtnTaskMonitorOverview02

DDL: P_CNSLDTNTASKMONITOROVERVIEW02 Type: view_entity COMPOSITE
13 Fields 3 Data Sources

P_CnsldtnTaskMonitorOverview02 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_CnsldtnTskMonitorOverviewFYP, P_CnsldtnTaskMonitorOverview01, I_CnsldtnVersion) and exposes 13 fields with key fields ConsolidationVersion, FiscalYear, FiscalPeriod, ConsolidationGroup, ConsolidationUnit.

Data Sources (3)

SourceAliasJoin Type
P_CnsldtnTskMonitorOverviewFYP fyp from
P_CnsldtnTaskMonitorOverview01 ovw1 inner
I_CnsldtnVersion ver inner

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationVersion P_CnsldtnTskMonitorOverviewFYP ConsolidationVersion Version
KEY FiscalYear P_CnsldtnTskMonitorOverviewFYP FiscalYear G/L Fiscal Year
KEY FiscalPeriod P_CnsldtnTskMonitorOverviewFYP FiscalPeriod Tax period
KEY ConsolidationGroup P_CnsldtnTaskMonitorOverview01 ConsolidationGroup Cons. Group
KEY ConsolidationUnit P_CnsldtnTaskMonitorOverview01 ConsolidationUnit Consolidation Unit
ConsolidationProcessPeriod P_CnsldtnTskMonitorOverviewFYP ConsolidationProcessPeriod
FiscalYearPeriod P_CnsldtnTskMonitorOverviewFYP FiscalYearPeriod Period/Year
ConsolidationProcessYearPeriod P_CnsldtnTskMonitorOverviewFYP ConsolidationProcessYearPeriod
ConsolidationUnitLocalCurrency byTime ConsolidationUnitLocalCurrency
CnsldtnUnivJournalIntegType byTimeVer CnsldtnUnivJournalIntegType
CnsldtnVersionRunMode I_CnsldtnVersion CnsldtnVersionRunMode
GroupCurrency I_CnsldtnVersion GroupCurrency Ledger curr.
CnsldtnTskRunIsCnsldtnMntrRun P_CnsldtnTaskMonitorOverview01 CnsldtnTskRunIsCnsldtnMntrRun

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 P_CnsldtnTaskMonitorOverview02.
-- 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 P_CnsldtnTaskMonitorOverview02 AS
SELECT
  fyp.ConsolidationVersion AS ConsolidationVersion,
  fyp.FiscalYear AS FiscalYear,
  fyp.FiscalPeriod AS FiscalPeriod,
  ovw1.ConsolidationGroup AS ConsolidationGroup,
  ovw1.ConsolidationUnit AS ConsolidationUnit,
  fyp.ConsolidationProcessPeriod AS ConsolidationProcessPeriod,
  fyp.FiscalYearPeriod AS FiscalYearPeriod,
  fyp.ConsolidationProcessYearPeriod AS ConsolidationProcessYearPeriod,
  byTime.ConsolidationUnitLocalCurrency AS ConsolidationUnitLocalCurrency,
  byTimeVer.CnsldtnUnivJournalIntegType AS CnsldtnUnivJournalIntegType,
  ver.CnsldtnVersionRunMode AS CnsldtnVersionRunMode,
  ver.GroupCurrency AS GroupCurrency,
  ovw1.CnsldtnTskRunIsCnsldtnMntrRun AS CnsldtnTskRunIsCnsldtnMntrRun
FROM P_CnsldtnTskMonitorOverviewFYP AS fyp
INNER JOIN I_CnsldtnVersion AS ver ON /* join condition not captured in parsed metadata */
INNER JOIN P_CnsldtnTaskMonitorOverview01 AS ovw1 ON /* join condition not captured in parsed metadata */
;

Learn More