C_CnsldtnUnitTP

DDL: C_CNSLDTNUNITTP Type: view_entity CONSUMPTION Package: FIN_CS_MD_UNIT
9 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

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. It is exposed through 1 OData service (UI_FINCS_CONSUNIT_DEFINE). It is used in 1 Fiori application: Define Consolidation Units. Part of development package FIN_CS_MD_UNIT.

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_FINCS_CONSUNIT_DEFINE UI_FINCS_CONSUNIT_DEFINE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4685 Define Consolidation Units Transactional An application used to create / change / display consolidation units master data.

Define Consolidation Units

Business Role: Administrator - Group Reporting

With this app, you manage the master data of consolidation units, including the assignment of time- and version-dependent attribute values, such as currency translation method, tax rate, or universal journal integration.Alternatively you can maintain this master data using the "Import Consolidation Master Data" app.For more information, see https://help.sap.com/viewer/4ebf1502064b406c964b0911adfb3f01/LATEST/en-US/a8f3c709a7f642398f1dd15de35b5320.html

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