P_SLOWMOMATPRMOSTOCKFLOAT

CDS View

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

Used by 1 CDS view(s) 4 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SlowMoMatPrMoStockDelta view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CalendarMonth CalendarMonth 1
KEY Material Material 1
KEY MaterialBaseUnit MaterialBaseUnit 1
KEY Plant Plant 1 
@AbapCatalog.sqlViewName: 'PSLOWMOMATSOFLT'
@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_SlowMoMatPrMoStockFloat as select from P_SlowMoMatPrMoStockDates
                                             
{

  key cast(left(right(StartDate, 4), 2) as nsdm_month) as CalendarMonth,
        
  key Material,
  key Plant,
  key MaterialBaseUnit,    
  
  // Stocks  

  StockQtyM1,
  StockQtyM2,
  StockQtyM3,
  StockQtyM4,  
  StockQtyM5,
  StockQtyM6,
  StockQtyM7,

  // Stock Delta Month - Previous Month  

  StockQtyM2 - StockQtyM1 as StockDeltaM2M1,
  StockQtyM3 - StockQtyM2 as StockDeltaM3M2,   
  StockQtyM4 - StockQtyM3 as StockDeltaM4M3, 
  StockQtyM5 - StockQtyM4 as StockDeltaM5M4,   
  StockQtyM6 - StockQtyM5 as StockDeltaM6M5, 
  

  // Number of BOM 

  cast(NumberOfBomM5  as nsdm_number_of_bom_used_in_flt) as NumberOfBomM5,
  cast(NumberOfBomM6  as nsdm_number_of_bom_used_in_flt) as NumberOfBomM6,
  cast(NumberOfBomM7  as nsdm_number_of_bom_used_in_flt) as NumberOfBomM7,
  cast(NumberOfBomM8  as nsdm_number_of_bom_used_in_flt) as NumberOfBomM8,
  cast(NumberOfBomM9  as nsdm_number_of_bom_used_in_flt) as NumberOfBomM9,
  cast(NumberOfBomM10 as nsdm_number_of_bom_used_in_flt) as NumberOfBomM10,
  
  
  // Number of BOM Delta

  cast(NumberOfBomM6  - NumberOfBomM5 as nsdm_number_of_bom_used_in_flt) as NumberOfBomDeltaM6M5,   
  cast(NumberOfBomM7  - NumberOfBomM6 as nsdm_number_of_bom_used_in_flt) as NumberOfBomDeltaM7M6,  
  cast(NumberOfBomM8  - NumberOfBomM7 as nsdm_number_of_bom_used_in_flt) as NumberOfBomDeltaM8M7,  
  cast(NumberOfBomM9  - NumberOfBomM8 as nsdm_number_of_bom_used_in_flt) as NumberOfBomDeltaM9M8,  
  cast(NumberOfBomM10 - NumberOfBomM9 as nsdm_number_of_bom_used_in_flt) as NumberOfBomDeltaM10M9   
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_SLOWMOMATPRMOSTOCKDATES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More