P_Lfodaterange

DDL: P_LFODATERANGE SQL: PLFODATERANGE Type: view COMPOSITE

P_Lfodaterange is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_SAPClient, P_Lfodates) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_SAPClient I_SAPClient inner
P_Lfodates P_Lfodates from

Parameters (2)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_NumberOfDays vdm_v_interval_day

Annotations (4)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
CalendarDate P_Lfodates CalendarDate
SAPClient I_SAPClient sapclient 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED //or #NOT_ALLOWED

@AbapCatalog.sqlViewName: 'PLFODATERANGE'//must start with "P"

define view P_Lfodaterange 
with parameters 
                P_KeyDate : vdm_v_key_date,
                P_NumberOfDays : vdm_v_interval_day 
as select from P_Lfodates (P_KeyDate: $parameters.P_KeyDate)
inner join I_SAPClient on  P_Lfodates.DayDiff  <= $parameters.P_NumberOfDays
{
 
 P_Lfodates.CalendarDate as CalendarDate,
 I_SAPClient.sapclient as SAPClient
  
}

Learn More