P_SlowMoMatPredMatDocRec

DDL: P_SLOWMOMATPREDMATDOCREC SQL: PSLOWMOMATDOCREC Type: view COMPOSITE

P_SlowMoMatPredMatDocRec is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 18 fields with key fields Material, Plant, StorageLocation, StockIdentifyingBatch, SpecialStockIdfgSupplier.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Parameters (1)

NameTypeDefault
P_InventoryConsumptionGroup inventory_consumption_group

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSLOWMOMATDOCREC 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 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
InventoryConsumptionGroup 
@AbapCatalog.sqlViewName: 'PSLOWMOMATDOCREC'
@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: 'Material Document Records'

define view P_SlowMoMatPredMatDocRec with parameters  P_InventoryConsumptionGroup: inventory_consumption_group

 as select from I_MaterialDocumentRecord
 
{
   
  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,
      
      cast ($parameters.P_InventoryConsumptionGroup as inventory_consumption_group preserving type ) as InventoryConsumptionGroup
       
}

Learn More