P_FISCALDATEFUNCTIONVALUEFY

CDS View

P_FISCALDATEFUNCTIONVALUEFY is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ActualBalFlowDateFunc view inner COMPOSITE
P_PlanBalFlowDateFunc view inner COMPOSITE 
@AbapCatalog.sqlViewName: 'PFIDATEFUNCVALFY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@VDM.viewType: #BASIC

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_FiscalDateFunctionValueFY
  as select from I_FiscalDateFunctionValue
//    inner join            I_FiscalYear as StartYear on  StartYear.FiscalYearVariant   =  I_FiscalDateFunctionValue.FiscalYearVariant

//                                                                     and StartYear.FiscalYearStartDate <= I_FiscalDateFunctionValue.DateFunctionStartDate

//                                                                     and StartYear.FiscalYearEndDate   >= I_FiscalDateFunctionValue.DateFunctionStartDate

//    inner join            I_FiscalYear as EndYear   on  EndYear.FiscalYearVariant   =  I_FiscalDateFunctionValue.FiscalYearVariant

//                                                                     and EndYear.FiscalYearStartDate <= I_FiscalDateFunctionValue.DateFunctionEndDate

//                                                                     and EndYear.FiscalYearEndDate   >= I_FiscalDateFunctionValue.DateFunctionEndDate


inner join I_FiscalCalendarDate as StartYear on I_FiscalDateFunctionValue.FiscalYearVariant = StartYear.FiscalYearVariant
                                            and I_FiscalDateFunctionValue.DateFunctionStartDate = StartYear.CalendarDate
inner join I_FiscalCalendarDate as EndYear   on I_FiscalDateFunctionValue.FiscalYearVariant = EndYear.FiscalYearVariant
                                            and I_FiscalDateFunctionValue.DateFunctionEndDate = EndYear.CalendarDate                                                                     
                                                                     
{
  key  DateFunction,
  key  I_FiscalDateFunctionValue.FiscalYearVariant,
  key  DateFunctionValidityDate,

       DateFunctionStartDate,
       DateFunctionEndDate,

       StartYear.FiscalYear          as FiscalYear,
       StartYear.FiscalYearStartDate as FiscalYearStartDate,

       StartYear.FiscalYear          as StartFiscalYear,
       EndYear.FiscalYear            as EndFiscalYear,

       _DateFunction
}

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

Learn More