P_StkValueByType1

DDL: P_STKVALUEBYTYPE1 Type: view_entity COMPOSITE Package: MM_IM_VDM_STOCK

'Stock value by type level 1

P_StkValueByType1 is a Composite CDS View that provides data about "'Stock value by type level 1" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 9 fields with key fields Material, Plant, StorageLocation, InventoryStockType, InventorySpecialStockType. Part of development package MM_IM_VDM_STOCK.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Annotations (6)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material StockIdentifyingMaterial
KEY Plant Plant
KEY StorageLocation StockIdfgStorageLocation
KEY InventoryStockType InventoryStockType
KEY InventorySpecialStockType InventorySpecialStockType
KEY CostEstimate CostEstimate
KEY MaterialBaseUnit MaterialBaseUnit
KEY CompanyCode CompanyCode
MatlWrhsStkQtyInMatlBaseUnit 
@ObjectModel: {
                usageType: {
                             sizeCategory: #XXL,
                             serviceQuality: #D,
                             dataClass:#TRANSACTIONAL
                           }
             }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
        private: true,
        viewType: #COMPOSITE
      }
define view entity P_StkValueByType1 as
select from I_MaterialDocumentRecord
{
  key StockIdentifyingMaterial as Material,
  key Plant,
  key StockIdfgStorageLocation as StorageLocation,
  key InventoryStockType,
  key InventorySpecialStockType, 
  key CostEstimate,
  key MaterialBaseUnit,
  key CompanyCode,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  sum(MatlStkChangeQtyInBaseUnit) as MatlWrhsStkQtyInMatlBaseUnit
}
group by StockIdentifyingMaterial, Plant, StockIdfgStorageLocation, InventoryStockType, InventorySpecialStockType, CostEstimate, MaterialBaseUnit, CompanyCode

Learn More