P_CnsldtnUnit_UnionByKeyText

DDL: P_CNSLDTNUNIT_UNIONBYKEYTEXT SQL: PCSCUUBYKT Type: view COMPOSITE

P_CnsldtnUnit_UnionByKeyText is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_CnsldtnGlobalParameter, I_CnsldtnGlobalSetting, I_CnsldtnUnitT, I_CnsldtnUnitText_3) and exposes 6 fields with key fields ConsolidationDimension, ConsolidationUnit, Language, ConsolidationUnit, Language.

Data Sources (4)

SourceAliasJoin Type
I_CnsldtnGlobalParameter _GlobalParameter inner
I_CnsldtnGlobalSetting _GlobalSetting inner
I_CnsldtnUnitT _Header from
I_CnsldtnUnitText_3 I_CnsldtnUnitText_3 union

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PCSCUUBYKT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey ConsolidationUnit view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationDimension I_CnsldtnUnitT ConsolidationDimension Dimension
KEY ConsolidationUnit I_CnsldtnUnitT ConsolidationUnit Consolidation Unit
KEY Language I_CnsldtnUnitT Language Report Text Language
KEY ConsolidationUnit ConsolidationUnit Consolidation Unit
KEY Language Language Report Text Language
Source

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_CnsldtnUnit_UnionByKeyText.
-- 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.
-- SQL view name: PCSCUUBYKT

CREATE VIEW P_CnsldtnUnit_UnionByKeyText AS
SELECT
  _Header.ConsolidationDimension AS ConsolidationDimension,
  _Header.ConsolidationUnit AS ConsolidationUnit,
  _Header.Language AS Language,
  cast(2 as abap.int1 ) AS Source
FROM I_CnsldtnUnitT AS _Header
INNER JOIN I_CnsldtnGlobalParameter AS _GlobalParameter ON /* join condition not captured in parsed metadata */
INNER JOIN I_CnsldtnGlobalSetting AS _GlobalSetting ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_CnsldtnUnitText_3
;