P_SlowMoMatPredConsDocRec

DDL: P_SLOWMOMATPREDCONSDOCREC SQL: PSLOWMOMATCNSPTN Type: view COMPOSITE

P_SlowMoMatPredConsDocRec is a Composite CDS View 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.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_InventoryCnsmpnGroupVH congroup cross
I_MaterialDocumentRecord rec from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSLOWMOMATCNSPTN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InventoryConsumptionGroup InventoryConsumptionGroup
KEY Material StockIdentifyingMaterial
KEY Plant Plant
KEY StorageLocation StockIdfgStorageLocation
KEY StockIdentifyingBatch StockIdentifyingBatch
KEY SpecialStockIdfgSupplier SpecialStockIdfgSupplier
KEY SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder
KEY SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem
KEY SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement
KEY SpecialStockIdfgCustomer SpecialStockIdfgCustomer
KEY SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner
KEY InventorySpecialStockType InventorySpecialStockType
KEY InventoryStockType InventoryStockType
KEY MaterialBaseUnit MaterialBaseUnit
PostingDate PostingDate
GoodsMovementType GoodsMovementType
MatlStkChangeQtyInBaseUnit MatlStkChangeQtyInBaseUnit
MatlCnsmpnQtyInMatlBaseUnit MatlCnsmpnQtyInMatlBaseUnit 
@AbapCatalog.sqlViewName: 'PSLOWMOMATCNSPTN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#NOT_REQUIRED
//@EndUserText.label: 'Stock Change and Consumption Quantity'

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

Learn More