C_MatlDocsByMonthAndBusProcess

DDL: C_MATLDOCSBYMONTHANDBUSPROCESS SQL: CMATDOCMNTHBUSPR Type: view CONSUMPTION

C_MatlDocsByMonthAndBusProcess is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_MatlDocsByMonthAndBusProcess) and exposes 24 fields with key fields SVTAggregationItemUUID, CalendarMonth, SVTBusinessProcess, CmplRqSVTScenario, SVTPreprocessedDocumentUUID. It has 2 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_MatlDocsByMonthAndBusProcess I_MatlDocsByMonthAndBusProcess from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _UnitOfMeasureMass $projection.QuantityUnit = _UnitOfMeasureMass.UnitOfMeasure
[1..1] C_Product _Product $projection.Material = _Product.Product

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMATDOCMNTHBUSPR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY SVTAggregationItemUUID SVTAggregationItemUUID
KEY CalendarMonth CalendarMonth
KEY SVTBusinessProcess SVTBusinessProcess
KEY CmplRqSVTScenario CmplRqSVTScenario
KEY SVTPreprocessedDocumentUUID SVTPreprocessedDocumentUUID
KEY ChmlCmplncInfoUUID ChmlCmplncInfoUUID
MaterialDocument MaterialDocument
Material Material
ProductDescription _Product ProductDescription
Quantity Quantity
QuantityUnit QuantityUnit
Plant Plant
MaterialDocumentItem MaterialDocumentItem
MaterialDocumentYear MaterialDocumentYear
CalculatedSubstanceVolume CalculatedSubstanceVolume
SubstanceVolumeUnit
PostingDate PostingDate
CreationTime CreationTime
ApplicationLogHandle ApplicationLogHandle
SVTAggregationHeaderUUID SVTAggregationHeaderUUID
_CalendarMonth _CalendarMonth
_SVTAggregationItem _SVTAggregationItem
_SVTAggregationHeader _SVTAggregationHeader
_UnitOfMeasureMass _UnitOfMeasureMass 
@AbapCatalog.sqlViewName: 'CMATDOCMNTHBUSPR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking
@VDM.viewType: #CONSUMPTION

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

@Metadata.allowExtensions: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.semanticKey: ['MaterialDocument', 'MaterialDocumentYear', 'MaterialDocumentItem' ]
define view C_MatlDocsByMonthAndBusProcess
  as select from I_MatlDocsByMonthAndBusProcess
  association [1..1] to I_UnitOfMeasure as _UnitOfMeasureMass on $projection.QuantityUnit = _UnitOfMeasureMass.UnitOfMeasure
  association [1..1] to C_Product as _Product on $projection.Material = _Product.Product
{
      //I_MatlDocsByMonthAndBusProcess

  key SVTAggregationItemUUID,
  key CalendarMonth,
  key SVTBusinessProcess,
  key CmplRqSVTScenario,
  key SVTPreprocessedDocumentUUID,
  key ChmlCmplncInfoUUID,

      MaterialDocument,
      Material,
      _Product.ProductDescription,
      @GenericPersistency.format:{
        displayTemplate: 'CalculatedSubstanceVolume'
      }
      @Semantics.quantity.unitOfMeasure: 'SubstanceVolumeUnit'
      Quantity,
      @Semantics.unitOfMeasure: true
      QuantityUnit,
      Plant,
      MaterialDocumentItem,
      MaterialDocumentYear,

      @Semantics.quantity.unitOfMeasure: 'SubstanceVolumeUnit'
      CalculatedSubstanceVolume,

      @Semantics.unitOfMeasure: true
      _UnitOfMeasureMass._Text[1:Language = $session.system_language].UnitOfMeasure as SubstanceVolumeUnit,

      PostingDate,
      CreationTime,
      
      ApplicationLogHandle,
      //For DCL need

      SVTAggregationHeaderUUID,

      //Associations

      _CalendarMonth,
      _SVTAggregationItem,
      _SVTAggregationHeader,
      _UnitOfMeasureMass
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_PRODUCT",
"I_MATLDOCSBYMONTHANDBUSPROCESS",
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT"
],
"ASSOCIATED":
[
"C_PRODUCT",
"I_CALENDARMONTH",
"I_SVTAGGREGATIONHEADER",
"I_SVTAGGREGATIONITEM",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_MATLDOCSBYMONTHANDBUSPROCESS"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More