P_ProcMonPeriodMonthStartSyst

DDL: P_PROCMONPERIODMONTHSTARTSYST SQL: PPOCPERIDMSTSY Type: view COMPOSITE

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (2)

NameTypeDefault
P_MonthsAgo abap.int4
P_SysDate syst_datum

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPOCPERIDMSTSY 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 (4)

KeyFieldSource TableSource FieldDescription
KEY DummyKey
PeriodStartTimeStamp
PeriodSysStartTimeStamp
PeriodSysStartDate 
@AbapCatalog.sqlViewName: 'PPOCPERIDMSTSY'
@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_ProcMonPeriodMonthStartSyst
  with parameters
    P_MonthsAgo : 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_MonthsAgo as abap.dec(17,4)) * 30 * -86400, 'FAIL') as abap.char(17) ),6), '01000000') as abap.numc(14)) as abap.dec(15,0) ) as PeriodStartTimeStamp,

      //      CONCAT(LEFT(DATS_ADD_MONTHS( TSTMP_TO_DATS(TSTMP_CURRENT_UTCTIMESTAMP(),abap_system_timezone( $session.client,'NULL' ), $session.client, 'FAIL' ), -$parameters.P_MonthsAgo , 'FAIL') , 6), '01')  as PeriodStartDate,

      //

      //      DATS_TIMS_TO_TSTMP(

      //          cast(

      //            CONCAT(

      //              LEFT(

      //                DATS_ADD_MONTHS(

      //                  TSTMP_TO_DATS(

      //                    TSTMP_CURRENT_UTCTIMESTAMP(), abap_system_timezone(

      //                      $session.client, 'NULL'

      //                    ), $session.client, 'FAIL'

      //                  ), -$parameters.P_MonthsAgo, 'FAIL'

      //                ), 6

      //              ), '01'

      //            ) as abap.dats

      //          ), cast(

      //            '000000' as abap.tims

      //          ), abap_system_timezone(

      //            $session.client, 'NULL'

      //          ), $session.client, 'NULL'

      //        )                                                                                                                                                                                                as PeriodStartDateTime

      // 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_MONTHS( $parameters.P_SysDate, $parameters.P_MonthsAgo * -1, 'FAIL'), '000000', abap_system_timezone( $session.client, 'NULL' ), $session.client, 'FAIL' ) as PeriodSysStartTimeStamp,
      
      DATS_ADD_MONTHS( $parameters.P_SysDate, $parameters.P_MonthsAgo * -1, 'FAIL') as PeriodSysStartDate

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

Learn More