I_SUBSTANCEDAILYSUBSTVOL

CDS View

Daily substance volumes

I_SUBSTANCEDAILYSUBSTVOL is a CDS View in S/4HANA. Daily substance volumes. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SubstanceDailySubstVol view_entity from CONSUMPTION Daily substance volumes 
@EndUserText.label: 'Daily substance volumes'
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory:   #L,
                         dataClass:      #TRANSACTIONAL }
@VDM: {
  viewType: #COMPOSITE
}
define view entity I_SubstanceDailySubstVol
  as select from I_SVTAggrgnItmByBusProcess                                                     
{
  key    SVTAggregationItemUUID,
  key    SubstanceUUID,
  key    SubPeriodTrackingStartDate,
  key    ChmlCmplncInfoUUID,
  key    PolymerCompositionIntID,
  key    SourceSubstanceUUID,
  
         @Semantics.quantity.unitOfMeasure: 'ConfirmedSubstanceVolumeUnit'
         cast( sum(ConfirmedSubstanceVolume) as ehpma_svt_subst_vol_ui ) as ConfirmedSubstanceVolume, -- OData 2 service definition doesn't support dec34 that is why casting
         ConfirmedSubstanceVolumeUnit,

         @Semantics.quantity.unitOfMeasure: 'PlannedSubstanceVolumeUnit'
         cast( sum(PlannedSubstanceVolume) as ehpma_svt_subst_vol_ui )   as PlannedSubstanceVolume, -- OData 2 service definition doesn't support dec34 that is why casting
         PlannedSubstanceVolumeUnit,
         
         //For DCL need

         SVTAggregationHeaderUUID,

         //Associations

         _SVTAggregationHeader,
         _SVTAggregationItem
}
group by
  SVTAggregationItemUUID,
  SubstanceUUID,
  SubPeriodTrackingStartDate,
  ChmlCmplncInfoUUID,
  PolymerCompositionIntID,
  SourceSubstanceUUID,
  SVTAggregationHeaderUUID, // Only needed so that the DCL can use it.

  ConfirmedSubstanceVolumeUnit,
  PlannedSubstanceVolumeUnit

Learn More