P_SLOWMOMATPREDCONSQTY

CDS View

Consumption Quantity

P_SLOWMOMATPREDCONSQTY is a CDS View in S/4HANA. Consumption Quantity. It contains 13 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 13 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_SlowMoMatPredConsSum view_entity inner COMPOSITE Consumption Aggregate
P_SlowMoMatPrMoConsSum view_entity inner COMPOSITE Consumption Aggregate

Fields (13)

KeyField CDS FieldsUsed in Views
KEY InventoryConsumptionGroup InventoryConsumptionGroup 2
KEY InventorySpecialStockType InventorySpecialStockType 1
KEY InventoryStockType InventoryStockType 1
KEY Material Material 2
KEY MaterialBaseUnit MaterialBaseUnit 2
KEY Plant Plant 2
KEY SpecialStockIdfgCustomer SpecialStockIdfgCustomer 1
KEY SpecialStockIdfgSalesOrder SpecialStockIdfgSalesOrder 1
KEY SpecialStockIdfgSalesOrderItem SpecialStockIdfgSalesOrderItem 1
KEY SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner 1
KEY SpecialStockIdfgSupplier SpecialStockIdfgSupplier 1
KEY SpecialStockIdfgWBSElement SpecialStockIdfgWBSElement 1
KEY StockIdentifyingBatch StockIdentifyingBatch 1 
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck:#NOT_REQUIRED
//@EndUserText.label: 'Consumption Quantity'

define view entity P_SlowMoMatPredConsQty as select from P_SlowMoMatPredConsDocRec  as rec
                                  left outer join I_InvtryCnsmpnMvtType      as mtyp
                                             on  rec.GoodsMovementType         = mtyp.GoodsMovementType
                                             and rec.InventoryConsumptionGroup = mtyp.InventoryConsumptionGroup

{
  key rec.InventoryConsumptionGroup as InventoryConsumptionGroup,
  key rec.Material,
  key rec.Plant,
  key rec.StorageLocation, 
  key rec.StockIdentifyingBatch,
  key rec.SpecialStockIdfgSupplier,
  key rec.SpecialStockIdfgSalesOrder,
  key rec.SpecialStockIdfgSalesOrderItem,
  key rec.SpecialStockIdfgWBSElement,
  key rec.SpecialStockIdfgCustomer,
  key rec.SpecialStockIdfgStockOwner,
  key rec.InventorySpecialStockType,
  key rec.InventoryStockType,
  key rec.MaterialBaseUnit,  
      rec.PostingDate,
      rec.GoodsMovementType,
    
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      case 
      when rec.InventoryConsumptionGroup = '000' 
           then rec.MatlCnsmpnQtyInMatlBaseUnit
      when mtyp.GoodsMovementType is not null
           then ( cast( 0 as nsdm_consumption_qty ) - rec.MatlStkChangeQtyInBaseUnit )
           else cast( 0 as nsdm_consumption_qty )
      end as MatlCnsmpnQtyInMatlBaseUnit   
  
}

Learn More