I_SVTTotalAggregationToDate

DDL: I_SVTTOTALAGGREGATIONTODATE SQL: ISVTTOTALDT Type: view COMPOSITE Package: EHPMA_CNS_SVT
11 Fields 2 Data Sources

Calculation for Total Substance Volume to date

I_SVTTotalAggregationToDate is a Composite CDS View that provides data about "Calculation for Total Substance Volume to date" in SAP S/4HANA. It reads from 2 data sources (I_SVTDailyAggregation, I_SVTDailyAggregation) and exposes 11 fields with key fields SVTAggregationItemUUID, SVTBusinessProcess, Material, Plant, SubstanceUUID. Part of development package EHPMA_CNS_SVT.

Data Sources (2)

SourceAliasJoin Type
I_SVTDailyAggregation _SVTDailyAggregation inner
I_SVTDailyAggregation I_SVTDailyAggregation from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISVTTOTALDT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Calculation for Total Substance Volume to date view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SVTAggregationItemUUID I_SVTDailyAggregation SVTAggregationItemUUID Aggr item uuid
KEY SVTBusinessProcess I_SVTDailyAggregation SVTBusinessProcess Business Process
KEY Material I_SVTDailyAggregation Material Vehicle Model
KEY Plant I_SVTDailyAggregation Plant Valuation Area
KEY SubstanceUUID I_SVTDailyAggregation SubstanceUUID Substance
KEY ChmlCmplncInfoUUID I_SVTDailyAggregation ChmlCmplncInfoUUID Chemical Compliance Information PP
KEY PostingDate I_SVTDailyAggregation PostingDate Posting Date for GR
ConfdTotToDteSubstVol
ConfirmedSubstanceVolumeUnit I_SVTDailyAggregation ConfirmedSubstanceVolumeUnit Conf subst vol unit
SVTAggregationHeaderUUID I_SVTDailyAggregation SVTAggregationHeaderUUID Agg header doc uuid
_SVTAggregationHeader I_SVTDailyAggregation _SVTAggregationHeader

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_SVTTotalAggregationToDate.
-- 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: ISVTTOTALDT

CREATE VIEW I_SVTTotalAggregationToDate AS
SELECT
  I_SVTDailyAggregation.SVTAggregationItemUUID AS SVTAggregationItemUUID,
  I_SVTDailyAggregation.SVTBusinessProcess AS SVTBusinessProcess,
  I_SVTDailyAggregation.Material AS Material,
  I_SVTDailyAggregation.Plant AS Plant,
  I_SVTDailyAggregation.SubstanceUUID AS SubstanceUUID,
  I_SVTDailyAggregation.ChmlCmplncInfoUUID AS ChmlCmplncInfoUUID,
  I_SVTDailyAggregation.PostingDate AS PostingDate,
  cast ( sum(_SVTDailyAggregation.ConfirmedDailySubstanceVolume) as ehpma_svt_volume_to_date preserving type ) AS ConfdTotToDteSubstVol,
  I_SVTDailyAggregation.ConfirmedSubstanceVolumeUnit AS ConfirmedSubstanceVolumeUnit,
  I_SVTDailyAggregation.SVTAggregationHeaderUUID AS SVTAggregationHeaderUUID,
  I_SVTDailyAggregation._SVTAggregationHeader AS _SVTAggregationHeader
FROM I_SVTDailyAggregation
INNER JOIN I_SVTDailyAggregation AS _SVTDailyAggregation ON /* join condition not captured in parsed metadata */
;

Learn More