P_FISCALDATEFUNCTIONVALUEFY

CDS View

P_FiscalDateFunctionValueFY

P_FISCALDATEFUNCTIONVALUEFY is a CDS View in S/4HANA. P_FiscalDateFunctionValueFY. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_ActualBalFlowDateFunc view_entity inner COMPOSITE P_ActualBalFlowDateFunc
P_PlanBalFlowDateFunc view_entity inner COMPOSITE P_PlanBalFlowDateFunc

Fields (1)

KeyField CDS FieldsUsed in Views
KEY DateFunction DateFunction 2 
@AccessControl.authorizationCheck: #CHECK
//@VDM.viewType: #BASIC

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view entity P_FiscalDateFunctionValueFY
  as select from I_FiscalDateFunctionValue as 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  I_FiscalDateFunctionValue.DateFunction,
  key  I_FiscalDateFunctionValue.FiscalYearVariant,
  key  I_FiscalDateFunctionValue.DateFunctionValidityDate,

       I_FiscalDateFunctionValue.DateFunctionStartDate,
       I_FiscalDateFunctionValue.DateFunctionEndDate,

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

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

       I_FiscalDateFunctionValue._DateFunction
}

Learn More