P_MPE_MaterialStorageLocStkQty

DDL: P_MPE_MATERIALSTORAGELOCSTKQTY Type: view_entity CONSUMPTION

Stock qty for Material in Stor Loc level

P_MPE_MaterialStorageLocStkQty is a Consumption CDS View that provides data about "Stock qty for Material in Stor Loc level" in SAP S/4HANA. It reads from 1 data source (I_MaterialStock) and exposes 10 fields with key fields Material, Plant, StorageLocation.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialStock I_MaterialStock from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Stock qty for Material in Stor Loc level view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY StorageLocation StorageLocation
MaterialBaseUnit MaterialBaseUnit
UnrestrinctedStock
QualityInspectionStock
StockInTrsferrStgeLoc
StockInTrsferrPlant
RestricktedUserStock
BlockedStock 
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@EndUserText.label: 'Stock qty for Material in Stor Loc level'
define view entity P_MPE_MaterialStorageLocStkQty as select from I_MaterialStock
{
key  Material   ,
key  Plant      ,
key StorageLocation,
  MaterialBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  cast(sum(case InventoryStockType when '01' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as nsdm_stock_qty ) as UnrestrinctedStock,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  cast(sum(case InventoryStockType when '02' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as nsdm_stock_qty ) as QualityInspectionStock,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  cast(sum(case InventoryStockType when '04' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as nsdm_stock_qty ) as StockInTrsferrStgeLoc,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  cast(sum(case InventoryStockType when '05' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as nsdm_stock_qty ) as StockInTrsferrPlant,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  cast(sum(case InventoryStockType when '08' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as nsdm_stock_qty ) as RestricktedUserStock,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  cast(sum(case InventoryStockType when '07' then MatlWrhsStkQtyInMatlBaseUnit else 0 end) as nsdm_stock_qty ) as BlockedStock

}
where (InventoryStockType = '01' or InventoryStockType = '02' or InventoryStockType = '04' or InventoryStockType = '08' or InventoryStockType = '07' or InventoryStockType = '05') 
  and (InventorySpecialStockType = '')
group by
Material,
Plant,
StorageLocation,
MaterialBaseUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALSTOCK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More