C_MaterialDailySubstanceVolume

DDL: C_MATERIALDAILYSUBSTANCEVOLUME Type: view_entity CONSUMPTION

Daily material substance volumes

C_MaterialDailySubstanceVolume is a Consumption CDS View that provides data about "Daily material substance volumes" in SAP S/4HANA. It reads from 1 data source (I_MaterialDailySubstanceVolume) and exposes 15 fields with key fields SVTAggregationItemUUID, SubPeriodTrackingStartDate, Material. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDailySubstanceVolume _MaterialDailySubstVol from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_LegalEntitySVTStatusMonitor _LegalEntitySVTStatusMonitor _MaterialDailySubstVol.SVTAggregationItemUUID = _LegalEntitySVTStatusMonitor.SVTAggregationItemUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Daily material substance volumes view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SVTAggregationItemUUID SVTAggregationItemUUID
KEY SubPeriodTrackingStartDate SubPeriodTrackingStartDate
KEY Material Material
LglEntityProductTotalSubstVol
ComplianceRequirement _LegalEntitySVTStatusMonitor ComplianceRequirement
SubstanceUUID _LegalEntitySVTStatusMonitor SubstanceUUID
LegalEntity _LegalEntitySVTStatusMonitor LegalEntity
SubstanceListName _LegalEntitySVTStatusMonitor SubstanceListName
SubstanceVolumeThresholdUnit _LegalEntitySVTStatusMonitor SubstanceVolumeThresholdUnit
CASNumber _LegalEntitySVTStatusMonitor CASNumber
ECNumber _LegalEntitySVTStatusMonitor ECNumber
Specification _LegalEntitySVTStatusMonitor Specification
SubstanceInternalName _LegalEntitySVTStatusMonitor SubstanceInternalName
SVTAggregationHeaderUUID SVTAggregationHeaderUUID
_LegalEntitySVTStatusMonitor _LegalEntitySVTStatusMonitor 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Daily material substance volumes'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    usageType:{
        dataClass: #MASTER,
        serviceQuality: #D,
        sizeCategory: #L
      }
}

@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
define view entity C_MaterialDailySubstanceVolume
  as select from I_MaterialDailySubstanceVolume as _MaterialDailySubstVol
  association [1..1] to C_LegalEntitySVTStatusMonitor as _LegalEntitySVTStatusMonitor on _MaterialDailySubstVol.SVTAggregationItemUUID = _LegalEntitySVTStatusMonitor.SVTAggregationItemUUID
{

  key SVTAggregationItemUUID,
  key SubPeriodTrackingStartDate,
  key Material,


      @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,
      @Semantics.text: true
      @ObjectModel: {
        readOnly: true,
        virtualElement,
        virtualElementCalculatedBy: 'ABAP:CL_EHFND_SUBSTANCE_EXIT'
      }
      //      _LegalEntitySVTStatusMonitor.SubstanceName ,

      cast( ''
        as ehfnd_sub_substance_name_ltd )               as SubstanceName,
      _LegalEntitySVTStatusMonitor.LegalEntity,

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



      //For DCL need

      SVTAggregationHeaderUUID,

      //Associations

      _LegalEntitySVTStatusMonitor
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_LEGALENTITYSVTSTATUSMONITOR",
"I_MATERIALDAILYSUBSTANCEVOLUME"
],
"ASSOCIATED":
[
"C_LEGALENTITYSVTSTATUSMONITOR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More