A_CnsldtnUnitByTimeVersion

DDL: A_CNSLDTNUNITBYTIMEVERSION Type: view_entity COMPOSITE
17 Fields 1 Data Sources

Consolidation Unit by Time and Version

A_CnsldtnUnitByTimeVersion is a Composite CDS View that provides data about "Consolidation Unit by Time and Version" in SAP S/4HANA. It reads from 1 data source (R_CnsldtnUnitByTimeVersionTP) and exposes 17 fields with key fields ConsolidationUnit, ConsolidationVersion, FromFiscalYearPeriod.

Data Sources (1)

SourceAliasJoin Type
R_CnsldtnUnitByTimeVersionTP R_CnsldtnUnitByTimeVersionTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Consolidation Unit by Time and Version view
OData.entitySet.name ConsolidationUnitByTimeVersion view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnit _Source ConsolidationUnit Consolidation Unit
KEY ConsolidationVersion _Source ConsolidationVersion Version
KEY FromFiscalYearPeriod _Source FromFiscalYearPeriod
ToFiscalYearPeriod _Source ToFiscalYearPeriod
ConsolidationUnitIsPartnerOnly _Source ConsolidationUnitIsPartnerOnly
CnsldtnCrcyTranslationMethod _Source CnsldtnCrcyTranslationMethod
TaxRate _Source TaxRate Tax Rate
FiscalYearVariant _Source FiscalYearVariant FY Variant
CnsldtnDataTransferMethod _Source CnsldtnDataTransferMethod
DocumentEntryIsInGroupCurrency _Source DocumentEntryIsInGroupCurrency
CnsldtnUnitLocalCrcySource _Source CnsldtnUnitLocalCrcySource
CnsldtnUnitGroupCrcySource _Source CnsldtnUnitGroupCrcySource
CnsldtnUploadMethod _Source CnsldtnUploadMethod
CnsldtnUnitDataCollection _Source CnsldtnUnitDataCollection
ConsolidationUnitPartner _Source ConsolidationUnitPartner
ConsolidationUnitPostingRule _Source ConsolidationUnitPostingRule
ConsolidationUnitValidation _Source ConsolidationUnitValidation

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 A_CnsldtnUnitByTimeVersion.
-- 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 A_CnsldtnUnitByTimeVersion AS
SELECT
  _Source.ConsolidationUnit AS ConsolidationUnit,
  _Source.ConsolidationVersion AS ConsolidationVersion,
  _Source.FromFiscalYearPeriod AS FromFiscalYearPeriod,
  _Source.ToFiscalYearPeriod AS ToFiscalYearPeriod,
  _Source.ConsolidationUnitIsPartnerOnly AS ConsolidationUnitIsPartnerOnly,
  _Source.CnsldtnCrcyTranslationMethod AS CnsldtnCrcyTranslationMethod,
  _Source.TaxRate AS TaxRate,
  _Source.FiscalYearVariant AS FiscalYearVariant,
  _Source.CnsldtnDataTransferMethod AS CnsldtnDataTransferMethod,
  _Source.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  _Source.CnsldtnUnitLocalCrcySource AS CnsldtnUnitLocalCrcySource,
  _Source.CnsldtnUnitGroupCrcySource AS CnsldtnUnitGroupCrcySource,
  _Source.CnsldtnUploadMethod AS CnsldtnUploadMethod,
  _Source.CnsldtnUnitDataCollection AS CnsldtnUnitDataCollection,
  _Source.ConsolidationUnitPartner AS ConsolidationUnitPartner,
  _Source.ConsolidationUnitPostingRule AS ConsolidationUnitPostingRule,
  _Source.ConsolidationUnitValidation AS ConsolidationUnitValidation
FROM R_CnsldtnUnitByTimeVersionTP
;

Learn More