P_SLOWMOMATPRMOSTOCKFLOAT
Float Values for Calculation
P_SLOWMOMATPRMOSTOCKFLOAT is a CDS View in S/4HANA. Float Values for Calculation. It contains 27 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SlowMoMatPrMoStockDelta | view_entity | from | COMPOSITE | Stock Delta |
Fields (27)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CalendarMonth | CalendarMonth | 1 |
| KEY | Material | Material | 1 |
| KEY | MaterialBaseUnit | MaterialBaseUnit | 1 |
| KEY | Plant | Plant | 1 |
| NumberOfBomDeltaM10M9 | NumberOfBomDeltaM10M9 | 1 | |
| NumberOfBomDeltaM6M5 | NumberOfBomDeltaM6M5 | 1 | |
| NumberOfBomDeltaM7M6 | NumberOfBomDeltaM7M6 | 1 | |
| NumberOfBomDeltaM8M7 | NumberOfBomDeltaM8M7 | 1 | |
| NumberOfBomDeltaM9M8 | NumberOfBomDeltaM9M8 | 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_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
}