I_MATLCHMLCMPSTNDAILYSUBSTVOL

CDS View

Daily material based composition substance volumes

I_MATLCHMLCMPSTNDAILYSUBSTVOL is a CDS View in S/4HANA. Daily material based composition substance volumes. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MatlChmlCmpstnDailySubstVol view_entity from CONSUMPTION Material Based Composition Daily Substance Volumes 
@EndUserText.label: 'Daily material based composition substance volumes'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory:   #L,
                         dataClass:      #MASTER }
@VDM: {
  viewType: #COMPOSITE
}
define view entity I_MatlChmlCmpstnDailySubstVol
  as select from I_SVTAggrgnItmByBusProcess
{
  key    SVTAggregationItemUUID,
  key    ChmlCmplncInfoUUID,
  key    SubPeriodTrackingStartDate,
  
         @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
}
where
     SVTBusinessProcess = 'PRO'
group by
  SVTAggregationItemUUID,
  ChmlCmplncInfoUUID,
  SubPeriodTrackingStartDate,
  SVTAggregationHeaderUUID, // Only needed so that the DCL can use it.

  ConfirmedSubstanceVolumeUnit,
  PlannedSubstanceVolumeUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SVTAGGRGNITMBYBUSPROCESS"
],
"ASSOCIATED":
[
"I_SVTAGGREGATIONHEADER",
"I_SVTAGGREGATIONITEM"
],
"BASE":
[
"I_SVTAGGRGNITMBYBUSPROCESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More