P_PrevMonthForCurrentMonth

DDL: P_PREVMONTHFORCURRENTMONTH SQL: PPREVMONTH Type: view CONSUMPTION Package: APPL_MM_PUR_DLVPRED_ML

Previous Month Details for Current Month

P_PrevMonthForCurrentMonth is a Consumption CDS View that provides data about "Previous Month Details for Current Month" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, I_CalendarDate) and exposes 2 fields with key field YearMonth. Part of development package APPL_MM_PUR_DLVPRED_ML.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate CurrMonth from
I_CalendarDate LastMonth left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PPREVMONTH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Previous Month Details for Current Month view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY YearMonth I_CalendarDate YearMonth
PreviousMonthNumber 
@AbapCatalog.sqlViewName: 'PPREVMONTH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Previous Month Details for Current Month'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_PrevMonthForCurrentMonth
  as select from    I_CalendarDate as CurrMonth
    left outer join I_CalendarDate as LastMonth on CurrMonth.YearMonth > LastMonth.YearMonth
{
  key CurrMonth.YearMonth      as YearMonth,
      max(LastMonth.YearMonth) as PreviousMonthNumber
}
group by
  CurrMonth.YearMonth

Learn More