C_SubstChmlCmpstnSubstVol

DDL: C_SUBSTCHMLCMPSTNSUBSTVOL Type: view_entity CONSUMPTION

Substance Based Composition Substance Volumes

C_SubstChmlCmpstnSubstVol is a Consumption CDS View that provides data about "Substance Based Composition Substance Volumes" in SAP S/4HANA. It reads from 1 data source (I_SubstChmlCmpstnSubstVol) and exposes 24 fields with key fields SVTAggregationItemUUID, ChmlCmplncInfoUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_SUBSTVOLRETRCKG_MANAGE).

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

Data Sources (1)

SourceAliasJoin Type
I_SubstChmlCmpstnSubstVol _SubstChmlCmpstnSubstVol from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Substance Based Composition 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

OData Services (1)

ServiceBindingVersionContractRelease
UI_SUBSTVOLRETRCKG_MANAGE UI_SUBSTVOLRETRCKG_MANAGE V4 C1 NOT_RELEASED

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SVTAggregationItemUUID SVTAggregationItemUUID
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
LglEntityProductTotalSubstVol
ComplianceRequirement _LegalEntitySVTStatusMonitor ComplianceRequirement
SubstanceUUID _LegalEntitySVTStatusMonitor SubstanceUUID
SubstanceName _LegalEntitySVTStatusMonitor SubstanceName
LegalEntity _LegalEntitySVTStatusMonitor LegalEntity
CmplRqVersTrackingPeriodText _LegalEntitySVTStatusMonitor CmplRqVersTrackingPeriodText
TrackingPeriodStartDate _LegalEntitySVTStatusMonitor TrackingPeriodStartDate
TrackingPeriodEndDate _LegalEntitySVTStatusMonitor TrackingPeriodEndDate
TrackingPeriodType _LegalEntitySVTStatusMonitor TrackingPeriodType
SubstanceList _LegalEntitySVTStatusMonitor SubstanceList
SubstanceListName _LegalEntitySVTStatusMonitor SubstanceListName
SubstanceVolumeThresholdUnit _LegalEntitySVTStatusMonitor SubstanceVolumeThresholdUnit
LglEntitySubstVolThldReachUnit _LegalEntitySVTStatusMonitor LglEntitySubstVolThldReachUnit
LglEntitySubstVolThldReachPct _LegalEntitySVTStatusMonitor LglEntitySubstVolThldReachPct
ProdAllocPercentUnit _LegalEntitySVTStatusMonitor ProdAllocPercentUnit
CmplRqSVTStatusCriticality _LegalEntitySVTStatusMonitor CmplRqSVTStatusCriticality
CASNumber _LegalEntitySVTStatusMonitor CASNumber
ECNumber _LegalEntitySVTStatusMonitor ECNumber
Specification _LegalEntitySVTStatusMonitor Specification
SubstanceInternalName _LegalEntitySVTStatusMonitor SubstanceInternalName
SVTAggregationHeaderUUID SVTAggregationHeaderUUID
_LegalEntitySVTStatusMonitor _LegalEntitySVTStatusMonitor 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Substance Based Composition Substance Volumes'
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    usageType:{
        dataClass: #MASTER,
        serviceQuality: #D,
        sizeCategory: #L
      }
}

@Metadata.allowExtensions: true

define view entity C_SubstChmlCmpstnSubstVol
  as select from I_SubstChmlCmpstnSubstVol as _SubstChmlCmpstnSubstVol
  association [1..1] to C_LegalEntitySVTStatusMonitor  as _LegalEntitySVTStatusMonitor  on  _SubstChmlCmpstnSubstVol.SVTAggregationItemUUID = _LegalEntitySVTStatusMonitor.SVTAggregationItemUUID
{
  key SVTAggregationItemUUID,
  key ChmlCmplncInfoUUID,
      
      @Semantics.quantity.unitOfMeasure: 'SubstanceVolumeThresholdUnit'
      PlannedSubstanceVolume + ConfirmedSubstanceVolume as LglEntityProductTotalSubstVol,
      
//      // 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.CmplRqVersTrackingPeriodText,
      _LegalEntitySVTStatusMonitor.TrackingPeriodStartDate,
      _LegalEntitySVTStatusMonitor.TrackingPeriodEndDate,
      _LegalEntitySVTStatusMonitor.TrackingPeriodType,
      _LegalEntitySVTStatusMonitor.SubstanceList,
      _LegalEntitySVTStatusMonitor.SubstanceListName,
      _LegalEntitySVTStatusMonitor.SubstanceVolumeThresholdUnit,
      _LegalEntitySVTStatusMonitor.LglEntitySubstVolThldReachUnit,
      _LegalEntitySVTStatusMonitor.LglEntitySubstVolThldReachPct,
      _LegalEntitySVTStatusMonitor.ProdAllocPercentUnit,
      _LegalEntitySVTStatusMonitor.CmplRqSVTStatusCriticality,
      _LegalEntitySVTStatusMonitor.CASNumber,
      _LegalEntitySVTStatusMonitor.ECNumber,
      _LegalEntitySVTStatusMonitor.Specification,
      _LegalEntitySVTStatusMonitor.SubstanceInternalName,
      
      //For DCL need

      SVTAggregationHeaderUUID,

      //Associations

      _LegalEntitySVTStatusMonitor
}

Learn More