P_SLOWMOMATPREDCNSMPNFLOAT

CDS View

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

Used by 1 CDS view(s) 14 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SlowMoMatPredCnsmpnDelta view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY CalendarMonth CalendarMonth 1
KEY InventoryConsumptionGroup InventoryConsumptionGroup 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: 'PSLOWMOMATCFLOAT'
@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_SlowMoMatPredCnsmpnFloat as select from P_SlowMoMatPredCnsmpnDates
                                             
{

  key InventoryConsumptionGroup,
  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,    
  
  // Consumption  

  cast(ConsumptionQtyM1 as nsdm_consumption_quantity) as ConsumptionQtyM1,
  cast(ConsumptionQtyM2 as nsdm_consumption_quantity) as ConsumptionQtyM2,
  cast(ConsumptionQtyM3 as nsdm_consumption_quantity) as ConsumptionQtyM3,
  cast(ConsumptionQtyM4 as nsdm_consumption_quantity) as ConsumptionQtyM4,  
  cast(ConsumptionQtyM5 as nsdm_consumption_quantity) as ConsumptionQtyM5,
  cast(ConsumptionQtyM6 as nsdm_consumption_quantity) as ConsumptionQtyM6,
  cast(ConsumptionQtyM7 as nsdm_consumption_quantity) as ConsumptionQtyM7,

  cast(ConsumptionQtyM1 as float) as ConsumptionQtyFloatM1,
  cast(ConsumptionQtyM2 as float) as ConsumptionQtyFloatM2,
  cast(ConsumptionQtyM3 as float) as ConsumptionQtyFloatM3,
  cast(ConsumptionQtyM4 as float) as ConsumptionQtyFloatM4,
  cast(ConsumptionQtyM5 as float) as ConsumptionQtyFloatM5,
  cast(ConsumptionQtyM6 as float) as ConsumptionQtyFloatM6,
  
  // Consumption Delta Month - Previous Month  

  cast(ConsumptionQtyM2 - ConsumptionQtyM1 as nsdm_consumption_quantity) as ConsumptionDeltaM2M1,
  cast(ConsumptionQtyM3 - ConsumptionQtyM2 as nsdm_consumption_quantity) as ConsumptionDeltaM3M2,   
  cast(ConsumptionQtyM4 - ConsumptionQtyM3 as nsdm_consumption_quantity) as ConsumptionDeltaM4M3, 
  cast(ConsumptionQtyM5 - ConsumptionQtyM4 as nsdm_consumption_quantity) as ConsumptionDeltaM5M4,   
  cast(ConsumptionQtyM6 - ConsumptionQtyM5 as nsdm_consumption_quantity) as ConsumptionDeltaM6M5, 
  
  cast(ConsumptionQtyM2 - ConsumptionQtyM1 as float) as ConsumptionDeltaFloatM2M1,
  cast(ConsumptionQtyM3 - ConsumptionQtyM2 as float) as ConsumptionDeltaFloatM3M2,
  cast(ConsumptionQtyM4 - ConsumptionQtyM3 as float) as ConsumptionDeltaFloatM4M3,
  cast(ConsumptionQtyM5 - ConsumptionQtyM4 as float) as ConsumptionDeltaFloatM5M4,
  cast(ConsumptionQtyM6 - ConsumptionQtyM5 as float) as ConsumptionDeltaFloatM6M5,
  
  // 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