C_SubstanceDailySubstVol

DDL: C_SUBSTANCEDAILYSUBSTVOL Type: view_entity CONSUMPTION Package: EHPMA_SVT_CNS_RETRACKING

Daily substance volumes

C_SubstanceDailySubstVol is a Consumption CDS View that provides data about "Daily substance volumes" in SAP S/4HANA. It reads from 1 data source (I_SubstanceDailySubstVol) and exposes 19 fields with key fields SVTAggregationItemUUID, SubPeriodTrackingStartDate. It has 1 association to related views. It is exposed through 1 OData service (UI_SUBSTVOLRETRCKG_MANAGE). Part of development package EHPMA_SVT_CNS_RETRACKING.

1 data source(s) Exposed by 1 service(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_SubstanceDailySubstVol _DailySubstVol from

Associations (1)

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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Daily substance volumes view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUBSTVOLRETRCKG_MANAGE UI_SUBSTVOLRETRCKG_MANAGE V4 C1 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SVTAggregationItemUUID SVTAggregationItemUUID
KEY SubPeriodTrackingStartDate SubPeriodTrackingStartDate
SourceSubstanceUUID SourceSubstanceUUID
PolymerCompositionIntID PolymerCompositionIntID
LglEntityProductTotalSubstVol
ComplianceRequirement _LegalEntitySVTStatusMonitor ComplianceRequirement
SubstanceUUID _LegalEntitySVTStatusMonitor SubstanceUUID
SubstanceName
LegalEntity _LegalEntitySVTStatusMonitor LegalEntity
SubstanceList _LegalEntitySVTStatusMonitor SubstanceList
SubstanceListName _LegalEntitySVTStatusMonitor SubstanceListName
SubstanceVolumeThresholdUnit _LegalEntitySVTStatusMonitor SubstanceVolumeThresholdUnit
CASNumber _LegalEntitySVTStatusMonitor CASNumber
ECNumber _LegalEntitySVTStatusMonitor ECNumber
Specification _LegalEntitySVTStatusMonitor Specification
SubstanceInternalName _LegalEntitySVTStatusMonitor SubstanceInternalName
SVTAggregationHeaderUUID SVTAggregationHeaderUUID
_SVTAggregationHeader _SVTAggregationHeader
_LegalEntitySVTStatusMonitor _LegalEntitySVTStatusMonitor 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Daily substance volumes'

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{ dataClass:      #MIXED,
                         serviceQuality: #C,
                         sizeCategory:   #L }

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

  key SVTAggregationItemUUID,
  key SubPeriodTrackingStartDate,
      SourceSubstanceUUID,
      PolymerCompositionIntID,

      //parentplmrsubuuid,

      @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'
              }
      cast( '' as ehfnd_sub_substance_name_ltd )        as SubstanceName,
      _LegalEntitySVTStatusMonitor.LegalEntity,

      _LegalEntitySVTStatusMonitor.SubstanceList,
      _LegalEntitySVTStatusMonitor.SubstanceListName,
      _LegalEntitySVTStatusMonitor.SubstanceVolumeThresholdUnit,
      _LegalEntitySVTStatusMonitor.CASNumber,
      _LegalEntitySVTStatusMonitor.ECNumber,
      _LegalEntitySVTStatusMonitor.Specification,
      _LegalEntitySVTStatusMonitor.SubstanceInternalName,
      
      //For DCL need

      SVTAggregationHeaderUUID,

      //Associations

      _SVTAggregationHeader,
      _LegalEntitySVTStatusMonitor
}

Learn More