P_ProcMonPeriodStart

DDL: P_PROCMONPERIODSTART SQL: PPOCPERIDST Type: view COMPOSITE

P_ProcMonPeriodStart is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 2 fields with key field DummyKey.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (1)

NameTypeDefault
P_DaysAgo abap.int4

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPOCPERIDST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DummyKey
PeriodStartTimeStamp 
@AbapCatalog.sqlViewName: 'PPOCPERIDST'
@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_ProcMonPeriodStart
  with parameters
    P_DaysAgo : abap.int4
  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

      //      DATS_ADD_DAYS( TSTMP_TO_DATS(TSTMP_CURRENT_UTCTIMESTAMP(),abap_system_timezone( $session.client,'NULL' ), $session.client, 'FAIL' ), -$parameters.P_DaysAgo , 'FAIL')    as PeriodStartDate,


      //      DATS_TIMS_TO_TSTMP( DATS_ADD_DAYS( TSTMP_TO_DATS( TSTMP_CURRENT_UTCTIMESTAMP(), abap_system_timezone( $session.client, 'NULL' ) , $session.client, 'NULL' ) , -$parameters.P_DaysAgo, 'NULL'), cast('000000' as abap.tims), abap_system_timezone( $session.client, 'NULL'), $session.client, 'NULL')

      //                                                                                                                                                                               as PeriodStartDateTime


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

Learn More