C_MatlChmlCmpstnDailySubstVol

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Based Composition Daily Substance Volumes'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    usageType:{
        dataClass: #MASTER,
        serviceQuality: #D,
        sizeCategory: #L
      }
}

@Metadata.allowExtensions: true

define view entity C_MatlChmlCmpstnDailySubstVol
  as select from I_MatlChmlCmpstnDailySubstVol as _MatlChmlCmpstnSubstVol
  association [1..1] to C_LegalEntitySVTStatusMonitor as _LegalEntitySVTStatusMonitor on _MatlChmlCmpstnSubstVol.SVTAggregationItemUUID = _LegalEntitySVTStatusMonitor.SVTAggregationItemUUID
{
  key SVTAggregationItemUUID,
  key ChmlCmplncInfoUUID,
  key SubPeriodTrackingStartDate,
  
      @Semantics.quantity.unitOfMeasure: 'SubstanceVolumeThresholdUnit'
      PlannedSubstanceVolume + ConfirmedSubstanceVolume                                 as LglEntityProductTotalSubstVol,

//      cast( SubPeriodTrackingStartDate as ehpma_svt_daily_volume_date preserving type ) as SubPeriodTrackingStartDate,


      //      // For Header information

      _LegalEntitySVTStatusMonitor.ComplianceRequirement,
      // Substance UUID is needed so that the virtual element SubstanceName can be caluclated correctly.

      _LegalEntitySVTStatusMonitor.SubstanceUUID,
      _LegalEntitySVTStatusMonitor.SubstanceName,
      _LegalEntitySVTStatusMonitor.LegalEntity,

      _LegalEntitySVTStatusMonitor.SubstanceList,
      _LegalEntitySVTStatusMonitor.SubstanceListName,
      _LegalEntitySVTStatusMonitor.SubstanceVolumeThresholdUnit,
      _LegalEntitySVTStatusMonitor.CASNumber,
      _LegalEntitySVTStatusMonitor.ECNumber,
      _LegalEntitySVTStatusMonitor.Specification,
      _LegalEntitySVTStatusMonitor.SubstanceInternalName,

      //For DCL need

      SVTAggregationHeaderUUID,

      //Associations

      _LegalEntitySVTStatusMonitor
}