P_SLOWMOMATPREDSTOCKFLOAT

CDS View

P_SLOWMOMATPREDSTOCKFLOAT is a CDS View in S/4HANA. It contains 13 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 13 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SlowMoMatPredStockDelta view from COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY CalendarMonth CalendarMonth 1
KEY InventorySpecialStockType InventorySpecialStockType 1
KEY InventoryStockType InventoryStockType 1
KEY Material Material 1
KEY MaterialBaseUnit MaterialBaseUnit 1
KEY Plant Plant 1
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 
@AbapCatalog.sqlViewName: 'PSLOWMOMATSFLOAT'
@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: 'Float Values for Calculation'

define view P_SlowMoMatPredStockFloat as select from P_SlowMoMatPredStockDates
                                             
{

  key cast(left(right(StartDate, 4), 2) as nsdm_month) as CalendarMonth,
        
  key Material,
  key Plant,
  key StockIdentifyingBatch,
  key SpecialStockIdfgSupplier,
  key SpecialStockIdfgSalesOrder,
  key SpecialStockIdfgSalesOrderItem,
  key SpecialStockIdfgWBSElement,
  key SpecialStockIdfgCustomer,
  key SpecialStockIdfgStockOwner,
  key InventorySpecialStockType,
  key InventoryStockType,
  key MaterialBaseUnit,    
  
  // Stocks  

  cast(StockQtyM1 as nsdm_stock_quantity) as StockQtyM1,
  cast(StockQtyM2 as nsdm_stock_quantity) as StockQtyM2,
  cast(StockQtyM3 as nsdm_stock_quantity) as StockQtyM3,
  cast(StockQtyM4 as nsdm_stock_quantity) as StockQtyM4,  
  cast(StockQtyM5 as nsdm_stock_quantity) as StockQtyM5,
  cast(StockQtyM6 as nsdm_stock_quantity) as StockQtyM6,
  cast(StockQtyM7 as nsdm_stock_quantity) as StockQtyM7,

  cast(StockQtyM1 as float) as StockQtyFloatM1,
  cast(StockQtyM2 as float) as StockQtyFloatM2,
  cast(StockQtyM3 as float) as StockQtyFloatM3,
  cast(StockQtyM4 as float) as StockQtyFloatM4,
  cast(StockQtyM5 as float) as StockQtyFloatM5,
  cast(StockQtyM6 as float) as StockQtyFloatM6,
  
  // Stock Delta Month - Previous Month  

  cast(StockQtyM2 - StockQtyM1 as nsdm_stock_quantity) as StockDeltaM2M1,
  cast(StockQtyM3 - StockQtyM2 as nsdm_stock_quantity) as StockDeltaM3M2,   
  cast(StockQtyM4 - StockQtyM3 as nsdm_stock_quantity) as StockDeltaM4M3, 
  cast(StockQtyM5 - StockQtyM4 as nsdm_stock_quantity) as StockDeltaM5M4,   
  cast(StockQtyM6 - StockQtyM5 as nsdm_stock_quantity) as StockDeltaM6M5, 
  
  cast(StockQtyM2 - StockQtyM1 as float) as StockDeltaFloatM2M1,
  cast(StockQtyM3 - StockQtyM2 as float) as StockDeltaFloatM3M2,
  cast(StockQtyM4 - StockQtyM3 as float) as StockDeltaFloatM4M3,
  cast(StockQtyM5 - StockQtyM4 as float) as StockDeltaFloatM5M4,
  cast(StockQtyM6 - StockQtyM5 as float) as StockDeltaFloatM6M5,
  
  // Number of BOM 

  cast(NumberOfBomM5  as nsdm_number_of_bom_used_in preserving type) as NumberOfBomM5,
  cast(NumberOfBomM6  as nsdm_number_of_bom_used_in preserving type) as NumberOfBomM6,
  cast(NumberOfBomM7  as nsdm_number_of_bom_used_in preserving type) as NumberOfBomM7,
  cast(NumberOfBomM8  as nsdm_number_of_bom_used_in preserving type) as NumberOfBomM8,
  cast(NumberOfBomM9  as nsdm_number_of_bom_used_in preserving type) as NumberOfBomM9,
  cast(NumberOfBomM10 as nsdm_number_of_bom_used_in preserving type) as NumberOfBomM10,
  
  cast(NumberOfBomM5  as float) as NumberOfBomFloatM5,
  cast(NumberOfBomM6  as float) as NumberOfBomFloatM6,
  cast(NumberOfBomM7  as float) as NumberOfBomFloatM7,
  cast(NumberOfBomM8  as float) as NumberOfBomFloatM8,
  cast(NumberOfBomM9  as float) as NumberOfBomFloatM9,
  cast(NumberOfBomM10 as float) as NumberOfBomFloatM10,  
  
  // Number od BOM Delta

  cast(NumberOfBomM6  - NumberOfBomM5 as nsdm_number_of_bom_used_in preserving type) as NumberOfBomDeltaM6M5,   
  cast(NumberOfBomM7  - NumberOfBomM6 as nsdm_number_of_bom_used_in preserving type) as NumberOfBomDeltaM7M6,  
  cast(NumberOfBomM8  - NumberOfBomM7 as nsdm_number_of_bom_used_in preserving type) as NumberOfBomDeltaM8M7,  
  cast(NumberOfBomM9  - NumberOfBomM8 as nsdm_number_of_bom_used_in preserving type) as NumberOfBomDeltaM9M8,  
  cast(NumberOfBomM10 - NumberOfBomM9 as nsdm_number_of_bom_used_in preserving type) as NumberOfBomDeltaM10M9,   
  
  cast(NumberOfBomM6  - NumberOfBomM5 as float) as NumberOfBomDeltaFloatM6M5,   
  cast(NumberOfBomM7  - NumberOfBomM6 as float) as NumberOfBomDeltaFloatM7M6,  
  cast(NumberOfBomM8  - NumberOfBomM7 as float) as NumberOfBomDeltaFloatM8M7,  
  cast(NumberOfBomM9  - NumberOfBomM8 as float) as NumberOfBomDeltaFloatM9M8,  
  cast(NumberOfBomM10 - NumberOfBomM9 as float) as NumberOfBomDeltaFloatM10M9 

}

Learn More