P_ProcMonPeriodStartSyst

@AbapCatalog.sqlViewName: 'PPOCPERIDSTSY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

// calculate a timestamp of now - P_DaysAgo


define view P_ProcMonPeriodStartSyst
  with parameters
    P_DaysAgo : abap.int4,
    @Environment.systemField : #SYSTEM_DATE
    P_SysDate : syst_datum //abap.dats 

  as select from I_SAPClient
{
  key '1'                                                                                                                                                                                         as DummyKey, //dummy key

      //      TSTMP_ADD_SECONDS( TSTMP_CURRENT_UTCTIMESTAMP() , $parameters.P_DaysAgo * -86400, 'FAIL') as PeriodStartTimeStamp, //86400 = seconds/day


      cast(cast(concat(left(cast(TSTMP_ADD_SECONDS( TSTMP_CURRENT_UTCTIMESTAMP() , cast($parameters.P_DaysAgo as abap.dec(15,0)) * -86400, 'FAIL') as abap.char(17) ),8), '000000') as abap.numc(14)) as abap.dec(15,0) ) as PeriodStartTimeStamp,

      // calculate relevant start date based on SysDate = $session.system_date as this global variable couldn't be used directly in functions (gap of HANA)

      DATS_TIMS_TO_TSTMP( DATS_ADD_DAYS( $parameters.P_SysDate, $parameters.P_DaysAgo * -1, 'FAIL'), '000000', abap_system_timezone( $session.client, 'NULL' ), $session.client, 'FAIL' ) as PeriodSysStartTimeStamp,
      
      DATS_ADD_DAYS( $parameters.P_SysDate, $parameters.P_DaysAgo * -1, 'FAIL') as PeriodSysStartDate

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/