P_SlowMoMatPredConsDocRec

DDL: P_SLOWMOMATPREDCONSDOCREC Type: view_entity COMPOSITE Package: ODATA_MM_IM_SLONOMOMAT

Stock Change and Consumption Quantity

P_SlowMoMatPredConsDocRec is a Composite CDS View that provides data about "Stock Change and Consumption Quantity" in SAP S/4HANA. It reads from 2 data sources (I_InventoryCnsmpnGroupVH, I_MaterialDocumentRecord) and exposes 18 fields with key fields InventoryConsumptionGroup, Material, Plant, StorageLocation, StockIdentifyingBatch. Part of development package ODATA_MM_IM_SLONOMOMAT.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_InventoryCnsmpnGroupVH congroup cross
I_MaterialDocumentRecord rec from

Annotations (6)

NameValueLevelField
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InventoryConsumptionGroup I_InventoryCnsmpnGroupVH InventoryConsumptionGroup
KEY Material I_MaterialDocumentRecord StockIdentifyingMaterial
KEY Plant I_MaterialDocumentRecord Plant
KEY StorageLocation I_MaterialDocumentRecord StockIdfgStorageLocation
KEY StockIdentifyingBatch I_MaterialDocumentRecord StockIdentifyingBatch
KEY SpecialStockIdfgSupplier I_MaterialDocumentRecord SpecialStockIdfgSupplier
KEY SpecialStockIdfgSalesOrder I_MaterialDocumentRecord SpecialStockIdfgSalesOrder
KEY SpecialStockIdfgSalesOrderItem I_MaterialDocumentRecord SpecialStockIdfgSalesOrderItem
KEY SpecialStockIdfgWBSElement I_MaterialDocumentRecord SpecialStockIdfgWBSElement
KEY SpecialStockIdfgCustomer I_MaterialDocumentRecord SpecialStockIdfgCustomer
KEY SpecialStockIdfgStockOwner I_MaterialDocumentRecord SpecialStockIdfgStockOwner
KEY InventorySpecialStockType I_MaterialDocumentRecord InventorySpecialStockType
KEY InventoryStockType I_MaterialDocumentRecord InventoryStockType
KEY MaterialBaseUnit I_MaterialDocumentRecord MaterialBaseUnit
PostingDate I_MaterialDocumentRecord PostingDate
GoodsMovementType I_MaterialDocumentRecord GoodsMovementType
MatlStkChangeQtyInBaseUnit I_MaterialDocumentRecord MatlStkChangeQtyInBaseUnit
MatlCnsmpnQtyInMatlBaseUnit I_MaterialDocumentRecord MatlCnsmpnQtyInMatlBaseUnit 
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#NOT_REQUIRED
//@EndUserText.label: 'Stock Change and Consumption Quantity'

define view entity P_SlowMoMatPredConsDocRec as select from  I_MaterialDocumentRecord as rec
                                          cross join  I_InventoryCnsmpnGroupVH as congroup  
                                    
{
  key congroup.InventoryConsumptionGroup,
  key rec.StockIdentifyingMaterial  as Material,
  key rec.Plant,
  key rec.StockIdfgStorageLocation  as StorageLocation, 
  key rec.StockIdentifyingBatch,
  key rec.SpecialStockIdfgSupplier,
  key rec.SpecialStockIdfgSalesOrder,
  key rec.SpecialStockIdfgSalesOrderItem,
  key rec.SpecialStockIdfgWBSElement,
  key rec.SpecialStockIdfgCustomer,
  key rec.SpecialStockIdfgStockOwner,
  key rec.InventorySpecialStockType,
  key rec.InventoryStockType,
  key rec.MaterialBaseUnit,  
      rec.PostingDate,
      rec.GoodsMovementType,
  
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  rec.MatlStkChangeQtyInBaseUnit,      
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  rec.MatlCnsmpnQtyInMatlBaseUnit 
  
}

Learn More