P_MATLSTKPERDSINMONTH

CDS View

Periods in months

P_MATLSTKPERDSINMONTH is a CDS View in S/4HANA. Periods in months. It contains 1 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 1 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
P_MatlStkPerdsInMonthRef view_entity from COMPOSITE Periods in months depending on reference date
P_SlowMoMatPredConsSum view_entity from COMPOSITE Consumption Aggregate
P_SlowMoMatPredKeyDate view_entity from COMPOSITE Key Date
P_SLOWMOMATPREDSTOCKSUM view_entity from COMPOSITE Stock Aggregate
P_SlowMoMatPredSysDate view_entity from COMPOSITE System Date
P_SlowMoMatPrMoConsSum view_entity from COMPOSITE Consumption Aggregate
P_SlowMoMatPrMoStockSum view_entity from COMPOSITE Stock Aggregate

Fields (1)

KeyField CDS FieldsUsed in Views
KEY StartDate StartDate 4 
@AccessControl.authorizationCheck:#NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@VDM.private: true
@VDM.viewType: #COMPOSITE

define view entity P_MatlStkPerdsInMonth
  as select from I_SAPClient as sc
   inner join I_CalendarDate as cd on sc.LogicalSystem =  '' //dummy "on" condition

                                  or sc.LogicalSystem <> ''
  
{
  key cd.CalendarYear,
  key cd.CalendarMonth, 
  min(cd.CalendarDate) as StartDate,
  max(cd.CalendarDate) as EndDate
 
}
  group by cd.CalendarYear,
           cd.CalendarMonth

Learn More