C_CnsldtnUnitValueHelp

DDL: C_CNSLDTNUNITVALUEHELP SQL: CCSUNITVH Type: view CONSUMPTION
3 Fields 2 Data Sources

Consolidation Unit Value Help

C_CnsldtnUnitValueHelp is a Consumption CDS View that provides data about "Consolidation Unit Value Help" in SAP S/4HANA. It reads from 2 data sources (I_CnsldtnGlobalParameter, I_CnsldtnUnit) and exposes 3 fields with key field ConsolidationUnit.

Data Sources (2)

SourceAliasJoin Type
I_CnsldtnGlobalParameter _GlobalParameter inner
I_CnsldtnUnit _Header from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCSUNITVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.semanticKey ConsolidationUnit view
ObjectModel.representativeKey ConsolidationUnit view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consolidation Unit Value Help view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnit I_CnsldtnUnit ConsolidationUnit Consolidation Unit
ConsolidationDimension I_CnsldtnUnit ConsolidationDimension Consolidation Dimension
ConsolidationUnitText Consolidation Unit Description

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_CnsldtnUnitValueHelp.
-- 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: CCSUNITVH

CREATE VIEW C_CnsldtnUnitValueHelp AS
SELECT
  _Header.ConsolidationUnit AS ConsolidationUnit,
  _Header.ConsolidationDimension AS ConsolidationDimension,
  _Text[1: Language=$session.system_language].ConsolidationUnitText AS ConsolidationUnitText
FROM I_CnsldtnUnit AS _Header
INNER JOIN I_CnsldtnGlobalParameter AS _GlobalParameter ON /* join condition not captured in parsed metadata */
;

Learn More