C_CnsldtnUnitValueHelp_2

DDL: C_CNSLDTNUNITVALUEHELP_2 SQL: CCSUNITVH2 Type: view CONSUMPTION Package: FIN_CS_MD_UNIT
2 Fields 1 Data Sources 8 OData Services

Consolidation Unit Value Help

C_CnsldtnUnitValueHelp_2 is a Consumption CDS View that provides data about "Consolidation Unit Value Help" in SAP S/4HANA. It reads from 1 data source (P_CnsldtnUnit_Combined) and exposes 2 fields with key field ConsolidationUnit. It is exposed through 8 OData services (ASQL_F2573, ASQL_F2653, ASQL_F2971, ...). Part of development package FIN_CS_MD_UNIT.

Data Sources (1)

SourceAliasJoin Type
P_CnsldtnUnit_Combined P_CnsldtnUnit_Combined from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CCSUNITVH2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 #D view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consolidation Unit Value Help view

OData Services (8)

ServiceBindingVersionContractRelease
ASQL_F2573 ASQL_F2573 C2 NOT_RELEASED
ASQL_F2653 ASQL_F2653 C2 NOT_RELEASED
ASQL_F2971 ASQL_F2971 C2 NOT_RELEASED
ASQL_F3831 ASQL_F3831 C2 NOT_RELEASED
ASQL_F6164 ASQL_F6164 C2 NOT_RELEASED
ASQL_F7093 ASQL_F7093 C2 NOT_RELEASED
ASQL_F8364 ASQL_F8364 C2 NOT_RELEASED
ASQL_F8365 ASQL_F8365 C2 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnit ConsolidationUnit Consolidation Unit
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_2.
-- 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: CCSUNITVH2

CREATE VIEW C_CnsldtnUnitValueHelp_2 AS
SELECT
  ConsolidationUnit,
  _Text[1: Language=$session.system_language].ConsolidationUnitText AS ConsolidationUnitText
FROM P_CnsldtnUnit_Combined
;

Learn More