P_FiscalDateFunctionValueFY

DDL: P_FISCALDATEFUNCTIONVALUEFY SQL: PFIDATEFUNCVALFY Type: view COMPOSITE

P_FiscalDateFunctionValueFY is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_FiscalCalendarDate, I_FiscalDateFunctionValue, I_FiscalCalendarDate) and exposes 10 fields with key fields DateFunction, FiscalYearVariant, DateFunctionValidityDate.

3 data source(s) 10 fields

Data Sources (3)

SourceAliasJoin Type
I_FiscalCalendarDate EndYear inner
I_FiscalDateFunctionValue I_FiscalDateFunctionValue from
I_FiscalCalendarDate StartYear inner

Annotations (7)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction
KEY FiscalYearVariant I_FiscalDateFunctionValue FiscalYearVariant
KEY DateFunctionValidityDate DateFunctionValidityDate
DateFunctionStartDate DateFunctionStartDate
DateFunctionEndDate DateFunctionEndDate
FiscalYear I_FiscalCalendarDate FiscalYear
FiscalYearStartDate I_FiscalCalendarDate FiscalYearStartDate
StartFiscalYear I_FiscalCalendarDate FiscalYear
EndFiscalYear I_FiscalCalendarDate FiscalYear
_DateFunction _DateFunction 
@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