C_CnsldtnUnitTextTP

DDL: C_CNSLDTNUNITTEXTTP Type: view_entity CONSUMPTION
7 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Consolidation Unit Text

C_CnsldtnUnitTextTP is a Consumption CDS View that provides data about "Consolidation Unit Text" in SAP S/4HANA. It reads from 1 data source (R_CnsldtnUnitTextTP) and exposes 7 fields with key fields Language, ConsolidationUnit. It is exposed through 1 OData service (UI_FINCS_CONSUNIT_DEFINE). It is used in 1 Fiori application: Define Consolidation Units.

Data Sources (1)

SourceAliasJoin Type
R_CnsldtnUnitTextTP R_CnsldtnUnitTextTP 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 Text 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 (7)

KeyFieldSource TableSource FieldDescription
KEY Language _CnsldtnUnitText Language Report Text Language
KEY ConsolidationUnit _CnsldtnUnitText ConsolidationUnit Consolidation Unit
ConsolidationUnitText _CnsldtnUnitText ConsolidationUnitText
ConsolidationUnitMdmText _CnsldtnUnitText ConsolidationUnitMdmText
ConsolidationUnitLongText _CnsldtnUnitText ConsolidationUnitLongText
ETag _CnsldtnUnitText ETag Update Token
LanguageNamelocalized

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_CnsldtnUnitTextTP.
-- 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_CnsldtnUnitTextTP AS
SELECT
  _CnsldtnUnitText.Language AS Language,
  _CnsldtnUnitText.ConsolidationUnit AS ConsolidationUnit,
  _CnsldtnUnitText.ConsolidationUnitText AS ConsolidationUnitText,
  _CnsldtnUnitText.ConsolidationUnitMdmText AS ConsolidationUnitMdmText,
  _CnsldtnUnitText.ConsolidationUnitLongText AS ConsolidationUnitLongText,
  _CnsldtnUnitText.ETag AS ETag,
  _CnsldtnUnitText._Language._Text.LanguageName : localized AS LanguageNamelocalized
FROM R_CnsldtnUnitTextTP
;

Learn More