P_LFODATES

CDS View

P_LFODATES is a CDS View in S/4HANA. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Lfodaterange view from COMPOSITE
P_Lfomonth view from COMPOSITE

Fields (1)

KeyField CDS FieldsUsed in Views
CalendarDate CalendarDate 2 
@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'

Learn More