E_CnsldtnUnitByTimeVersion

DDL: E_CNSLDTNUNITBYTIMEVERSION SQL: ECSCONSUNITATVD Type: view EXTENSION
4 Fields 1 Data Sources

Consolidation Unit by Time and Version - Extension

E_CnsldtnUnitByTimeVersion is a Extension CDS View that provides data about "Consolidation Unit by Time and Version - Extension" in SAP S/4HANA. It reads from 1 data source (fincs_bunit_atvd) and exposes 4 fields with key fields ConsolidationUnit, CnsldtnUnitAttributeVersion, FromFiscalYearPeriod.

Data Sources (1)

SourceAliasJoin Type
fincs_bunit_atvd Persistence from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ECSCONSUNITATVD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #EXTENSION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Consolidation Unit by Time and Version - Extension view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationUnit fincs_bunit_atvd bunit Consolidation Unit
KEY CnsldtnUnitAttributeVersion fincs_bunit_atvd cuavs CU Attributes
KEY FromFiscalYearPeriod
ToFiscalYearPeriod

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 E_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.
-- SQL view name: ECSCONSUNITATVD

CREATE VIEW E_CnsldtnUnitByTimeVersion AS
SELECT
  Persistence.bunit AS ConsolidationUnit,
  Persistence.cuavs AS CnsldtnUnitAttributeVersion,
  cast (Persistence.fromyearper as fins_fyearperiod) AS FromFiscalYearPeriod,
  cast (Persistence.toyearper as fins_fyearperiod) AS ToFiscalYearPeriod
FROM fincs_bunit_atvd AS Persistence
;

Learn More