P_APCurrentMonth

DDL: P_APCURRENTMONTH SQL: PAPCURMONTH Type: view COMPOSITE

P_APCurrentMonth is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_APCalendar, I_CalendarDate) and exposes 5 fields with key fields CalendarYear, CalendarMonth.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
P_APCalendar CA inner
I_CalendarDate CD from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PAPCURMONTH view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CalendarYear I_CalendarDate CalendarYear
KEY CalendarMonth I_CalendarDate CalendarMonth
CalendarDate I_CalendarDate CalendarDate
FirstDayOfMonth FirstDayOfMonth
LastDayOfMonth LastDayOfMonth 
@AbapCatalog.sqlViewName: 'PAPCURMONTH'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_APCurrentMonth
  as select from I_CalendarDate as CD
    inner join   P_APCalendar   as CA on CA.YearMonth = CD.YearMonth
{

  key CD.CalendarYear,
  key CD.CalendarMonth,
      CD.CalendarDate,
      FirstDayOfMonth,
      LastDayOfMonth

}
where
  CD.CalendarDate = $session.system_date
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"P_APCALENDAR"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More