P_StkValueByType1

DDL: P_STKVALUEBYTYPE1 Type: view COMPOSITE

P_StkValueByType1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 9 fields with key fields Material, Plant, StorageLocation, InventoryStockType, InventorySpecialStockType.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord I_MaterialDocumentRecord from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PSTCKVALTYP1 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
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog: {
                sqlViewName: 'PSTCKVALTYP1',
                compiler.compareFilter: true,
                preserveKey: true
              }
@ObjectModel: {
                usageType: {
                             sizeCategory: #XXL,
                             serviceQuality: #D,
                             dataClass:#TRANSACTIONAL
                           }
             }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
        private: true,
        viewType: #COMPOSITE
      }
define view 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,
  sum(MatlStkChangeQtyInBaseUnit) as MatlWrhsStkQtyInMatlBaseUnit
}
group by StockIdentifyingMaterial, Plant, StockIdfgStorageLocation, InventoryStockType, InventorySpecialStockType, CostEstimate, MaterialBaseUnit, CompanyCode
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More