C_CnsldtnUnitTP

DDL: C_CNSLDTNUNITTP Type: view_entity CONSUMPTION
9 Fields 1 Data Sources

Consolidation Unit

C_CnsldtnUnitTP is a Consumption CDS View that provides data about "Consolidation Unit" in SAP S/4HANA. It reads from 1 data source (R_CnsldtnUnitTP) and exposes 9 fields with key field ConsolidationUnit.

Data Sources (1)

SourceAliasJoin Type
R_CnsldtnUnitTP R_CnsldtnUnitTP projection

Annotations (8)

NameValueLevelField
Metadata.allowExtensions false view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consolidation Unit view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnit _CnsldtnUnit ConsolidationUnit Consolidation Unit
Country _CnsldtnUnit Country Venue: Ctry/Reg
ConsolidationUnitLink _CnsldtnUnit ConsolidationUnitLink
ConsolidationUnitLinkLabel _CnsldtnUnit ConsolidationUnitLinkLabel
Company
CompanyName
ETag _CnsldtnUnit ETag Update Token
CountryNamelocalized
ConsolidationUnitTextlocalized

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_CnsldtnUnitTP.
-- 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 C_CnsldtnUnitTP AS
SELECT
  _CnsldtnUnit.ConsolidationUnit AS ConsolidationUnit,
  _CnsldtnUnit.Country AS Country,
  _CnsldtnUnit.ConsolidationUnitLink AS ConsolidationUnitLink,
  _CnsldtnUnit.ConsolidationUnitLinkLabel AS ConsolidationUnitLinkLabel,
  _CnsldtnUnit._Company.Company AS Company,
  _CnsldtnUnit._Company.CompanyName AS CompanyName,
  _CnsldtnUnit.ETag AS ETag,
  _CnsldtnUnit._Country._Text.CountryName : localized AS CountryNamelocalized,
  _CnsldtnUnit._Text.ConsolidationUnitText : localized AS ConsolidationUnitTextlocalized
FROM R_CnsldtnUnitTP
;

Learn More