I_MATLDOCSBYMONTHANDBUSPROCESS

CDS View

Mat Doc Info By Month and Bus Process

I_MATLDOCSBYMONTHANDBUSPROCESS is a CDS View in S/4HANA. Mat Doc Info By Month and Bus Process. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MatlDocsByMonthAndBusProcess view from CONSUMPTION 
@AbapCatalog.sqlViewName: 'IMATBYMONTHBP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Mat Doc Info By Month and Bus Process'

@VDM.viewType: #COMPOSITE

@ObjectModel: {
    usageType:{
        dataClass: #MIXED,
        serviceQuality: #D,
        sizeCategory: #L
      }
}

@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_MatlDocsByMonthAndBusProcess
  as select from I_SVTAggrgnItmByBusProcess
    inner join   I_SVTCalculationItemAggrgn on I_SVTAggrgnItmByBusProcess.SVTAggrgnItmByBusProcUUID = I_SVTCalculationItemAggrgn.SVTAggrgnItmByBusProcUUID
    inner join   I_SVTCalculationHeader     on I_SVTCalculationItemAggrgn.SVTCalculationHeaderUUID = I_SVTCalculationHeader.SVTCalculationHeaderUUID
    inner join   I_SVTPreprocessedDocuments on I_SVTCalculationHeader.SVTPreprocessedDocumentUUID = I_SVTPreprocessedDocuments.SVTPreprocessedDocumentUUID
    inner join   I_CalendarDate             on I_SVTAggrgnItmByBusProcess.SubPeriodTrackingStartDate = I_CalendarDate.CalendarDate
  {
  key SVTAggregationItemUUID,
  key CalendarMonth,
  key SVTBusinessProcess,
  key CmplRqSVTScenario,
  key I_SVTPreprocessedDocuments.SVTPreprocessedDocumentUUID,
  key I_SVTAggrgnItmByBusProcess.ChmlCmplncInfoUUID,

      MaterialDocument,
      I_SVTPreprocessedDocuments.Material,
      I_SVTPreprocessedDocuments.Quantity,
      
      I_SVTPreprocessedDocuments.QuantityUnit,
      MaterialDocumentItem,
      MaterialDocumentYear,
      I_SVTPreprocessedDocuments.Plant,
      @Semantics.quantity.unitOfMeasure: 'substancevolumeunit'
      cast( CalculatedSubstanceVolume as ehpma_svt_subst_vol_ui ) as CalculatedSubstanceVolume,
      SubstanceVolumeUnit,
      PostingDate,
      CreationTime,
      ApplicationLogHandle,

      //For DCL need

      SVTAggregationHeaderUUID,

      // Associations

      _CalendarMonth,
      _SVTAggregationItem,
      _SVTAggregationHeader
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_SVTAGGRGNITMBYBUSPROCESS",
"I_SVTCALCULATIONHEADER",
"I_SVTCALCULATIONITEMAGGRGN",
"I_SVTPREPROCESSEDDOCUMENTS"
],
"ASSOCIATED":
[
"I_CALENDARMONTH",
"I_SVTAGGREGATIONHEADER",
"I_SVTAGGREGATIONITEM"
],
"BASE":
[
"I_CALENDARDATE",
"I_SVTAGGRGNITMBYBUSPROCESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More