P_AnalyzeAccrualPostingStrtDte

DDL: P_ANALYZEACCRUALPOSTINGSTRTDTE SQL: PANALACEDATE Type: view COMPOSITE Package: ODATA_GL_ACE_ANALYZE_POSTG

Start Date for Visual Filter

P_AnalyzeAccrualPostingStrtDte is a Composite CDS View that provides data about "Start Date for Visual Filter" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, I_CalendarDate) and exposes 1 field with key field CalendarDate. Part of development package ODATA_GL_ACE_ANALYZE_POSTG.

2 data source(s) 1 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate _Last3Months inner
I_CalendarDate ThisMonth from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (5)

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

Fields (1)

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

define view P_AnalyzeAccrualPostingStrtDte 
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate         : sydate
  as select from I_CalendarDate as ThisMonth
    inner join   I_CalendarDate as _Last3Months on _Last3Months.CalendarDate = DATS_ADD_MONTHS(
      $parameters.P_KeyDate, - 2, 'FAIL'
    )
{
  key _Last3Months.CalendarDate    as CalendarDate
}
where
  ThisMonth.CalendarDate = $parameters.P_KeyDate

Learn More