DATEFUNC_FISCAL_SIMULATE_QUERY

DDL: DATEFUNC_FISCAL_SIMULATE_QUERY SQL: FISCDFSIMQUERY Type: view

Simulates the date range values

DATEFUNC_FISCAL_SIMULATE_QUERY is a CDS View that provides data about "Simulates the date range values" in SAP S/4HANA. It reads from 1 data source (I_FiscalDateFunctionValue) and exposes 5 fields with key field id.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_FiscalDateFunctionValue DateFucntionValue from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FISCDFSIMQUERY view
EndUserText.label Simulates the date range values view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY id DateFunction
DateFunctionStartDate DateFunctionStartDate
DateFunctionEndDate DateFunctionEndDate
clientFAILasDateFunctionStartDateTime
clientFAILasDateFunctionEndDateTime 
@AbapCatalog.sqlViewName: 'FISCDFSIMQUERY'
@EndUserText.label: 'Simulates the date range values'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory:  #M
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view DATEFUNC_FISCAL_SIMULATE_QUERY 
//as select from C_GregorianCalDateFunction (P_Language : $session.system_language, P_DateFunctionValidityDate : $session.system_date) {

//   key DateFunction as id, 

//   DateFunctionStartDate,

//   DateFunctionEndDate

//}

as select from I_FiscalDateFunctionValue        as DateFucntionValue
 
 {
 key DateFunction as id,
 DateFunctionStartDate,
 DateFunctionEndDate,
  dats_tims_to_tstmp(DateFunctionStartDate, cast( '000000' as abap.tims),
                   abap_user_timezone($session.user, $session.client, 'FAIL'),
                   $session.client,    'FAIL' ) as DateFunctionStartDateTime,
      dats_tims_to_tstmp(DateFunctionEndDate, cast( '235959' as abap.tims),
                   abap_user_timezone($session.user, $session.client, 'FAIL'),
                   $session.client,    'FAIL' ) as DateFunctionEndDateTime
 }
 where 
 DateFunctionValidityDate =  $session.system_date and DateFucntionValue.FiscalYearVariant = 'K4'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FISCALDATEFUNCTIONVALUE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More