I_SVTAggrgnLegalEntityByMonth

DDL: I_SVTAGGRGNLEGALENTITYBYMONTH SQL: ISVTBYMONTH Type: view COMPOSITE Package: EHPMA_CNS_SVT
11 Fields 3 Data Sources

Legal Entity by Month Aggregation

I_SVTAggrgnLegalEntityByMonth is a Composite CDS View that provides data about "Legal Entity by Month Aggregation" in SAP S/4HANA. It reads from 3 data sources (I_CalendarDate, I_CalendarYear, I_SVTAggrgnItmByBusProcess) and exposes 11 fields with key fields SVTAggregationItemUUID, CalendarMonth, CalendarYear, SVTBusinessProcess, CmplRqSVTScenario. Part of development package EHPMA_CNS_SVT.

Data Sources (3)

SourceAliasJoin Type
I_CalendarDate _CalendarDate inner
I_CalendarYear _CalendarYear inner
I_SVTAggrgnItmByBusProcess I_SVTAggrgnItmByBusProcess from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISVTBYMONTH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Legal Entity by Month Aggregation view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SVTAggregationItemUUID SVTAggregationItemUUID Aggr item uuid
KEY CalendarMonth I_CalendarDate CalendarMonth Calendar Month
KEY CalendarYear I_CalendarDate CalendarYear Year
KEY SVTBusinessProcess SVTBusinessProcess Business Process
KEY CmplRqSVTScenario CmplRqSVTScenario Scenario
ConfirmedSubstanceVolume
SVTAggregationHeaderUUID SVTAggregationHeaderUUID Agg header doc uuid
_SVTAggregationHeader _SVTAggregationHeader
_SVTAggregationItem _SVTAggregationItem
_CalendarMonth I_CalendarDate _CalendarMonth
_CalendarYear _CalendarYear

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 I_SVTAggrgnLegalEntityByMonth.
-- 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: ISVTBYMONTH

CREATE VIEW I_SVTAggrgnLegalEntityByMonth AS
SELECT
  SVTAggregationItemUUID,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.CalendarYear AS CalendarYear,
  SVTBusinessProcess,
  CmplRqSVTScenario,
  cast( sum(ConfirmedSubstanceVolume) as ehpma_svt_subst_vol_ui ) AS ConfirmedSubstanceVolume,
  SVTAggregationHeaderUUID,
  _CalendarDate._CalendarMonth AS _CalendarMonth
FROM I_SVTAggrgnItmByBusProcess
INNER JOIN I_CalendarDate AS _CalendarDate ON /* join condition not captured in parsed metadata */
INNER JOIN I_CalendarYear AS _CalendarYear ON /* join condition not captured in parsed metadata */
;

Learn More