P_SLOWMOMATPREDSTOCKFLOAT

CDS View

Float Values for Calculation

P_SLOWMOMATPREDSTOCKFLOAT is a CDS View in S/4HANA. Float Values for Calculation. It contains 31 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 31 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SlowMoMatPredStockDelta view_entity from COMPOSITE Stock Delta

Fields (31)

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
NumberOfBomM10 NumberOfBomM10 1
NumberOfBomM5 NumberOfBomM5 1
NumberOfBomM6 NumberOfBomM6 1
NumberOfBomM7 NumberOfBomM7 1
NumberOfBomM8 NumberOfBomM8 1
NumberOfBomM9 NumberOfBomM9 1
StockDeltaM2M1 StockDeltaM2M1 1
StockDeltaM3M2 StockDeltaM3M2 1
StockDeltaM4M3 StockDeltaM4M3 1
StockDeltaM5M4 StockDeltaM5M4 1
StockDeltaM6M5 StockDeltaM6M5 1
StockQtyM1 StockQtyM1 1
StockQtyM2 StockQtyM2 1
StockQtyM3 StockQtyM3 1
StockQtyM4 StockQtyM4 1
StockQtyM5 StockQtyM5 1
StockQtyM6 StockQtyM6 1
StockQtyM7 StockQtyM7,target 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: 'Float Values for Calculation'

define view entity 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