P_Lfodates

DDL: P_LFODATES SQL: PLFODATES Type: view COMPOSITE

P_Lfodates is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 3 fields.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PLFODATES view

Fields (3)

KeyFieldSource TableSource FieldDescription
CalendarDate I_CalendarDate CalendarDate
DayDiff
DayDiffActual 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED //or #NOT_ALLOWED

@AbapCatalog.sqlViewName: 'PLFODATES'

define view P_Lfodates 
with parameters P_KeyDate : vdm_v_key_date 
as select from I_CalendarDate {
  I_CalendarDate.CalendarDate                      as CalendarDate,
  DATS_DAYS_BETWEEN($parameters.P_KeyDate, CalendarDate) as DayDiff,
  DATS_DAYS_BETWEEN(CalendarDate, $parameters.P_KeyDate) as DayDiffActual // used for actual cash flow

}
where I_CalendarDate.CalendarDate >= $parameters.P_KeyDate
  --and I_CalendarDate.CalendarDate <= '20500101'
           
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More